The Challenge
The Department of Education manages data for thousands of public schools across the Philippines — student enrollment records, personnel files, budgets, learning materials, and administrative reports — all previously spread across siloed spreadsheets and legacy systems with no unified interface.
The mandate: design a modern, scalable management information system with complex role-based access control that non-technical administrators could operate confidently, while also satisfying the reporting and audit requirements of a government institution.
The Solution
I architected a modular MIS with a clear information hierarchy — starting with a national dashboard that cascades down to regional, division, and school-level views. Each user role sees only the data relevant to their context, reducing cognitive load and compliance risk.
- Role-based access control UI with permission-aware navigation
- Multi-level data hierarchy: National → Regional → Division → School
- Student enrollment module with batch import and validation workflows
- Personnel management with appointment tracking and leave management
- Automated reporting templates aligned to DepEd's official report formats
- Audit trail interface for compliance and transparency requirements
My Process
Government projects require careful stakeholder management. I embedded myself with administrators and field staff to understand the real workflows — not just the ideal processes as documented in policy.
- Stakeholder interviews with school principals, division superintendents, and IT administrators
- Workflow mapping sessions to document actual (vs. documented) process flows
- Information architecture design with card sorting exercises across user groups
- Accessibility-first wireframes tested with users of varying digital literacy
- High-fidelity Figma prototype with fully interactive navigation and data states
- Functional prototype built using design-to-code workflows for stakeholder demos
