Deliverable 1 – Data Validation Memo

Assignment Content

1. Competency
   Describe 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