Automating the Process of Preparing the School Timetable
- 作者: Petrosyan A.S.1, Surmachevskaya A.A.1, Safonova E.A.1, Kuznetsova E.M.1, Gareeva G.A.1
-
隶属关系:
- Kazan National Research Technical University named after A.N. Tupolev-KAI
- 期: 卷 13, 编号 4 (2023)
- 页面: 188-204
- 栏目: Articles
- ##submission.datePublished##: 30.12.2023
- URL: https://journals.rcsi.science/2328-1391/article/view/348638
- DOI: https://doi.org/10.12731/2227-930X-2023-13-4-188-204
- EDN: https://elibrary.ru/NXATGJ
- ID: 348638
如何引用文章
全文:
详细
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.
作者简介
Ashot Petrosyan
Kazan National Research Technical University named after A.N. Tupolev-KAI
编辑信件的主要联系方式.
Email: ashot_116@mail.ru
student
俄罗斯联邦, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian FederationAngelica Surmachevskaya
Kazan National Research Technical University named after A.N. Tupolev-KAI
Email: 2db6db@mail.ru
student
俄罗斯联邦, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian Federation
Ekaterina Safonova
Kazan National Research Technical University named after A.N. Tupolev-KAI
Email: sea55555@bk.ru
student
俄罗斯联邦, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian Federation
Evelina Kuznetsova
Kazan National Research Technical University named after A.N. Tupolev-KAI
Email: 270303ava@gmail.com
student
俄罗斯联邦, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian Federation
Gulnara Gareeva
Kazan National Research Technical University named after A.N. Tupolev-KAI
Email: gagareeva1977@mail.ru
ORCID iD: 0000-0002-8539-4541
SPIN 代码: 3279-8465
Scopus 作者 ID: 36801593200
Researcher ID: М-1728-2015
Head of the Department of Information Systems, Candidate of Pedagogical sciences, Associate professor
俄罗斯联邦, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian Federation
参考
- Tugov V.V. Proektirovanie avtomatizirovannykh sistem upravleniya [Designing automated control systems] / V.V. Tugov, A.I. Sergeev, N.S. Sharov. St. Petersburg: Lan, 2019, 172 p.
- Modeli i metody issledovaniya informatsionnykh sistem [Models and methods of information systems research] / A.D. Khomonenko, A.G. Basyrov, V.P. Bubnov [et al.]. St. Petersburg: Lan, 2019, 204 p.
- Zlatopol’skiy D.M. Osnovy programmirovaniya na yazyke Python [Fundamentals of programming in the Python language]. M.: DMK Press, 2017, 284 p.
- Ponomareva L.A., Chiskidov S.V., Ronzhina I.A., Golosov P.E. Proektirovanie komp’yuternykh obuchayushchikh sistem [Designing computer-based learning systems]. Tambov: Consulting company Yukom, 2018, 120 p.
- Vinogradova E.Yu. Intellektual’nye informatsionnye tekhnologii – teoriya i metodologiya postroeniya informatsionnykh sistem [Intellectual information technologies - theory and methodology of building information systems]. Yekaterinburg: Ural State University of Economics, 2011, 263 p.
- Kozlov A. A., Batishchev A. V. Territoriya nauki, 2017, no. 5, pp. 55-64.
- Avanesyan N. L. Nauchnyy potentsial XXI veka: materialy Mezhdunarodnoy (zaochnoy) nauchno-prakticheskoy konferentsii [Scientific potential of the XXI century: materials of the International (extramural) scientific-practical conference]. Astana, 2017,
- pp. 61-65.
- Ivanov A. D. Vestnik Volzhskogo universiteta im. V.N. Tatishcheva, 2016, vol. 1, no. 3, pp. 126-132.
- Nasibulin R.O., Gareeva G.A. Molodezh’ i sistemnaya modernizatsiya strany: Sbornik nauchnykh statey 7-y Mezhdunarodnoy nauchnoy konferentsii studentov i molodykh uchenykh. V 5-ti tomakh, Kursk, 19–20 maya 2022 goda [Youth and system modernization of the country: Collection of scientific articles of the 7th International Scientific Conference of Students and Young Scientists. In 5 volumes, Kursk, May 19-20, 2022] / ed. M.S. Razumov. Vol. 3. Kursk: South-West State University, 2022, pp. 425-427.
- Gareeva G.A., Safonov I.M., Dzhibladze Z.G. [et al.] Nauchno-tekhnicheskiy vestnik Povolzh’ya, 2023, no. 1, pp. 52-55.
- Alex Root Jr. Aiogram Documentation, November 2022. https://readthedocs.org/projects/aiogram/downloads/pdf/latest/
- David Love. Tkinter GUI Programming by Example. Packt Publishing, 2018, 340 p.
- Baji Shaik, Avinash Vallarapu Beginning PostgreSQL on the Cloud: Simplifying Database as a Service on Cloud Platforms. Apress, 2018, 381 p.
- Chatbots: history, modernity and prospects. http://w7phone.ru/chat-boty- istoriya-sovremennost-i-perspektivy-132460
- Telegram Bot API. https://core.telegram.org/bots/api
补充文件
