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.
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.
Access more for free here!
This Computing topic explores the real-life context of the America’s Cup race start where the boats need to cross the start line as close to the gun as possible but not before!
Check out the full resource including further lessons and game access as well as our other resources at www.stemcrew.org
This engaging activity will promote computational thinking, providing both a challenge and a competitive experience. Throughout this topic, students will understand the importance of coding efficiency by exploring a range of algorithmic solutions developed using code blocks. They will sequence instructions to develop a program which they will test and then make further refinements.
This topic comprises of a set of slides which support underpinning computational thinking concepts and provide the teacher with guidance and suggestions for further exploration.
Code for the Cup game available for students at www.stemcrew.org/coding-game