All the spreadsheets featured on this page, have been produced to support the Primary Framework and are available on the Primary frameworks website. They are a really useful resource for supporting mental oral work, calculation exploring patterns etc…
Title |
Excel Image |
Key Stage |
Detail |
+/- Flashcards |
 |
Key Stage 1
& 2 |
Develops knowledge of the
relationships between + and – (inverse) |
4 Numbers |
 |
Key Stage 1
& 2 |
Develops number bonds to
10, 20 & 50. |
4 Operations –
Missing Number or Sign
A basic calculation sentence generator which allow you to hide the individual numbers within the sentence, the operation or the answer. |
 |
Key Stage 1 |
Develops the ‘empty box’
with all 4 operations as well as just + and -. You can remove digits as well
as the operations. |
4 Operations
with Small Numbers
A flexible number grid which allows you to select numbers and multiply, subtract, add or divide. |
 |
Key Stage 1
& 2 |
Develops reasoning skills
around the ‘magic square’ using all four operations.
Deals with single digits to tens of thousands. |
+/- 1, 10 &
100
Take any number and add or subtract 1, 10, 100 or 1000. |
 |
Key Stage 1
& 2 |
+/- 1, 10 & 100 to a
range of numbers. Predict outcomes. |
+/- Missing
Number or Sign |
 |
Year 2 – KS2 |
Develops the ‘empty box’
with all 4 operations as well as just + and -. You can remove digits as well
as the operations – uses higher numbers. |
Addition Facts |
 |
Key Stage 1
& 2 |
Develops reasoning. This
is the ‘empty box’ on a larger scale looking at + facts to 10+10 and 100+10. |
Addition and
Subtraction Number Sentences
A simple number sentence generator which focuses on families of number facts.
Hide or reveal part of the number sentence |
 |
Key Stage 1
& 2 |
Looks at the ‘empty box’
questions with smaller numbers, multiples of 10 and a mixture of 1 and
2-digit numbers |
Addition and Subtraction Trios
|
 |
Key Stage 1 |
Would be good used in
conjunction with +/- flashcards.
Looks at developing the
relationships between + and – (inverse). |
Addition of 1
& 2-digit numbers |
 |
Key Stage 1
& 2 |
Can be used as a target
board to develop addition facts. Add columns and rows to create different
totals. |
Array Creator
Makes arrays from a range of 5 colours. |
 |
Key Stage 1
& 2 |
This spreadsheet allows
you to create your own arrays. Also good to use for ratio and proportion,
e.g. for every 3 yellow counters there are 4 red counters. |
Calculating
Percentages
|
 |
Key Stage 2 |
These 3 spreadsheets
develop finding percentages of amounts and discounts. |
Carroll Diagram
(Year 2) |
 |
Year 2-Lower
KS2 |
Sort shapes and numbers
with two criteria. |
Carroll Diagram |
 |
Key Stage 1
& 2 |
This builds on the
previous Carroll Diagram spreadsheet and extends to two criteria for shapes and
numbers. |
Complements
|
 |
Key Stage 2 |
Complements to 1, decimals
to 10 and 10 pounds (choose a time limit to answer – great for mental
recall!)
|
Converting Measures |
 |
Key Stage 1
& 2 |
Converting g/kg and mls/l
using a counting stick. |
Converting
Units of Measure |
 |
Key Stage 1
& 2 |
A great conversion tool
for all units of measure. Includes two pages of problems (amounts can be
changed) involving the conversion of measures – KS2 level. |
Coordinate
Cells |
 |
Key Stage 1 |
Develops plotting
coordinates using one quadrant of numbers and letters. |
Counting Over
Boundaries |
 |
Key Stage 1
& 2 |
Develops the skills of
counting over different boundaries of whole numbers and decimals by adding on
different quantities. A great mental recall tool as you can time responses. |
Counting Stick
with Further Options |
 |
Key Stage 1
& 2 |
Covers whole number, decimal, percentages, fractions, conversions and time. Allows you to set the start
number and increment of the counting stick before choosing a measure for
conversion. Includes time and FDP. |
Decimal
Addition and Subtraction Facts |
 |
Key Stage 2 |
Reveal some of the empty
boxes to create ‘missing number’ calculations with decimals. |
Decimal Target
Board |
 |
