Spreadsheets

This spreadsheet is designed to help pupils apply their knowledge of number facts. Totals of numbers are revealed and pupils can use their knowledge of facts to reason which facts would satisfy the totals vertically and horizontally. Pupils can describe how the problem was solved orally or, where appropriate, in writing.

This guidance is to support the use of the mathematics spreadsheet: 4 numbers. How to use the spreadsheet and key questions and prompts are outlined.

This resource explores what happens when the same calculation is carried out on a set of numbers. Children can predict what happens.

This spreadsheet randomly displays a calculation using one of the four operations: addition, subtraction, multiplication or division. The numbers or the signs can be hidden and pupils can use their knowledge of facts to reason which numbers or signs would make the calculation correct.

This spreadsheet can be used to add or subtract 1, 10, 100 and 1000 from a number. Children can develop their understanding of place value as well as their ability to predict outcomes.

This spreadsheet randomly displays a calculation using addition and subtraction. The numbers or the signs can be hidden and pupils can use their knowledge of facts to reason which numbers or signs would make the calculation correct.

This spreadsheet can be used with either a 'set' grid or as a grid with 'random numbers'. Rows and columns can be added to create different totals and to explore addition facts.

This spreadsheet can be used to consolidate pupils’ understanding of the relationship between addition and subtraction. Pupils can be given an addition calculation and then asked to predict the addition calculation and two subtraction calculations that make up the 'family'. Different tabs display different ranges of numbers.

This program allows the exploration of 'families' of calculations and the inverse relationship between addition and subtraction.

This spreadsheet randomly generates a four by four addition grid that can be used to rehearse the pupils’ knowledge of addition and subtraction facts up to and including 10 & 10 and 100 & 100. It can be used to develop reasoning skills.