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. 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 persons 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.
Your objective is to provide the lead attorney with data to support their legal position. This should include current and historical data in the following key areas:
Data Presentation (PowerPoint with embedded Excel charts)