Home » Google » Add a Rubric to Google Classroom with Google Sheets

Add a Rubric to Google Classroom with Google Sheets

You can add a rubric to a Google Classroom assignment using Google Sheets. This is my preferred way.

Template

Make a copy of the rubric template to help you successfully upload your rubric. It has to be in a specific format. I created a no code template.

Rename Spreadsheet

Google Sheets automatically saves to Google Drive. No need to do anything once you enter your rubric information. However, to make it easy to find when adding rubrics to Google Classroom I suggest you rename the spreadsheet to something meaningful and use the word rubric in the title so when you search Google Drive you can find it.

Add Criteria Title and Description

The format that Google Classroom requires has some information in rows 1 and 2, I have hidden those. You don’t need to look at them, but they need to be there.

The criteria goes in the yellow cell in column A and you can describe generically what that means in the blue cell in column A.

Put criteria title into the yellow cell A1 and description into A2

When you enter a criteria title and description this will automatically create a new criteria row and description.

New criteria row automatically appears

Level Descriptions

Read up on researcher Dr. Thomas Guskey who says to not use “Exceeds” on your rubric. What you expect is your top category. As per Dr. Guskey’s recommendation I have defaulted the levels in the rubric to be “Meets standard.” You can modify these in the green cells. These descriptions will be copied to each criteria row.

In the pink cells you can give a detailed explanation of what you expect in order to reach each level.

Delete Title and Description

A new row for criteria title and description will continue to appear as you add criteria. Simply delete the yellow “title” and blue “description” and this will stop the automatic row generation.

No Save Button

Google Sheets has no save button. Simply close the spreadsheet.

Rubric in Google Classroom

In Google Classroom, when creating an assignment, click on the Rubric. button and choose “Import from Sheets.” Your rubric will be right there. Easy peasy.

Scoring Guide

If you are creating a scoring guide I have a template for this as well:

6 thoughts on “Add a Rubric to Google Classroom with Google Sheets”

  1. Hi, Alice! Thanks for your work! When I tried to upload the file after adding information it said there was an error. So, I entered all the info straight into the rubric form in docs. When I looked at the SS generated by my rubric, the difference between your template and the SS is it looks like the actual numerical score is missing (5,4,3,2,1) from each of the topics. Any suggestions?

  2. Thanks for this helpful tutorial! However, I encountered a similar problem (using the gcscoring template). When I tried importing the Sheet, I got a little pop up error saying ‘There was an error importing the rubric’. Annoyingly GC doesn’t give any more information, only the option to ‘dismiss’ the pop up. I added two columns in the Sheet, but that shouldn’t be a problem, should it? (I copied all of col E and pasted it into F and G.) I also tried deleting all the unused rows, in case the formulae hiding in them was causing a problem, but no luck. Any ideas?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.