Over the past 1.5+ years, COVID-19 has posed an immense challenge to public health systems around the world.
In this exercise, you will
- find the most recent daily — i.e., the most recent data point — data for your chosen countries on cumulative numbers of confirmed cases per million people, cumulative numbers of confirmed deaths per million people, and cumulative vaccination rates per hundred people for COVID-19;
- find a series of data on two indicators of the country’s health status;
- find a series of data on (i) how much of the budget and (ii) how much of gross domestic product the government of the country spends on health;
- arrange the data in the second two bullet points on one or more graphs using Excel; and
- write a brief narrative on whether you have found a relationship between the severity of COVID=19 and (i) the overall health situation in the country; and (ii) the extent of government spending on public health.
Data Sources
- COVID-19: COVID-19 data here (Our World in Data) (链接到外部网站。)
- Health indicators (select two): Country data on health indicators here (WHO) (链接到外部网站。)
- Domestic general government health expenditure (% of general government expenditure): here (World Bank) (链接到外部网站。) and Domestic general government health expenditure (% of GDP) here (World Bank) (链接到外部网站。)
If you are unfamiliar or rusty with making graphics from data in Excel, a tutorial is available here Excel Quick and Simple Charts Tutorial (链接到外部网站。). Your product should be a professional looking and no longer than two pages, including graphics.
0 comments