Optimización del sistema de generación de boletines académicos en el Colegio Santo Ángel mediante la automatización del ingreso y cálculo de notas – 2025.

Abstract

At Colegio Santo Ángel, the generation of academic report cards is currently carried out through Excel spreadsheets, where teachers manually enter students’ grades. Although this method is commonly used, it presents significant limitations: transcription errors, difficulties managing active and inactive students, and the absence of an automated system that ensures accuracy in results. These weaknesses not only affect the reliability of the information but also cause delays in the consolidation of academic reports. This project is justified by the need to strengthen academic management through technological solutions that integrate efficiency, reliability, and control. Based on the principles of industrial engineering and aligned with the philosophy of continuous improvement, the automation of this process seeks to optimize registration times, reduce human errors, and contribute to institutional quality in the delivery of academic results. The general objective is to develop an algorithm to automate the entry of partial grades, calculate final scores, and generate reliable reports. For this purpose, Google Colab was employed as the programming environment in Python, facilitating the creation, testing, and validation of the code in a collaborative and accessible platform. The methodology was designed as a qualitative case study, combining semi-structured interviews with teachers, participant observation, and document analysis of the current records. These techniques made it possible to identify weaknesses in the existing system and validate the benefits of the proposed solution. The work plan included four phases over a four-month period: analysis and design of the data flow, algorithm coding in Google Colab, functionality testing, and the preparation of a user manual with training for teaching staff. (Traducción del resumen al idioma inglés)