Key Stage 2 |
Add up columns, rows or
pairs of decimals to create a total. |
Number Grid
Generator |
 |
Key Stage 1 &
2 |
Allows you to create a
number grid of a variety of columns with a start number of your choice. |
Doubling and
Halving |
 |
Key Stage 1
& 2 |
Doubling and halving
activities for all year groups. A number is given and you can reveal its
double or half of it. |
Estimation |
 |
FS &
Key Stage 1 |
Allows you to estimate
from up to 15 to up to 127 stars! |
FDP Converter |
 |
Key Stage 2 |
Convert a mixed number
into a proper fraction, a decimal and a percentage!
Ideal for showing the connections between percentages, decimals, mixed numbers and improper fractions. Start from any of the above and alter them gradually using the sliders. |
Facts and Place
Value |
 |
Key Stage 2 |
Multiplication and
division facts are used in a ‘empty box’ context (using inverse) to solve the
problems. The place value comes from the related facts linked to the first
operation that may be 10/100 times more than the last number. |
Find the
Multiples |
 |
Key Stage 1
& 2 |
Choose a multiple first.
You will be then presented with 6 numbers. Which numbers are the multiples of
your chosen number? |
Flexible
Problems |
 |
Key Stage 1
& 2 |
Random and flexible money
problem generators. Hide or reveal the totals. Challenge the children by altering either the number or price of the objects.
A fantastic word problems resource! |
Flexible Line
Graph Story
What is the story behind the graph? |
 |
Key Stage 2 |
Choose one of the many
line graphs and a title to ‘tell the story of the graph’. |
Fractions of
Amounts Problems |
 |
Key Stage 2 |
Allows you to develop your
knowledge in finding fractions of amounts and then apply this to adaptable
word problems. |
Fraction
Percentage Equivalence |
|
Key Stage 2 |
Converts most fractions
into a percentage. |
Fractions of
Amounts |
|
Year 2 (Level
3) to Key Stage 2 |
Allows you to find
fractions of smaller quantities. |
Fractions |
 |
Key Stage 2 |
A great fractions
spreadsheet looking at FDP conversion on a counting stick, fractions of
amounts and also provides a handy fraction wall! |
Guess My Number |
 |
Key Stage 2 |
A fantastic reasoning
activity. Children are given a series of clues to find the ‘mystery number’. |
Guess My
Shape/Number |
 |
