Business&ITCenter21: Google Sheets Fundamentals

Google Sheets Lesson Plans

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

 

Unit: Using Formulas and Functions


Description

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

Lessons

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

 

Unit: Data Management and Analysis


Description

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

Lessons

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

 

Unit: Formatting in Google Sheets


Description

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.

Lessons

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

 

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


Description

 

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.

Lessons

  1. Age is Only a Number
module-back-button.png
New call-to-action