Skorkita - SMKN 12 Jakarta
A centralized web application built for OSIS SMKN 12 Jakarta to digitize, track, and manage student score points, merits, and school activity records.
01. Problem
School activities, student merits, and OSIS points at SMKN 12 Jakarta were previously tracked manually using paper ledgers or scattered spreadsheets, leading to data loss, delayed updates, and poor transparency.
02. Target User
SMKN 12 Jakarta students, OSIS committee members, teachers, and school administrators tracking student points and activity records.
03. Architectural Solution
Designed a centralized, role-based web platform hosted on the official school domain featuring secure authentication, granular RBAC permissions, and real-time score logging.
04. Key Features
- — Role-Based Access Control (RBAC) authentication system for OSIS admins, teachers, and students.
- — Real-time student score and merit tracking dashboard with automated point calculations.
- — Searchable student directory and activity record logging with exportable reporting capabilities.
05. Engineering Challenge
Designing a secure multi-role authorization layer to prevent unauthorized score modifications while maintaining fast database queries during school-wide traffic spikes.