Using Google Forms for surveys and school self review

[Rob Clarke]

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.

[Anna Powrie]

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.

[Author]

Posts