Tag: ClassroomEfficiency

Posted on

Student Comment Generator

By Avi Megiddo and ChatGPT

In the educational landscape, providing individualized and fair feedback to students is a cornerstone of effective teaching. Yet, the task of crafting comments can be a daunting challenge for educators, particularly when faced with the sheer volume of evaluations required.

The Student Comment Generator supports the creation of student feedback based on set performance metrics.

Simplifying Feedback through Automation

The Student Comment Generator is a custom Google Apps Script designed to automate the process of writing student feedback comments in Google Sheets. It works by analyzing performance metrics from specified columns and using predefined phrases to compose tailored comments for each student.

The tool is designed with both efficiency and fairness in mind. By automating the initial draft of student comments, it offers a consistent framework that ensures each student is evaluated against the same criteria. This saves valuable time for educators and fosters a more equitable assessment environment.

Instructions

Setting Up Your Sheet: Begin by entering each student’s first name in column B and selecting the appropriate gender pronoun in column A from a dropdown list. This step primes the tool with the necessary personalization details for each comment.

Name and gender setup

Defining Performance Metrics: In row 1, cells D1 through K1, define up to eight performance metrics such as Summative completion or Participation. These metrics drive the content of the automated comments.

Performance metrics header row example

I teach MYP Design, and we use performance metrics such as overall completion, design cycle knowledge, and original and creative work.

Performance level dropdowns

Crafting Performance Descriptors: For each metric, write corresponding low, middle, and high descriptors in columns N through U. These descriptors are used to construct comments reflecting each student’s performance.

The descriptor text should include the placeholder [Name] and the pronouns He, he, His, his, him, and himself instead of actual student names and specific gender pronouns. The script replaces these placeholders with the correct student name and pronouns automatically.

Masculine pronouns are used intentionally in templates for linguistic clarity and reliable substitution. This ensures accurate replacement across all genders during automation.

Descriptor phrases table

Generating Comments: With a single click in cell L1, comments tailored to each student’s performance populate in column C. An optional final sentence can be added in column L for personalization.

Generated comments

Continuity for New Classes: Duplicate the sheet for new classes and replace names, genders, and metrics as needed.

Duplicating the sheet

Key Components: Understanding the Script

  • Data Retrieval: The script identifies the ranges containing student data and performance metrics. Columns D through K store metric levels.
  • Comment Construction: The script matches each metric level to predefined phrases in columns N through U and assembles a coherent comment.

Script logic overview

  • Rich Text Styling: Sentences are color coded based on performance level to enhance clarity.
  • Final Output: Comments are written back to the sheet with consistent formatting aligned to each student.

Styled comments

© Avi Megiddo 2023 ·
CC BY-NC

Posted on

Teacher tool: make random orders, partners, and groups


Make random orders, partners, and groups

This is a handy tool that will make organizing random orders, partners, and groups a breeze in your classroom. With just a few simple steps, you can randomize student names, create random partners, and form groups of three or four. This tool is designed to save you time and ensure fairness in your classroom activities and assignments.

DEMO:

To get started, follow these instructions:

  1. Open the template preview of the Google Sheet.
  2. Click the ‘USE TEMPLATE‘ button in the top-right corner.
  3. Paste the names of your students in Column B, starting from cell B3.
  4. To randomize the order of the names, click the ‘Randomize‘ button.
  5. To create random partners, click the ‘Make Partners‘ button.
  6. Click the ‘Groups of 3‘ or ‘Groups of 4‘ buttons as you wish.

The code:

I would like to assure you that running the unverified Google Apps Script I’m sharing is a safe and straightforward process. Here’s what you can expect:

  1. Authorization Request: When you run the script, you’ll encounter an authorization request. This is a standard procedure and necessary for the script to access specific data within your Google account.
  2. Clicking “Advanced”: During the authorization process, you will be prompted to click on the “Advanced” option. This step allows you to review and understand the script’s permissions before proceeding.
  3. Allowing Script to Run: After clicking “Advanced,” you might encounter a warning about the script being unverified. Rest assured, this doesn’t mean any malicious activity is occurring. To proceed, simply select the option to allow the script to run.

Please note that by allowing the script to run, you are basically giving it permission to read from and modify the contents of cells in the sheet. This is necessary for the script to perform the requested actions for you.

Additionally, I want to clarify that the code for this script was authored with ChatGPT. However, it is self-contained and does not involve any external APIs or calls to AI when it is run. Your data and device will remain secure. Feel free to use and modify the code as per your requirements.

I hope this tool simplifies your classroom management and fosters a collaborative and inclusive learning environment. If you have any questions or feedback, please don’t hesitate to reach out.

Happy teaching!

Avi