Peer Teaching: Exploring Google Sheets

Peer Teaching Project: Exploring the Functions of Google Sheets

Grade Level: Middle School
Duration: 7 class periods
Materials Needed:

Computers with internet access
Google Sheets access
Projector/screen for presentations

Learning Objective

Students will collaboratively explore and demonstrate key features of Google Sheets including formulas, data manipulation, formatting, and visualization. They will learn these features using peer-led tutorials. By the end of this unit, they will apply these skills to individually complete a comprehensive assignment that combines all the presented skills.

Lesson Outline

1. Introduction (Day 1)

Introduce project and explain goals
Discuss the importance of spreadsheet skills in real-world applications
Divide students into small groups; assign each group a Google Sheets skill area (e.g., formulas, charts/graphs, conditional formatting, collaboration tools, sorting and filtering data)

2. Research & Preparation (Day 2–3)

Students explore their assigned topic using tutorials, examples, and guided exploration
Each group prepares a short tutorial (5–7 minutes) to teach classmates
Teacher circulates to guide research and ensure accuracy
Groups produce a short practice activity that helps reinforce concepts

3. Peer Presentations (Day 4-6)

Each group presents their tutorial & practice activity to the class
Teacher provides feedback and clarifies misconceptions

4. Culminating Activity (Day 7)

Students complete a Google Sheets assignment that requires use of all skills presented (e.g., analyzing a dataset, creating a chart, using formulas, and formatting results)
Students work individually to demonstrate mastery