Automatización con macros para control de asistencia e informes, impulsando inclusión digital y profesionalización docente en la Laguna

Violeta Martínez Ramírez; Blanca Estela Véliz Sugasti; Lorena Elizabeth Balandra Aguilar; Ana Wendy Gómez Flores; Miguel Ángel Pérez Irigoyen

doi:10.61117/ipsumtec.v8i2.431

Authors

Violeta Martínez Ramírez National Technological Institute of Mexico https://orcid.org/0000-0003-1518-786X
Blanca Estela Véliz Sugasti National Technological Institute of Mexico
Lorena Elizabeth Balandra Aguilar National Technological Institute of Mexico
Ana Wendy Gómez Flores National Technological Institute of Mexico https://orcid.org/0009-0007-6399-8575
Miguel Ángel Pérez Irigoyen National Technological Institute of Mexico

DOI:

https://doi.org/10.61117/ipsumtec.v8i2.431

Keywords:

asistencia, Excel, macros, notificación, reports

Abstract

The attendance control system, coded with macros in Microsoft Visual Basic for Applications and called Attendance Soft, was developed in Excel to meet the needs of a professional teacher at a primary school, facilitating the daily recording of class attendance. It digitally alerts students of the highest number of absences and automatically generates a family report, which is sent to notify them of a negative score and to implement preventive measures jointly with the school and family that could impact their academic performance during the school year. At the end of the school year, the system issues perfect attendance certificates to students who cultivate the value of responsibility.

Downloads

Download data is not yet available.

Metrics

Metrics Loading ...

Author Biographies

Violeta Martínez Ramírez , National Technological Institute of Mexico

Dr. Violeta Martínez Ramírez, who studied Computer Systems Engineering in Programming, holds a Master's Degree in Education Sciences and a Doctorate in Education. She is a professor in the Systems and Computing Department at the Technological Institute of Puebla, teaching mainly Programming in Information Technology and Communications Engineering. Desirable Profile PRODEP (2020), leader of the Academic Body “Applied Computing” (2021), and head of Outreach Projects (2020).

Blanca Estela Véliz Sugasti , National Technological Institute of Mexico

Blanca Estela Vélez Sugasti holds a Master of Science degree in Industrial Engineering and Industrial Engineering from the Instituto Tecnológico de la Laguna. She has held administrative positions as head of the Information Center, Professional Studies Division, and Teacher Training. She has participated in academic events and in the design of specialised modules in Industrial Engineering, as well as collaborating with Innovatec. She has training in reading and is a certified auditor of the Quality Management System. She is currently a lecturer and head of the Methods Engineering Laboratory at the Instituto Tecnológico de la Laguna.

Lorena Elizabeth Balandra Aguilar , National Technological Institute of Mexico

Lorena Elizabeth Balandra Aguilar holds a PhD in Education, with previous training in Higher Education and Computer Systems. Since 1996, she has been teaching at TecNM, with experience at the Technological Institutes of Comitán and Puebla. She has been a full-time professor since 2013. She has been a member of academic bodies, the State System of Researchers, and the National Network for Data Monitoring and Collection. She is a Level I National Researcher for CONAHCYT for the period 2025–2029.

Ana Wendy Gómez Flores, National Technological Institute of Mexico

Ana Wendy Gómez Flores holds a Master's Degree in E-Commerce from the Monterrey Institute of Technology and Higher Education, obtained in May 2011, and a Degree in Computer Systems Engineering from the Tuxtla Gutiérrez Institute of Technology, obtained in May 1996. She has been a full-time lecturer since July 1996 and is currently attached to the Systems and Computing Department at the National Technological Institute of Mexico/Comitán Technological Institute, with recognition of desirable profile for full-time lecturers from July 2017 to date. Member of the Academic Body in Training from 2015-2018 and 2023-2025, member of the National Data Monitoring and Collection Network since 2024.

Miguel Ángel Pérez Irigoyen, National Technological Institute of Mexico

Miguel Angel Pérez Irigoyen is an intern engineer in Information and Communications Technology, a graduate of the Technological Institute of Puebla. During his training, he participated in the development of a web-based management system for extracurricular activities and an attendance monitoring project. He has a particular interest in databases and programming.

References

El Sol de la Laguna. ¿Cuántos lagos había en La Laguna? Origen y significado de la Comarca Lagunera [Internet]. Torreón: El Sol de la Laguna; 2023 nov 8 [citado 2025 sep 16]. Disponible en: https://oem.com.mx/elsoldelalaguna/local/cuantos-lagos-habia-en-la-laguna-origen-y-significado-de-la-comarca-lagunera-18391648

Secretaría de Agricultura. La Comarca Lagunera, primer lugar en producción de leche, carne de ave y forrajes: SAGARPA [Internet]. México: Secretaría de Agricultura; 2016 sep 6 [citado 2025 sep 16]. Disponible en: https://www.gob.mx/agricultura%7Cregionlagunera/articulos/la-comarca-lagunera-primer-lugar-en-produccion-de-leche-carne-de-ave-y-forrajes-sagarpa

