Before the BKK Madiun Regency scholarship platform was built, the entire municipal student scholarship intake relied on Google Forms and manual Google Sheets spreadsheets.

While spreadsheets appear convenient initially, handling thousands of student submissions containing transcripts, recommendation letters, and identification files creates severe administrative bottlenecks.

1. Core Bottlenecks of Spreadsheet Workflows

  • Unstructured Documents: Broken Google Drive permissions, mixed file formats (PNG, DOCX, ZIP), and tedious manual download requirements.
  • Deduplication Risks: Lack of real-time validation against duplicate national ID (NIK) or student ID (NIM) submissions across different categories.
  • Slow Evaluation Cycles: Administrative staff had to manually calculate category weights and quotas in fragile spreadsheet formulas prone to accidental overwrites.

BKK Scholarship Verification Dashboard

2. Solution: Filament PHP Administrative Dashboard

Leveraging Laravel and Filament PHP, we engineered a streamlined verification platform focused on reviewer productivity:

  • In-App Document Preview: Reviewers can inspect PDF transcripts and ID cards directly within the administrative console without downloading files locally.
  • One-Click Actions & Revision Notes: Fast actions for Approve, Reject, or Request Document Revision that immediately trigger status updates on the applicant’s student portal.
  • Role Scoping with Spatie RBAC: Reviewers are restricted strictly to categories assigned to them (e.g. non-academic athletic reviewers cannot inspect medical scholarship dossiers).

3. Automated Scoring & Ranking Pipelines

Scholarship qualification and ranking logic were migrated directly to the database service layer:

  • GPA normalization adjusted for university accreditation tiers.
  • Regional quota allocations per district to ensure fair regional scholarship distribution.
  • Automated generation of official graduation and selection reports formatted as printable PDFs.

This digital transformation slashed the verification turnaround time from 3-4 weeks down to just 4-5 business days with 100% data auditability.