Creating a Workbook in 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 create a workbook in Google Sheets by entering data into cells and formatting them.
Part 1 of 3
Warm-up video
Unknown Channel · 5:00
We don't generate video — this one is by Unknown Channel on YouTube. The practice questions and exit ticket below were drafted by AI for this objective, and every question is editable in the teacher guide.
Part 2 of 3
Practice
5 questions
Describe the steps you would take to create a new Google Sheets workbook from a template.
What information would you need to enter into the gradebook template to track student performance effectively? Provide an example of the type of data you would include.
Part 3 of 3
Exit ticket
Quick comprehension check
“Create a new Google Sheets workbook and enter the following data into the first three cells of the first column: "Student A," "Student B," and "Student C." Then, format these cells to be bold and centered. Describe the steps you took to complete this task. In a new Google Sheets workbook, enter the following grades into the first three cells of the second column: 85, 90, and 78. After entering the data, format these cells to have a light green background color. Describe the steps you took to complete this task.”
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
