Unit 6B: Spreadsheet modelling Section 2: SHORT FOCUSED TASKS
Objectives
Children should learn:
technique: to identify formulae and enter them into a spreadsheet
Activities
Outcomes
Children:
Remind children how to enter a formula into a spreadsheet, such as '=c2/c3'. Ask the children to identify the formulae they would need to enter to calculate:
the area of a rectangle;
the perimeter of a rectangle.
Ask the children to set up a spreadsheet to work out the area and perimeter of a rectangle. The length and width of the rectangle should appear so that the values can be changed.
Ask the children to explore what happens when the data in the two cells is changed.
identify and enter the correct formulae into cells, modify the data, make predictions of changes and check them
Points to note
Children who find the work difficult could be given a prompt sheet showing cell references.
More able children could try more complex formulae such as '=2*(10-c2)' to find the lowest values.
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.
