I have my students work in Collaborative Learning Groups (CLG’s). I learned this from the amazing Jackie Gerstein. I intentionally design collaboration activities that they will do with their CLG. Writing COLLABORATION super huge at the top of your lesson plans is one of the things I suggest. The CLG group provides students a support system and helps students to be more independent of me.

Peer Collaboration Google Form

I ask students to evaluate their collaboration with their CLG and the group members. A Google Form is perfect for this.

Template

alicekeeler.com/peercollabeval

Edit the Form

The template is generic, you will want to edit the Google Form to suit your needs. I highly recommend that you do NOT let students type in the names of their peers. It will make a mess of your data. Instead, use the dropdown question type to paste your roster of students. Click on “Option 1” for the dropdown question type and use Control V to paste your roster. It will fill in each student into a new choice. Quickly repeat for each group member.

The template has 6 group members (for a total of 7 collaborators) possibly this is too many for your student collaboration groups. Delete the questions that you don’t need.

Create a Spreadsheet

Do not forget to go to the “Responses” tab and click on the spreadsheet icon.

Conditional Formatting

In the spreadsheet select the column with the ratings. (Tip: You can hold down the Control key and select multiple columns at once.)

Right click or use the formatting menu to choose “Conditional formatting.” This will open a sidebar for you to create conditional formatting rules.

The default for formatting is “Cell is not empty.” Change this to “Is equal to.”

Set the condition to be 1 and use the paint can in the sidebar to highlight those cells red.

Click on “Add another rule.”

This will copy that formatting rule, thus preserving the range of selected cells. Edit the formatting rules for this second rule. Change “Is equal to” to “Less than.” and edit the 1 to a 5 and change the paint color to orange.

Choose “Add another rule” again. Edit this third rule to be “Less than” 7 and paint the cells yellow.

Click “Done.” Your list of formatting rules will appear in the sidebar.

Sample Data

If you would like to practice CLICK HERE to make a copy of the spreadsheet.