Spreadsheet lesson framework
Standards Addressed (Idaho Content Standards/Common Core State Standards)
- 5.SS.2.1.4 Name and locate the 50 States and their Capitals, and U.S. Territories.
- 5.SS.2.1.2 Identify the regions of the United States and their resources.
Learning Goals
- Students will be able to research and record information to collaborative learn about the regions of the United States and their resources.
- I can use technology and Google Sheets to collaborative learn about the regions of the United States and their resources.
- Students will be able to name and locate the 50 States, their Capitals and U.S. Territories.
- I can use technology and Google Sheets to collaborative learn about the 50 States, their Capitals and U.S. Territories.
- Students will be able to add content to share Google Sheet.
- Students will be able to make a copy of Google Sheet.
- Students will be able to sort data in Google Sheet.
Materials
Chromebooks
Collaborative Google Sheet
Collaborative Google Sheet
Data Collection and Collaboration
1. Students will be divided in to groups to research and complete the missing information for their region on the shared Google Sheet.
2. Once research is complete, students will learn how to make a copy of the sheet and manipulate data on the sheet.
2. Once research is complete, students will learn how to make a copy of the sheet and manipulate data on the sheet.