Lesson plan: Adding up with formulas
Subject: Introduction to spreadsheets
Teacher: Hannah Doyle
Group: Adult beginners, 14 learners
Date: 12 October 2027
Length: 90 minutes
What learners already know
How to open a file and type in a cell.
Learning aims
By the end of the lesson, learners can:
Write a formula that adds a column of numbers
Copy a formula down a column
Fix a formula that shows an error
Materials and equipment
Laptops with the spreadsheet app
Practice file 'Shop sales'
Projector
Printed step sheet
Activities
0 to 10 min: Warm-up. Learners name where they see totals in daily life.
10 to 30 min: Demonstrate adding with the SUM formula, then learners try with the practice file.
30 to 40 min: Break.
40 to 65 min: Pairs build the total for each shop and copy the formula.
65 to 80 min: Find and fix three formula errors.
80 to 90 min: Recap and exit question.
Checking learning
Walk round and look at screens. Exit question: 'What does the equals sign start in a cell?'
Support and stretch
Learners who need support get the step sheet and work with a partner. Quick finishers add a percentage column.
Follow-up
Practise with the household budget file. Bring one question next week.
Notes for next time
Timer ran short; move the pair task earlier next time.