Suffolkmaths Homepage
Enhancing the Teaching of Mathematics
These resources have been
compiled as a result of a group of teachers getting together
led by Charlie Dawson (HoD @ Northgate High)
Excel
is a much under used resource and in particular it can be used
for modelling a wide range of situations including statistical
graphs, reflection, statistical experiments, sampling for
coursework, investigating quadratics, simulating projectiles
and number puzzles amongst many others. The following
files are designed to inspire and to provide a starting point,
they are a resource and not part of a lesson plan, how you use
them is up to you. Some of the files require you to
press the F9 key to generate new data.
If you want to put together
your own interactive spreadsheets then Rob Simpson has put
together a tutorial to lead you through the process 
Click here
There are other sources of
Excel based resources which can be found at the bottom of
this page. 
Excel Tutorials
Niels Weterings has created
a website which offers a fully illustrated Excel tutorial + 300
examples 
Click here
Kasper Langmann and
Mikkel Sciegienny have created a superb blog about Excel
with clearly explained tutorials for those wishing to optimise
their own use of this excellent program

Click here 
Number
Calculation

BIDMAS  Charlie Dawson
Simple two step
BIDMAS problems, where you can hide or reveal the
first step to help support learning

Multiplication Game

Rob Simpson
www.mathsit.org.uk
An interactive multiplication game for two players.
This game is played on an interactive whiteboard.
Hit the answer to the multiplication question before
your opponent and score a point. Get one wrong and
lose a point! Settings available to customise
questions.

Multiplication
Grid Puzzles  Rob Simpson
www.mathsit.org.uk
Produces random grid puzzles to solve. Choose the
range of numbers and the operation.

Times Tables  Mark
Greenaway
Randomly generated times tables grids, answers can
be revealed a row at a time.

Number Target Boards 
Mark Greenaway
& Charlie Dawson
A range of boards for use as a focus for questioning
 Press F9 for a new board

Number Line
 Rob Simpson
www.mathsit.org.uk
An interactive number line. Change the start and end
values or change the interval. Show/hide the numbers
on the line.

Negative number line
 Rob Simpson
www.mathsit.org.uk
Show negative numbers moving up and down a number
line. Show/hide the numbers and/or their position on
the number line.

Calculating with Negatives  Charlie Dawson
Using the four rules with negative numbers, choice
of operation or mix of operations (Number Tab at
bottom)  hide and reveal
facility

Long Multiplication
 Mark Greenaway & Charlie Dawson
This spreadsheet solves long multiplication problems
in 4 different ways.
Fractions, Decimals,
Percentages and Ratio

Percentages Spider
 Mo Ladak & Mark Greenaway
Calculate a range of percentages that you choose of
a number that you select. Hide/reveal the
answers.

Percentage Problems
 Charlie Dawson
Percentage of and Percentage Increase/Decrease
problems with the ability to hide/reveal.

Fractions  Charlie
Dawson
The four rules using Fractions  hide/reveal steps
in the working out

Fractions, Decimals & Percentages  Charlie
Dawson
three levels of difficulty when converting between
FD&P  Hide and Reveal values

Fractions ratios decimals and percentages  Rob
Simpson
www.mathsit.org.uk
Compare equivalent fractions, ratios, decimals and
percentages. Change a grid of squares to represent a
proportion. Show or hide the fractions, ratios,
decimals and percentages.

Fractions Grid  Mark Greenaway
Adjustable grid from 1 by 1 up to 10 by 10, user can
colour in cells in a choice of 4 colours

Percentage increase and decrease  Rob Simpson
www.mathsit.org.uk
Use and find percentage increase and decrease,
including reverse percentage problems. Show/hide any
of the values.

Successive Percentage Changes
 Rob Simpson
& Mo Ladak
This allows you to explore the effect of two
successive percentage changes

Ratios  Mark Greenaway
Splitting amounts into ratios, randomly generated
different levels of difficulty and with the ability
to hide/reveal different values

Ratios  Charlie Dawson  Alternative
Version to the one above

Ratios  Mark Greenaway
As with the file above but split into 2 or 3 pieces
given total or an individual amount

Proportional
Reasoning  Mark Greenaway
Grid as used for conversions, compound measures
etc... Hide/reveal one value and/or multiplier
Place Value

Rounding  Rob Simpson
www.mathsit.org.uk
Round numbers to
nearest 100, 10, 1, 0.1 ... Represent the number on
a number line. Show which digit is important in
deciding whether to round up or down. Show/Hide
digits.

Rounding  Charlie Dawson
Rounding
numbers to a certain number of decimal places or
significant figures

Times & Divide by Powers of 10  Mark
Greenaway
You select a start number and then identify either
the operations or the resulting number, with the
ability to hide/reveal cell values

