Formulas and Functions
Information Technology · 6th Year · Data Handling with Spreadsheets · 3.º Período

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.

NCCA Curriculum SpecificationsLCA ICT Module 3: Spreadsheets, LO 3LCA ICT Module 3: Spreadsheets, LO 4

About This Topic

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.

Key Questions

  1. How does a formula begin in a spreadsheet?
  2. What is the difference between a formula and a function?
  3. How can cell referencing save time?

More in Data Handling with Spreadsheets

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.

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