# Crunching numbers;Numeracy

There are several aspects of mathematics which do not get the attention in the Numeracy Strategy they deserve. One of these is investigational work. Children need to explore mathematics as well as follow the strategy's prescribed routes.

There are many ways in which you can use either specific software or a general spreadsheet program such as Excel to remedy this situation. For example, Maths Frames, from Semerc, is an excellent resource which can be used, even by inexperienced teachers, to help children explore areas of numeracy.

The program provides scenarios in which children can experiment. In the garden centre, for example, children could be asked to find out how much it would cost to germinate seeds or to investigate how a fixed budget could be spent to improve a garden (Ground Force beware!). The scenarios can be adapted to incorporate local data.

The many programs available from SMILE are also a rich source of ideas for investigating. The latest pack (Number 8) of MicroSmile for Windows, contains nine programs on numeracy. Programs, such as Number Lines and Ten Sprint will help children to develop strategies for applying their knowledge of numbers as well as practising number bonds.

Smile Pack 4 also contains programs not only to complement work on numbers, but also to develop pupils' ability to make predictions and explore relationships. Predict is, unsurprisingly, one such program, where children enter numbers and have to guess the rules that are being used by the program to produce the output. Define and Identify deal with the properties of numbers (odd, even, square and so on).

Although many of the programs in Maths Puzzles are familiar (Frogs, Tower of Hanoi and so on), they are a rich source of investigative work and lead to either an algorithm or a general rule.

Finally, you may well be competent enough to set up a spreadsheet, in Excel or similar programs. If not, it is fairly easy to learn how to do so, and there are several books which give examples of how to use spreadsheets in maths (for example, Mathematics Through Spreadsheets from the Mathematical Association).

A program like Predict is straightforward to produce. Set up a cell for the input number, enter a formula in the cell labelled for the output and then hide the formula. Or why not develop the skills of making and testing hypotheses by using a sheet in which a starting number and finishing number are given.

Pupils have to explore how to jump from the start to the end in a sequence and to find how many such sequences there are. This can, of course, be extended by using a different starting point.

Older or more able pupils can set up their own spreadsheets to explore situations like being asked to run a drinks stall at the summer fair. They will need to enter formulae to calculate costs and income, and can use the program to draw a graph showing the break-even point and profit made. Generating patterns such as Pascal's Triangle, the Fibonacci sequence or triangle numbers can be performed on a spreadsheet and children will benefit from learning how to do this themselves, because they will be forced to focus on the relationships between the numbers.

Ian Wilson

It only takes a moment and you'll get access to more news, plus courses, jobs and teaching resources tailored to you

## Latest stories

### 3 great teaching ideas from Trump’s impeachment

Donald Trump's impeachment offers a huge opportunity to enhance pupils' understanding of the world, writes Chris Lindop
Chris Lindop 19 Jan 2021

### School attendance now 5 times higher than 1st lockdown

New DfE figures reveal primary and secondary attendance rates last week were both five times higher than under the first lockdown
Dave Speck 19 Jan 2021

### Regional approach to school openings 'likely'

Schools could open more widely at different times in different areas, says deputy chief medical officer
Tes Reporter 19 Jan 2021

### Why parents need support with online learning

Getting pupils engaged in online learning isn't as simple as providing laptops – schools must reach out to parents, too
Grainne Hallahan 19 Jan 2021

### Teaching online is putting our eyesight at risk

Hours staring at a screen is damaging teachers' eyes, says Yvonne Williams – who offers some tips to reduce the strain
Yvonne Williams 19 Jan 2021

### How I found a way to teach life skills in lockdown

A teacher explains how his students found new skills amid Covid restrictions thanks to an innovative online competition
Darren Lim Jen Zen 19 Jan 2021

### Coronavirus and schools: LIVE 19/1

A one-stop shop for teachers who want to know what impact the ongoing pandemic will have on their working lives
Tes Reporter 19 Jan 2021

### Schools struggle with online SEND support, say teachers

SENCOs 'overwhelmingly' also report significant increase in workload during pandemic
Amy Gibbons 19 Jan 2021

### Lockdown shows why teachers need more preparation time

In-service weeks rather than in-service days could be the way ahead, says teacher Sammy McHugh
Sammy McHugh 19 Jan 2021

### One in four young people 'unable to cope with life'

Half of 16- to 25-year-olds say their mental health has worsened since the start of the pandemic, research shows
Tes Reporter 19 Jan 2021