Times & Divide by Powers of 10
 Mark Greenaway
You set the upper and lower values on a number line
split into 10 equal parts. Each of the two
sheets has 3 additional parallel number lines (x10,
x100, x1000 and divide) Hide/Reveal any of the
numbers on the 4 parallel number lines

Estimation  Mark Greenaway
Would make a good introduction to the Golf Courses
above. Requiring only multiplication to score
a goal if the answer is within limits you can set.

Standard Form 
Charlie Dawson
Randomly generated Standard Form conversions with
the ability to hide/reveal the normal form or either
part of the standard form.
Other Number Work

Multipliers
 Rob Simpson
www.mathsit.org.uk
Use and find multipliers from one number to another.
Randomly selects original number and multiplier
according to user settings. Show/hide different
values.
 Trial and
Improvement 
Wentworth
Troon
Belfrey
Augusta 
Charlie Dawson
Four Golf Courses, each comprising 18 holes where
you have to find the answer to a problem within
given limits. In order of difficulty starting
with the easiest.

Loans
& Savings Calculator

Mark Greenaway
Explore the effect of different interest rates,
amounts loaned or payments made when you have a
mortgage or a credit card. Plus how long will
it take to save up for ...

Number Bases  Mark
Greenaway
This coverts between number bases and calculates in
any number base (+,  or x)

Algebra
Expressions

Substitution  Charlie Dawson
Substitution into simple expressions, can also be used for
solving simple equations depending upon what you
hide/reveal.

Substitution 
Substitution into expressions that are linked such as x then
x+2 then 3(x+2)  hide and reveal facility

Simplifying Simple Expressions  Charlie Dawson
Using the four rules with simple expressions, choice
of operation or mix of operations (Algebra Tab at
bottom)  hide and reveal
facility
Sequences

Guess  Charlie Dawson 
Instructions
Series of 8 problems highlighting the link between the table
graphs, tables,
patterns and formulae. Each problem gives you a letter that
comprises part of an anagram

Guess the Connection  Charlie Dawson
Random problems highlighting the link between the table
graphs, tables,
patterns and formulae.

Sequence generator
 Rob Simpson
www.mathsit.org.uk Investigate various sequences with this interactive
workbook. Show/hide values and formulas, change the settings
to suit the class. Contains linear, quadratic, exponential
and fibonacci sequences.

Sequence Blanks  Mark Greenaway Randomly generate linear sequences with numbers missing,
hide or reveal individual cells
Coordinates & Straight Lines

Coordinates  Rob Simpson
www.mathsit.org.uk
Enter coordinates to draw shapes on the grid. Use the first
or all four quadrants.

Straight line Graphs
 Mark Greenaway
Change the gradient and intercept and explore the effect on
the resulting graph. Option to hide/reveal all or some
of the information leaving just the graph.

Guess the Connection  Charlie Dawson
Random problems highlighting the link between the table
graphs, tables,
patterns and formulae.

Straight Lines  Mark Greenaway
Enter a value for m and c and then change x and see the
effect on y, hide or reveal whatever you choose

Straight Line Generator
Hide or reveal the equation of randomly generated straight
line graphs

Which line?  Mark Greenaway
Press F9 and randomly generate a point and three straight
line equations, decide which line the point lies on

Find the Equation  Mark Greenaway Enter any two coordinates and then use this to discuss the
equation of the resulting graph
Solving Equations

Trial and Improvement  Mark Greenaway A self checking spreadsheet that requires students to
complete all the necessary steps to solve Trial &
Improvement problems.

Simultaneous equations
 Rob Simpson
www.mathsit.org.uk Investigate the graphical solitions of simultaneous
equations. Alter the equations and see how the graphs change
and how this affects the intersection point.

Sum Triangles  Charlie Dawson Number Pyramid with challenges at different levels
Quadratics

Product and Sum  Rob Simpson
www.mathsit.org.uk
Finding the products and sums
of numbers or the numbers which give a target sum or product

Quadratic expressions  Rob Simpson
www.mathsit.org.uk
Investigate the different forms of a quadratic expression
and their graph.

Multiply & Factorise Quadratics  Mark Greenaway
& Charlie Dawson 3 levels of questions where you can hide/reveal any part of
a quadratic expansion

Graphs of Quadratics and Solution of Simultaneous Equations
such as x^{2} + 3x  5 = 4x + 1 by drawing a curve
and a straight line. Includes a a hide/reveal table
for the quadratic curve  Charlie Dawson
Proportionality

Proportionality
 Rob Simpson
www.mathsit.org.uk
Investigate direct, inverse and square
proportionality. Interactive workbook, containing
table of values, graph and equation.

Shape, Space and Measures
Measures

