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
