Embedded Files
This is a collection of the games and tools I have co-authored with ChatGPT.
All of them use Google Apps Script to enhance Google Sheets or Google Slides. All resources on this site were independently developed by Avi Megiddo and are not affiliated with or owned by any employer or institution.
© Avi Megiddo 2023 CC BY-NC
Click on an image to preview the template and make your own copy!
SlideSeats – Transform Google Slides™ into Dynamic Seating Charts & Group Manager
SlideSeats is a Google Slides™ add-on for educators that simplifies seating chart creation and classroom group management. Whether you want to form balanced groups, avoid pairing conflicts, or randomize individual seat assignments on a slide, SlideSeats has you covered.
Key Features:
• Automatic Chart Creation: Generate seating charts with customizable layouts
• Group Management: Easily create, rearrange, and swap student groups for projects or discussions.
• Individual Seat Randomization: Shuffle seat assignments to mix up seating dynamically.
• Conflict Avoidance: Set bad pairings to prevent conflicts, with smart wildcard management.
• Random Selector: Promote fair participation by randomly selecting and highlighting students.
• Intuitive Editing: Drag-and-drop adjustments and slide duplication let you save and reuse configurations.
How It Works:
Installation: Install SlideSeats from the Google Workspace Marketplace™.
Launch: Open the add-on and sidebar from the Extensions menu
Input Data: Enter student names using comma-, space-, or mixed formats.
Customize: Select your seating arrangement, set group sizes or randomize individual seats, and let SlideSeats generate your chart.
Perfect for educators, administrators, and instructional designers, SlideSeats saves time and enhances classroom management while keeping all data secure in your Google Drive.
Support:
For questions or feedback, email: megiddo at gmail dot com
Google Sheets Wordle software development.pdfStudent Comment Generator!
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.
Note: I have updated this tool, if you made your own copy of the template before September 8, 2024, consider getting a new copy.
Better visualization of random seating and groups. Can select random student, add bad pairings, reload classes from script properties.
September 8, 2024 update: now with adaptive difficulty based on average word length and total words. Automatically create word search puzzles and answer keys. Includes diagonals and reverse arrangments. Create a PDF of the puzzle. Read more about this tool here.
Bulk insertion of images one-by-one into slides. center all, left-align all, add/remove text box from all.
(a.k.a. Box of Thanks)
A take on Box of Thanks, with an aquarium theme. Click on the fish to see the thankful comments. Read more about this tool here.
Users recognize classmates/ colleagues who have been helpful. read thankful comments from others.
(Single & Double-Elimination)
Easily manage multiple tournaments, randomize order, check box to indicate winner, sheet manages winner/loser advancement. Read more about this tool here.
Students can simultaneously choose their mood, see how everyone is feeling, see their mood meter heat map over time. Read more about this tool here.
MYP Scoring Rubric
MYP Scoring Rubric
& Comment Bank
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.
Code walkthrough, and how to set up the trigger:
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.
Adapted from Peter Liljedahl's collaboration rubric, this interactive sheet allows students to evaluate their group members post-project, generate a comment based on their collaboration score range, and email the sheet to their group member(s).
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.
Print Queue
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.
Page updated
Google Sites
Report abuse