12 & 24 hour clock  Rob Simpson
www.mathsit.org.uk
Displays the time shown on an analogue clock in digital
format using both 12 and 24 hour clock. Show/Hide digital
clocks.

Measuring
 Rob Simpson
www.mathsit.org.uk
An interactive scale. Change the scale by altering the size
of the divisions. Includes negative numbers to look at
temperature. Alter the size of the measurement.

Speed  Distance  Time Calculations  Mark
Greenaway
The 1st tab has values for distance, speed and time, you can
hide any of the values and use for questioning. The
2nd tab has 10 randomly generated questions. Again
hide any values you wish and press F9 to generate a new set
of questions.
Properties of Shapes

Quadrilaterals  Mark Greenaway
A puzzle where you are required to enter the missing
coordinates to form a given quadrilateral
Mensuration

Area & Perimeter of Polygons  Mark Greenaway
Change the size of the diagonal and the number of sides of
the polygon and "discover" the ratio of pie.
Transformations

Transformation Golf
 Duncan Keith
www.subtangent.com
Complete a round of golf using reflections, translations and
rotations.

Handling Data
Averages

Averages
 Mark Greenaway
Set of 3, 4 or 5 numbers with averages displayed. Hide
or reveal any of the values

Averages  Matt Nixon
www.kangaroomaths.com
Randomly generate a set of 5 integers between limits you set
with the averages calculated. You can hide or reveal any of
the values by clicking on the cell.

Mean, Median & Range  Mark Greenaway
The spreadsheet randomly generates a set of results and
displays the Mean, Median and Range. You are required
to select a set of numbers that match these results.

Averages from Frequency Tables  Mark Greenaway
Randomly generated frequency tables allowing you to talk
through the process of finding the averages. The steps
can be hidden or revealed.

Moving Averages  Mark Greenaway
This generates sets of 8 pieces of data and allows you to
draw a 2, 3, 4 or 5 point moving average. You can hide
or reveal any of the data and view the graph with and
without the moving averages plotted.
Handling Data Graphs

Pie Charts  Charlie Dawson
Random Pie Charts with the ability to hide/reveal values,
percentages or angles

Comparing BoxPlots
You can draw and compare up to 4 boxplots by entering the
min, max and quartiles.

Correlation
 Rob Simpson
www.mathsit.org.uk
Investigate correlation. Produces randon data based on your
settings. Comment on correlation, outliers and
relationships. Extends to A'Level Statistics including PMCC.

Data Set 1  Goals per game
 Rob Simpson
www.mathsit.org.uk
Compare several sets of football related data. Interactive
features include automatic sorting, all summary values
calculated, colour cells or boundaries between cells, view
box plots for the data.

Data Set 2  Daisies per sq metre
 Rob Simpson
www.mathsit.org.uk
Same as above, but for flower related data, (well, sort of!)

Data Set 3  Stamps in a week
 Rob Simpson
www.mathsit.org.uk
Interactive frequency table. Includes group totals for
calculating mean and cumulative frequencies for finding the
median. Show/hide values.

Data set 4  Colours of cars
 Rob Simpson
www.mathsit.org.uk
Compare Frequency diagram and pie chart for qualitative
data. Show/hide the data or the graphs.
Simulation

Random Number Generator  Rob Simpson
www.mathsit.org.uk
Random numbers generated
between limits you set and displayed to an accuracy of your
choosing

Coupon Collecting  Mark Greenaway
This spreadsheet allows you to simulate collecting coupons
or gifts from cereal packets. You can specify any number of
coupons from 1 to 10.

Probability

Racing  Rob Simpson
www.mathsit.org.uk
Roll the Dice to move the cars! Which will win? Change the
rule to move the cars, change the maximum number on each
die. Investigate combined probability.

Space Diagrams  Rob Simpson
www.mathsit.org.uk
Create space diagrams for investigating combined
probability. Includes finding the sum, difference, maximum
and minimum of two numbers.

Spinner  Rob Simpson
www.mathsit.org.uk
A random spinner with user defined outcomes.

Tree Diagrams  Mark Greenaway
Randomly generate questions involving green and red cubes
with and without replacement, hide/reveal facility in place.
Also problems involving decimals and sheets so you can enter
your own fractions or decimals.

One Armed Bandit
 Mark
Greenaway (adapted from 
The Bandit by Rob Simpson)
An interactive one armed bandit! Change the settings to make
the bandit more or less likely to pay up

Other Sources of Excel
Files More Excel worksheets
covering lots of topics
www.mathsfiles.com/Excel.htm
Ten Maths Activities using Excel
www.mathsit.org.uk/Resources.htm
Wow
Maths
Mr Gallinaghs Maths
www.numeracysoftware.com/xm.html 
