Tool Download Link time table generation tool (1161 downloads)
to create academic time table is a time-consuming task. the process of making a 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
- Class Room Time Tables
- Faculty Master Time Table (Feature will be added in next version)
it saves time by generating different timetables from one sheet where the
so it can help by saving time and errors for time table creation.
let us try to understand how to use it.
download the excel file by clicking below linktime table generation tool (1161 downloads)
open and enable the macro first.
to enable all macro click on Developer Tab than Macro Security and choose to Enable all macros options from available options list as shown in the below image.
follows the steps given in the sheet named dashboard.
STEP 1 : Configuration (this details will be reflected in class and faculty time table)
STEP 2 : Configure Faculty
here on clicking the OPEN FACULTY CONF. will open sheet where you may enter faculty details as shown in the below image.
here Print column is for setting printing options. to exclude any faculty timetable from printing you may just add 0 for the faculty.
after all configuration you may use CREATE FACULTY TIME TABLE button here to generate faculties time table.
STEP 3 : Configure Class
class name details can be entered here as shown in the below image
rest of the options are the same as faculty sheet.
STEP 4 : CONFIGURE CLASS ROOM NUMBERS
classrooms and laboratories numbers can be added in this sheet as shown in below image.
STEP 5 : ENTER TIME TABLE DETAILS
in this sheet time table details can be entered as shown in the image below
Note that here class , teacher and class room must match with the already entered details other wise you may find issue during time table generation.
it uses below sheets for creating respective time tables.
CTT – to create class timetable
FTT – to create faculty time table
RTT – to create room time table.
after completion of TT sheet entry, one can start creating faculty, class, and classroom time tables from the dashboard sheet.
my below video tutorial will also help you in using this app