Description
Unformatted Attachment Preview
Wk 2 – Excel Foundations
Assignment Content
You work in your state’s health department. Your manager wants your help in analyzing the local Covid transmission
rates. She is hoping you can automate a spreadsheet so it can quickly summarize critical information for your department.
Create a spreadsheet that utilizes conditional formulas within Microsoft Excel spreadsheet to fulfill your manager’s
request by completing the following steps:
•
Access data on Covid transmission rates from the CDC website. This website lists the data in a spreadsheet
format.
•
Open Microsoft Excel software
•
Create a new Microsoft Excel file named “MPH 560 Excel Assignment”
•
Create a new worksheet in your Microsoft Excel file and name it “Conditional Formulas”
•
Add Covid data for at least 10 counties in your state or a neighboring state that are close to your local area
including the following:
.=County_population
=Covid_inpatient_bed_utilization
==Covid_hospital_admissions_per_100k
==Covid_cases_per_100k
====Covid-19_community_level
•
Create column titles that accurately describe each type of data you chose to include
•
Create an automated snapshot of the data by using the conditional function COUNTIF in Microsoft Excel to show
the following:
•
•
Number of counties with medium community risk level
•
•
•
Number of counties with high community risk level
Number of counties with low community risk level
Number of counties with more than 100 Covid cases per 100,000 people
Number of counties with more than 10 Covid hospitalizations per 100,000 people
Review the following resources from Microsoft 365 support to help you complete your assignment:
•
•
Basic tasks in Excel
Overview of formulas in Excel
•
COUNTIF function
•
Excel video training
Within your Excel spreadsheet, write a 75- to 90-word response on the value of creating automated data snapshots or
dashboards for public health concerns. Consider the following questions:
How can public health administrators leverage automated data snapshots or dashboards?
How can the public in general leverage automated data snapshots or dashboards?
Cite any sources to support your assignment.
Note.
My state is Texas and the 10 counties are
1. Collin County, TX
2. Dallas County, TX
3. Denton County, TX
4. El Paso County, TX
5. Grayson County, TX
6. Hunt County, TX
7. Kaufman County, TX
8. Rockwall County, TX
9. Sherman County, TX
10. Tarrant County, TX
Purchase answer to see full
attachment