INTELLIGENT AUTOMATION OF A VOCATIONAL COLLEGE TIMETABLE: A HYBRID MODEL OF OR-TOOLS/ILP AND AN LLM ASSISTANT
Keywords:
timetable, intelligent automation, OR-Tools, ILP, CP-SAT, LLM assistant, vocational collegeAbstract
This article presents a hybrid model for the intelligent automation of academic scheduling in a vocational college environment. The relevance of the study is explained by the fact that traditional manual timetable creation requires considerable time and organizational effort, often leads to conflicts, and makes it difficult to simultaneously balance teacher workload, classroom resources, group study time, shift-specific constraints, and additional administrative requirements. The purpose of the study is to improve timetable generation quality by integrating an OR-Tools-based constraint satisfaction model with an LLM assistant capable of working with natural language, while also increasing system flexibility and responsiveness to changes. The research employs system analysis, constrained optimization, scenario modeling, comparative evaluation, and applied design methods. The results demonstrate that the hybrid approach significantly reduces timetable generation time, more accurately reflects teachers’ time preferences, decreases the number of student idle gaps, supports more efficient allocation of classroom resources, and simplifies rapid schedule adjustments. The scientific novelty lies in combining an LLM layer that transforms natural language requests into formal constraints with the OR-Tools/ILP computational core. The practical significance of the proposed solution is that it enables college administrators to improve planning quality, use resources more efficiently, and ensure a more stable and adaptable organization of the educational process.
References
Babaei, H., Karimpour, J., & Hadidi, A. (2015). A survey of approaches for university course timetabling problem. Computers & Industrial Engineering, 86, 43–59. https://doi.org/10.1016/j.cie.2014.11.010
Bettinelli, A., Cacchiani, V., Roberti, R., & Toth, P. (2015). An overview of curriculum-based course timetabling. TOP, 23(2), 313–349. https://doi.org/10.1007/s11750-015-0366-z
Ceschia, S., Di Gaspero, L., & Schaerf, A. (2023). Educational timetabling: Problems, benchmarks, and state-of-the-art results. European Journal of Operational Research, 308(1), 1–18. https://doi.org/10.1016/j.ejor.2022.07.011
Chen, M. C., Sze, S. N., Goh, S. L., Sabar, N. R., & Kendall, G. (2021). A survey of university course timetabling problem: Perspectives, trends and opportunities. IEEE Access, 9, 106515–106529. https://doi.org/10.1109/ACCESS.2021.3100613
Davison, M., Kheiri, A., & Zografos, K. G. (2025). Modelling and solving the university course timetabling problem with hybrid teaching considerations. Journal of Scheduling, 28(2), 195–215. https://doi.org/10.1007/s10951-024-00817-w
De Werra, D. (1985). An introduction to timetabling. European Journal of Operational Research, 19(2), 151–162. https://doi.org/10.1016/0377-2217(85)90167-5
Holm, D. S., Mikkelsen, R. Ø., Sørensen, M., & Stidsen, T. J. R. (2022). A graph-based MIP formulation of the International Timetabling Competition 2019. Journal of Scheduling, 25(4), 405–428. https://doi.org/10.1007/s10951-022-00724-y
Kingston, J. H. (2013). Educational timetabling. In A. Ş. Etaner-Uyar, E. Özcan, & N. Urquhart (Eds.), Automated scheduling and planning: From theory to practice (pp. 91–108). Springer. https://doi.org/10.1007/978-3-642-39304-4_4
Kristiansen, S., & Stidsen, T. R. (2013). A comprehensive study of educational timetabling: A survey (DTU Management Engineering Report No. 8-2013). Technical University of Denmark.
Ongar, A. (2026). Research and development of an information system for scheduling classes for Yassawi College [Unpublished master’s dissertation]. Khoja Akhmet Yassawi International Kazakh-Turkish University.
OpenAI. (2023). GPT-4 technical report (arXiv:2303.08774). arXiv. https://arxiv.org/abs/2303.08774
Perron, L., Didier, F., & Gay, S. (2023). The CP-SAT-LP solver. In R. H. C. Yap (Ed.), 29th International Conference on Principles and Practice of Constraint Programming (CP 2023) (Leibniz International Proceedings in Informatics [LIPIcs], Vol. 280, pp. 3:1–3:2). Schloss Dagstuhl – Leibniz-Zentrum für Informatik. https://doi.org/10.4230/LIPIcs.CP.2023.3
Perron, L., & Furnon, V. (2025). OR-Tools [Computer software]. Google. https://developers.google.com/optimization
Qu, R., Burke, E. K., McCollum, B., Merlot, L. T. G., & Lee, S. Y. (2009). A survey of search methodologies and automated system development for examination timetabling. Journal of Scheduling, 12(1), 55–89. https://doi.org/10.1007/s10951-008-0077-5
