Virtual Professional Practice Experience

Virtual Professional Practice Experience Assignment 3 (10 hours)

Visual Representations of Statistical Data Bachelor Competency III.4 Examine health care findings with data visualizations.

Associates Competency III.4. Report health care data through graphical representations.

Go to the CDC website about the Coronavirus: https://www.cdc.gov/coronavirus/2019- ncov/index.html (Links to an external site.).

Part 1

 The click on the ‘Data and Surveillance’ button which will take you to the information that has been being collected.

 Create an excel spread sheet which shows the current number of cases by state and the number of deaths by state.

 Once this data has been entered onto the excel spreadsheet, please create a line graph for each column representing this data.

 Here are a couple of tools which may be helpful:  https://support.microsoft.com/en-us/office/present-your-data-in-a-column-chart-

d89050ba-e6b6-47de-b090-e9ab353c4c00  https://www.youtube.com/watch?v=X7O6WQl62Ks

Part 2

 Choose 3 states to compare the following COVID-19 data: o Confirmed cases by gender (M/F) – create a pie graph representation o Death by gender (M/F) – create a pie graph representation o Confirmed cases by age – create a bar graph representation o Confirmed deaths by age – create a bar graph representation

Part 3

 Provide a written summary of your findings, 1-2 pages, make sure to include references.  You will submit the excel spreadsheets, the corresponding graphs and summary to Dr.

Simmons.