↓Skip to main content

NOTESI

·1 min
Laravel PHP MySQL Blade Templates Bootstrap Microsoft Graph API OAuth2 Query Caching MVC Architecture RESTful API Database Design Responsive Design Web Application Eloquent ORM Middleware Single Sign-On Problem Solving Web Developement
Table of Contents
NOTESI Logo

The Problem #

Students faced chaos when checking grades:

  • Marks scattered across multiple Excel/PDF files sent separately by different teachers via Outlook
  • No centralized place to view all grades
  • Time-consuming process to calculate semester averages
  • Impossible to know class rankings or compare performance

The Solution #

Interface #

Student View

Student Grade View

Students see their semester average, class rank, and detailed module breakdown with coefficient-weighted calculations.

Admin Dashboard

Admin Dashboard

Administrators upload and manage grades, students, and courses through CSV imports.

Authentication

Microsoft Login

Secure single sign-on using institutional Microsoft accounts.

Tech Stack #

ComponentTechnology
BackendLaravel 9 (PHP 8)
FrontendBlade Templates + Bootstrap
DatabaseMySQL
AuthMicrosoft Graph API (OAuth2)
CachingLaravel Eloquent Query Cache

Key Features #

For Students:

  • All grades centralized in one place
  • Access all semesters with one click
  • Automatic semester total calculation
  • Class rank and mean comparison
  • Customizable coefficients per subject
  • Mobile-responsive interface

For Administrators:

  • Dashboard to manage students, marks, and semesters
  • CSV bulk imports for data management
  • User activity tracking
  • Role-based access control (Super admins, admins, moderators, normal users)

Impact #

Served 200+ students with 5 moderators managing the system.