I am diving full speed into Learning Goal / Standards Based Grading this year, and I’m still using the gamified spreadsheet that I started working with last year thanks to Kyle Pearce, Jon Orr, and others (see posts here, here, and here).
I just finished the latest version of the spreadsheet, ready to use for the year. I cleaned up and simplified the student version of the sheet, made a few of the auto-populated areas go faster, added a separate tab for student E-mail and URLs so the script can automatically send links to students if you have their e-mail addresses. I also protected certain ranges so it will warn you if you try to edit something that you probably shouldn’t mess with; that should help prevent anybody out there using it who is less savvy from accidentally breaking it.
This is what a published website version of this version looks like – what the students see
This is what the sheet where you actually enter your learning goals and scores on looks like:
Pretty slick additions! The master sheet has been cleaned up really nicely, also!
I can’t wait to check it out further. Liking the idea of having a weighting option, too. This thing is getting pretty complex, but more simple to use with each iteration. I LIKE IT! 🙂
Thanks for sharing!
This is amazing! I absolutely want to implement it next year…..but I can’t get it to work. For some reason, when I input info into the master sheets, it doesn’t populate to the rest. Any ideas on what I’m doing wrong?
I am not really using this spreadsheet anymore (or at least I’m taking a break from it). Not sure why it wouldn’t be auto-filling for you, but I recommend you try a different version of the sheet anyway that has been rather extensively improved by Michael Matera.
You can find a post about it here: http://explorelikeapirate.com/standard-based-grading-gamified-and-googled/
(That site appears to be down for me this moment, but I expect it will come back up soon).