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

You might also like

Resource
Resource collection
Resource collection
Resource collection

Published by

Actions

Share this resource

Collections

This resource is part of these collections

Comments