Collaboration Feedback

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.