CoRubrics operation

CoRubrics is an Add-on in the Google Sheets Chrome Webstore.

Install CoRubrics Add-on.

Create a template of CoRubrics.

Below, a spreadsheet is open with three sheets. In the first, there is a rubric to fill-in.


You can change the names of the levels (Expert, Advanced, Apprentice, Novell) and their scores. And if you want, you can add or remove levels. The same is true for the aspects evaluated, which you can remove or add. It is only important that the column where are indicated the weights be the last column of the rubric.

The second sheet should indicate the names and addresses of students. 

If you assess students, add their names and emails (These can be imported from Google Classroom):

If you assess groups, put the name of the group and all the emails of the students that form this group:


If you wish for parents to receive a copy of their child's rubric, their email can be added as well.

The third sheet is used to indicate the name and the email of the teacher (or teachers).


Now, the rubric is customized. You just have to use the menu at the top, Add-ons / CoRubrics.

1- Create a form with the contents of the rubric:

The first step is to create the form. When the menu is selected, you can create a form with the rubric.

We asked for a name for the form. Then, the form will be created.

No need to open the form at the moment, but it looks like this:


2- Send the form by email to students or get the link if only the teachers is assessing the students:

Now the CoRubrics menu has changed. The first option is to email the link to students. If selected, each student will receive an email like this:

The students can click the link and answer the form. CoRubrics automatically detects if any students assess themselves.

If the assessment is done by the teacher, rather than send the link to students, you can get the link to the form. The teacher then fills out the form for each student. CoRubrics automatically detects if it is the teacher who fills out the form.

3- Process the data to obtain mean score:
Once you send the link to students or see it on the screen, the CoRubrics menu has changed once again. When you and/or your students have answered the form, you should choose Process form responses from the menu.

In doing so, a new sheet will be created after the sheet entitled "Students". The name of this sheet is the date and time of processing and it contains all averages. In the same sheet, you can see:
  • Co-evaluation: Averages of all answers for each student.
  • Self-evaluation: Qualifications answered by the student themselves.
  • Teacher's evaluation: Averages of all teachers answers for each student.

You can see averages for every Aspect and the Overall grade.

In the example (picture), Student 1 has been assessed by one peer, one teacher and himself. Student 2 has been assessed by two students and one teacher.

In the first aspect, Student 1 obtained the maximum grade (4) in three evaluations (by other students, by himself and by the teacher). Student 2 obtain 3/4 by other students and 2/4 by teacher.

To turn a rubric in a numeric grade is always a problem. For this, two global grades are offered. The first grade is the lowest aspect and the second grade is the weighted average of the issues.

In this example, Students 1 obtained 7.5 in the lowest item (in three evaluations) and 9.5 (co-evaluation), 9 (self), 8.5 (teacher) in the weighted average.
 

At the end, you can see Comments: students comments and teachers comments.


If any students assess the same students twice (or a teacher assesses the same student twice), when CoRubrics processes the data, a pop-up screen will ask you if the second answer will be deleted or not.


4- Send results and comments to students

Finally, the CoRubrics menu has changed again. It lets you send the results to students by email. First, you must choose which result you wish to send: Co-evaluation, Self-evaluation or Teacher evaluation.

Each student (or each group of students) will only receive their results.

Clicking the menu will ask you about send options (send comments, send final grade...).

Students will receive an email like the following (in this case indicating the final grade is sent):


When the process is finished, you can restart. So that if the rubric is passed more than once with the same group, we have several sheets of results to compare the data.