General Number
This selection of spreadsheets, designed by the Primary National Strategies to aid teaching and learning, tackles number in a variety of ways. Number grid generator has three spreadsheets and a guidance file. They allow numbers to be generated, by choosing a start number and a step, that can be used in a variety of ways to spot…
Data, Graphs, Charts, Measures and Money
This selection of spreadsheets, designed by the Primary National Strategies to aid teaching and learning, tackles data, graphs, charts, measures and money, in a variety of ways. Carroll diagram allows either shapes or numbers to be dragged into an either one or two criteria table. The criteria can be selected and the results…
General
This selection of spreadsheets, designed by the Primary National Strategies to aid teaching and learning, tackles a variety of topics. 4 numbers has a two by two grid with the sums of the columns and rows shown. The task is to find out what the numbers in the grid are. There are three levels of difficulty. Teacher guidance is…
Extra Resources
A variety of resources, from the Association for Science Education (ASE): a model spreadsheet exploring sound waves, two articles from Catalyst magazine, Hunt the Transmitter activity and Reading Rain Radars. Sound Waves is a good example building spreadsheet models that students can interact with. Contributed by Simon Waters,…
Large Datasets from stats4schools
These datasets from stats4schools are compiled from the responses given by over 1500 people to a survey. They are intended to be used flexibly but some ideas are given to guide students in their interrogations. There are three sheets in each set 1. Decoded data 2. An explanation of the questions that were asked in the survey 3.…
Addition and Subtraction
This selection of spreadsheets, designed by the Primary National Strategies to aid teaching and learning, tackles addition and subtraction in a variety of ways. Number line counting shows a number line of ten places, numbers between 0 and 99 can be chosen. The numbers on the line can be hidden or revealed. Counting stick shows…
Transformation Golf
In this interactive golf game from Subtangent the player has to get the ball in the hole by choosing the most effective geometric transformations to beat the target score for each hole. There are two versions of the game. Transformation golf 2 has an option for players to restart individual holes, allowing students to improve…
Interactive Data Resources
This resource from SMILE contains eight interactive spreadsheets as described below: Rolling one dice: simulates the rolling of one dice and then records the number in the frequency table and simultaneously in the bar graph The difference when rolling two dice: simulates the rolling of two dice and then recording the difference…
Place Value, Rounding, Estimation, Fractions, Percentages and Decimals.
This selection of spreadsheets, designed by the Primary National Strategies to aid teaching and learning, tackles place value, rounding, estimation, fractions, percentages and decimals, in a variety of ways. Place value dots shows the visual representation of a chosen number up to 999, in hundreds, tens and units. The number…
Multiplication and Division
This selection of spreadsheets, designed by the Primary National Strategies to aid teaching and learning, tackles multiplication and division in a variety of ways. The five Multiplication and division facts spreadsheets have a four by four blank multiplication table that generates random numbers and multiplies them to fill the…
Other Resources
These Making Statistics Vital resources are provided for those studying the S2 Module of A Level Statistics and present opportunities to investigate Markov chains. A Markov chain is a mathematical system that undergoes transitions from one state to another, between a finite number of states. This spreadsheet allows the user…
The Poisson Distribution
These Making Statistics Vital resources are provided for those studying the S2 Module of A Level Statistics and are designed to help students identify when a Poisson distribution is a suitable model to use, as well as how to use the Poisson distribution as an approximation to the binomial distribution. Having the opportunity to apply…