Chapter 8: Healthcare Analytics is part of the required reading this week. Data

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