• Scenario
• Getting organised
• Planning
• Keeping track
• 
• Survey
  • Data collection
  • Analysis
  • Results
• Database
• 
• Database report
• Information leaflet
• Bookmark
• Presentation
• 
• eportfolio
• Review

You must create a spreadsheet to analyse the survey data.

Create a spreadsheet using this design to help you.

Enter the data from your survey into the spreadsheet. Make sure you add all the females first, then the males.

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

Use your spreadsheet to produce these charts:

• a pie chart showing the average rating for each animal group

• a column chart showing how much people are prepared to pay to adopt an animal

• a chart to compare the ratings given by males and females for different types of animal

Make sure that each chart has a suitable title and labels.

Ask your teacher to give you feedback. Make changes if necessary.

Save your spreadsheet and charts in your EVIDENCE folder. Make sure that the moderator can see both the values and the formulae. You may need two files.

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