Active learning ideas
Formulas and functions are the 'engine' of a spreadsheet, allowing for automated and accurate calculations. This topic introduces 6th Year students to the basics of spreadsheet math, starting with simple formulas and moving to built-in functions like SUM and AVERAGE. They learn the power of cell referencing, which ensures that their calculations update automatically when data changes.
Activity 01
Divide the class into 'Expert Groups' for different functions (SUM, AVERAGE, MIN, MAX). Each group masters their function and then rotates to teach it to other students using a provided data set.
How does a formula begin in a spreadsheet?
Activity 02
Groups are given a budget spreadsheet and must use formulas to see how a 10% increase in costs would affect the total. They must use cell references so that the whole sheet updates automatically.
What is the difference between a formula and a function?
Activity 03
Students are given a task (e.g., adding 50 numbers) and must decide whether to use a manual formula or a built-in function. They discuss the pros and cons of each in pairs before sharing with the class.
How can cell referencing save time?
A few notes on teaching this unit
Watch Out for These Misconceptions
You should type the actual numbers into the formula (e.g., =10+20).
Formulas should use cell references (e.g., =A1+B1) so they update automatically if the data changes. A 'live update' demonstration quickly shows why cell referencing is superior.
The SUM function is only for adding two numbers.
SUM is designed to add large ranges of cells quickly. Peer-led races to add a long column of numbers using a formula vs. a function can highlight the efficiency of functions.
Methods used in this brief
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.
8 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.
8 methodologies