Published on November 28th, 2010 | by What2Learn0
Spreadsheet Project: California Road Trip
This activity is part of a series of resources to help KS3 teachers delivering lessons on spreadsheet applications. This mini-project requires students to carry out a number of tasks, combining their use of spreadsheet applications with a range of other skills and applications. As such, it is expected that it will take around three hours of lesson time for most classes to complete.
The project requires students to plan the ultimate road trip for a vacation in California.
Click here to download the worksheet ‘California Road Trip’.
Click here to download the spreadsheet ‘California’.
Click here to download the presentation ‘California Cities Map’.
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:
This is the final activity in a sequence of lessons on spreadsheets. It is expected that students should be becoming much more autonomous in their use of the application. As much as possible students should lead this activity by reading the worksheet through with the whole class and discussing what is required at each stage. This activity aims to reinforce student knowledge of functions, formulae and charts, and of using spreadsheet models to try to find answers to problems. It should 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.
The key thing for the teacher to manage is to try to ensure that the class does not become too stretched and working on totally different activities – it becomes extremely hard to provide quality instruction to the students when this becomes the case.
As extension and plenary students should play the activities within the KS3 Spreadsheets topic (share code 907795 to unlock this).