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.

Want More Help with This? Become a Premium Member

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:

Turn Your Docs into Forms and Slides

How to turn a Google Doc into a Form. Use Document Outline by Schoolytics Add-on to quickly turn your Google Docs into Forms, Slides, or Sheets.

Canva Jamboard Background

Try designing your backgrounds for Google Jamboard in Canva. Canva Jamboard Backgrounds are easy and make your Jams really Jam!

9 Google Forms Formative Assessment Tips

Want to use Google Forms as a formative assessment quiz? Check out these 9 tips. Google Forms Formative Assessment

Google Forms: STOP Students From Going to Previous Section

In Google Forms with Sections, how do you stop a student from going to a previous section they already completed?

How to Use Quiz Helper for Google Forms™

Use Google Forms as a quiz. Get your settings right. Provide students feedback in Google Docs. Allow students to finish their quiz later.

8 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.