PLAZA COLLEGE Samhsa.Gov Quality Of Care Project Student________________________________________________Date___________ AHIMA Domain l: Data Content, Structure & Standards Subdomain l.D.2: Data Management Competencies: Apply graphical tools for data presentation (BL3) Curricular Considerations: Graphical tools & presentations AHIMA Domain lll: Informatics, Analytics And Data Use Subdomain lll.C.1: Analytics and Decision Support Competencies: Explain analytics and decision support (BL2) Curricular Considerations: Analytics and decision support (data visualization, dashboard, data capture tools, and technologies) Objectives: By the end of this course students will be able to

• Construct an Excel chart with graph to analyze the differences in reported data (BL3)
• Illustrate and explain differences in data from governmental secondary data sources (BL2)
• Analyze and draw conclusions from governmental secondary data sources (BL4)

Standards: Student must achieve a minimum score of 70% Assessment: Will be based on the completed tasks, including the answer sheet and the Excel chart Task Points Log on to Samhsa, find and review the URS Reporting Tables for New York State ______/5 Log on to Samhsa, find and review the URS Reporting Tables for the second state ______/5 Based on the reports, answer Questions 1 6 Question 1 - ______/5 Question 2 - ______/6 Question 3 - ______/6 Question 4 - ______/6 Question 5 - ______/6 Question 6 - ______/6 Total One through Six: ______/35 Excel chart, correct and submitted on time: ______/35 Question 7 - ______/5 Question 8 - ______/15 Total Seven and Eight: ______/20 Project Total: ______/100 Instructor ___________________________________________ Date __________ Visit the Substance Abuse and Mental Health Services Administration [SAMHSA] National Mental Health Information Center Web site at www.samhsa.gov

2. Click on DATA in the black bar
4. Click on Reports and Data Tables
6. On the left: set Survey Collection Dates to the latest available dates (usually a year behind)

For example, From: 2017 To: 2017

2. On the left: Survey Type choose Uniform Reporting System (URS)
4. Look for the latest report for New York 20xx Uniform Reporting System (URS) Table for New York
6. Download this file and save it so that you can work offline.
8. Do the same process to find and download the report for your assigned other state for the same year.

How to read this report: Look at the two arrows ALWAYS use the percentage rates, not the population numbers. The United States and its territories have a much larger population than New York State alone, so comparing numbers will be meaningless. When comparing the two states, you can have both documents open on your screen and scroll down. NOTE: The first few pages are summary pages look inside the report! __________________________________________________________________ Based on the reports shown, neatly type your answers on this template. Complete the following questions:

2. Can you find consumer survey results details within the report? If your answer is Pg 1, 2, or 3, you are wrong

Yes No If yes, what page? ___

2. What types of data are available within this report? Enter at least 5 different categories, and give the page numbers. If your answers are Pg 1, 2, or 3, you are wrong

2. How does New York State compare to the U.S. national average on various measures surveyed? Where is (are) the largest difference(s) you see? The smallest? Use PERCENTAGES, not population figures or dollar amounts.

2. Select a report for your assigned second state and compare the two state reports.
   2. __________________
5. To what extent does New York State and your assigned state report the same categories of information? Where is (are) the largest difference(s) you see? The smallest? Use PERCENTAGES, not population figures or dollar amounts. Be clear and organized when you write this part.

2. Is some optional information reported by one state and not by the other? Be clear and organized when you write this part.

Planning and reporting on your chart:

2. How could the Excel reports for PART TWO be structured to provide meaningful information about your 5 sets of data? What type of graph will you plan? Why?

2. Explain in words what the Excel graph created for PART TWO shows about the five sets of data.

For example: The graph shows that Hawaii exceeds the US average in percentage of mental health consumers who are employed, but New York State has a higher percentage than both Hawaii and the US average. Next, .. . Type your answer BELOW this line - _______________________________________________________________________ Part Two Of This Assignment: Using Excel, produce a chart and graph to compare FIVE (5) items reported you must compare New York State, your second state, and the U.S. amounts for the reported measures. PUT YOUR NAME at cell A1 on the sheet where you set up the chart for the graph. Start the chart at A5.

• You must submit the EXCEL file, not a PDF or shared Google doc, in addition to this file.

BE SURE to answer Question 7 (Planning the chart) and Question 8 (Reporting the results)!