CoRubrics GSD operation

CoRubrics GSD is in Add-on Google sheets Gallery.

Install CoRubrics GSD Add-on.

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, Add-ons / CoRubrics GSD.

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. Ready, the form will have been created.

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 the teacher who answers.

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-evaluation: 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 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.