• Scenario
• Getting organised
• Planning
• Keeping track
• 
• Student information
• Survey
  • Data collection
  • Results
• Database
• 
• Trip lists
• Invitation
• Welcome posters
• What's on?
• 
• eportfolio
• Review

Students from your centre will go with the visitors on the coach trips. You must ask local students about the types of trip you should offer. You also need to gather information about local activities such as clubs and sports.

Use this data collection form to gather data from about 20 students. You may work in a group and share the data. You MUST collect data from at least 5 students yourself.

You must use a spreadsheet to analyse the survey data.

Create a spreadsheet using this design to help you.

Check that your formulae are correct.

Enter the data from the data collection forms into the spreadsheet.

Test the spreadsheet to make sure that it works.

Ask your teacher to test the spreadsheet and give you feedback. Make any necessary changes.

Save your spreadsheet for your eportfolio. Make sure that it is possible to look at the formulae as well. Ask for help if you need to.

Update your sources table.

Finished? Make sure your ongoing plan is up-to-date. Have you remembered to add comments?