Crescent Hostel Attendance - Building Attendance for 500+ Students

"Hostel attendance during night roll-calls faces two bottlenecks: paper logbooks that take hours to digitize, and spotty Wi-Fi inside concrete hostel blocks."

As part of a Taskdrift engineering engagement, I designed and delivered the full-stack architecture for the Crescent Hostel Attendance & Gate Pass System, tailored for institutional administration at B.S. Abdur Rahman Crescent Institute of Science and Technology.

The Institutional Challenge

Traditional paper-based roll calls across multi-story hostel blocks create administrative friction:

Manual entry is slow and prone to errors during night roll calls.
Wardens lack real-time visibility into student presence or active gate passes.
Network connectivity inside reinforced concrete hostel corridors is notoriously spotty.

Technical Solution & Role Split

To address these operational requirements, the system splits tools by administrative role:

1. Resident Tutor (RT) Mobile PWA

Single-Tap Roll Call: RTs mark Present, Absent, or Out-on-Pass with single-tap card controls.
Offline-First Queueing: Attendance data captured during network outages is stored in a resilient local queue and auto-synced to Supabase when connectivity restores.
Gate Pass Integration: Active gate passes automatically prefill student statuses during night checks.

2. Admin & Warden Operations Dashboard

Real-Time Analytics: Wardens track block and floor submission completion percentages live.
Chronic Absenteeism Tracking: Highlights 30-day attendance trends for proactive student welfare.
Client-Side Matrix Exports: Automated generation of formatted Excel spreadsheets (.xlsx) via ExcelJS and landscape PDF reports via jsPDF.

Architecture & Security

Built on Next.js 14 App Router and Supabase PostgreSQL, access controls are strictly enforced at the database level using PostgreSQL Row-Level Security (RLS) policies and definer functions.

Learn more about the system design on the Crescent Hostel Attendance Project Page.