Education · Philippines
Enrolment, assessments, weighted grading, seat plans, analytics and reports for administrators, faculty and students — rebuilt from Laravel so every visitor gets their own private copy of the data.
A department's semester lives in too many places: the roster in one spreadsheet, scores in another, seat plans on paper and grading weights in somebody's head. A demo of a system like this has a problem of its own, too — on a shared database, one visitor's changes are the next visitor's mess.
Three portals over one model. Administrators keep the directory, subjects, sections and grading weights; faculty schedule assessments, record scores, build seat plans and generate reports; students follow their grades and message the people who teach them. It began as a Laravel and MySQL university capstone and was rebuilt in Next.js, with the whole relational model shipped as seed data and kept per visitor in the browser — so everyone gets a private, writable copy they can reset from the sidebar.
From setting up a subject to printing the grade sheet, in the order a department actually works.
The administrator creates subjects and sections, and sets grading weights that must total 100%.
Cohorts are enrolled into classes by school year and semester.
Faculty schedule quizzes, unit tests, activities and exams, each tied to a midterm or final term.
Scores go into a sheet that checks every entry against the assessment's maximum.
Weighted grades recompute the moment scores land. 75 passes.
Grade sheets and summaries print to PDF or export as CSV.
Students, faculty and sections, with cohorts enrolled into classes by school year and semester.
Quizzes, unit tests, activities and examinations, each scoped to a midterm or final term.
Set the weight of every assessment type per subject; grades recompute as soon as scores are recorded.
Lay out the room, drop each student into a seat — or auto-fill alphabetically, or shuffle — and keep it with the class record.
Pass/fail, grade distribution and per-assessment averages, then class grade sheets printed to PDF or exported as CSV.
Students reach the faculty who teach them; faculty reply from one inbox with unread counts.
Every subject sets its own weights for four kinds of assessment. Change the weights or the averages and watch the term grade move.
PassingPass mark 75
An illustration of the system's weighting model: weights must total 100%, the overall grade is the average of the midterm and final terms, and 75 passes.
A public demo on a shared database fills up with other people's experiments, and serverless hosting has nowhere writable to keep one anyway.
The whole relational model ships as versioned seed data and is persisted per visitor in the browser. Everyone gets an isolated, writable copy; a newer seed version replaces an old copy, and a reset button restores it.
The original averaged midterm and final terms as written — so before finals were marked, an ungraded term counted as zero and whole classes appeared to be failing mid-semester.
A separate current grade computed over graded terms only, with the original figures still shown beside it and the report saying so.
The Laravel version leaned on server libraries for PDFs and Excel files, and polled the server for new messages every minute.
A print stylesheet replaces the PDF library, CSV files carry a byte-order mark so Excel opens them correctly, and messages update from the shared store instead of polling.
Grade charts that only tell series apart by colour fail for colour-blind users, and dark mode tends to wreck the palette.
Separate light and dark palettes, direct labels and an HTML legend on every chart, and a table view of the same data — so nothing relies on colour alone.
Captured from the live product — the site, and the app where there is one. Select any screen to enlarge it.
The manual steps between your tools, removed — quotes, bookings, invoices, reminders and handovers running without anybody retyping anything.
A site that loads fast, answers the question the visitor arrived with, and gets maintained every month instead of ageing quietly in the background.
Anyone can sign in as an administrator, a faculty member or a student. The data lives in their own browser, so nothing they change touches anyone else's — and it resets from the sidebar.
Tell us what is not working. We'll tell you what it would take.
BUSY BUREAU