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
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:
- Summing or averaging results to get an instant overview of the results.
- Using conditional formatting to quickly highlight strengths or areas of need.
- Developing questions about your data.
- Commenting on aspects of the data to encourage interaction and dialogue about the results.
- Sharing the sheet and protecting parts of it to encourage transparency around staff dialogue.
- 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:
- 0:00 Intros
- 0:29 Protecting student privacy
- 0:55 Overview of aims of the session
- 1:40 Developing questions about the results
- 3:45 How to make a new tab in your Sheet
- 8:06 Data literacy: primary and secondary level questions
- 9:56 Ways to analyze the data: summing results
- 11:43 Formatting the Sheet to make it easy to read
- 12:50 Data literacy: how to create a SUM function to analyse the results
- 15:10 Data literacy: how to use the AVERAGE function to analyse the results
- 16:15 School leadership: creating a level of transparency by involving others in the analysis
- 16:48 Data literacy: how to round numbers in the spreadsheet
- 18:05 Data literacy: using conditional formatting to quickly highlight strengths or areas of need
- 21:25 Data literacy: how to copy formulas to other parts of your Sheet 1
- 22:40 Data literacy: how to create an overall analysis tab in your Sheet
- 23:35 Data literacy: how to copy formulas to other parts of your Sheet 2
- 28:05 Data literacy: how to drag formulas across to other cells in your Sheet
- 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 ago by Rob Clarke.
- This reply was modified 7 years ago by Rob Clarke.
- This reply was modified 7 years 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 ago by Rob Clarke.