A great way to study Africa!
Summary of Creation: Students use the CIA World Factbook website to find information about all the countries of a specified continent and display the data in a table in an Excel spreadsheet.
Summary of Analysis: Using the table created in Continent Table Version 3 Creation or the Continent Table Version 3 Analysis Optional Student File, students use formulas and data sorting to analyze and answer questions about the countries of the continent.
Summary of Charts: Using the table created in Continent Table Version 3 Creation or the Continent Table Version 3 Analysis Optional Student File, students create charts to display selected information about the countries of the continent.
This lesson is in my Level 5 Curriculum Progression.
Recommended for Fifth through Twelfth Grade
Uses Microsoft Excel, but can be adapted for other spreadsheet software.
Creation Teacher Instructions (pdf)
Creation Student Instructions (pdf)
Creation Example (pdf)
Analysis Teacher Instructions (pdf)
Analysis Student Instructions and Worksheet (pdf)
Analysis Answer Key (pdf)
Charts Teacher Instructions (pdf)
Charts Student Instructions All (pdf)
Charts Student Instructions Indiv (pdf)
Charts Example (pdf)
Optional Student File (Excel)
Duration: Six to ten 60-minute class sessions