CompetencyDescribe the process of creating data sets.
Student Success Criteria
View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.
Scenario
The Covid-19 pandemic has had a tremendous impact on communities around the world. The impact has been felt in healthcare, economic, business, government, education, and social areas. It has put people at odds over vaccines, placed local government policies against federal policies, and beliefs versus medicine. Some may say the world we are living in is full of chaos over this situation. Businesses are demanding that employees get vaccinated or face termination of employment. And this has led to a situation where the legality of getting vaccinated has reached the state courthouse in Your State, USA.
The stage has been set for two opposing legal teams to argue their case before the state supreme court in Your State, USA. A very large grocery store chain, Fine Foods, has asked that their employees get vaccinated or face termination of employment. The company argues that as a supplier of goods and services to government entities, Fine Foods must follow vaccine guidelines set by Your State, USA. The Grocery Union Workers of America is arguing that their members cannot be required to get vaccinated and that this is against the law.
For this assignment, you will choose a legal team, either Fine Foods or Grocery Union Workers of America (GUWA). Your role is a data analyst for the respective law firm representing the side YOU choose. The lead attorney has tasked you with extracting data to support their legal case for vaccinations. If you choose the Fine Foods legal team, you will support all employees getting vaccinated. If you choose the Grocery Union Workers of America (GUWA) legal team, you will support a person’s right to choose to get vaccinated and, of course, not lose their job. It is important for you to focus on your role as a data analyst and provide data. You should not try to present any actual laws pertinent to Covid-19.
Although this topic may be emotionally charged, your job is to present
data–centric evidence which can be presented in court. Your data should be credible and convincing.
Instructions
Now that you have been selected as the data analyst to work on this case, you need to prepare for your first meeting with the attorney. You were provided with a case brief, and the lead attorney expects you to come to the meeting with your initial data sets already identified. Your task is to review the data files provided and identify the data content that will be useful. You will need to determine the key data elements that you will use from those files.
For this assignment, prepare a memo to the lead attorney. In this memo provide an overview of how you validate data sources.
- Discuss the first data source: https://covid.cdc.gov/covid-data-tracker/#rates-by-vaccine-status.
- List 3 – 4 data elements and provide a description for each.
- Explain the relationships between the data elements.
- Explain how this data source is relevant to the case.
- Download the data to Excel.
To download the Excel file:
Visit the CDC page
Scroll down and click Download Data
On the new page, click Export (on the right side of the page)
Choose CSV for Excel
Submit both your memo and Excel file.
In your memo, be sure to include a brief overview of the scenario, address all bullet points above, and include a summary paragraph in your memo. The length of your memo should be approximately two pages.
Data Files
For this deliverable, please reference these data files as necessary.
Extra Data Files
These resources are not required but may help in your research:
https://covid.cdc.gov/covid-data-tracker/#rates-by-vaccine-status
https://covid.cdc.gov/covid-data-tracker/#vaccine-effectiveness
https://covid.cdc.gov/covid-data-tracker/#covidnet-hospitalizations-vaccination
https://covid.cdc.gov/covid-data-tracker/#cases_casesper100klast7days
https://covid.cdc.gov/covid-data-tracker/#trends_dailycases
https://covid.cdc.gov/covid-data-tracker/#compare-trends_newcases
https://covid.cdc.gov/covid-data-tracker/#demographicsovertime
https://covid.cdc.gov/covid-data-tracker/#demographics
https://www.cdc.gov/coronavirus/2019-ncov/science/forecasting/mathematical-modeling.html
