Reply To: Using Google Forms for surveys and school self review

Home Forums Google Sheets & Forms Using Google Forms for surveys and school self review Reply To: Using Google Forms for surveys and school self review

#4328
Anna Powrie
Participant
Points: 143

Here is a follow-up meeting with Rob, Anna and her principal John where we start exploring how to analyse the data from the Google Form to help inform school review on student wellbeing. Topics covered include:

  1. Summing or averaging results to get an instant overview of the results.
  2. Using conditional formatting to quickly highlight strengths or areas of need.
  3. Developing questions about your data.
  4. Commenting on aspects of the data to encourage interaction and dialogue about the results.
  5. Sharing the sheet and protecting parts of it to encourage transparency around staff dialogue.
  6. Overview of pivot tables to drill down into the data (this is the focus of the next step).

This video is 36 minutes 35 seconds long:

If you go into Youtube to watch this video – by clicking on the Youtube icon bottom right – you will see in the video description the timings of each part of the session. These are clickable so you can jump to the part of the video you are most interested in. Here is the overview of timings:

  1. 0:00 Intros
  2. 0:29 Protecting student privacy
  3. 0:55 Overview of aims of the session
  4. 1:40 Developing questions about the results
  5. 3:45 How to make a new tab in your Sheet
  6. 8:06 Data literacy: primary and secondary level questions
  7. 9:56 Ways to analyze the data: summing results
  8. 11:43 Formatting the Sheet to make it easy to read
  9. 12:50 Data literacy: how to create a SUM function to analyse the results
  10. 15:10 Data literacy: how to use the AVERAGE function to analyse the results
  11. 16:15 School leadership: creating a level of transparency by involving others in the analysis
  12. 16:48 Data literacy: how to round numbers in the spreadsheet
  13. 18:05 Data literacy: using conditional formatting to quickly highlight strengths or areas of need
  14. 21:25 Data literacy: how to copy formulas to other parts of your Sheet 1
  15. 22:40 Data literacy: how to create an overall analysis tab in your Sheet
  16. 23:35 Data literacy: how to copy formulas to other parts of your Sheet 2
  17. 28:05 Data literacy: how to drag formulas across to other cells in your Sheet
  18. 30:20 School leadership: sharing the sheet and protecting parts of it to encourage transparency around staff dialogue -commenting on aspects of the data

Next steps: using pivot tables to drill down into the data in a more granular way.

  • This reply was modified 6 years, 5 months ago by Rob Clarke.
  • This reply was modified 6 years, 5 months ago by Rob Clarke.
  • This reply was modified 6 years, 5 months ago by Rob Clarke. Reason: Added in the timings for the video to make it easier to jump to different sections
  • This reply was modified 6 years, 5 months ago by Rob Clarke.
Skip to toolbar