Home » Google » Apps » Apps Script » Google Sheets: Rubric Template

Google Sheets: Rubric Template

Alice Keeler Rubric Template

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

RubricTab Template

Go to https://alicekeeler.com/rubrictab to create a copy of the template.
For an updated version try https://alicekeeler.com/rubrictab2

 

MAXCASES

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.

Alice Keeler 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.

Roster

On the first tab you can paste a list of your student names.

Run Script

Use the button on the first tab or use the “Create Rubrics” menu at the top next to the Help menu. This will create a copy of the rubric for each student on the roster.
Create Rubrics Menu

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

44 thoughts on “Google Sheets: Rubric Template”

  1. Alice,

    Thank you for all of insight and wisdom in using GAFE! I am curious to know, are you using this individual assignment/project rubric along with Google Classroom? I have been using Goobric in collaboration with Doctopus and Google Classroom. I see this being a few steps shorter (easier) if the rubric works well with Google Classroom. Also, is it possible to have each of the student rubric scores emailed to them just like Goobric?

    Thanks in advance,
    Dean Mantz (@dmantz7)

      1. Not that it would not work in Google Classroom, I really think it comes down to me comparing it further to the rubrics I have setup for Goobric. Goobric just happens to function a bit differently by opening within the item being evaluated where as your resource would be a separate tab/window. I will also checkout your epicrubric option for emailing feedback.

        Nonetheless, I greatly appreciate all of your resources and collaboration!

        1. Goobric is a great resource. Highly recommend! It assumes the students work is in a Google Doc. Student work may be a project, spreadsheet, presentation or other representation. What I like about my rubric is that it calculates the grade by allowing you to set what each column (Excellent, Above Average, Average, Below Average and Unacceptable) are set at. I have seen some teachers mistakenly confuse a rubric score as a percentage. On a 4 point rubric the options should not be A, C, F or really low F. This sets students up for failure.

      2. Pingback: OTR Links 01/08/2015 | doug — off the record

      3. Hi Alice,

        I would love to use flubaroo for grading, but my IT department is concerned about a 3rd party having access to student grades. Do you have any thoughts on that or any suggestions for addressing that with them?

      4. I’m sure I’m just missing this somewhere, but from where are you pasting a copy of your roster? We use Infinite Campus as our SIS. Don’t see an option to copy a roster. Are you typing a roster for each class in Docs and then just using it all year? If so, which type of doc will allow you to copy it and then put each name in a separate cell without dumping the copy into a single cell?

        1. Every system is different. I am sure there is an export of something somewhere in your system. Quick and Dirty… ask your students to fill out a Google Form with their name, ID and email. Copy and paste from that. Boom 🙂

      5. Pingback: Using RubricTab to Assess Students | Teachers Blog

      6. Pingback: #ISTE2015 Takeaways | Technology.xcuz.me

      7. Hi Alice! Hope you are doing well. I’m trying to set up a rubric and was wondering if you think it would be more economical/efficient to place all students for all my classes in the same sheet or make a separate sheet for each class.

      8. I have downloaded and used your rubric tab template and I love it! Thank you! I have used it to grade a new assignment using a rubric I generated (withyou help on the template) however I cannot figure out how to email the students their grades. Each has their own tab generated in the google spreadsheets. Is there any way to share each tab with each individual students via email instead of printing out the completed rubrics?

      9. Hello , thank you for the rubric! My question is: if a student doesn’t have an account in Google Drive, can they still see their rubric when emailed it to them? I just don’t want to do all the work of creating one so that in the end they cannot see it if they don’t have an account. thank you so much!

          1. I am having an issue with the Rubric Tab Add-on. I have used the rubric template script with no issues until very recently. Now, when I try to email the students their copies of the rubric, it will only email the first student on the list and then gets stuck and will not email to any additional students in the class. It does this with every rubric I have created. I have tried creating a brand new rubric from the download with no luck. Any suggestions? If I can’t find a solution, I may have to try a different app. Being able to use an individualized rubric like this is invaluable for my foreign language live performance assessments.

              1. I don’t think it is a restriction issue. All of our students have a Gmail account, but the tag is specific to our schools. I have since discovered that this happens when I REUSE a rubric. If I create a new one from scratch, there are no issues with email, but if the rubric is reused/copied, that is when it will only email the first person their scores and then gets hung up. This happens every time. Any other suggestions?

              2. I used this template and it generated all of the tabs for the students. I graded each student project, but when I told it to email the rubrics, it would only do it for the first student. When I clicked on the document link it was generating, it was a link to your original generic template, but not the one I had edited on the rubric template tab. Any suggestions?

              3. Hi Alice, I love the rubric, but it will only make the first two students out of 5 document links, and comply their scores. Then it will only email it to the first student. My students and I have gmail accounts.

              4. I am having trouble finding the button to create the tab/rubric for each student. I have my rubric made and my roster put in but I can’t manage to find the “create rubrics” button!

                Thanks!

              5. Hi, I am an art teacher and I want to say that I am OBSESSED with Rubric Tab. However, whenever I try to make a new document google asks that I authorize and verify rubric tab. I have 500 students and projects on top of projects that I want to get through. Is there a way to keep rubric tab as an add on permanently without running the whole process over and over again?

                1. It would have to be submitted and permanently added to the Add-on menu. This is an approval process that has to go through Google and is a hassle. I am a casual coder not a professional. It is not worth the time and effort to jump through the hoops, and most likely be rejected due to requirements of having advanced features beyond what I’m capable of.

Leave a Reply

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