Sometimes its good to call on random students during class.
Calling on students is easy. Making it truly random and fair to everyone ISN'T.
I've tried various methods over the years (notecards, popsicle sticks, even playing cards once), but as it always happens, I can't always find them when I want them, I lose them, or I do a poor job shuffling and feel I'm not being random.
In order to make it more fair, I wrote a script in Google Sheets to pull the list of students from my spreadsheet (one sheet per class) and randomly pull a student's name from the list. It will continue (without replacement) to randomly select the students in the class until all are used up.
Instructions on how to add a script (along with the actual script) can be found here.
The script itself is here.
Full disclosure: I am NOT a programmer and I have no background in programming. I learned everything I know through books and Googling stuff. If you have a suggestion to improve on my script, let me know! I'll update it and give you credit. I'm a programming n00b and I do this in my (limited) spare time.
No comments:
Post a Comment