International Journal of Advanced Studies (Dec 2023)

AUTOMATING THE PROCESS OF PREPARING THE SCHOOL TIMETABLE

  • Ashot S. Petrosyan,
  • Angelica A. Surmachevskaya,
  • Ekaterina A. Safonova,
  • Evelina M. Kuznetsova,
  • Gulnara A. Gareeva

DOI
https://doi.org/10.12731/2227-930X-2023-13-4-188-204
Journal volume & issue
Vol. 13, no. 4
pp. 188 – 204

Abstract

Read online

This paper presents a development that optimizes the process of educational scheduling by creating algorithms that automatically distribute the load of the educational process and take into account all the preferences of teachers. One of the currently popular platforms for deploying these developments is the google tables platform for creating google tables and creating code based on google app script. The peculiarity of the system implemented with the help of this platform is the ease of use and minimization of resources spent on software storage, which greatly simplifies interaction with the system. Purpose – create a tool for drawing up a study schedule, interacting with a database created in Google Tables, interacting with participants of an educational institution online, which saves personal time of teachers and employees of the dean’s office. Method or methodology of the work: the article discusses a way to optimize the creation of a weekly schedule, taking into account the convenience of the teacher in the distribution of pairs and taking into account the load of the educational process by creating algorithms based on Google app script. For implementation, online tables are used that are accessible to all teachers and employees of the dean’s office, updated in real time, Tables created in Google and the google app script programming language. Result: a unique tool has been developed that implements the functions of adding, storing, interacting and round-the-clock access to training schedule data. Scope of application of the results: the curriculum, stored in online tables and updated by the dean’s office staff, should be used for monitoring by each teacher, keeping track of their time of couples in educational institutions.

Keywords