Rob is a maths teacher with many years of experience. He does lots of clever things with Excel spreadsheets to help him teach.
Following hours of work to create these resources he has agreed to share some of them with other teachers on TES.

Rob is a maths teacher with many years of experience. He does lots of clever things with Excel spreadsheets to help him teach.
Following hours of work to create these resources he has agreed to share some of them with other teachers on TES.

Creates a complete times tables bingo game (2x to 12x).
Generates a list of random questions and a set of 33 bingo cards randomised each time.
UPDATED: Now ensures no repeated numbers in the cards or in the answers to questions.

Randomised worksheet generator for column addition. Allows for assessment of students followed by nine different levels of addition problems. Starting at two 2-digit numbers requiring no carries up to two 4-digit numbers with carries. (Updated for new KS2 SATs requirements)
The worksheet automatically produces an answer sheet showing correct working too.
It is suitable for students between the ages of 7 and 16 who need graduated practice in addition. This sheet will generate worksheets for class work or homework.

Randomised worksheet generator for short bus stop division. Allows for assessment of students followed by seven different levels of division problems. Starting at 2-digit numbers divided by 1-digit numbers with no remainders up to 4-digit numbers divided by 11 or 12 with remainders.
The worksheet automatically produces an answer sheet showing correct working too.
It is suitable for students between the ages of 7 and 16 who need graduated practice in division. This sheet will generate worksheets for class work or homework.

Many schools ask parents to fill in the Ofsted Parent View questionnaire once per year.
This spreadsheet analyses Ofsted Parent View questionnaires and produces a parent-view style set of graphs and a numerical grid by year group.
Useful for discussions with Governors, LA, MAT or as data for Ofsted.

Colour-coded fraction and percentage wall. Covers all fractions from 1 whole to 10 tenths.
Also has 100%, 50%, 33 1/3%, 25%, 20%, 12.5%,10% (Percentage colour matches fraction colour)
Useful for display, sticking in books, printing on card and cutting up to make manipulatives or for reference on desks.

Randomised worksheet generator for column subtraction. Allows for assessment of students followed by six different levels of subtraction problems. Starting at two 2-digit numbers requiring no borrowing up to two 5-digit numbers with borrows.
The worksheet automatically produces an answer sheet showing correct working too.
It is suitable for students between the ages of 7 and 16 who need graduated practice in subtraction. This sheet will generate worksheets for class work or homework.
Updated for new KS2 Maths Curriculum.

Randomised worksheet generator for column multiplication. Allows for assessment of students followed by six different levels of multiplication problems. Starting at 1-digit x 2-digit numbers requiring no carries up to 3-digit numbers x 2 digit numbers with carries.
The worksheet automatically produces an answer sheet showing correct working too.
It is suitable for students between the ages of 7 and 16 who need graduated practice in multiplication. This sheet will generate worksheets for class work or homework.

Creates a sample SATs Paper 1 (Calculations) for Year 3 students, formatted in the SATs paper style. Also produces answer sheet showing working (for questions with working marks).
Produces random questions covering the Year 3 mathematics National Curriculum. Topics covered include fractions (adding, subtracting, unit fractions of an amount), adding, subtracting, multiplying and dividing integers, sequences (counting up and down), simple time questions and place value (missing numbers, value of digits).
Set to produce 30 random questions each time (can be adjusted to suit).
This was specifically written to the specification of the new Year 3 NC with 37 different types of questions.

Displays random selection of questions covering the Number sections of the NEW GCSE maths specifications. With separate selections for Foundation (over 100 question types) and Higher (over 90 question types) the sheet has questions on Primes, Multiples (including LCM), Factors (including HCF), Square Numbers and Cubes. Indices, Fractions, Ratio, Proportion, Decimals, Multiplication, Division, Addition and Subtraction, Rounding and truncation (d.p., s.f. and nearest power of ten), Upper/Lower Bounds and surds.
Each question has randomised numbers, creating an (almost) infinitely different set of questions with solutions.
Can be used as a lesson starter or as a worksheet generator.
Perfect for GCSE revision in the run up to the exam.

Displays random selection of questions covering the Algebra sections of the new GCSE maths specifications. With separate selections for Foundation (over 40 question types) and Higher (over 80 question types) the sheet has questions on functions, coordinates, Solving (linear, quadratic and simultaneous), Re-arranging, Substitution, Factorising and expanding brackets, sequences (linear & quadratic), Inequalities (with answers in set notation) and algebraic fractions.
Each question has randomised numbers, creating an (almost) infinitely different set of questions with solutions.
Can be used as a lesson starter or as a worksheet generator.
Perfect for GCSE revision in the run up to the exam.
Version for Number also available separately.

All of the randomised worksheet generators.
Includes Column Addition, Column Subtraction, Column Multiplication and Bus-stop Division.
Each has an assessment worksheet and a set of targeted worksheets.
Gives answers for each worksheet including showing working (carries, borrows etc).
Subtraction and addition updated for new KS2 maths curriculum.

Displays six random questions covering the Number sections of the GCSE maths specifications. With separate selections for Foundation (9 question types) and Higher (9 question types).
This is a free sample version of the full starter generator.

Displays six random questions covering the Algebra sections of the GCSE maths specifications. With separate selections for Foundation (9 question types) and Higher (9 question types).
This is a free sample version of the full Algebra starter generator.

Enter the maximum mark for the test and this gives you a list of all the scores with the percentage calculated.
Works with tests up to a maximum of 200 marks.
Very useful to have on screen when marking tests. Saves hours of calculations.

Displays random selection of questions covering the Algebra sections of the GCSE maths specifications. With separate selections for Foundation (over 40 question types) and Higher (over 80 question types) the sheet has questions on coordinates, Solving (linear, quadratic and simultaneous), Re-arranging, Substitution, Factorising and expanding brackets, sequences (linear & quadratic), Inequalities and algebraic fractions.
Each question has randomised numbers, creating an (almost) infinitely different set of questions with solutions.
Can be used as a lesson starter or as a worksheet generator.
Perfect for GCSE revision in the run up to the exam.
Version for Number also available separately.
Written for Pre-2017 GCSE Maths Specification (Useful still for students retaking old spec).

Displays a random selection of questions covering the Year 3 mathematics National Curriculum. Topics covered include fractions (adding, subtracting recognising, ordering), counting up and down (tenths, ones and tens), adding, subtracting, multiplying and dividing numbers, ordering numbers, converting between units (mm/cm/m, g/Kg, l/ml), comparing units, simple time and place value (missing numbers, value of digits).
Set to produce 6 random questions each time and time how long students have been working on the questions. Gives answers to the questions. Can also be used to generate worksheets with up to 21 random questions.
This was specifically written to the specification of the new Year 3 NC with over 50 different types of questions.

Creates 33 different random bingo cards with Roman Numerals from 1 to 100 and random questions.
Everything you need for a fun game to reinforce and practice Roman Numerals from 1 to 100.

Displays random selection of questions covering the Number sections of the GCSE maths specifications. With separate selections for Foundation (over 100 question types) and Higher (over 90 question types) the sheet has questions on Primes, Multiples (including LCM), Factors (including HCF), Square Numbers and Cubes. Indices, Fractions, Ratio, Proportion, Decimals, Multiplication, Division, Addition and Subtraction, Rounding (d.p., s.f. and nearest power of ten), Upper/Lower Bounds and surds.
Each question has randomised numbers, creating an (almost) infinitely different set of questions with solutions.
Can be used as a lesson starter or as a worksheet generator.
Perfect for GCSE revision in the run up to the exam.
Written for Pre-2017 GCSE Maths Specification (Useful still for students retaking old spec).