I’m now entering my third week of remote teaching due to school closure for the coronavirus pandemic. The past few weeks have been a whirlwind – having to go from teaching students in a classroom to teaching them remotely from home has been a monumental task, especially considering that we made the transition over about a 48 hour time period. Fortunately, I am reasonably adept with technology, and have spent considerable time learning new platforms for remote teaching, as well as exploring new features of platforms that I use regularly.
Google Classroom is a platform that I use as an online hub for all of my classes. I noticed recently that there was an option to create a rubric to assist in grading of assignments, but after playing with it a bit I found the process of creating one in Classroom a bit cumbersome and time consuming. I also noticed that a rubric could be imported from Google Sheets. I use Sheets all the time, and it seemed like it might be a better tool than the native rubric creator on Classroom. The problem was that I didn’t know what format the Sheets file needed to be in to get it to import (my first few tries failed). To figure it out, I created a 1-item rubric in Classroom, then exported it to Sheets. I then opened the file in sheets, which provided a template for a single question that could be copied and pasted to add multiple criteria for an assignment.
In an effort to help others who might be trying to do the same, here is a link to a Google Sheets Rubric Template that I made for Google Classroom (to make a copy for yourself, click the “File” dropdown, then “Make a Copy”). It is formatted only for five criteria/items, with each one having 6 levels. Any cell on here can be modified easily, and you can cut and paste the set of rows for any given criterion to add more below on the spreadsheet. You can also add columns to the right side on each scale if you want to do a 10 point scale and so on.
Hope this helps, let me know if you have questions and I can try to help!