Introduction to Spreadsheet Design
Information Technology · 6th Year · Data Handling with Spreadsheets · 3.º Período

Introduction to Spreadsheet Design

Students are introduced to the grid layout of spreadsheets, learning to enter data, adjust cells, and format worksheets. They will create basic tables for tracking information.

NCCA Curriculum SpecificationsLCA ICT Module 3: Spreadsheets, LO 1LCA ICT Module 3: Spreadsheets, LO 2

About This Topic

Students are introduced to the grid layout of spreadsheets, learning to enter data, adjust cells, and format worksheets. They will create basic tables for tracking information.

Key Questions

  1. What is the difference between a row and a column?
  2. How do we format cells for currency and dates?
  3. Why are spreadsheets useful in business?

More in Data Handling with Spreadsheets

Formulas and Functions

This topic covers the use of basic mathematical formulas and built-in functions like SUM and AVERAGE. Students will automate calculations within their data sets.

2 methodologies

Creating Charts and Graphs

Students learn to visually represent numerical data by generating pie charts, bar charts, and line graphs. They will format charts to ensure they are clear and accurately labelled.

2 methodologies