December 1, 2022

niagaraonthemap

Simply Consistent

FASTER! Create Rubrics for Google Classroom

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.

IT IS SLOW TO MAKE RUBRICS IN GOOGLE CLASSROOM!

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.

Specific Formatting

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.

Create rubrics for Google Classroom by using a spreadsheet template. Fill in each of the shaded cells. The first cell is in row 3 because the first 2 rows are hidden. Put the criteria title.

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.

GC Rubric is easier because it will automatically duplicate the level titles for each criteria row.

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.

Book Stepping up to Google Classroom by Alice Keeler and Kim Mattina is available on Amazon
Buy Stepping Up to Google Classroom on Amazon.

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

Adding a spreadsheet rubric to Google Classroom is as easy, if not easier, as reusing rubrics in 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!

Rubric Button: Create rubric, Reuse rubric, Import from Sheets

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

  1. Start a new Google Sheets Spreadsheet
  2. Use the Extensions menu to select GC Rubric by Alice Keeler
  3. In the Sidebar select Scoring Guide or Rubric.
  4. A template is automatically added to the spreadsheet.
  5. Fill in the criteria and levels on the spreadsheet.
    Customize for as many levels as you want.
  6. Use “Finalize & Download” from the GC Rubric by Alice Keeler menu
  7. In a Google Classroom assignment, choose “Import from Sheets.”

FASTER! Create Rubrics for Google Classroom

Rubrics for Google Classroom are slow to create and hard to reuse. Try GC Rubric by Alice Keeler to create faster and better rubrics for Google Classroom.

Fast – Add Student Birthdays to Google Calendar

Add multiple Google Calendar events at once. CalAdd by Alice Keeler makes it fast to add student birthdays to Google Calendar. Or any list of calendar events.

Bulk suspend google accounts

BULK SUSPEND GOOGLE ACCOUNTS

BULK SUSPEND GOOGLE ACCOUNTS. For admin of Google Workspace accounts. This free Add-on by CLAYCODES allows you to create a list of users and bulk suspend user accounts.

How Are Click Here Made

Are you wondering “How are click here made?” You see “Click Here” in many websites or emails. Here are the steps for how to create your own hyperlinks so people can click here.

Delete Multiple Google Calendars At Once

How to delete multiple google calendars at once! Created by Alice Keeler the Add-on DelCal quickly allows you to delete or unsubscribe from multiple Google Calendars. Delete multiple Google Calendars,…

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: