Friday, 16 December 2011

AO 4 Create a Spreadsheet to Analyse the Data

Task 1

Use formulae/functions to analyse the results of the questionnaire and present the results in tables on a separate sheet.
Format these tables to make them easier to read as they will be used in a presentation showing your findings.



Task 2

Produce graphs that clearly show your findings.
You will have to explain your results in a presentation later so make sure they graphs have all the correct labels and titles. You should use three different type of graph if possible.


Task 3

Give the spreadsheet a more user friendly appearance by adding formatting