Chapter 8: Healthcare Analytics is part of the required reading this week. Data is what drives most business decisions and not in just healthcare. So, it is important for one to know how to present data and digest data.
This assignment is a step away from the normal text-based work, and it allows students to show their creativity through a chart or graph. Here are the instructions: 1. Read chapter 8 in the course textbook. 2. Review these details about creating: a. A scatter or line chart in MS Excel: https://support.microsoft.com/en-us/topic/present-…
b. A column chart in MS Excel: https://support.microsoft.com/en-us/office/present…
c. A pie chart in MS Excel: https://support.microsoft.com/en-us/office/add-a-p…
3. Of the three types listed above, students can select any one of those for this assignment. 4. Type a “made-up” scenario that would call for the selected type of chart to be used. The Scenario must revolve around one of these topics: Artificial Intelligence, DNA Health Test Kits (i.e. 23 and me, Ancestry, or etc.), Quality of Care, or health crisis emergency response. <<<< students can choose whichever topic they feel most comfortable discussing. Students who have charts that do not surround these topics will automatically not be able to receive a score higher than a 87% (B+). 5. Populate a chart with hypothetical data for the scenario. So, the submitted work should have two portions: • The situation being described for which the chart or graph is being used; this portion should be 75-100 words. *Remember to only use one of the required topics. • The actual chart or graph with hypothetical data coinciding with the made-up situation. Also, be sure to upload the actual Excel file/raw data file; this is so we can confirm the student actually created the graph/chart and did not just download a photo from a web page. *All students should have access to MS Excel, but on the rare occasion they do not, students can research how to execute these graphs/charts utilizing the free Google Office Suite, but this should be an absolute resort. _______________ Here is an abbreviated example of what could be submitted: Scenario: • Leadership wants to see the proportion of the lunch money each department is using from the available pool. Pie Chart: Rubric Graph/Chart Assignment Graph/Chart Assignment CriteriaRatingsPts This criterion is linked to a Learning OutcomeOrganization 25 ptsFull Marks The appropriate graph or chart type is selected to represent the information (i.e. Bar, Pie, Line, or etc.) 21 ptsPartial While the data can be digested. Another graph or chart would have better presented the information. 25 pts This criterion is linked to a Learning OutcomeDesign 25 ptsFull Marks There are colors, 3D affects, photos, and etc. that make the presentation “come alive.” 21 ptsPartial The data is not disorganized, but the information is presented in basic grayscale and is not visually appealing. 25 pts This criterion is linked to a Learning OutcomeClarity 25 ptsFull Marks All key components are represented, and everything is clearly labeled. There is even a key that briefly explains the table/graph. 21 ptsPartial There are one or two portions of the graph/table that does not correlate with the requested output. OR One or two key components are just not included. 25 pts This criterion is linked to a Learning OutcomeGrammar 25 ptsFull Marks No misspellings or incorrect descriptors. 21 ptsPartial There is one or two misspellings or a descriptor that just does not match what is presented. 25 pts Total Points: 100