Spreadsheet Lesson Framwork
This page contains an example of a lesson framework to teach students how to store data in Google Sheets, then create a bar graph from the sheet. An example of a possible sheet and bar graph is included.
Topic:
Fourth Grade English Language Arts, Data Tracking
Goals:
By the end of this lesson, students will be able to manually track their learning on paper, transfer that learning data to a Google Sheet, then create a bar graph. Students will be able to analyze the data and information, then write a reflection paragraph about their findings.
Complex Lessons: Students will understand how the visual representation of data can help analyze information and look for patterns. Students will practice looking for patterns in meaningful, real-world situations.
Lesson Framework:
Topic:
Fourth Grade English Language Arts, Data Tracking
Goals:
By the end of this lesson, students will be able to manually track their learning on paper, transfer that learning data to a Google Sheet, then create a bar graph. Students will be able to analyze the data and information, then write a reflection paragraph about their findings.
Complex Lessons: Students will understand how the visual representation of data can help analyze information and look for patterns. Students will practice looking for patterns in meaningful, real-world situations.
Lesson Framework:
- Essential Question: How does tracking my scores help me realize the power of growth?
- Hook: Show students this Class Dojo Video: The Power of Yet
- Discuss with students what YET means. Students will Pair/Share with each other times in their lives they've had to practice something in order to improve.
- Introduce Activity-
- Students will be tracking every pre-test and post-test score for Reading Language standards. Pre-test scores will be tracked in red (on paper), and post-test scores will be tracked in green (on paper).
- After scores are written down, students will learn to input their data in Google Sheets and create a chart. Each column represents a new assessment, and the rows representing their scores.
- Once several scores are recorded, students will analyze their data, focusing on their growth (not their grade or percentage).
- Students will then write at least ten complete sentences discussing what the power of yet means and how tracking their scores helps them understand the power of yet.