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
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.
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.
Thank you so much for sharing!!!!
Good afternoon,
I have made a copy of your template so I can utilizing this outstanding resource for peer collaboration evaulation however, the copy is not showing up in my Drive. Could you please help me?
I would guess it is in another account inadvertently. https://alicekeeler.com/conflict if you are signed into more than one account at the same time this will happen.