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! 👇

Google Sheet for e-asTTle Writing data - formulas and conditional formatting

Kia ora koutou, 

To assist with managing your e-asTTle writing test data, I have put together a Sheet with formulas and conditional formatting. Either use the drop down boxes or type the 'R' values into each cell (B-H) and it will give you a total (cell I) and a writing level (cell J). Row 36 also gives you a break down of how many of your learners are at each curriculum level, based on their results on their test. 

Hopefully you find this resource helpful!

Have a look for yourself by exploring the embedded window of the Sheet below and feel free to make a copy of the Sheet using this link. Also, if you have any questions, feel free to email me - jeremy.ferguson@manaiakalani.org

Hāpara Champion Educator!

Kia ora everyone,

I am happy to announce that I have received my recognition for completing the Hāpara Champion Certification Program earlier this month! I am really looking forward to putting into practice the skills that I have learnt during this course.

Below is the link to the Hāpara Workspace that I created as part of the final assignment. I based it on the e-asTTle Writing test, as this was a need that I was facing in my school at the time. I am happy for teachers to make a copy of it and use it in their schools.

Ngā mihi  

      

Click on the screenshot above to check out the Workspace and make a copy of it for yourself