SURVEY - Analysis |
|
|---|
You must create a spreadsheet to analyse the survey data.
Create a spreadsheet using this design to help you.
Enter the data from all five data collection forms into the spreadsheet.
Ask your teacher to test the spreadsheet and give you feedback. Make changes if necessary.
Use your spreadsheet to produce five charts to show:
how much of each food group you ate during the week (column chart)
how popular each food group was during the week (pie chart showing percentages)
the total amount of each food group eaten during the week by each student (comparative chart)
the average amount of daily exercise for each student (showing minutes)
one more interesting result of your choice
Make sure that each chart has a suitable title and labels.
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?
Print this page