Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.
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 of the two numbers in a frequency table and simultaneously in the bar graph
The sum when rolling two dice: simulates the rolling of two dice and then records the sum of the two numbers in the frequency table and simultaneously in the bar graph
Using an assumed mean: demonstrates how an assumed mean can be used to calculate the mean height of five students
Calculating the mean from a frequency table: demonstrates how to calculate the mean of up to seven numbers from data in a frequency table. The values can be any set of consecutive numbers with the first number between 0 and 10
Calculating the mean: demonstrates how to calculate the mean of up to seven numbers. The value of each number can be any integer between 1 and 10. The calculation of each set of numbers is displayed. If the calculation involves decimals, these are initially displayed correct to 10 decimal places and then rounded to two decimal places
Calculating the median and range: demonstrates how to calculate the median and range of up to seven numbers. The value of each number can be an integer between 1 and 10
Calculating the mode: demonstrates how to calculate the mode of up to 10 numbers. The value of each number can be an integer between 1 and 7.
Show health and safety information
Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.
Downloads
-
Calculating the mode 46 KB
-
Difference between 2 dice 59.5 KB
-
Rolling 1 die 66 KB
-
Sum of 2 dice 57.5 KB
-
The mean from a frequency table 43.5 KB
-
Using an assumed mean 41 KB
-
Calculating the mean 35 KB
Show downloads
-
Calculating the mode 46 KB -
Difference between 2 dice 59.5 KB
-
Rolling 1 die 66 KB
-
Sum of 2 dice 57.5 KB
-
The mean from a frequency table 43.5 KB
-
Using an assumed mean 41 KB
-
Calculating the mean 35 KB
-
Download all files as a .zip110.47 KB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
