CoRubrics GSuite operation

CoRubrics GSuite Add-on is in Add-on Google sheets Gallery.

Install CoRubrics G Suite Add-on.

If CoRubrics menu is empty, Add-ons / Manage Add-ons / CoRubrics G Suite / Use in this document


Create template of CoRubrics.

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


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

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

If you assess students, put the names and emails:

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


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


Now, the rubric is customizated. You just have to use the menu at the top, named 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 and it is located in My Drive.


We asked permission for the script use our Drive and our Gmail. We will have to concede. 

We asked for a name for the form. Ready, the will have been created in My Drive.

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


2- Send by mail the form to students or get the link if only teacher corrects:

Now the CoRubrics menu has changed. The first option is to mail 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 himself.

If the assessment makes only by the teacher, rather than send the link to students, you can get the link of the form. So you can answer it. CoRubrics automatically detects if is teh teacer who answer.

3- Process the data to obtain mean:
Once you send the link to students or seen it on screen, the menu CoRubrics has changed 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 students. The name of this sheet is date and time of processing and it contains all averages. In the same sheet, you can see the averages:
  • Co-evaluationa: Averages of all answer to one student.
  • Self-evaluation: Qualifications answered by the own student.
  • Teachers evaluation: Averages of all teachers answers to one student.

You can see averages for every Aspect and Overall rate.

In the example (picture), Student 1 has been assessed by 1 student, 1 teacher and himself. Student 2 has been assessd by 2 students and 1 teacher.

In first aspect, Student 1 obtain the max punctuation (4) in three evaluations (by other students, by himself and by 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 example, Students 1 obtain 7.5 in the lowest item (in three evaluaiton) and 9.5 (coevaluation), 9 (self), 8.5 (teacher) i the weighted average.
 

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


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


4- Send results and commentary students

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

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

Pressing the menu will ask us if we want to send the final grade. If you say not, only aspecte scores will be sent. If you say yes, we asked which of the two final grade will be sent.

Then, pop-up screen ask you about comments, if you want to send or not.

Students will receive an email like the following (in this case indicating the final grae 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.