Spreadsheet+Exercise

Complete this exercise below using a spreadsheet.

1. Carry out a survey of your class as follows:
 * Your survey should ask everyone in their class to vote on something, for example favourite colour, favourite band, favourite football team.
 * Each person survey must give their 1st, 2nd and 3rd favourite choices

2. Create a spreadsheet with the following columns:
 * Option (e.g. colour, band, team etc.)
 * First choice
 * Second choice
 * Third choice
 * Score (this should be a formula which gives 3 points for each first choice pick, 2 points for each 2nd choice pick and 1 point for each 3rd choice pick

3. Add a formula to the bottom of each column to total the number of 1st choice, 2nd choice and 3rd choice picks.

4. Sort the spreadsheet into score order

5. Create a pie chart of the results