Key Stage 2 |
As above with an
additional page using the same idea to guess a mystery shape. |
Number Grid
Generator – 4 digits |
|
Key Stage 2 |
Builds on the first number
grid generator with a choice of your start number and columns but this time
decimals and larger numbers can be used. |
Increasing
Number Grid Generator |
|
Key Stage 1
& 2 |
Choose a start number, column
size and increment for an increasing number sequence. |
Making Amounts
of Money |
|
Key Stage 1
& 2 |
Create an amount using
different types of coins or find the totals of different coins used. |
Make Numbers |
|
Key Stage 1 & 2 |
Use one of the 4 operations
and select one number from grid A and another from grid B to create a
calculation (numbers to 20 – decimals to 2d.p.) |
Measures
Counting Stick |
|
Key Stage 2 |
Converts capacity measures
and also contains a conversion graph of m into km. |
Midpoint
Can you find the midpoint between two numbers? |
|
Key Stage 1
& 2 |
Select a start and end
number for your number line and find the midpoint |
Miles/km |
|
Key Stage 2 |
Conversion graph of miles
into km and vice versa. |
Money Problems |
|
Key Stage 1
& 2 |
Looks at the
multiplication of money and the later spreadsheets put this into the context
of a diner (ordering off a menu). |
Money Problems
2 |
|
Key Stage 1
& 2 |
Problem solving with
reasoning. Looks at the coins that could have made up an amount in a money
box. |
Multiplication
Grid |
|
Key Stage 1
& 2 |
An interactive
multiplication grid. |
Multiplication
and Division Facts (2 & 5) |
|
Key Stage 1 |
An ‘empty box’ reasoning
activity surrounding the tables 2 & 5. |
Multiplication
and Division Facts 2-6 and 20-60 |
|
Key Stage 1
& 2 |
An ‘empty box’ reasoning
activity surrounding the tables 2-6 and 20-60. |
Multiplication
and Division Facts 2-6 |
|
Key Stage 1
& 2 |
An ‘empty box’ reasoning
activity surrounding the tables 2-6. |
Multiplication
and Division Facts |
|
Key Stage 2 |
An ‘empty box’ reasoning
activity surrounding the tables to 10. |
Multiplication
and Division Trios |
|
Key Stage 1
& 2 |
Interactive tables trios. |
Multiplication
and Division with Partitioning |
|
Key Stage 2 |
Develops multiplication
and division calculations with strategies to partition them. |
Multiplication
and Division Facts – Mixed Decimals |
|
Key Stage 2 |
Develops the
multiplication of decimals using the reasoning and the ‘empty box’. |
Multiplication
and Division Facts (with a missing number or sign) |
|
Key Stage 1
& 2 |
Allows you to focus on
facts less than 7 or all facts to 10. Allows you to remove operations as well
as numbers. A good reasoning activity. |
Number Boards |
|
Key Stage 1
& 2 |
Creates a range of number
boards from time to measures to use as ‘target boards’ within the classroom
discussion. Useful for mental recall. |
Order Numbers
on a Number Line |
|
Key Stage 1
& 2 |
Allows you to place
numbers to 10, 20 and 100 on a number line depending on what the start and
end number is. Another great reasoning activity. |
Patterns in
Calculation |
|
Key Stage 1
& 2 |
Allows children to explore
the ‘related facts’ from simple calculations. |
Pie Chart |
|
Key Stage 2 |
Develops children’s
understanding of the segments of pie charts and their fractional value as
well as how much this is worth in relation to the overall amount the pie
represents. |
Pie Charts |
|
Key Stage 2 |
Contains the Pie chart
spreadsheet above as well as number sequence starters and the Fraction to %
converter. |
Place Value
Dots |
|
Key Stage 1
& 2 |
Represents numbers
visually. The hundreds, tens and ones are given a different colour. |
Place Value
Charts and Partitioning Tool |
|
Key Stage 1
& 2 |
A great tool to create
numbers using place value from whole numbers to decimals to 3d.p. |
Prime Factors |
|
Key Stage 2 |
A useful tool to find
prime factors as well as have lots of practice with random numbers. |
Probability |
|
Key Stage 2 |
Probability activities
involving coloured cube selection and dice throwing. |
Problems Year 3 |
|
Key Stage 2 |
Adjustable problems
involving division. |
Real Problems 1 |
|
Key Stage 2 |
Adjustable problems
involving multiplication. |
Rounding
Decimals |
|
Key Stage 2 |
An excellent tool to round
decimals up to 3d.p. |
Rounding |
|
Key Stage 2 |
As above only with the
additional feature of rounding whole numbers. |
Sequences |
|
Key Stage 2 |
Develops reasoning – guess
the sequence as numbers are revealed (whole numbers to decimal sequences) |
Shape Puzzle |
|
Key Stage 1
& 2 |
A simple calculation
puzzle – finding the value of a shape, becomes increasingly complex as you
progress through the pages to work on larger grids with more clues to solve! |
Sum, Product
& Difference |
|
Key Stage 2 |
Find the sum, product and
difference of two numbers or reveal the sum, product and difference to guess
the two numbers. Great for developing mathematical vocabulary. |
Target Practice |
|
Key Stage 1
& 2 |
Like ‘Countdown’. Create a
number to 99 or 999 using the 6 numbers given and any of the 4 operations. |
Timed Number
Bonds |
|
Key Stage 1
& 2 |
Number bonds to 10, 20,
100 and 1 (with 1 and 2d.p.) in a selected time limit. Great for mental
recall! |
Total 20s |
|
Key Stage 1 |
Three numbers total 20.
What are they? The spreadsheet also extends beyond 20. A great reasoning activity. |
Multiplication
and Division Flashcards |
|
Key Stage 2 |
Multiplication and Division
trios using larger numbers and listing all the facts from the arrangement. |
Number Line
Counting |
|
Key Stage 1
& 2 |
A simple number line
generator. Select a start number of your choice. |
Three Monkeys |
|
Key Stage 2 |
An excel spreadsheet of
the mathematical challenges investigation ‘Three Monkeys’. |
Which Number
Where |
|
Key Stage 1
& 2 |
An extension on the ‘empty
box’. This extends to three boxes (good for trial and improvement questions)
and becomes complex when the boxes begin to link together. |