Hero image

STEM Crew's Shop

Average Rating5.00
(based on 10 reviews)

Free teaching resources to bring STEM to life in the classroom, using elite sport as the context. Ideal for KS3 students.

Free teaching resources to bring STEM to life in the classroom, using elite sport as the context. Ideal for KS3 students.
Creating an excel spreadsheet
STEMCrewSTEMCrew

Creating an excel spreadsheet

(0)
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!
Code for the Cup
STEMCrewSTEMCrew

Code for the Cup

(2)
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