Published on November 28th, 2010 | by What2Learn0
Spreadsheet Task: Tornado Valley
This free 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 analyses the frequency of tornadoes in Colorado. In doing so they will need to use the SUM and AVERAGE functions and create charts using carefully selected data.
Click here to download the worksheet ‘Tornado Valley’
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 fourth in a sequence of lessons on spreadsheets, it is expected that students should be becoming much more autonomous in their use of the application. This activity aims to reinforce student knowledge of functions, formulae and charts, but also to get them thinking about how to effectively combine work in a spreadsheet with work they do in other applications to create a more useful end-product.
Most of this task should be self-explanatory and students should be able to follow the instructions on the worksheet. For Tasks 2 and 3 (calculating totals and averages) students may need to be shown how to use the SUM function and the AVERAGE function.
As extenstion and plenary students should play the activities within the KS3 Spreadsheets topic (share code 907795 to unlock this).