Welcome to > teachers > teaching resources > key stages 3 and 4 > handling data

Just click on the name of the resource and save it onto your computer




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
       
 
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
       
If you have found mrbartonmaths.com useful, and you have a spare minute, please help support the website by clicking on one of the adverts below. Your support is very much appreciated!