Abstract
In this challenge, students will use available data on the COVID 19 pandemic with an Excel spreadsheet to create graphics that show the evolution throughout time according to different parameters. Students will learn the basics of descriptive statistics.
This activity should be developed in groups of 3 learners. Teachers should help maintain the motivation of the learners particularly when they are struggling with the Excel tool or with the data interpretation.
Learning Outcomes
Skills and Competences
The learners can develop the following skills and competences:
- Teamwork and collaboration
- Leadership
- Communication and presentation skills
- Designing a solution to a complex problem by breaking it into small, manageable problems
- Apply the engineering design process to solve problems
- Management of time and resources
- Use of spreadsheet software
- Use of visual data representation tools
Knowledge
The following knowledge can be gathered by the learners:
- Basic statistics
- Basic data representation
Other Instructions
1. Using Excel, select the data for each graphic and generate the corresponding graphic. 2. If necessary, generate the necessary descriptive statistics. 2. Repeat for each requested graphic. 3. Create a graphic that your group thinks will provide the best comparative view of the pandemic progression in the full set of countries. 4. Compare your graphics with the ones available here: https://ourworldindata.org/coronavirus 5. Save the new spreadsheet
URL
RESOURCES
Author
Language
English
English (UK) 
Български 
Português 
Italiano 
Lietuvių kalba 
Македонски јазик 
Ελληνικά