[Anna Powrie]

Thanks for this – I had a colleague saying just yesterday ‘I wish there was a quick way to open a new doc…..’

Perfect!

[Anna Powrie]

 

Legend – I have just ‘reactivated’ her! Thanks!!

[Anna Powrie]

Hey Rob,

Sounds like a super full on, yet interesting week! Hope this one is slightly slower paced for you 🙂

Thanks for the reply – I had a feeling it would be something like that. I have passed on all of this to John as well – might pay for us to think about the docs we ‘share’ vs the ones accessible in the different Team Drives. Especially the more ‘sensitive’ docs/templates.

 

Thanks heaps – talk soon I’m sure!

[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.

[Anna Powrie]

Will this work if I don’t have the ‘Admin Cog’ – I assume it only shows up on my screen(s)?

I know John tried to change them, but they reverted back. I might need to follow up  bit more on this and get back to you as we don’t have it sussed yet.

[Anna Powrie]

Brilliant thanks – will print out tomorrow and share with the staff!

Anna 🙂

[Anna Powrie]

So, I managed to figure it out. I had to upload the picture through ‘Settings’ and then select the box ‘visible to everyone’ rather than ‘visible only to people I chat with’. As this was the option I preferred, I had left this box checked each time. Once I selected the everyone option, suddenly it allowed me to save and completed the action. Not sure as to why but am happy it worked for now 🙂

[Anna Powrie]

Hey Rob,

Yes I do, and that is def the place I intend to start now I’ve sussed most of the Gmail tricks from the first course. Should be interesting as I’ve never called myself an Excel expert to say the least.

Cheers,

Anna

[Author]

Posts