style=”display:inline-block”
data-ad-client=”ca-pub-5585383174233656″
data-ad-slot=”3973085649″>


ICT / Computing

Published on November 28th, 2010 | by What2Learn

0

Spreadsheet Task: Professor Stealyarty

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!

Resources

Click here to download the worksheet ‘Professor Stealyarty’

Interactive assessments

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.

Learn more.

Sample Spellcheck Game
Teacher Guidance

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).

Back to the KS3 Spreadsheet Topic page


Related posts:



Tags: , , , ,


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