Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Create a List of Rubrics – Automagically

Create a List of Rubrics – Automagically
create a list of rubrics

Previously I had created a template for creating rubrics to assess students. https://alicekeeler.com/rubrictab2 Assuming you may use rubrics for multiple assignments, I created ListRubrics to make this process easier.


RubricTab is an Add-On script I wrote to make assessing with a rubric a snap.

  • Design the rubric
  • Use the Add-On menu to call up a sidebar of options.
  • Paste a roster of your student names and email address
  • Run the script to create rubrics for each student
  • Assess each student. RubricTab does the math for you.
  • Run the script to email rubrics to students. They will receive a copy of their assessment.
  • View the roster tab to see a list of each student, their number of points, percentage, comments, how students scored on each category, and a link to their copy of the rubric.


ListRubrics allows you to create a list of your assignments that use a rubric and quickly create a copy of the RubricTab for each assignment.


After creating a copy of the template above, go the Add-On menu and find “listRubrics.” Choose “List rubrics” to reveal the sidebar menu.
Copy of List Rubrics

Start a List

In the sidebar, choose the “Start a List” button. This will create a new tab in your spreadsheet to allow you to list your assignments.

List Assignments

In columns A, B and C type out a list of the assignments you wish to create a rubric for. Column C is for the point value of the assignment. Since RubricTab does the math for you, go ahead and use wacky point values.
Sample assignments

Create Rubric Templates

After creating a list of assignments, click on the “Create Rubric Templates” button in the sidebar menu. This will generate a template for each assignment and link to it right in the spreadsheet. Be patient, it can take a few minutes to generate each rubric.

Edit Rubrics

In column D a link to a rubric was created for each assignment. Click on each one to edit the rubric.

Return to List

After you have designed each rubric, you will notice there are 20 numbered columns in E through X. Click on a blank cell in one of the columns for each assignment. From the sidebar, click the “Reuse Rubric” button. This will create a copy of your designed rubric and place it into RubricTab. A link to the copied rubric will be placed in the spreadsheet in the cell you selected.
Click on blank cells

Be patient, it can take a few seconds for each rubric to be copied and linked into the cell. Wait for the previous link to appear before creating another one.
Create links to rubrics

Using RubricTab

Clicking on the link to the rubric will allow you to copy and paste a roster of your students and their email addresses. RubricTab does require a valid email address. If your students do not have an email, you can enter your email address instead.
List of student emails


Use the Add-On menu select “RubricTab” and then select “Create rubrics.” This will reveal the sidebar.

Create Rubrics

Since the template for the rubric was copied over from the ListRubrics spreadsheet you are ready to create rubrics for each student. From the sidebar choose the “Create Rubrics” button.
Create Rubrics Button

Assess Students

After clicking on the “Create Rubrics” button, a tab is created for each student on the roster. Click on the tabs along the bottom. For each student give them comments in the comment box and change the default values of 4 to the appropriate rubric assessment.

RubricTab will calculate the math for you!
assess each student

Email Rubrics

After assessing all students, click on the “Email Rubrics” button in the sidebar. This will create a COPY of each students rubric assessment and email it to them. It also places this rubric assessment in their Google Drive.


Back on the roster tab, the students points, percentages, comments, category scores and a link to the students rubric assessment are all listed in one place. Google Classroom teachers can copy and paste the document link into the students comment box on the assignment.
Rubric Reporting in a single list

7 thoughts on “Create a List of Rubrics – Automagically

  1. I ran the scrip to email the completed rubric to each student. It stopped about half way through. Some of my students are done, but a link did not populate for the other half.

Leave a Reply

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

© 2024 All Rights Reserved.