Manaiakalani Toolkits Term 2 2021 - Simplifying testing with Google Forms

Kia ora everyone,

It was great to be able to lead a Toolkit this afternoon on the topic of using Google Forms to create self-marking tests. This idea was birthed out of me getting fed up with the hours of marking of tests done on paper, such as the Schonell Spelling test, Maths basic facts, etc. I thought to myself that there has to be a more simple way of getting assessments done, without the hours of time spent marking, So, I did some Googling and watching of YouTube tutorials, and realised that I could solve my problem using Google Forms. I tried it with my class during mid-year testing last year, and it was a success! 

In terms of how Forms can help in this situation, the 'Quiz mode' feature of Forms is the key here - setting an answer key for each question and appointing a point value for each question. This way, as soon as the student submits the Form, it is marked instantly and the data is then readily available for teachers to view and analyse.

Check out the Meet recording and the Slides below! 👇

Self-marking Google Form - Schonell Spelling test 1

Kia Ora koutou, 

I had a few people asking me to share the link to the self-marking Schonell Spelling test Google Form which I had created, following the DFI session in which I referenced it. 

The link is attached below. It'll prompt you to make a copy of the Form and then you can go from there. All you'll need to do is connect it to a Sheet in the responses section. Also, as you'll see, it's only test 1. So if you want to duplicate for tests 2, 3 and 4, you'll need to do that for yourselves. I have also started inserting audio files using the extension 'Talk and Comment' but this isn't completed as yet. If you want to finish this, you can use this YouTube video tutorial. Here is the link to the test Form or on the screenshot below

If you have any questions, feel free to email me at: jeremy.ferguson@manaiakalani.org