Most teachers need to use a rubric at some point. This template is a 4 point rubric that will help you to score student work against the rubric. Make a copy of the template. Copy and paste your students names onto the roster tab and enter in your rubric information. Run the RubricTab script in the spreadsheet.
Google Developer Expert for Google Workspace, Alice Keeler, developed this unofficial add-on to help you with using rubrics for your class more efficiently.
The Add-on authorization screen will let you know that the Add-on is not approved by Google. However, you have made a copy and you are simply authorizing YOURSELF access to your own files. It is completely safe.
Make a Copy of the Template
Hint: Rubric First
While the first tab of the spreadsheet is your class roster, I would recommend that you create your rubric first. Go to the 2nd tab in the spreadsheet and build your rubric.
1) Rubric Tab
Go to the 2nd tab labeled “Rubric.”
2) Student Name
Leave cell B2 blank. You can put the students name into cell B2 once the tabs for each student are created.
3) Assignment Name
Replace the default text (click once and start typing, no need to delete) to be the assignment name.
4) Points Possible
Type a numerical value for the number of points possible for the assignment. The spreadsheet will automatically calculate the number of points the student earns based on the rubric.
5) Adjust Percentages
Determine what percentage each rubric level is weighted at. Please remember that a rubric score is NOT a percentage. A 2 on a rubric represents basic understand which is NOT the same as a 2/4 or 50%. Change the default percentages if you wish.
6) Determine Categories
Replace the default text of “Criteria One,” etc… with the categories your rubric assesses. Note that in a spreadsheet you do not need to delete the default text. Instead click one time on the cell and start typing. This will replace the default text.
If you have more than 4 categories the rubric will automatically adjust. Continue adding categories in column C.
7) Category Criteria
For each category replace the default text for the criteria at each rubric level. Do NOT double click to edit. Currently the cell has an intimidating formula written in it. Single click on the cell and type your new criteria. If you would like to to have multiple lines in the same cell (insert a hard carriage return) you can hold down the Control key on a PC or the Command key on a Mac while editing a cell.
8) Weight Categories
By default the categories are evenly weighted. If you want the categories to have different percentage values DELETE all of the category percentages and type in new percentages. You will want your percentages to add up to 100%. Cell B4 adds up the percentages of the categories. If your percents do NOT add to 100% the cell will turn red and tell you how many percentage points you need to adjust your categories by.
Make Your Own Copy of the Rubric Template
Use the File menu to make a copy of the spreadsheet with your template but no roster entered. Name this copy with the word “template” in the title. For example if this is your rubric for your “Of Mice and Men essay” title the copy: “Rubric Template of Mice and Men Essay.” This will allow you to reuse this rubric year after year and for multiple classes.
Make a copy of your template so you can reuse your own rubric.
The Roster Tab
On the first tab you can paste a list of your student names.
Run Unofficial Script
Other Script Templates
This Add-on is an adaptation of Alice Keeler’s TemplateTab Add-on. It adds additional functionality to add all of the student rubric scores in one place.