Skip to main content

Google Sheets Fundamentals

Google SheetsThis module provides more information and activities with Google Sheets, involving relative and absolute cell references, functions, and spreadsheet formatting.

Start My Curriculum Trial

Unit: Using Formulas and Functions


In this unit, students will practice entering formulas, learn about relative and absolute cell references and practice using functions.


  1. A Pancake Recipe (Part 1)
  2. A Pancake Recipe (Part 2)
  3. Coffee Shop Inventory
  4. Quiz


Unit: Data Management and Analysis


In this unit, students will learn about: sorting in ascending and descending order, sorting based on multiple criteria, and filtering using column entries.


  1. Sorting a Membership List
  2. Filtering an Employee List
  3. Quiz


Unit: Formatting in Google Sheets


In this unit, students will learn about: using data and character formats to make spreadsheets look great as they hide and unhide columns, change cell formats, merge cells, add cell borders, and format text using conditional formatting.


  1. Overdue Library Books
  2. Make It Look Great
  3. Quiz


Reinforce Project: Who's Who - Age is Only a Number



In this project, students research and calculate the exact age of each person. Students then calculate the youngest, oldest, and average age. They also calculate the age difference between the teacher and these.

This project is part of a larger group of projects based around a single theme about well-known people. Prior to beginning any of the projects, students need to generate a list of well-known people in a profession or area of life.


  1. Age is Only a Number


Start My Free Curriculum Trial

Back to Catalog