This activity is part of a series of resources to help KS3 teachers delivering lessons on spreadsheet applications. In this lesson the students will need to create a spreadsheet that carries out some mathematical calculations. Once finished, they will need to use the spreadsheet model to formulate a plan to assist Professor Stealyarty in his dastardly deeds!
Click here to download the worksheet ‘Professor Stealyarty’
Teachers – reduce your marking and develop your student’s knowledge and motivation with W2L games. There is a relevant activity with the title ‘Simple spreadsheet calculations’. The best way to play these is for students to register for a free W2L account, log in and enter share code ’907795′ to unlock the KS3 Spreadsheets topic. By logging in to play the activities scores will be recorded and attainment rewarded.
Suggested method of delivery:
Being the third in a sequence of lessons on spreadsheets, it is expected that students should be becoming much more autonomous in their use of the application. Although the hook for this lesson revolves around helping Professor Stealyarty to steal a painting, the thinking skills required in using a spreadsheet model to come up with one possible answer to a problem is where the real educational value lies.
Most of this task should be self-explanatory and students should be able to follow the instructions on the worksheet. For Task 5 (calculating total cost) students should be encouraged to use the SUM function rather than adding up each of the costs one at a time.
As extension and plenary students should play the activities within the KS3 Spreadsheets topic (share code 907795 to unlock this).
- Spreadsheet Task: Barry’s burger van
- Spreadsheet Task: Tornado Valley
- How to write spreadsheet formulae