Quality Assured
Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.

General

This selection of spreadsheets, designed by the Primary National Strategies to aid teaching and learning, tackles a variety of topics.

[b]4 numbers[/b] has a two by two grid with the sums of the columns and rows shown. The task is to find out what the numbers in the grid are. There are three levels of difficulty. Teacher guidance is included.

[b]Array creator[/b] enables the user to produce arrays (up to 20 x 18) of five different colours to model multiplication and division. Teacher guidance is included.

[b]Find the multiples[/b] gives six randomly generated numbers from which multiples of a given number have to be identified. The multiples of numbers from 2 to 99 can be selected.

[b]Flexible problems[/b] provides opportunity for practise of calculation strategies and application to solve two-step problems. Students are required to work out the cost of multiples of objects. The multiples can be specified or selected. There are versions with or without solutions.

[b]Guess my shape/number[/b] provides clues to help students work out which of the given shapes/numbers the program has secretly selected. Teacher guidance is included.

[b]Midpoint half way between[/b] can be used to develop skills of finding the midpoint between two numbers. The middle number can be hidden, and the level of challenge can be increased by changing the start and finish numbers. Teacher guidance is included.

[b]Missing number or sign[/b] shows a four operations calculation where all three numbers and the sign can be hidden or revealed.

[b]Patterns of calculations[/b] in addition and subtraction. There are three levels of difficulty, at the first level an addition sum with a hidden number is given and squares to visually support how to find the missing number, there are then further sums that follow a pattern. Further levels allow the starting number, the second number and the step change in the pattern to be selected.

[b]Prime factors[/b] has three parts. The first two generate a three or four digit number, which is then divided by the numbers 1 to 10, the answers can then be hidden or revealed to find the prime factors. The third part allows a number to be entered and then the answers to six division sums to be revealed, allowing testing for prime factors.

[b]Sequences[/b] provides opportunity to explore sequences with different start numbers and step sizes, presented on different grids.

[b]Shape puzzle y4[/b] is a selection of grids where shapes hide and represent numbers. The sums of the rows and columns are given.

[b]Sum, product, difference, quotient[/b] allows numbers to be generated and then the four functions to be revealed. Teacher guidance included.

[b]Three monkeys[/b] eat 25 or 24 nuts between them. The task is to work out all the possible even or odd number of nuts each monkey ate.

Please enable the macros to allow the resources to function correctly.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Downloads

Show downloads

Close

Download all files as a .zip807.77 KB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
Subject(s)Mathematics
Age5-7, 7-11
Published2000 - 2009
Published by

Collections
Direct URLhttps://www.stem.org.uk/rxwz4
RequirementsPlease enable macros

Actions

Add to favourites list

Share this resource