Softwiro
Free Excel template

Exam schedule with committees and invigilators (Excel)

A free Excel sheet for an exam schedule. You enter your classes with their student counts, your committees (exam rooms) with their capacity, and your invigilators with a limit on how many sessions each can supervise, then record each exam with its date, slot, class, committee and invigilator. The sheet warns you if a class has two subjects in one slot, if a committee or an invigilator is booked twice in the same slot, or if a class has more students than its committee has seats. It counts each invigilator's sessions against their limit and summarizes the exams on each day and in each slot.

Excel file (.xlsx) · 102 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “الامتحانات” tab (Arabic), with the numbers and formulas that are in the file.
التاريخالفترةالمادةكود الفصلكود اللجنةكود المراقبالحالة
46376الأولىعربيف1L1S01سليم
46376الأولىعربيف2L2S02سليم
46376الأولىعربيف3L3S03سليم
46377الأولىرياضياتف1L1S02سليم
46377الأولىرياضياتف2L2S03تعارض طالب
46377الأولىحاسبف2L4S06تعارض طالب
46377الأولىرياضياتف3L3S04سليم
46378الأولىعلومف1L1S03سليم

Example from the “الامتحانات” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • الفصول (Classes): For each class: code, name and number of students, then the number of its exams recorded and the number of its conflicting exams.
  • اللجان (Committees): For each committee: code, name and capacity in seats, then the number of exams in it, the number of duplicate bookings and the number of times capacity is exceeded.
  • المراقبون (Invigilators): For each invigilator: code, name and maximum number of sessions. The sheet then shows their number of sessions, what remains of their limit, their status (within limit, over limit or no assignment) and their number of conflicting sessions.
  • الامتحانات (Exams): The exams log: date, slot (first or second), subject, class, committee and invigilator. Next to it appear the invigilator's name, the class's students, the committee's capacity, student conflict, committee conflict, invigilator conflict, over capacity, the number of problems and the status.
  • الملخص (Summary): The number of exams, how many are valid, and the count of each kind of conflict; the number of invigilators, how many are over the limit or have no assignment, and the highest and lowest number of sessions; then a table of dates that you enter, with each slot's exams, the total and how many have a problem.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

Instead of finding out while you prepare exam papers that a class has two subjects at once, that an invigilator is listed in two committees, or that a committee cannot hold its students, you record the schedule and see every violation in red with its type. From "المراقبون" (Invigilators) you see who is over their limit and who has not been assigned anything, so you can adjust the allocation.

How to use it

  1. In the "الفصول" (Classes) tab, enter each class's code, name and number of students.
  2. In the "اللجان" (Committees) tab, enter each committee's code, name and capacity in seats.
  3. In the "المراقبون" (Invigilators) tab, enter each invigilator's code, name and the maximum number of sessions they can supervise across the whole exam period.
  4. In the "الامتحانات" (Exams) tab, record each exam on a row: date, slot, subject, class, committee and invigilator.
  5. Next to each exam the sheet writes its status: valid, or student, committee or invigilator conflict, or over capacity, and colors the offending row red.
  6. Open "المراقبون" (Invigilators) to see each person's number of sessions and whether they exceeded their limit, then the "الملخص" (Summary) tab for exams on each day and slot and the problems.

Before you start:

  • Student conflict = a class listed in more than one exam on the same date and in the same slot, because students of one class cannot sit two exams at once.
  • Committee conflict = a committee listed in more than one exam on the same date and slot. Invigilator conflict = an invigilator listed in more than one committee on the same date and slot.
  • Over capacity = the class's student count is greater than the capacity of the committee listed for its exam. The sheet compares each class with its committee on each row separately.
  • The slot is chosen from the list: "first" or "second". Enter the dates of the days in the Summary cells so that their counts appear.
  • What remains of an invigilator's limit = their limit − their number of sessions. A negative number means they are over the limit. An invigilator with no sessions shows the status "no assignment".
  • The sheet holds 200 classes, 200 committees, 200 invigilators and 400 exams. The names and numbers in the example are fictional.

Excel file (.xlsx) · 102 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

Cheat sheet: exam schedule, rooms and invigilators (1/3)Cheat sheet: exam schedule, rooms and invigilators (2/3)Cheat sheet: exam schedule, rooms and invigilators (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

In this sheetIn Custom Software from Softwiro
One file that one person edits at a time, and copies reach you on WhatsApp.A program with a login for each user and permissions you define, and everyone sees the same data.
You type everything and check the numbers by hand.We design the screens around your work steps, so each person records only what concerns them.
Columns and formulas are fixed as the sheet was designed.We build what you need: reports, alerts and screens your way.
Backups and security are your own responsibility.The program runs on a secured server with regular backups.

See Custom Software from Softwiro · Ask for a demo

Frequently asked questions

What is a student conflict?

The same class is listed in more than one exam on the same date and in the same slot, because students of one class cannot sit two exams at once. The sheet compares the class with the date and slot on every row.

How does the sheet know a committee is too small for a class?

It takes the class's student count from the "الفصول" (Classes) tab and the committee's capacity from the "اللجان" (Committees) tab, and writes "over capacity" if the students outnumber the seats. The comparison is made row by row, so if two classes sit in one committee, check their combined total yourself.

How do I share invigilation fairly?

In "المراقبون" (Invigilators) you read each invigilator's number of sessions and what remains of their limit, and in "الملخص" (Summary) you read the highest and lowest number and the gap between them. Then you move a session from the most loaded to the least loaded by changing the code in the exams log. The sheet does not allocate automatically.

How many exams does it hold?

It holds 400 exams, 200 classes, 200 committees and 200 invigilators. The Summary tab has six date cells, which you can change as you like.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

All the templates in this group: Excel templates for teachers: gradebook, lesson planning and follow-up

More free templates for: Schools and students

More free templates

All templates · Free tools