Renewed Framework Excel Resources
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 | ![]() | 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 |