Case · English academy in Busan
From a shared spreadsheet and a group chat
to one screen per role
An English academy ran its daily operations on one shared spreadsheet and a staff group chat. I designed and built an operations system that keeps the same data but gives the director, teachers, study-lab staff and parents each their own screen.
Fictional academy and data. Best viewed on a computer.
How it went
What changed
- Problem
Too many spreadsheet tabs. Filters hid the row being edited, formulas broke when rows were deleted, and absences or student issues got lost in a busy staff group chat.
- Insight
The data itself was fine. The problem was the entrance: everyone opened the same sheet, so everyone saw everything and edited in the wrong place.
- Design
Nine role-based screens on the same data model. One curriculum and class-level table drives lesson plans, report cards and parent reports automatically.
- Build
A director home, teacher class records, study-lab records with automatic retests, a shared schedule synced to Google Calendar, student notes routed to the right person, and report cards that fill themselves.
- Next
Staff and rule settings, and parent messages sent straight from the monthly report. The same structure is being packaged for other academies.
Tell me about your academy's day.
We start by finding where time leaks and which students are slipping out of view.
You can also email me directly: [email protected]
At first the teacher turns the light on. In the end, students turn it on themselves.