Sistema de gestión para la reducción de tiempos en los procesos de selección de monitores, desarrollo y evaluación de monitorías de la Universidad Santo Tomás usando Power Platform.

Abstract

This project describes the development of a system for managing the selection, development, and evaluation processes of academic monitors at Universidad Santo Tomás, using Microsoft's Power Platform tools. Previously, these processes were carried out manually through approximately 56 Excel files, resulting in a high workload and significant time consumption for those involved, especially the staff of the Student Development Coordination. In response to this situation, the main objective was to develop a support system for the monitor selection, development, and evaluation processes at Universidad Santo Tomás, by using the Power Platform toolset to reduce the time required for these procedures. The process began with the collection of requirements from the Student Development Coordination, using use case diagrams. Then, an evaluation of Power Platform tools was conducted to determine the most suitable ones for visual interface development, business logic, and data storage. Based on the requirements, the data model and software mockups were designed, followed by the system’s development using three specific Power Platform tools. Finally, a functional test was carried out in the Faculty of Electronic Engineering with a group of students to verify the correct operation of the system and its compliance with the established requirements. The results showed a significant reduction in the time and effort required to carry out the entire monitoring process, especially in the creation of the call for applications, monitor selection, and their final evaluation.