Avi Megiddo's Script-Enabled
Google Templates
Click on an image to preview the template and make your own copy!
Student Comment Generator!
Automate student feedback & comment writing. Tailor comments based on individual performance metrics, with easy gender pronoun customization. Enhance your educational workflow in Google Sheets with color-coded, personalized commentary.
Read more about this tool here or below:
Automatically create random orders, partners, or groups of 3-5. Smart remainder management. Video is of Version 2; Version 3 allows prevention of bad pairings. Read more about this tool here.
This Sheet sends a birthday reminder email to the teacher, with names and classes of students whose birthday is today or tomorrow. Choose the frequency and time of email via setting a trigger in the script editor.
Code walkthrough, and how to set up the trigger:
Print Queue
Rows get timestamped and sorted upon adding to queue. Subsequent edits lead to "losing your place in line"; that row moves down the queue, with a new timestamp. Spreadsheet alerts generated upon trying to edit the row of a different student.