This is a sample case study showing the format. Replace it with a real project.
Problem
The school office manually copied class schedules from the system into spreadsheets, sent SMS reminders and assembled weekly attendance reports for the owners. It took about two working days a week.
Decisions
- Schedule sync through the school system’s API instead of CSV exports.
- A scheduled notification queue: SMS reminders a day and an hour before class, with cancellation handling.
- Reports generated automatically and sent on Monday mornings.
- A full event log and an alert when an integration fails.
Outcome
- About 15 hours of work saved per week.
- Zero manual exports.
- Fewer no-shows thanks to reminders running 24/7.