Spreadsheet Essentials
– Communication Technology Domain –
The ICT Spreadsheet Essentials course focuses on fundamentals of creating and using spreadsheets. Students will:
- Learn about the purpose of spreadsheets
- Identify spreadsheet elements
- Learn how to insert, format, copy and move cell data, and format columns and rows
- Create tables and charts, and modify chart elements according to the spreadsheet data
- Learn functions, formulas and conditional formatting
Course Table of Contents
Lesson 1: Introduction to Spreadsheet
LESSON SECTIONS
- Spreadsheet Basics
- Creating and Managing Spreadsheet Data
- Sorting and Filtering Spreadsheet Data
- Formatting Cells, Columns and Rows
- Printing Your Spreadsheet
SUGGESTED ACTIVITIES
- Spreadsheet Terms (Online)
- Spreadsheet Matching (Hands-On)
- Create a Spreadsheet (Hands-On)
- Sorting Spreadsheet Data (Hands-On)
- Filtering Spreadsheet Data (Hands-On)
- Modifying Columns and Rows (Hands-On)
- Formatting Spreadsheets (Hands-On)
LESSON 1 QUIZ
Lesson 2: Working with Charts
LESSON SECTIONS
- Utilizing Spreadsheet Charts
SUGGESTED ACTIVITIES
- Charts Crossword (Hands-on)
- Charts Word Search (Hands-on)
- Creating a Column Chart (Team)
- Creating Data Charts (Hands-on)
- Modifying Advanced Chart Options (Hands-on)
- Chart Terms (Online)
CASE STUDY
- Purchasing a New Tablet
LESSON 2 QUIZ
Lesson 3: Working with Formulas and Functions
LESSON SECTIONS
- Using Common Spreadsheet Formulas
- Exploring Common Spreadsheet Functions
- Working with Conditional Formatting
CASE STUDY
- Expense Analysis