Supporting the effective use of ICT across the primary curriculum
www.ictopus.org.uk contact@ictopus.org.uk
Mathematics Ages 10 - 11: The Sheep Pen Introduction: This lesson is about problem solving. It is an investigation into the relationship between area and perimeter. The lesson uses a spreadsheet program to perform the calculations and the graphing facility to illustrate the results. Although this is a reasonably well publicised problem for solving on a spreadsheet, the follow-up activities listed below offer a number of further challenges to the more able pupils Resources • One computer per two children for group work, or one computer and a data projector for whole class work • Spreadsheet software (e.g. Excel) • Children may need paper and pencil to help them with their calculations. Less able children may also need a calculator and squared graph paper. Previous learning Children should have the ability to work out the area and perimeter of a rectangular shape They should know how to enter numbers into a spreadsheet. Learning Objectives • To recognise that shapes with the same perimeter may have different areas • To develop a strategy for solving the problem • To enter formulae into a spreadsheet • To use a spreadsheet to draw a graph. What to do Here is the scenario: Farmer Jones has to create a new grazing pen for his sheep. He has 144 metres of fencing and all the necessary posts. However, he also has a stone wall that he can use for one side of his pen, so he only has to worry about the other three sides. He is building a rectangular pen. How should he lay out this pen in order to give the sheep the maximum area to graze? What is the maximum area in square metres that the sheep can have and what will be the dimensions of the pen? Initially the children may think that it makes no difference. They could try to complete a table like the one shown below. Width (metres) 1 2 5 10 20
Length (metres)
Perimeter (mtrs)
Area (sq metres)
This should help to illustrate that the area does change despite the fact that the perimeter is the same. The next stage is to try to produce a formula that gives the length. Some children will be able to articulate how they have worked out the length, without necessarily expressing the calculation as algebraic formulae. Lead them to the idea that the length = 144 – 2 x width. Then move them on to the spreadsheet. The children set this up in a very similar fashion to the above table. In © ictopus ltd
lessons2go
Maths Ages 10 - 11: Sheep Pen 2010