Empower student reflection and peer evaluation with Collaboration Feedback, an Add-on for Google Sheets™ by Avi Megiddo.

This Google Sheets™ add-on helps students reflect on their groupwork, evaluate their peers' collaboration, and generate thoughtful, structured feedback—all from within a spreadsheet.

Built on Peter Liljedahl’s collaboration rubric and grounded in the IB MYP Design framework, this tool streamlines the entire reflection process into one clear, easy-to-use interface.

🔧 What It Does
Allows students to assess peer collaboration using an interactive Likert-scale rubric

Automatically calculates a total score based on checked values

Categorizes feedback into key collaboration dimensions:

Respect & Inclusion

Team Participation

Communication

Team Impact

Generates a tailored comment paragraph using tone-matched feedback phrases

Adds a closing comment based on overall score level

Lets students export the evaluation as a clean PDF

Enables sending feedback via email with one click—no file attachments needed

🎓 Why It Matters
Collaboration is a skill. Reflection makes it visible.

This add-on supports student growth in:

Approaches to Learning (ATL) skills in IB programs

Visible Thinking Routines and reflection strategies

Peer feedback and formative assessment

21st-century competencies like communication, empathy, initiative, and leadership

The tool encourages students to consider not just what they did in a group project—but how they showed up for others, how they contributed, and how they affected the team dynamic.

🧩 Designed For
IB MYP Design and Product Design

Project-based learning in any subject

Humanities, Science, Art, and interdisciplinary projects

Group presentations, labs, investigations, and creative collaboration

🖥️ How It Works
Open the add-on in a Google Sheet™.

Import a fresh evaluation template with one click.

Complete the evaluation using structured checkboxes (rows 8–17).

Click "Generate Comment" to receive customized feedback.

Export to PDF or email to group members and the teacher.

🔒 Privacy & Data Use
This add-on only accesses the active Google Sheet™ and the email addresses entered by the user.
It does not store or transmit any student data externally. PDF exports happen client-side, and emails are sent only to the specified recipients.

Scopes used:

spreadsheets: to read/write data in the sheet

script.external_request: to fetch the PDF blob

gmail.send: to email the PDF

script.container.ui: for sidebar and dialog interactions

drive.file: only for files opened/created by the script

🔗 Additional Features Coming Soon
Student self-evaluation mode

Scheduled group reflection cycles

Comment language customization

Sheet dashboard view for teachers

Support reflective collaboration. Make peer feedback visible.
Try "Group Member Feedback" today.