Five-A-Day

Five A Day Survey

Three students have carried out a survey to check out what fruit they eat in a week.

Have a look at their completed data collection.doc forms. (rtf).

How do you compare with these students?

Find out by collecting your own data so that you can analyse all the results in a spreadsheet.

Use this copy of the data collection form.doc to collect your own data for seven days. (rtf).

Mark Checklist

Design and develop a spreadsheet to enter the collected data into.

Here is an example of how to design a spreadsheet. The spreadsheet with formulae.

The spreadsheet with sample data added.   

You must produce a report which shows the results of the survey. Produce four charts to:

• show how much fruit you ate each day during the week (column chart)
• show the total amount of fruit eaten by each student during the week (any suitable chart)
• show which colour group is most popular (pie chart showing percentages)
• compare the four colour groups for each student (comparative chart)
• make sure that each chart has a suitable title and axis/data labels.

The complete spreadsheet showing charts.

Save your spreadsheet into your eportfolio.

Mark checklist.