Secretaría de Economía | Data México. Metro Area. La Laguna [Internet]. México: Secretaría de Economía; 2016 sep 6 [citado 2025 sep 16]. Disponible en: https://www.economia.gob.mx/datamexico/es/profile/geo/la-laguna

Antesala Política. Destacan el trabajo de escuelas privadas en el sector educativo de Coahuila [Internet]. 2022 sep 2 [citado 2025 sep 16]. Disponible en: https://www.antesalapolitica.com/2022/09/blog-post_97.html

Milenio. En La Laguna, desertaron 60% de alumnos de escuelas particulares durante 2023 [Internet]. México: Milenio; 2023 dic 12 [citado 2025 sep 16]. Disponible en: https://www.milenio.com/estados/laguna-el-2023-desertaron-60-por-ciento-de-alumnos-de-escuela-privada

Pereira L. Transformación digital [Internet]. 2024 feb 21 [citado 2025 sep 16]. Disponible en: https://www.sydle.com/es/blog/asistencia-escolar-63d7c6a96a38c10ae1ad6f74

Fundación Educacional OPORTUNIDAD. Estrategias para promover la asistencia en la escuela [Internet]. [s.f.] [citado 2025 sep 16]. Disponible en: https://oportunidadenlinea.cl/cursos/estrategias-para-promover-la-asistencia-en-escuelas/

Paredes Torres S. La Importancia Vital de la Asistencia Escolar [Internet]. Los Cabos: Liceo Los Cabos; 2024 abr 26 [citado 2025 sep 16]. Disponible en: https://www.liceoloscabos.edu.mx/liceo_blog/la-importancia-vital-de-la-asistencia-escolar/

Bravo Donoso EA. Desarrollo e implementación de un sistema de control de asistencia para los establecimientos educativos de la zona escolar No. 2 de la UTE No. 1 del cantón Ambato de la provincia de Tungurahua [Internet]. Ecuador: Pontificia Universidad Católica del Ecuador; 2013 [citado 2025 sep 16]. Disponible en: https://repositorio.puce.edu.ec/server/api/core/bitstreams/df0cd529-34ee-4898-b08b-9f9ed97ebaee/content

Higuera López PH, Borrego Ramírez N, García Collazo AL. Recursos Abiertos para Control de Asistencia Escolar [Internet]. Docentes Conectados. 2020 ago 19;3(5):40-53 [citado 2025 sep 16]. Disponible en: https://docentesconectados.unsl.edu.ar/index.php/dc/article/view/92

Zárate Gonzales AF, Lima Taype ZI. Sistema de gestión con tecnología RFID para la eficiencia del control de asistencia de estudiantes en una institución educativa privada [Internet]. Perú: Universidad Peruana Unión; 2020 sep 6 [citado 2025 sep 16]. Disponible en: https://repositorio.upeu.edu.pe/items/c7ba4f99-980d-4b50-94cc-5bb2a1ce2542

Mateo Borbor AA. Automatización y agilización en el proceso de control de asistencia estudiantil mediante un dispositivo biométrico [Internet]. Ecuador: Universidad Estatal Península de Santa Elena; 2019 [citado 2025 sep 16]. Disponible en: https://repositorio.upse.edu.ec/server/api/core/bitstreams/c0ad93eb-7f26-47e4-a115-198dce1c9bc6/content

García Peña A. Sistema para el control y seguimiento de asistencia de alumnado [Internet]. Madrid: Universidad Politécnica de Madrid; 2017 [citado 2025 sep 16]. Disponible en: https://oa.upm.es/51597/

Mella C. Software de Control de Asistencia: Innovaciones que marcarán 2025 [Internet]. México: Geo Victoria; 2025 [citado 2025 sep 16]. Disponible en: https://www.geovictoria.com/es-mx/blog/software-de-control-de-asistencia-innovaciones

Worki 360. ¿Qué es el control de asistencia escolar? [Internet]. 2025 [citado 2025 sep 16]. Disponible en: https://www.worki360.com/asistencia/Que-es-el-control-de-asistencia-escolar

Verified Market Reports. Navegar por el futuro: las 7 principales tendencias en el mercado de software de asistencia escolar [Internet]. 2025 [citado 2025 sep 16]. Disponible en: https://www.verifiedmarketreports.com/es/blog/top-7-trends-in-school-attendance-software-market/

Dinella J. El futuro del seguimiento de la asistencia en las escuelas K12: cómo el SIS lo hace más fácil que nunca [Internet]. Vetriche; 2024 oct 18 [citado 2025 nov 12]. Disponible en: https://www.classter.com/es/recursos/libros-electronicos-y-libros-blancos/libros-electronicos/el-futuro-del-seguimiento-de-la-asistencia-en-las-escuelas-k12-como-el-sis-lo-hace-mas-facil-que-nunca/