Propuesta para automatizar el proceso de designación d

Abstract

Abstract: This paper, developed within the academic and work context of the Universidad Técnica Particular de Loja, addresses the problem of assigning academic workloads and thesis projects to teaching staff. This process is slow, error-prone, and leads to an unequal distribution of responsibilities. As a solution, an automated system based on Excel macros and analytical tools was designed, applying linear programming principles. When exploring the methodology, the authors opted to analyze institutional regulations, collect data, and develop a theoretical model that allows them to improve the efficiency of work assignment. When analyzing the results, the reduction in processing times, the elimination of human error, and the fairness of academic load allocation were highlights. This is in addition to ensuring greater transparency and flexibility in its management, making it a scalable tool within the system that can be adapted to the institution's future needs.