Averages
and Range
excel
finding
averages and range
you
type in a set of numbers, and excel works out the mean, median,
mode and range whenever you click the buttons. Please
Note: See technical issues
if you are having trouble getting excel files to work properly!
word
interesting
questions about averages
four
questions about averages that pupils might find more interesting
than the usual ones from the textbook
powerpoint
averages
puzzle
a
nice puzzle that tests pupils' ability to interpret information
and use knowledge of averages
tarsia
jigsaw
averages
jigsaw
a
match up activity testing pupils' knowledge of all three averages
and the range
powerpoint
importance
of averages
a
cricket example which illustrates the importance of choosing
the correct average
powerpoint
recap
of averages and range
a
recap of mean, median, mode and range, complete with some catchy
little poems!
excel
average
of 5 numbers
can
you work out the mean, median and mode of 5 numbers? clicking
on the star generates another set
powerpoint
averages
bingo
a
nice bingo game to add some spice to practicing averages
word
averages
bingo cards
the
cards to accompany the above bingo game
word
mean
- cross number
a
crossword where students must work out the mean of a group of
numbers in order to fill in the answers. solution provided
Code
Breaking
powerpoint
code
breakers
an
introduction into the pigeon and railfence ciphers
powerpoint
code
breakers - frequency analysis
an
introduction into the use of frequency analysis to crack codes
word
frequency
analysis extract
a
code to crack using frequency analysis
excel
frequency
analysis - collection sheet
an
excel file to collect the data from the above frequency analysis
Moving
Averages
excel
moving
averages
provides
and editable set of data, and plots both the data points and
the moving average
Probability
tarsia
jigsaw
probability
jigsaw
pupils
must match up outcomes with their probabilities
excel
probability
bingo
the
computer rolls two dice, adds the scores, and keeps a record
of the results on a grid. good for playing bingo and introducing
sample spaces
excel
probability
games
lots
of games to introduce important concepts of probability
excel
tree
diagrams
generates
an infinite number of simple tree diagrams, both with replacement
and without
flash
player
coin
races
probability
experiments involving tossing different numbers of coins
flash
player
quincunx
a
nice simple version of a quincunx
flash
player
probability
tools
a
nice package of tools for introducing and developing important
probability concepts
powerpoint
playing
cards
pictures
of all 52 playing cards, just in case you ever need them!
flash
player
probability
simulator
a
very good way of seeing and recording the outcomes of different
coin and dice experiments
powerpoint
most
likely starter
a
nice little warm up activity about which is most likely that
can lead to some nice discussions
excel
probability
line
students
must place a number of scenarios on the probability scale. provides
a nice introduction to probability
excel
red
and green counters
a
simple tool for randomly generating a mixture of counters in
a bag which students must then work out the probability
Amazon.co.uk
Widgets
Raw
Data
excel
world
stats
lots
of statistics about lots of the world's countries
excel
random
number generator
a
very basic random number generator with editable parameters
autograph
lottery
data
data
from the last 10 years of the national lottery which can be
quickly put into statistical diagrams
Reading
Scales
flash
player
throwing
a
fun game testing pupils' ability to read a number of different
scales
Statistical
Diagrams
powerpoint
labeling
axis
pupils
must identify the mistakes made when setting out each of these
four sets of scales
flash
player
handy
bar graph
a
simple program allowing you to quickly create a colourful bar
graph
flash
player
statistical
diagrams
you
change the values in the frequency table and observe what happens
to the pie chart, bar chart and box and whisker diagram.
powerpoint
displaying
data
a
quick example of different ways of displaying the same data
powerpoint
interpreting
pie and bar charts
questions
requiring pupils to read information from pie charts and bar
charts
powerpoint
cumulative
frequency and box plots
a
lesson, complete with an interactive example, for teaching cumulative
frequency and box plots
powerpoint
scatter
diagrams
three
interesting examples to introduce the concepts of scatter diagrams
and correlation
excel
cumulative
frequency
change
data values and see the effect on the cumulative frequency diagram.
allows you to work out the median as well!
powerpoint
interpreting
diagrams
pupils
are presented with a statement and a diagram and they must decide
if the diagram supports the statement or not
powerpoint
stem
and leaf
a
lesson teaching the basics of stem and leaf diagrams with a
nice colourful example
excel
misleading
graphs
a
very simple activity to show how some diagrams can be misleading
powerpoint
interpreting
and comparing diagrams
questions
requiring pupils to read and compare information from pie charts,
bar charts and line graphs
powerpoint
census
at school starter
a
nice starter activity where students must decide the order of
other students' answers
excel
bar
charts to pie charts
an
interactive excel worksheet that generates simple bar charts
and challenges students to create the pie chart
powerpoint
comparing
distributions
a
nice starter activity where students must match-up bar charts
of heights to group photos
powerpoint
reading
bar charts and pie charts
questions
requiring students to read and interpret bar charts and pie
charts. has a bit of ratio thrown in there too