I have a love hate relationship with the rubrics in Google Classroom. I obviously want rubrics but I also want more from the Google Classroom rubrics. Unfortunately, rubrics are NOT part of the Google Classroom API. What does this mean? I can NOT code the rubrics to be able to aggregate the scores 😡.While I can not code the rubrics I CAN CODE SPREADSHEETS! You can create rubrics for Google Classroom FASTER if you import them from Google Sheets.
Adding Rubrics for Google Classroom
You can create your rubrics right in Google Classroom. Personally, I find the workflow challenging. You have to input the scoring words and points for EACH criteria row. If you duplicate the criteria you have to delete the description for each of the bins.
Sharing Google Classroom rubrics is also a challenge. To accomplish this you would have to a) add someone as a co-teacher and they reuse the assignment b) share the assignment to a shell class that is shared with other teachers c) awkwardly export the rubric to a spreadsheet and share the spreadsheet.
The share a spreadsheet option is really the best. You can share a Google Sheets spreadsheet with anyone. However, it’s confusing how to export the rubric to a spreadsheet.
You can not just upload your spreadsheet rubric to Google Classroom. The spreadsheet has to be formatted in a very specific way… SO I CREATED GC RUBRIC!
GC Rubric by Alice Keeler
Previously I had created a template alicekeeler.com/rubric and alicekeeler.com/scoringguide … the problem with this of course is you have to remember how to find these templates. I decided to turn these popular templates into an official Add-on. This is a Google Sheets Add-on. It will create the structure to allow you to more quickly create a rubric.
Sharing is The Way to Go
GOOD rubrics are time consuming and difficult to make. Why make a new one when you can use one someone else has made?! By creating your rubrics in Google Sheets, and encouraging others to as well, we can share much more easily! Create a folder in your Google Drive and label it Google Classroom rubrics. Change the sharing on the folder to allow others to VIEW. Share out the rubric spreadsheets on social media
In your Google Sheets spreadsheet, use the Extensions menu to select “GC Rubric by Alice Keeler.” Choose Show Sidebar.
Rubric or Scoring Template
There are 2 types of rubrics you can add to Google Classroom. One that is strictly to communicate feedback to students and one that helps you with scoring the assignment. In the sidebar, select the type of rubric you want to use.
Fill in the Criteria
Most rubrics have multiple criteria (rows). For the Google Classroom template, each “row” takes up 4 rows. The criteria title, the description, the rubric levels, and the description of each level. My template defaults to 4 levels plus a missing option. However you can change this by adding more levels or deleting levels.
Rename the Levels
I am not a fan of “exceeds expectations,” so I start the levels at “Meets Standard.” You very likely have your own verbiage you use in your rubrics. This is easily changed in the template. Single click on the green cell that says “Meets Standard” and start typing a new level title. No need to use the delete key.
Want More Help with This? Become a Premium Member
Automatic New Criteria Row
Once you enter a title for a criteria row, a new criteria row will be generated. This helps to speed up the process of creating a rubric.
Level Headings Match But Do Not Have To
When a new criteria row is created the level headings are copied from the previous criteria. No need to reenter. However, if your criteria row has different level headings you can easily change them. Notice in the image below that I have 5 levels for the 1st criteria but only 2 on the second. For the third, I may want to use the levels of the first criteria. Copy and paste the titles or type new ones. Cell D12 of the image below is blank. Type in it the level title you want and it will automatically adjust to having 3 levels instead of 2.
Finalize & Download
When you are done creating your rubric, use the option to “Finalize & Download” from the Extensions menu. It is misleading to say you download a Google Sheets spreadsheet, it is already saved to Google Drive. However, choosing Finalize & Download will remove extra criteria rows since a new criteria row automatically generates. It also removes any cells that say “description.” This allows you to leave the default “description” text throughout the rubric without having the word show up in your final product.
Organize in Google Drive
I highly recommend you create a folder in your Google Drive to organize your spreadsheet rubrics. Add the word rubric to the title. Name your rubric something meaningful such as “participation rubric.” In Google Classroom, the rubrics are saved as the assignment title which tells you little about what kind of rubric you have attached that you would want to reuse. Organizing your rubrics in Google Sheets gives you a lot more control. It is also extremely easy to share rubrics created in Google Sheets. Click the Share button. Easy peasy.
Add to Google Classroom
When creating an assignment in Google Classroom, there is a “Rubric” button. There are 3 options when you click on the Rubric button: Create rubric, Reuse rubric, Import from Sheets. Choose “Import from Sheets.” This allows you to search your Google Drive to find the rubric that you named with a meaningful name. Simply select the spreadsheet and it imports in with ease!
Reusing Rubrics is Much Easier
If you want to reuse your spreadsheet rubric it is very easy. On a new assignment, select Rubric and Import from Sheets. Search your drive for your spreadsheet rubric.
Reusing rubrics from Google Classroom requires you remember which assignment in which class had the rubric. I have always found this challenging and slow. Spreadsheet rubrics instead are the way to go!
Steps for Creating Rubrics
- Start a new Google Sheets Spreadsheet
- Use the Extensions menu to select GC Rubric by Alice Keeler
- In the Sidebar select Scoring Guide or Rubric.
- A template is automatically added to the spreadsheet.
- Fill in the criteria and levels on the spreadsheet.
Customize for as many levels as you want.
- Use “Finalize & Download” from the GC Rubric by Alice Keeler menu
- In a Google Classroom assignment, choose “Import from Sheets.”
Google Sheets Rubric Template for Google Classroom
I had previously created a Google Sheets rubric template for Google Classroom. One for scoring and one for feedback. These use NO CODE. If you are unable to install GC Rubric by Alice Keeler you can still use the Google Sheets Rubric Templates: