to create academic time table is very time consuming task. the process of making time table is as follow.
- to take/collect subject choice from the teaching faculties.
- to finalize and assign subjects to faculties.
- to finalize which classrooms and labs to assign to which students and at which time ( master plan 🙂 ).
- to start creating faculty and class timetable on big sheets using eraser and pencil.
- to computerize the prepared sheet.
the created tool can help in step number 6.
this tool can help to generate class time tables , faculty time tables and class room time tables.
it saves time by generating different timetables from one sheet where
so it can help by saving time and errors for time table creation.
let us try to understand how to use it.
download the sheet from here.
open and enable the macro first.
follow the steps given in sheet named dashboard.