Creating an Excel spreadsheet
Learning Objectives
- To be able to organise a spreadsheet on excel.
- To be able to use the SUM and AVERAGE functions on Excel.
- To explain why spreadsheets are better than paper questionnaires.
- To apply knowledge to create an excel spreadsheet for the Spirit scoring system in Ultimate frisbee.
Lesson Description
These two lessons guide students learning on several Microsoft Excel skills and the use of questionnaires. The context of the SPIRIT scoring system of Ultimate frisbee will help students see a real-life use of how ICT skills can assist a sporting context.

For immediate access to all of our free Key stage 3 and 4 STEM teaching resources.





Subject
Key Stage
Related Resources
Calculating The Power of The Wind
Explore the concept of power using the context of the super-fast SailGP GBR catamaran and the cutting-edge technology of wind turbines. Students will have the chance to build a working model wind turbine and use their new knowledge of calculating power to build the most efficient design. There is also the chance to find out from SailGP GBR sailors and wind industry experts about their fields and careers. The sustainable recycling process of wind turbines is also considered giving students the opportunity to come up with their own solutions.