This module provides an overview of the fundamentals of Microsoft Excel, including relative and absolute cell references, common functions, and formatting.
Unit: Using Formulas and Functions
In this unit, students will learn about: Microsoft Excel formulas including relative and absolute cell references, Autofill, common functions, and the IF function.
1. A Pancake Recipe (Part 1)
2. A Pancake Recipe (Part 2)
3. 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 and custom criteria.
1. Sorting a Membership List
2. Filtering an Employee List
Unit: Formatting in Excel
In this unit, students will learn about: formatting and conditional formatting in Excel as they make an existing spreadsheet more visually appealing.
1. Overdue Library Books
2. Make It Look Great
Project: Who's Who - Age is Only a Number
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. Read the "Who's Who Project Guide" for information.
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.
Project: Using an Excel Template
In this project, students will download a template and customize it based on a specific assignment selected by the teacher.