Visualising your survey data using Excel

If you would like to see your class or school data represented on a summary form or via a pie chart you can use this handy Excel spread sheet prepared for us by Matthew Courtney. Simply enter your data on the first sheet, titled ‘Input’, and pie charts will be generated on the second sheet, entitled ‘Charts’. Remember to enter the number of children surveyed before you add any further data.

Download the excel spread sheets here:

KS1 Reading Survey Visualisation KS2 Reading Survey Visualisation Parent's Reading Survey Visualisation

Subscribe to our newsletter