Splinx Studio
Oakwood Secondary School
A comprehensive school management platform pairing a public-facing website with a powerful administrative dashboard — replacing manual and Excel-based workflows with one centralized system.
Client
Oakwood Secondary School
Industry
Education
Role
Full-Stack Development (Frontend, Backend, Database, UI/UX)
Stack
React, Node.js, MongoDB Atlas
Project Overview
Oakwood Secondary School managed student records, fee collection, and class assignments through a mix of paper records and disconnected Excel spreadsheets, making it difficult to track admissions, payments, and enrollment consistently.
Objective
Build a full-stack platform combining a public school website with a secure administrative dashboard that digitizes student management, automates fee collection, and centralizes school data — while supporting a smooth migration from existing spreadsheets.
Feature Showcase
A closer look at the platform.
Every metric that matters, on one screen.
The dashboard overview gives staff a live snapshot of total students, active teachers, pending fees, and new admissions the moment they log in, with quick actions for the most common daily tasks.
- Live enrollment, fee & revenue metrics
- Attendance-ready architecture
- Quick actions for common tasks
- Secure, role-based dashboard access
Every student record, searchable instantly.
Staff can register, search, and manage student profiles — including roll numbers, admission numbers, and parent information — from a single screen, with CSV export and bulk Excel import built in.
- Student registration & profiles
- Roll & admission number management
- Search & filtering
- CSV export & bulk Excel import
Staff records, qualifications, and status in one place.
A dedicated teacher directory tracks employee IDs, qualifications, and active status, giving administrators an at-a-glance view of teaching staff across the school.
- Teacher profiles & employee IDs
- Qualification tracking
- Active / inactive status management
Academic structure that's easy to manage.
Administrators configure grades, sections, and monthly fees per academic year, with student transfers between sections and capacity monitoring handled directly from the dashboard.
- Grade & section management
- Per-grade fee configuration
- Student transfers between sections
- Capacity monitoring per section
Automated invoicing, from due date to late fee.
Monthly fees generate automatically for every student, with late fees applied automatically after the due date — removing manual recalculation entirely and giving staff a clear view of outstanding balances.
- Automatic monthly invoice generation
- Automatic late fee calculation
- Payment tracking & history
- Outstanding balance management
What We Solved
From scattered spreadsheets to one platform.
Manual, Excel-based operations
Manual and Excel-based workflows created inefficiencies across admissions, attendance, and fee tracking, with no single source of truth for student or financial data.
A centralized management platform
A centralized management platform with role-based access, automated fee workflows, and bulk Excel migration tools that bring every school process into one system.
Challenges
What made this project difficult.
Migrating years of student records from scattered, inconsistent Excel spreadsheets without creating duplicate entries or losing data.
A guided bulk Excel import tool with automatic duplicate prevention and data validation before records ever enter the system.
Fee collection needed to account for monthly invoicing and late fees without manual recalculation every month.
An automated billing engine that generates monthly invoices and calculates late fees automatically, with full payment history and balance tracking.
Different staff roles needed different levels of access to sensitive student and financial data.
A secure, role-based access control system built on JWT authentication, giving each user type only the permissions they need.
Results
Measurable outcomes.
Full-stack architecture with REST APIs
Secure JWT-based authentication
Scalable, modular backend
Automated fee & late fee generation
Bulk Excel import with duplicate prevention
Role-based access control