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, and they will identify spreadsheet elements. They will learn how to insert, format, copy, and move cell data, and format columns and rows. They will also create tables and charts, and modify chart elements according to the spreadsheet data. Finally, they will be introduced to functions, formulas, and conditional formatting.

After completing the ICT Spreadsheet Essentials course, students will be able to:

  • Develop and apply fundamental spreadsheet skills, including identifying spreadsheet elements, navigating spreadsheets, inserting various data types, copying and moving data, formatting cells, sorting and filtering data, inserting and resizing columns and rows, merging cells, and applying shading and borders.
  • Demonstrate proficiency in using moderately complex spreadsheet tools such as tables and charts, including table ranges, creating tables, identifying chart types and components, creating charts, and modifying chart types to represent base data.
  • Demonstrate proficiency in using complex spreadsheet tools such as formulas and functions, including using spreadsheet functions, inserting common spreadsheet formulas, absolute vs. relative cell references, and conditional formatting.

Course Table of Contents

Lesson 1: Introduction to Spreadsheets

BELL RINGERS

  • Spreadsheet Basics
  • Creating and Managing Spreadsheet Data
  • Sorting and Filtering Spreadsheet Data
  • Formatting Cells, Columns and Rows

ACTIVITY:

  • Spreadsheet Match
  • Create a Spreadsheet
  • Sorting Spreadsheet Data
  • Filtering Spreadsheet Data
  • Modifying Columns and Rows
  • Formatting Spreadsheets
  • Lesson 1 QUIZ

Lesson 2: Working with Charts and Tables

BELL RINGERS

  • Creating Tables
  • Utilizing Spreadsheet Charts

ACTIVITY:

  • Charts and Tables Word Search
  • Creating a Table
  • Charts and Tables Crossword
  • Creating a Column Chart
  • Creating Tables and Charts
  • Modifying Advanced Chart Options
  • Lesson 2 QUIZ

CASE STUDY:

  • Purchasing a New Tablet

Lesson 3: Working with Formulas and Functions

BELL RINGERS

  • Exploring Common Spreadsheet Functions
  • Using Common Spreadsheet Formulas
  • Working with Conditional Formatting

ACTIVITY:

  • Lesson 3 QUIZ
Close Window
Previous
Next