EduCoreSuite is a comprehensive, enterprise-ready academic management system that has been transformed from a functional application into a professional, modern educational platform. The system features a complete professional UI design system with consistent styling across all 35+ views, providing administrators with an intuitive interface to manage students, courses, faculty, and academic operations.
The platform combines robust functionality with professional visual design, using ASP.NET MVC, Entity Framework Core, and Microsoft SQL Server with a modern, responsive interface that inspires confidence and enhances user experience.
Status: 35/35 Views Completed (100%)
The EduCoreSuite has been successfully transformed into a professional, enterprise-ready educational management system with:
Modern, Intuitive User Interface - Consistent professional design across all views
Comprehensive Data Management - Full CRUD operations for all entities
Professional Visual Design - Enterprise-level styling that inspires confidence
Scalable Architecture - Ready for future enhancements and growth
Responsive Design - Works seamlessly across all device sizes
Enhanced User Experience - Intuitive navigation and professional workflows
| Layer | Technology |
|---|---|
| Frontend | ASP.NET Razor Views, Bootstrap 5 |
| Backend | ASP.NET MVC, Entity Framework Core |
| Database | Microsoft SQL Server |
| Audit Log | ActivityLog for all key operations |
- Separation of concerns via MVC architecture (Models, Views, Controllers)
- Entity Framework Code First with normalized relational database schema
- Git-based collaboration using feature branches (e.g.,
vincent,gerry) merged intoforgefor integration and testing
📊 View System Architecture Diagram (draw.io)
- Real-time statistics: today’s enrollments, weekly totals
- Most enrolled courses (e.g., Computer Science – 1250, Nursing – 150)
- Total faculty count
- Activity feed with audit trail showing:
- New enrollments
- Course completions
- Student registrations
Implemented by: Mercy Migendi and Brian Vuhuga
- Add Student Form:
- Captures: Full name, email, gender, date of birth, national ID, county, phone number, admission number, and campus
- Relational dropdowns for: gender, department, program, level, and campus
- Student List:
- Paginated, searchable list showing department, progress, academic year
- Enrollments:
- Enroll student into one or more courses
- Bulk enrollment supported:
- Multiple students to one course
- All students to all courses
- Filtered by program or academic year
Implemented by: Gerry Migiro, Elvis Karinge
Extended by: Elvis Karinge – for enhanced student detail capture
The "Courses" navigation now includes a dropdown menu that leads to modular sub-pages for configuring all academic metadata. This makes the platform scalable and eliminates hardcoded values.
- Course List
- Accordion UI grouped by department
- Each course shows: name, level, exam body, study status
- Add Course Form
- Relational dropdowns for: department, program, exam body, level, campus, study mode, and study status
- Departments
- Programs
- Exam Bodies
- Campuses
- Study Modes
- Study Levels
Each submodule allows administrators to manage institutional data dynamically from the UI, reflecting updates immediately throughout the system.
Implemented by: Vincent Omondi Owuor and Gerry Migiro
- Dynamic filters:
- Department
- Course
- Faculty
- Year
- Enrollment Status
- Report Output Includes:
- Student ID
- Course
- Department
- Exam score
- Grade
- Transcript status
- Export functionality (CSV, PDF) currently in development
[In Development]
EduCore uses a normalized SQL Server schema with referential integrity, foreign key constraints, and support for auditability. The system is extensible, ensuring new data types or structures can be added without affecting core functionality.
Students: Stores biodata, contact information, department, gender, program, and campusCourses: Defines academic offerings and links to departments, programs, levels, study modes, campuses, and exam bodiesEnrollments: Many-to-many relationship between students and courses, tracking enrollment statusActivityLog: Captures entity operations (e.g., "Student Registered", "Course Enrolled") with user reference and timestamp
DepartmentsProgramsExamBodiesCampusesStudyModesStudyLevelsGendersCountiesStudyStatuses
- Students ↔ Enrollments ↔ Courses (many-to-many)
- Courses reference multiple normalized lookup entities
- Enrollments use composite primary key (
StudentID,CourseID) to enforce uniqueness - Audit Logs are linked to user actions for traceability
| Feature | Status | Notes |
|---|---|---|
| Student Registration | Complete | Extended to include ID number, county, campus, and contact details |
| Course Creation + Listing | Complete | Relational form fields and department-grouped UI |
| Academic Configuration Dropdown | Complete | Dynamic CRUD for all academic lookup tables |
| Enrollment (Single/Bulk) | Complete | Batch assignments supported via filters and dropdown logic |
| Dashboard Metrics & Activities | Complete | Audit feed implemented; metrics integration in progress |
| Reports Filtering & Export | Complete | Filtering complete; CSV/PDF export pending |
| Data Normalization | Cmplete | All form inputs reference backend lookup tables |
| Accessibility (WCAG 2.2 AA) | Complete | Semantic HTML, ARIA attributes, proper form labels |
| Area | Enforcement Details |
|---|---|
| Branching | Git feature branches → forge integration branch |
| Commits | Conventional format: feat:, fix:, refactor:, etc. |
| Code Reviews | Mandatory peer reviews for all pull requests |
| Security | Form validation, SQL injection protection, EF-safe queries only |
| Testing | Manual UI walkthroughs, DB constraints, and schema validation |
| Accessibility | Conformance to WCAG 2.2 AA via semantic HTML, ARIA roles, tab order |
| Name | Role | Area of Focus |
|---|---|---|
| Vincent Omondi | Scrum Master | Course module, academic configuration dropdowns |
| Gerry Migiro | Developer | Student registration, dropdown integrations |
| Elvis Karinge | Developer | Enhanced student form, bulk enrollment logic |
| Mercy Migendi | Developer | Dashboard UI and page composition |
| Brian Vuhuga | Developer | Dashboard logic, real-time metric calculations |
Project supervised by Mr. Nick Silver