Google Sheets Fundamentals

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