Advisory Service KentRenewed Framework Excel Resources

Back to Renewed Framework page

Download this page (pdf)

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…

Gateshead LEA have produced ITP Lesson Plans

Title

Excel Image

Key Stage

Detail

+/- Flashcards

screenshot

Key Stage 1 & 2

Develops knowledge of the relationships between + and – (inverse)

4 Numbers

screenshot

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.

screenshot

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.

screenshot

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. 

screenshot

Key Stage 1 & 2

+/- 1, 10 & 100 to a range of numbers. Predict outcomes.

+/- Missing Number or Sign

screenshot

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

screenshot

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

screenshot

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

 

screenshot

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

screenshot

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.

screenshot

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

 

screenshot

Key Stage 2

These 3 spreadsheets develop finding percentages of amounts and discounts.

Carroll Diagram (Year 2)

screenshot

Year 2-Lower KS2

Sort shapes and numbers with two criteria.

Carroll Diagram

screenshot

Key Stage 1 & 2

This builds on the previous Carroll Diagram spreadsheet and extends to two criteria for shapes and numbers.

Complements

 

screenshot

Key Stage 2

Complements to 1, decimals to 10 and 10 pounds (choose a time limit to answer – great for mental recall!)

 

Converting Measures

screenshot

Key Stage 1 & 2

Converting g/kg and mls/l using a counting stick.

Converting Units of Measure

screenshot

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

screenshot

Key Stage 1

Develops plotting coordinates using one quadrant of numbers and letters.

Counting Over Boundaries

screenshot

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

screenshot

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

screenshot

Key Stage 2

Reveal some of the empty boxes to create ‘missing number’ calculations with decimals.

Decimal Target Board

screenshot

Key Stage 2

Add up columns, rows or pairs of decimals to create a total.

Number Grid Generator

screenshot

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

screenshot

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

screenshot

FS &

Key Stage 1

Allows you to estimate from up to 15 to up to 127 stars!

FDP Converter

screenshot

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

screenshot

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

screenshot

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

screenshot

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?

screenshot

Key Stage 2

Choose one of the many line graphs and a title to ‘tell the story of the graph’.

Fractions of Amounts Problems

screenshot

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

screenshot

Key Stage 2

Converts most fractions into a percentage.

Fractions of Amounts

screenshot

Year 2 (Level 3) to Key Stage 2

Allows you to find fractions of smaller quantities.

Fractions

screenshot

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

screenshot

Key Stage 2

A fantastic reasoning activity. Children are given a series of clues to find the ‘mystery number’.

Guess My Shape/Number

screenshot

Key Stage 2

As above with an additional page using the same idea to guess a mystery shape.

Number Grid Generator – 4 digits

screenshot

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

screenshot

Key Stage 1 & 2

Choose a start number, column size and increment for an increasing number sequence.

Making Amounts of Money

screenshot

Key Stage 1 & 2

Create an amount using different types of coins or find the totals of different coins used.

Make Numbers

screenshot

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

screenshot

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?

screenshot

Key Stage 1 & 2

Select a start and end number for your number line and find the midpoint

Miles/km

screenshot

Key Stage 2

Conversion graph of miles into km and vice versa.

Money Problems

screenshot

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

screenshot

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

screenshot

Key Stage 1 & 2

An interactive multiplication grid.

Multiplication and Division Facts (2 & 5)

screenshot

Key Stage 1

An ‘empty box’ reasoning activity surrounding the tables 2 & 5.

Multiplication and Division Facts 2-6 and 20-60

screenshot

Key Stage 1 & 2

An ‘empty box’ reasoning activity surrounding the tables 2-6 and 20-60.

Multiplication and Division Facts 2-6

screenshot

Key Stage 1 & 2

An ‘empty box’ reasoning activity surrounding the tables 2-6.

Multiplication and Division Facts

screenshot

Key Stage 2

An ‘empty box’ reasoning activity surrounding the tables to 10.

Multiplication and Division Trios

screenshot

Key Stage 1 & 2

Interactive tables trios.

Multiplication and Division with Partitioning

screenshot

Key Stage 2

Develops multiplication and division calculations with strategies to partition them.

Multiplication and Division Facts – Mixed Decimals

screenshot

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)

screenshot

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

screenshot

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

screenshot

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

screenshot

Key Stage 1 & 2

Allows children to explore the ‘related facts’ from simple calculations.

Pie Chart

screenshot

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

screenshot

Key Stage 2

Contains the Pie chart spreadsheet above as well as number sequence starters and the Fraction to % converter.

Place Value Dots

screenshot

Key Stage 1 & 2

Represents numbers visually. The hundreds, tens and ones are given a different colour.

Place Value Charts and Partitioning Tool

screenshot

Key Stage 1 & 2

A great tool to create numbers using place value from whole numbers to decimals to 3d.p.

Prime Factors

screenshot

Key Stage 2

A useful tool to find prime factors as well as have lots of practice with random numbers.

Probability

screenshot

Key Stage 2

Probability activities involving coloured cube selection and dice throwing.

Problems Year 3

screenshot

Key Stage 2

Adjustable problems involving division.

Real Problems 1

screenshot

Key Stage 2

Adjustable problems involving multiplication.

Rounding Decimals

screenshot

Key Stage 2

An excellent tool to round decimals up to 3d.p.

Rounding

screenshot

Key Stage 2

As above only with the additional feature of rounding whole numbers.

Sequences

screenshot

Key Stage 2

Develops reasoning – guess the sequence as numbers are revealed (whole numbers to decimal sequences)

Shape Puzzle

screenshot

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

screenshot

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

screenshot

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

screenshot

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

screenshot

Key Stage 1

Three numbers total 20. What are they? The spreadsheet also extends beyond 20.  A great reasoning activity.

Multiplication and Division Flashcards

screenshot

Key Stage 2

Multiplication and Division trios using larger numbers and listing all the facts from the arrangement.

Number Line Counting

screenshot

Key Stage 1 & 2

A simple number line generator. Select a start number of your choice.

Three Monkeys

screenshot

Key Stage 2

An excel spreadsheet of the mathematical challenges investigation ‘Three Monkeys’.

Which Number Where

screenshot

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.

Kent County Council logo. Link to web site
spacer

[ Contact Us ]

© Kent County Council 2004 | Site Template Designed by EIS, Maidstone
Kent NGfL, Oxford Road, Maidstone, ME15 8AW. Tel: 01622 672779 Fax: 01622 663591