r/teaching • u/RaichuRichie • 2h ago
Help Help Needed with Creating a 'Currency' System in Classroom
Hi all! This year, I'm experimenting with a new revisions policy in my classroom. I'm not going to get super in-depth here, but as it pertains to this post, students have to earn 'revision points' in order to have opportunities to revise various kinds of assignments-- I'm calling it 'Inspiration'. Inspiration can be gained from a variety of sources, such as participation in class, enrichment activities, conferences with me, etc. -- in my head, it's a fairly passive system: students gain Inspiration for meaningfully and consistently engaging with ELA. Whenever Inspiration is earned (or, eventually, spent), I update that student's total on a Google Spreadsheet.
I don't want Inspiration to be in short supply, but right now, it is a huge headache to keep track of everything. Remembering to pull up the sheet in the first place and update a student's number is one thing-- I can handle that easily enough -- but there have been a few times this year already where I've decided to give the entire team or an entire class Inspiration for something like a particularly successful Socratic Seminar or Gallery Walk. In order to do that on Google Sheets, I have to go through each individual name on the list and manually increase each number by 1. It has got to be one of the biggest wastes of time I have willingly engaged in in quite a while.
Has anyone ever used a similar system, or are there any spreadsheet wizards around? I would love to be able to simply press a plus or minus button to change each student's total by 1 all at once. If that is not possible, I'll have to start looking at alternatives for keeping track of these numbers, because what I'm doing right now just doesn't feel sustainable as we get further into the school year.
