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.
Creating an Excel spreadsheet
These two lessons use the context of the scoring system of Ultimate frisbee to help students see a real-life use of how spreadsheets and data handling can assist a sporting context.
Lesson 1 shows students how to create a Microsoft Excel spreadsheet and then use it to calculate a sum and an average. Students are then asked to create their own spreadsheet for a shopping list using student worksheet 1.
The use of spreadsheets is then continued into lesson 2 where students are asked to use them to calculate the score for an Ultimate frisbee game using student worksheet 2. The sum and average practice spreadsheet could be used to start this second lesson to recap the learning from the previous lesson. The video describes the rules and scoring system for a game of Ultimate frisbee which gives the students the background they need to complete the scoring spreadsheet. A spreadsheet template is given for this activity, but more able students might be asked to create their own rather than use the template.
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
Show downloads
Download all files as a .zip17.4 MB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
