Exam Seating Arrangement System – Google Sheets Apps Script

Every exam season, the same problem: hundreds of students, several rooms, and someone assigning roll numbers to seats by hand on paper or in a sprawling spreadsheet. This system does the allocation for you. Add your students, rooms and exams, and it seats everyone automatically — then prints the charts, the attendance sheets, the admit cards and the invigilator roster.

What it does

Rooms are defined with their real capacity — total seats, single-desk seats and extra double seats — along with building and floor. Students are registered against programmes and papers, with accessibility details where they matter: PwBD subcategory, low vision, whether a scribe is required. Run the allocation and the engine fills rooms in roll-number order using a column-major layout, so adjacent candidates are not sitting the same paper. Each room then yields a printable seating plan for the notice board, and each student an admit card showing their date, session, paper, room, column and seat number.

Highlights

• Bulk-print every admit card and seat slip at once rather than one at a time
• Attendance sheets generated per room and date, with roll number, name, programme, paper and a signature column
• Absentees marked straight from the seating plan, feeding the exam's present/absent totals
• Invigilator duty roster by room, date and session — assignments show back on the room record automatically
• UFM (unfair means) case register with evidence, witness, copies count and action taken
• Three roles — admin, exam coordinator, invigilator — with an About App page comparing what each can do
• CSV import for bulk student and programme data

Who it is for

Colleges, universities, schools and examination boards running multi-room sittings, where seating a few hundred candidates currently costs days of manual work and still produces clashes.