- View more resources from this publisher
Core Maths
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.
Olympic medal ranking
This Core Maths task looks at how countries are ranked at the 2012 Olympic Games. Students use Excel to order the data and are asked to comment on whether the ranking is fair. This activity is designed to then lead to a discussion of weighted rankings.
The teachers' notes give an outline of the task and suggestions for extension activities.
The activity sheet gives students clear instructions for each step of as they interact with the data. This includes writing formulae so that various weightings can be used and differences in the rankings compared.
The resource contains an Excel file of data for students and another file for teachers containing an exemplar of what the final work of students may look like.
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
-
Olympic medal table (activity sheet) 536.74 KB
-
Medal table data (data set) 12.48 KB
Show downloads
-
-
-
Olympic medal table (activity sheet) 536.74 KB
-
-
Medal table data (data set) 12.48 KB
Download all files as a .zip1.24 MB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
