.

ISSN 2063-5346
For urgent queries please contact : +918130348310

AUTOMATED TIME TABLE GENERATOR USING SPREAD SHEET FOR EDUCATIONAL MODULES

Main Article Content

Neha Pradyumna Bora, Pradyumna Mulchand Bora, Dinesh Chandra Jain
» doi: 10.31838/ecb/2022.11.s3.765

Abstract

The creation of timetables is a challenging work, but it is crucial in educational institutions. Conflicts arise while manually creating a schedule. Due to numerous hard and soft constraints, creating an effective timeline is a difficult task. Creating different schedules, such as the master timetable, class timetables, personal timetables, etc., takes a lot of time on the part of Timetable In-charge. Additionally, it takes time to distribute timetables to different parties. By using inputs like the number of subjects, teachers, workload of a teacher, semester, and priority of subjects, this automatic timetable generator software creates the timetables automatically. Timetable incharge must manually input the master timetable into the builder created in Google spreadsheet, which helps them detect various restrictions like resource conflicts, alerts of back-to-back lectures, etc. This generator automatically creates all other timetables after adding the master schedule. This technology is actually used in one of the engineering college's 120 student departments. As a result, roughly 30+ timetables are automatically prepared. This builder saves an enormous time and helps the person in charge of creating the schedule by carefully taking all types of limits into account. Even the distribution of timetables may be done very easily by simply sharing them with all relevant parties and giving them the option to view them exclusively.

Article Details