All projects

Normalite EDGE — Everyday Guide to Excellence

A reviewer system for Cebu Normal University's BLEPT department. Students get mock exams, flashcards, score analytics and scheduling; staff get exam import and export, so content no longer has to be keyed in by hand. I translated the department's requirements into the workflows the system runs on.

ReactTypeScriptNode.jsExpressPrisma ORMPostgreSQL
Normalite EDGE — Everyday Guide to Excellence — Case Study

Overview

A web-based reviewer system for Cebu Normal University's BLEPT department. Students get mock exams, flashcards, score analytics and scheduling. Staff get exam import and export, which automates content management that was previously keyed in by hand. React and TypeScript on the front, an Express API behind it, Prisma ORM over PostgreSQL.

My role

Developer, and the person who translated the department's requirements into the workflows the system actually runs on.

Screenshots

Normalite EDGE — Everyday Guide to Excellence — Screen 1 of 1

Screen 1 of 1

Mobile

Normalite EDGE — Everyday Guide to Excellence — Home, mobile
Home

Lessons learned

  • Requirements gathering

    The BLEPT department described what they needed in their own terms. Turning that into workflows was the actual work, not the screens.

  • Automating the real bottleneck

    Exam import and export mattered more than the exam-taking UI, because hand-keying content was the thing standing in the way.

  • Prisma ORM & PostgreSQL

    A typed schema with migrations, shared between an Express API and a React client.

Technology & approach

ReactTypeScriptNode.jsExpressPrisma ORMPostgreSQL

Links

Client work — 2 screenshots