ICT Essentials Suite

Spreadsheet Essentials
- Communication Technology Domain -

ICT Spreadsheet Essentilas

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

Lesson 3 Quiz

Close Window
Previous
Next