PortfolioServicesCase StudiesProcess
← Portfolio/SaaS Platforms

Department of CSE, Shahjalal University of Science & Technology  ·  Sylhet, Bangladesh  ·  2025

Grade & Result Analytics

Integrated 8-semester curriculum browser, personalized CGPA calculator, PyMuPDF result parser, and administrative batch analytics portal

Grade & Result Analytics
Grade & Result Analytics detail

Curriculum Scope

8 Semesters

160+ total credit hours mapped across theory, lab, and elective courses.

PDF Extraction Engine

PyMuPDF (fitz)

Automated tabulation result parser syncing scores directly to PostgreSQL.

Admin Analytics

Batch Matrix

Side-by-side student performance comparison and custom semester CGPA calculators.

01 / Executive Overview

Setting
the Stage

"Empowering 1,000+ CSE students and faculty with real-time CGPA planning, automated tabulation parsing, and multi-semester comparative analytics."

SUST CSE Academic Curriculum & Result Management Portal is an integrated academic system developed for the Department of Computer Science & Engineering at Shahjalal University of Science and Technology. Built with Next.js (App Router, Turbopack), PostgreSQL (Neon), Prisma ORM, and Python PyMuPDF result parsing pipelines.

02 / The Challenge

Manual CGPA Calculations & Fragmented Academic Tabulation

Students had no centralized tool to calculate multi-semester target CGPAs or inspect prerequisites across 8 semesters. Department administration processed official result tabulations manually, making batch performance comparison slow and error-prone.

Key Bottlenecks

  • 1Manual credit tracking and lack of automated target CGPA planning tools.
  • 2Unstructured official tabulation PDFs requiring manual extraction.
  • 3Absence of multi-semester comparative performance tools and automated batch leaderboards.

03 / Solution

Interactive Web Portal & Automated Tabulation Ingestion

We engineered an interactive curriculum explorer, a persistent CGPA calculator supporting the standard SUST grading scale, secure JWT authentication with student registration IDs, and a Python PyMuPDF coordinate-based tabulation parser syncing directly with PostgreSQL.

01

Interactive 8-Semester Explorer

Course catalog search, syllabus viewer, and prerequisite inspector for 160 credit hours.

02

Personal CGPA Planner & Cloud Sync

Real-time semester GPA calculator, degree completion progress, and cloud grade persistence.

03

Administrative Analytics & Leaderboard

Official batch ranking, custom selected semester CGPA filter, side-by-side peer comparison, and CSV exports.

04 / Technical Stack

Engineered with Precision

Frontend

Next.js (App Router)React 19TypeScriptTailwind CSSLucide React

Backend & DB

Next.js Route HandlersPostgreSQL (Neon)Prisma ORMJWTbcryptjs

Parsing & Testing

PythonPyMuPDF (fitz)Playwright E2E

05 / Business Impact

Streamlined Academic Tracking & Data-Driven Insights

The platform eliminated manual calculation errors for hundreds of CSE students and provided faculty administration with instant batch analytics.

100% Exact

Calculation Accuracy

< 10 Secs/PDF

Tabulation Ingestion

Department-Wide

Student Adoption