Basics of using Google Sheets
Free to teach as-is — the teacher guide, student handout, and slides are included.
Free — we'll email you an access link. Google Docs format.
Objective
I can use Google Sheets to organize data and perform basic calculations.
Part 1 of 3
Key concepts
3 concepts
- 1
Google Sheets is a powerful online tool that helps you organize information and perform calculations using cells arranged in rows and columns.
- 2
To make your data clear and easy to read, you can format cells by changing the font, adding colors, or putting borders around them.
- 3
All formulas in Google Sheets start with an equals sign (=), and you can use built-in functions like SUM() or AVERAGE() to simplify calculations.
Part 2 of 3
Practice
7 questions
What is the primary purpose of Google Sheets, as described in the reading passage?
In Google Sheets, what are the individual 'boxes' where you can type data called?
Part 3 of 3
Exit ticket
Quick comprehension check
“Imagine you are using Google Sheets to track the number of books read by three students: Alex, Ben, and Chloe. Alex read 15 books, Ben read 12 books, and Chloe read 18 books. Describe how you would organize this data in a simple way using cells and columns. Then, write the formula you would use in a separate cell to calculate the total number of books read by all three students.”
Sample answer included in the free materials
Get the materials
Teacher guide, student handout, and slides — free, in Google Docs format
Teacher Guide
Complete lesson plan with answer keys and alternate activities
Student Handout
Printable worksheet
Slides
Ready to present
We'll ask for your email to send your access link — nothing else.
Teaching a group at a different level?
Where are your students right now? We'll rebuild this lesson to match — including the teacher guide, student handout, and slides, saved to your Google Drive.
Adapt This Lesson