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.
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.
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.
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.
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.
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.
Use the Add-On menu select “RubricTab” and then select “Create rubrics.” This will reveal the sidebar.
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.
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.