Designing Query Optimization for Scheduling the Lecture Across Faculties and Study Programs

  • Joko Aryanto Universitas Teknologi Yogyakarta
  • Ahmad Tri Hidayat UTY
DOI: https://doi.org/10.46923/ijets.v3i1.119
Keywords: Lecture scheduling, querying, optimization

Abstract

One of the implementation models of combinatorial optimization that has a high complexity is the preparation of lecture schedules. Scheduling optimization needs to be optimized based on the schedule reference constraints. This study aims to design an optimization model with dynamic scheduling slots every day. The method used is query re-optimization with schedule distribution in accordance with predetermined limits. The models designed include space models, lecture times, and schedules. The model uses data that is in sync with the schedule, such as classrooms (theory and practice), credit and course loads (odd and even), lecturer schedules (teaching) and course time slots, as well as lecture sessions per day. This research is able to produce an optimal class schedule with all combinations of plotted schedules. The results of plotting the schedule are as desired and there are no conflicting schedules.

Submitted
2021-05-16
Accepted
2021-07-20
How to Cite
Aryanto, J., & Ahmad Tri Hidayat. (2021). Designing Query Optimization for Scheduling the Lecture Across Faculties and Study Programs . International Journal of Engineering Technology and Natural Sciences, 3(1), 33 - 38. https://doi.org/10.46923/ijets.v3i1.119
Issue
Vol. 3 No. 1 (2021): International Journal of Engineering, Technology and Natural Sciences
Section
Articles

Copyright (c) 2021 Ahmad Tri Hidayat

Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Copyright Notice

The Authors submitting a manuscript do so on the understanding that if accepted for publication, copyright of the article shall be assigned to journal IJETS, University Of Technology Yogyakarta as publisher of the journal, and the author also holds the copyright without restriction.

Copyright encompasses exclusive rights to reproduce and deliver the article in all form and media, including reprints, photographs, microfilms and any other similar reproductions, as well as translations. The reproduction of any part of this journal, its storage in databases and its transmission by any form or media, such as electronic, electrostatic and mechanical copies, photocopies, recordings, magnetic media, etc. , are allowed with a written permission from journal IJETS, University Of Technology Yogyakarta.

Jurnal IJETS Board, University Of Technology Yogyakarta, the Editors and the Advisory International Editorial Board make every effort to ensure that no wrong or misleading data, opinions or statements be published in the journal. In any way, the contents of the articles and advertisements published in the journal IJETS, University Of Technology Yogyakarta are sole and exclusive responsibility of their respective authors and advertisers.