← Back to all work Systems · Google Apps Script + Sheets

Chapter 2 · Turn the solution into infrastructure

Student Assignment Systems

The logistics infrastructure for experiential learning. Across four programs, I built the assignment engines that quietly place hundreds of students into the trips, activities, and workshops that make a school's signature experiences actually happen.

700+
Students placed
4
Programs powered
15
Discover India trips
50+
Hours saved
Overview

The infrastructure behind experiential learning

Experiential programs, service learning, "Week Without Walls" trips, activity days, STEAM workshops, are the experiences students remember most. They're also a logistics nightmare: hundreds of students, ranked preferences, capacity caps, fairness constraints, and teacher staffing, all of which has to resolve into a clean assignment before anyone boards a bus.

Over a single year I built and ran the assignment engines for four of AISC's flagship programs. Individually each saved real time; together they formed a reusable pattern for how the school runs experiential learning at scale.

The Problem

Great programs, fragile logistics

Every one of these programs was being assembled by hand, different spreadsheets, different people, different ad-hoc rules each time. The work was invisible until it broke: an over-capacity trip, a grade-skewed workshop, a student who never got placed. And because the process lived in someone's head, it couldn't be handed off or trusted to run the same way twice.

What I Built

Four assignment engines, one pattern

SEVAI Community Service

Oct–Nov 2025

The system that started it all: a 700+ line engine assigning 150+ students to 12 activities by ranked preference, with grade balance, capacity limits, automated notifications, and test mode. Saved 20–30 hours per cycle. Full case study →

Discover India, "Week Without Walls"

Apr–May 2026

The largest of the four. A complete assignment algorithm plus a 50+ page operations manual to place ~237 students across 15 trips spanning three pillars, Adventure, Service, and Culture. Handled 215+ student sign-up responses, capacity rules (20 students and 3 teachers per trip), gender balance, and a formal appeals process. I built the backend engine; I also chaperoned a trip myself.

Discovery Day 2026

Feb 2026

Automated assignment across 34 activities, morning, afternoon, and full-day sessions, from 215 student sign-up responses, with a capacity-tracked dashboard and near-full assignment at launch.

STEAM Week 2026 Distribution

Mar 2026

An automated workshop-distribution tool allocating 120+ students across 12+ prototype workshops over three days for Grades 6–8. I owned the assignment-automation piece in partnership with the program leads.

Impact & Results

Hundreds of students, placed reliably

700+
Total placements
across four programs
15
Trips assigned
Discover India alone
34
Activities
Discovery Day sessions

Across SEVAI, Discover India, Discovery Day, and STEAM Week, the systems placed well over 700 students by ranked preference while enforcing capacity, grade, and gender balance, and they did it repeatably. Each program could re-run its assignment, preview before committing, and hand the process to someone new without losing the logic.

The Discover India system in particular was built as a deliberate handover artifact: 50+ pages of documentation alongside the algorithm, so the school's signature trip program could keep running long after I left.

Lessons Learned

What I'd carry forward

  • Logistics is pedagogy’s silent partner.

    The trip nobody remembers as "well-organized" is the one that worked. Good assignment infrastructure is invisible by design, and that’s the point.

  • Reuse beats rebuild.

    Solving SEVAI cleanly meant Discover India, Discovery Day, and STEAM Week each started from a proven pattern instead of a blank spreadsheet.

  • Build the manual, not just the machine.

    A 50+ page operations manual is what turns a clever script into an institutional system that outlives its author.

Running a program that's held together by spreadsheets and luck?