References:
Problem Description:
The hypothetical province makes multi-day announcements regarding the COVID-19 situation in the province. The quoted paragraphs below are samples of such announcements.
In September 9, 2021, across the province, 774 new COVID-19 cases were announced in the past 24 hours. Active cases rose marginally to 5,594. There were 262 people in hospital, including 35 in intensive care. Five people died due to COVID-19 in the past 24 hours. 86.9% of eligible people 12 or older have received their first dose of COVID-19 vaccine and 78.1% received their second dose. Some restrictions were announced for the Central Region.
As of Tuesday, September 7, 2021, the province were reporting 2,425 new cases of COVID-19 for the past 96 hours. There were 5,465 active cases in the province. Of the active cases, 255 individuals are in hospital and 126 are in intensive care. In the past 96 hours, 15 new deaths have been reported. 85.7% of eligible people 12 or older have received their first dose of COVID-19 vaccine and 77.1% received their second dose. The restrictions placed on the North region were lifted.
In August 30, 2021, provincially, 1,853 new COVID-19 cases were announced over the past 72 hours with 5,918 cases considered active. Across the province 176 people are in hospital, of which 91 are receiving intensive care. There was no new death related to COVID-19 in this period of time. 84.2% of eligible people 12 or older have received their first dose of COVID-19 vaccine and 76.4% received their second dose. No new restriction orders were announced.
The above paragraphs are just samples of the three most recent announcement from the province. You can expect that there are many more announcements with similar information published in the past 18 months.
Your Task:
Design an Excel table to store the data extracted from the above descriptions. Each column of the table should have an appropriate and meaningful name. Make sure to use bold font for the title names.
Fill the table with the data extracted from the above descriptions. Properly format the cells to reflect the appropriate data types of the data stored in these cells.
How to submit:
To submit your assignment, name your solution Excel file as your Lastname_A1.xlsx, then login to your VIU Learn account, find the CSCI 112 course page, click on the "Assessment" drop-down menu, click on the "Assignments" item, then click on the folder named "A1". Then you can click on the "Add a File" button to browse and upload your solution Excel file.
If you have difficulties to make the VIU Learn submission work, please email me to let me know and attach your text solution file with your email.