Avi Megiddo's Script-Enabled
Click on an image to preview the template and make your own copy!
Better visualization of random seating and groups. Can select random student, add bad pairings, reload classes from script properties.
Users recognize classmates/ colleagues who have been helpful. read thankful comments from others.
Score by checking comment boxes, Auto aggregate comments to form feedback text, create, share, email PDF score report.
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.
Background: For some reason, as of October, 2023, EMFs in Google Drive can no longer be opened with Google Drawings. In the past, CloudConverted EMFs could be opened with Google Drawings and copied into Slides, enabling vector graphic editing in Google Cloud. This script converts their MIME type back to the old one.
Students can self-evaluate how a unit impacted their ATLs, if at all. The script will generate a summary comment for each ATL subskill from the categories of Thinking, Research, Self-management, and Communication.
Change the color of each shape on the slide, based on either 1) the current colors on that slide, 2) the hex codes (with #) in pasted text, or 3) using x random hex codes, where x is a quantity of your choosing.
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.