MIGT SMP
A custom web application built for a private school in Ghana to manage student records, fees, and attendance — replacing error-prone Excel spreadsheets.
The Challenge
The school was managing student records, fee payments, and attendance entirely in Excel spreadsheets. As enrolment grew past 400 students, this became error-prone and time-consuming — administrators were spending hours each week reconciling data across multiple files.
What We Built
We designed and developed a full-stack web portal with role-based access for administrators, teachers, and parents. Key features included:
- Student registration and profile management — complete academic history per student
- Term-based fee tracking — automated calculation of outstanding balances with payment receipt generation
- Attendance logging — per-class, per-day records with absence alerts to parents
- Parent-facing dashboard — real-time access to their child's attendance, grades, and fee status
- Admin reporting — term summaries, financial reports, and export to PDF/Excel
The Process
We started with a two-week discovery phase — shadowing staff through their daily workflows to understand exactly where the pain points were. This meant the final product solved real problems rather than assumed ones.
The build took eight weeks across three sprints, with working demos reviewed by school staff at the end of each sprint.
The Outcome
Admin time spent on record-keeping dropped by over 60% in the first term. The school now has a single source of truth for all student data, accessible from any device. Parents receive automatic SMS and email notifications for fee due dates and absences.
Technologies Used
Next.js · TypeScript · PostgreSQL · Prisma · Tailwind CSS · Vercel