Active learning ideas
The true power of spreadsheets lies in their ability to perform calculations automatically. This topic introduces students to basic formulas and built-in functions like SUM and AVERAGE. This is a core component of the Leaving Certificate Applied ICT syllabus, focusing on practical mathematical applications in a digital environment.
Activity 01
In pairs, one student writes a simple math problem (e.g., 10 + 20) and the other must write the corresponding spreadsheet formula using cell references.
How do we start a formula?
Activity 02
Groups are given a list of expenses. They must use the SUM function to find the total and the AVERAGE function to find the mean spend per day.
What is the SUM function?
Activity 03
Students create a simple sales sheet. They then change one price and observe how all the totals update automatically, explaining the process to a partner.
How do we calculate an average?
A few notes on teaching this unit
Watch Out for These Misconceptions
Typing numbers directly into formulas (e.g., =10+5) instead of using cell references.
Show what happens when the original data changes. A 'Dynamic vs Static' demonstration helps students see why cell references (e.g., =A1+B1) are superior.
Forgetting the equals sign (=) at the start of a formula.
Explain that the equals sign tells the computer to 'do math' rather than just display text. A quick 'Formula or Text?' sorting game can reinforce this.
Methods used in this brief