Unit: Using Formulas and Functions
In this unit, students will practice entering formulas, learn about relative and absolute cell references and practice using functions.
- A Pancake Recipe (Part 1)
- A Pancake Recipe (Part 2)
- Coffee Shop Inventory
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.
- Sorting a Membership List
- Filtering an Employee List
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.
- Overdue Library Books
- Make It Look Great
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.
- Age is Only a Number