8.1+Task+Three

==   ==

Today you will learn:
=  =
 * how to collate survey results
 * how to carry out complex analysis of the results


 * enter and group your survey results in a spreadsheet
 * produce a graph based on the results and comment on the outcomes

Task Three instructions:
====  1. Depending on the style of your questions, enter your questions and responses in a worksheet in a spreadsheet application.  2. Look at this set of results of a leisure survey [|2007 Leisure Centre Survey Results.pdf]. You can see how the questions and responses are grouped together.  3. Check out this website and files for examples of quizzes and surveys input into spreadsheets, collated and analysed:    [|Quiz Zone]     Phone Quiz [|Phone_Quiz.xls]     Green Quiz [|Green_Quiz.xls]     Personality Quiz [|Personality_Quiz.xls]     4. Now input your questions and data and use formulas to group the results. This document ([|How+to+create+charts+and+graphs+in+Excel.doc]) will show you how to enter data and produce a graph. <span style="mso-bookmark: OLE_LINK1"><span style="mso-bookmark: OLE_LINK2"> 5. Now create your own graph to display some results. Explain through labelling and commentaries what these results show. You can write your commentaries next to the graph(s) in your spreadsheet. <span style="mso-bookmark: OLE_LINK1"><span style="mso-bookmark: OLE_LINK2"> 6. **Homework**: complete your spreadsheet of results. ====