Civic AI ClubPomfret School
Bring us a problem (opens in a new tab)

Case F · Project: Pomfret · Built by Christoph Ortenburg ’28, Lucas Shi ’29, Serena Xu ’28, Keke Li ’27, Luke Ryan ’27

Project: Pomfret sorting

One click on Create draft placements proposes groups for every student, then shows how many take a Major or two Minors and what needs review. Demo data.

The chore

Each year, hundreds of form answers had to be read and balanced into project groups by hand. The sorter proposes every group and explains each placement.

The fix

Proposed Project: Pomfret groups, sorted by students’ choices and the program’s rules.

Lives in

A Google Sheet with a “Project: Pomfret” menu.

Makes

A master list with each student’s two weeks, a roster for every group, and a reason for every placement.

Balances

Group sizes, Majors and Minors, grade order, friend requests and last year’s projects.

The one rule

The sorter proposes and a person decides. Anything it can’t settle is flagged for review.

How it works

  1. Students’ form answers go into a Google Sheet.

  2. The sorter counts interest by grade and suggests which projects run as Majors or Minors.

  3. It proposes one Major or two Minors for every student, with the reason, and flags anything a person should decide.

  4. The program’s director checks the groups and makes the final changes.

The sorter counts interest by grade, proposes groups for both weeks, and explains a placement. Demo data.

  1. At 0 seconds:Every student’s choices, counted by grade.
  2. At 4.3 seconds:Choose which projects run, as Majors or Minors.
  3. At 7.3 seconds:One click proposes groups for both weeks.
  4. At 9.8 seconds:Anything a person should decide is flagged.
  5. At 16.8 seconds:Every placement says why.
One student’s placement and the reason for it, with tags for whether they checked each project and whether its type and goal match. Demo data.
The project groups for Week 1 and Week 2: the Minor groups change between weeks, and the Majors stay the same. Demo data.

Credits

Built by Christoph Ortenburg ’28, Lucas Shi ’29, Serena Xu ’28, Keke Li ’27 and Luke Ryan ’27 for Project: Pomfret.

  • Runs on Google Sheets and Apps Script.
  • Status Delivered in October 2026 as proposed groups. The program’s director makes the final changes.
  • Repository (opens in a new tab)

Next: Case A

All cases

Three students’ color-coded weekly tables in AutoPlanner, one after another. Demo data.

AutoPlanner

CLC Supported Study Hall

Each student’s Canvas assignments, rebuilt as a weekly Google Doc.