CoRubrics is an Add-on in the Google Sheets Chrome Webstore.
- Install CoRubrics Add-on.
- Use Add-on menu / CoRubrics / Create a template of CoRubrics.
- 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 (4, 3, 2 ,1). And, if you want, you can add or remove levels. The same is true for the aspects evaluated, 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:
- If you use Google Classroom, you can import your students names and emails:
- 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).
- If you use Google Classroom and you've imported students, this sheet contain teacher's name and email.
- 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 or publish in Classroom:
- Now the CoRubrics menu has changed.
- The first option is to email the link to students. If you select it, 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 you use Moodle or another LMS, you can obtain the link of the form with second option un menu.
- If you use Google Classroom, you can publish this link as an annoucement.
CoRubrics automatically detects if it is the teacher who fills out the form, the owner student or another student.
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 (one time for every product to evaluate), you should choose Process form responses from the menu.
- You can choose the maximum grade (10, 100, 4...). Any integer is accepted.
- In doing so, a new sheet will be created after the sheet entitled "Teachers". 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 10 other students, one teacher and himself. Student 2 has been assessed by 12 other students, one teacher and himself.
- In the first aspect, Student 1 3.7/4 in Coevaluation, 4/4 in selfevaluation and 4/4 in teacher's evaluation.
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 the next grades:
- Usually, we use weighted average grade. But, in this example, is good to know that this student hav some problems with one aspect.
- If you need only one grade (Overall Grade), CoRubrics calculates the average of three assessments (Co-evaluation, Self-evaluation and Teacher evaluation). You can manually change the percentage assigned to each one.
- At the end, you can see Comments: teachers comments, students comments and students themselves 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.