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
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
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.
On the first tab you can paste a list of your student names.
Use the Rubric
A tab for each student on the roster has been created. Each tab has the rubric duplicated. When assessing student work go to the tab with that students name. Replace the default values of 4 for each category with the score that you assess the student work at. The rubric template will automatically calculate the students percentage and score.
Other Script Templates
This template is based on the generic TemplateTab template. Click Here
To create a blank tab per student try the RubricTab template. Click Here