OIRE — Institutional Research Data Portal
American University of Nigeria, Office of Institutional Research & Effectiveness
- Problem
- The office needed one place to load, check and report on admissions, enrolment and retention data, with control over who can see and change what.
- What I built
- A role-based portal for administrators, analysts and viewers; CSV import pipelines with import history; analytics modules for admissions, enrolment, retention and academic performance; and an audit log of every significant action.
- Stack
- PHP 8, MySQL 8, Apache on Ubuntu. No framework; CSRF-protected forms and per-page role checks throughout.
- Outcome
- Running against live institutional data: 3,540 users, 16,094 student records and 10,184 enrolments across seven academic semesters.