Unit 5D: Introduction to spreadsheets Section 4: SHORT FOCUSED TASKS
Objectives
Children should learn:
technique: to use 'SUM' to calculate the total of a set of numbers in a range of cells
Activities
Outcomes
Children:
Remind the class how '=c1+c2+c3+c4+c5+c6' produces a total. Discuss the amount of typing required. Introduce the use of '=SUM(c1:c2)' as a shorter way of producing totals. Ask the children to use 'SUM' to calculate the total cost of a meal.
use 'SUM'
Points to note
Stress the importance of brackets.
Some children will find it easier to add columns than rows.
This unit is divided into sections. Each section contains a sequence of
activities with related objectives and outcomes. You can view this unit by
moving through the sections or print/download the whole unit.
