Using Google Forms for surveys and school self review

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

Viewing 1 reply thread
  • Author
    Posts
    • #4269
      Rob Clarke
      Keymaster

      Here is a video from a meeting I had with Anna from Everglade School, in which we constructed a wellbeing survey for her school. I hope you find it useful:

      This video is 40 minutes 35 seconds long.

    • #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 7 years, 1 month ago by Rob Clarke.
      • This reply was modified 7 years, 1 month ago by Rob Clarke.
      • This reply was modified 7 years, 1 month 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 7 years, 1 month ago by Rob Clarke.
Viewing 1 reply thread
  • You must be logged in to reply to this topic.
Skip to toolbar