Case studyFull-Stack
Exam Seating Arrangement
Allocate exam seating from student and timetable data.
- Year
- 2026
- Focus
- Exam seating allocation
Overview
An exam seating system with student and timetable imports, room configuration, automated allocation, and spreadsheet exports.
The challenge
Seating allocation must combine room layouts, exam sessions, branch subjects, and individual elective choices.
How it works
Import student records, elective choices, and timetables from spreadsheets into SQLite through Express APIs.
Configure room bench layouts and run the rule-based allocator in single or double seating mode.
Manage sessions in React and export seating arrangements to Excel or PDF.
Technology stack
- React
- Node.js
- Express.js
- SQLite
- ExcelJS
- PDFKit
Highlights
- student and timetable data
- Imports
- single and double seating
- Allocation
- Excel and PDF seating plans
- Exports