If you are sending the Virtual School Games events home as your PE lesson/homework and want an easier system for collating results rather than them being sent by email we have provided a step by step process for personalising the scoresheet so a simple url link can be sent.
You will need to have (or set up) a Gmail Account.
Here are the steps to set up the sheets:
- Click on the relevant link below and create 1 copy per class/team of each file
- Change each sheet with:
- New title to differentiate between classes
- School Name
- Year Group
- Class Name
- Pupils' First Names
- Deadline date for parents (different to deadline date for the event entry
- Send out each sheet with their new link to class teachers to send to their own pupils' parents
- On deadline, lift the data from the 4 sheets and enter team results on the google forms
DO NOT SEND THE LINKS BELOW TO PARENTS
KS1:
https://docs.google.com/spreadsheets/d/150cObUXHpAJO8EKMAqfN205b1WOuJ6NRDTDCUp6GQ9o/copy
KS2:
https://docs.google.com/spreadsheets/d/1YkTKJYC6qlKn4xa8-wtaFqRpmnXC3Emm3QH4TCZVuws/copy
We have also produced a video to talk you through how to do this.
https://www.youtube.com/watch?v=1JsDjCUlius&ab_channel=BerkshireSchoolGames
