Developing a management system for course enrollment amendments: implementing Google Apps for an efficient workflow
DOI:
https://doi.org/10.18041/1900-3803/entramado.2.13429Keywords:
Management system, Data System, Cloud Service, Apps Script, Google Suite, Course Enrollment, Amendment, Knowledge Management, Efficiency ThresholdAbstract
Efficient course enrollment amendments require scalable tools to manage administrative complexities. This study develops and evaluates a Google Apps Script (GAS)-based smart office system implemented in a university to modernize online asynchronous workflows and analyze staff adoption of the system. The descriptive research encompassed 44 academic units managing 9,914 requests from 5,432 students across 226 interaction routes. The results demonstrated a 66% improvement in response time efficiency compared to the institutional benchmarks. A critical efficiency threshold was identified, where staff adoption reached 100%, indicating that low-code adoption is driven by administrative survival during peak workloads. The system successfully managed high-complexity structures by simulating relational data in a free-tier cloud environment. This implementation establishes a robust knowledge management framework, proving the cost-effective potential of low-code solutions for digital transformation in higher education. The findings confirm a non-linear correlation between workload and technology adoption, providing a verified background for institutional scalability.
Downloads
References
AIRINEI, Dinu; HOMOCIANU, Daniel. Cloud Computing Based Web Applications. Examples and Considerations on Google Apps Script. In: Proceedings of the IE 2017 International Conference, pp.64-69. 2017. http://doi.org/10.2139/ssrn.2964756
2. ALCAIDE, Paulino III; FINEZ, Kaizley D; MAGWILI, Glenn V. Real-time Monitoring of Bicycle Behavior in IoT Fall Detection System. In: 2024 8th International Conference on Communication and Information Systems. 2024. p. 191-196. http://doi.org/10.1109/iccis63642.2024.10779382
3. BAKRANIA, Smitesh; JOHNSON, Brad. A Cloud-based Tool for Assigning Students to Projects. In: 2015 ASEE Annual Conference & Exposition. 2015. p. 20-26. http://doi.org/10.18260/p.23361
4. BARANKOV, Viktor; BARANKOVA, Irina; MIKHAILOVA, Ulyana; KALUGINA, Olga. Experience of Developing Cloud Service for accounting Sales in installments. In: Journal Of Physics Conference Series. 2018. vol. 1015, no. 4. http://doi.org/10.1088/1742-6596/1015/4/042004
5. BAZÁN-CRUZ, Eduardo Daniel. Implementación de un sistema de seguimiento de egresados de la EAP de Ingeniería Agroindustrial basado en un modelo de gestión. Tesis de Ingeniería Agroindustrial. Trujillo-Perú: Universidad Nacional de Trujillo. 2017. http://dspace.unitru.edu.pe/handle/UNITRU/10953
6. BHUVANESHWARI, Balan; PRASADH, Harish; SATHISH, P; ANUJA, Vishnu; MYTHILY, A. Automated Contactless Attendance System. In: Lecture Notes on Data Engineering and Communications Technologies. 2023. vol 166. p. 523-532. http://doi.org/10.1007/978-981-99-0835-6_37
7. CHARÃO, Andrea; HOFFMANN, Guilherme; STEFFENEL, Luiz; KIRSCH-PINHEIRO, Manuele; DE-OLIVEIRA-STEIN, Benhur. Performance Evaluation of Cloud-based RDBMS through a Cloud Scripting Language. In: Proceedings of the 19th International Conference on Enterprise Information Systems. 2017. vol 1. p. 332-337. http://doi.org/10.5220/0006350803320337
8. CUIPING, Han. Design and implementation of Student Management System of Educational Management System. In: 2014 IEEE Workshop on Advanced Research and Technology in Industry Applications (WARTIA). 2014. p. 199-202. http://doi.org/10.1109/wartia.2014.6976231
9. DEBELL, Thomas; GOERTZEN, Luke; LARSON, Lars; SELBIE, William; SELKER, John; UDELL, Chet. OPEnS Hub: Real-Time Data Logging, Connecting Field Sensors to Google Sheets. In: Frontiers In Earth Science. 2019. vol. 7. http://doi.org/10.3389/feart.2019.00137
10. DEVAPRAKASH; GOWTHAM; MURALI; MURALIDHARAN; VIJAYALAKSHMI, V. J. Centralized attendance monitoring system. In: 2020 6th International Conference on Advanced Computing and Communication Systems (ICACCS). 2020. p. 1288-1291. http://doi.org/10.1109/ICACCS48705.2020.9074162
11. DIAZ-ARRUNATEGUI, Karina Lucia. External services integration for internal usage of an organization, using Google Apps Script. Treball Final de GrauEstudis de primer/segon cicle. Enginyeria Tècnica de Telecomunicació, Especialitat en Telemàtica (Pla 2000). Universitat Politècnica de Catalunya, 2015. https://upcommons.upc.edu/entities/publication/c92c0e2b-a633-4dbc-b108-8fb894a0d9cb
12. EKANAYAKE, Lahiru; IHALAGE, Deepthi; ABYESUNDARA, Sachith. Performance Evaluation of Google Spreadsheet over RDBMS through Cloud Scripting Algorithms. In: 2021 International Conference on Computer Communication and Informatics (ICCCI). 2021. p. 1-7. http://doi.org/10.1109/ICCCI50826.2021.9402432
13. FRANSEN, Janet; KOCHER, Megan; KEMPF, Jody. Google forms for staff self-assessment: Creating customization. In: College and Research Libraries. News (CRL). 2011. vol. 72, no. 10. p. 587-591. https://doi.org/10.5860/crln.72.10.8653
14. GOOGLE, Apps Script - Google Apps Script. 2023. https://developers.google.com/apps-script?hl=es-419
15. HOMOCIANU, Daniel; HOMOCIANU, Mihaela. GiPlot: An interactive cloud-based tool for visualizing and interpreting large spectral data sets. In: Spectrochimica Acta Part A Molecular and Biomolecular Spectroscopy. 2019. vol. 209, p. 234-240. http://doi.org/10.1016/j.saa.2018.10.046
16. JHAN, Prasobj; SREEKUMAR, M; KURIAKOSE, Rosemary. Enhancing library services with artificial intelligence: A framework for an automated news delivery system. In: IFLA Journal. 2025. vol. 51, no. 3. p. 836-848. http://doi.org/10.1177/03400352251358064
17. KAPRIELIAN, Paul; PHAM, Thach; YOUNG, Alex; DOW, Douglas; GRENQUIST, Scott; DECKER, Bruce. Winter Cabin Water Tap Monitor and Release System to Reduce Risk of Freezing. In: 2022 IEEE 13th Annual Ubiquitous Computing, Electronics & Mobile Communication Conference (UEMCON). 2019. p. 606-609. http://doi.org/10.1109/uemcon47517.2019.8993098
18. KISHAN, Surapaneni; HAMEED, Syed; CHARAN, Jampani; SRIKAR, Yaragudipati. RFID-Based Elevator Access Control System. In: 2024 15th International Conference on Computing Communication and Networking Technologies (ICCCNT). 2024. p. 1-5. http://doi.org/10.1109/icccnt61001.2024.10724057
19. KOK-HOE, Ho; YOTSUYANAGI, Tamon. Development of Smart Mini Manufacturing System Model for Industry 4.0 Application. In: Journal of Advanced Research in Applied Mechanics. 2024. vol. 114, no. 1. p. 94-108. https://semarakilmu.com.my/journals/index.php/appl_mech/article/view/5275
20. LAXMI, Geetha; JACOB, Alwyn; G-S, Jeevitha; MOHANDAS, Mahesh; GATTY, Mithali. Web-based University Results Analytics Tool. In: Grenze International Journal of Engineering and Technology. 2024. Vol. 10, no. 2. p. 5157-5162. https://thegrenze.com/index.php?display=page&view=journalabstract&absid=3340&id=8
21. LIRA-CAMARGO, Jorge; OGOSI-AUQUI, José Antonio; VERA-TITO, Francisca Sonia. Implementation of Google App script for automatic generation of pre-registration form. In: DYNA. 2025. vol. 92, no. 238. p. 35-38. https://doi.org/10.15446/dyna.v92n238.117750
22. LOGESHWARAN, E; MADANIKA, M; MANUPRABHA, R; VENKATESHKUMAR, M; SUYAMPULINGAM, A. Smart Agriculture: Real-Time Environmental Monitoring and Temperature Forecasting Using Machine Learning. In: 2024 2nd International Conference on Cyber Physical Systems, Power Electronics and Electric Vehicles (ICPEEV). 2024. p. 1-6. http://doi.org/10.1109/icpeev63032.2024.10932004
23. LUTSENKO, Galyna; HRYTSENKO, Valerii. Using Low-Code Development in Teaching Project Work Technology. In: Futureproofing Engineering Education for Global Responsibility. 2025. vol. 1280. p. 501-508. http://doi.org/10.1007/978-3-031-83523-0_46
24. NISHIOKA, Shie; OKAMOTO, Hiroyuki; CHIBA, Takahito; KITO, Satoshi; ISHIHARA, Yoshitomo; ISONO, Masaru; ONO, Tomohiro; MIZOGUCHI, Asumi; MIZUNO, Norifumi; TOHYAMA, Naoki; KUROOKA, Masahiko; OTA, Seiichi; SHIMIZU, Daisuke. Technical note: A universal worksheet for failure mode and effects analysis-A project of the Japanese College of Medical Physics. In: Medical Physics. 2024. vol. 51, no. 5. p. 3658-3664. http://doi.org/10.1002/mp.17033
25. PACIOS, David; IGNACIO-CERRATO, Sara; VAZQUEZ-POLETTI, José Luis; MORENO-VOZMEDIANO, Rafael; SCHETAKIS, Nikolaos; STAVRAKAKIS, Konstantinos; DI-IORIO, Alessio; GOMEZ-SANZ, Jorge J; VAZQUEZ, Luis. Amazon Web Service–Google Cross-Cloud Platform for Machine Learning-Based Satellite Image Detection. In: Information. 2025. vol. 16, no. 5. p. 381. http://doi.org/10.3390/info16050381
26. PREECHADECH, Jirayus; YONGSIRIWIT, Karn. Development of a Smart Office System through LINE Official Account: A Case Study of the Public Sector Development Group, Department of Medical Services. In: 2024 8th International Conference on Information Technology (InCIT). 2024. p. 411-416. https://doi.org:10.1109/InCIT63192.2024.10810552
27. RAJPUT, Pruthvish; PAREKH, Rutu. On-Board Diagnostics based remote emission test for Light Motor Vehicles. In: 2020 IEEE International Conference on Electronics, Computing and Communication Technologies (CONECCT). 2020. p. 1-6. http://doi.org/10.1109/CONECCT50063.2020.9198374
28. RAMADHANI, Shumaya. The utilization of G-suite features combination on developing small size of android application. In: 2020 3rd International Conference on Applied Science and Technology. 2020. p. 230-235. http://doi.org/10.1109/iCAST51016.2020.9557668
29. REVUELTA-ARRIBAS, Alberto. Creación de un complemento para Google Apps Script para la gestión de datos UPM. Trabajo Fin de Grado. Grado en Ingeniería Informática. Escuela Técnica Superior de Ingenieros Informáticos, Universidad Politécnica de Madrid, España. 2020. https://oa.upm.es/58093/
30. SHIVAKUMAR, Ramasami. Implementation and Effective Utilization of Analytical Tools and Techniques in Knowledge Management. In: International Journal of Recent Technology and Engineering (IJRTE). 2019. vol. 8, no. 2. p. 6469-6482. http://doi.org/10.35940/ijrte.a9488.078219
31. SIIMAN, Leo; MÄEOTS, Mario. Assessing Students’ Digital Literacy with Interactive Computer-Based Tasks Created in Google Apps Script In: EDULEARN19 Proceedings. 11th International Conference on Education and New Learning Technologies. 2019. p. 10265-10271. http://doi.org/10.21125/edulearn.2019.2578
32. THAKKAR, Devang; RAJPUT, Pruthvish; DUBEY, Rahul; PAREKH, Rutu. Design and Implementation of Autonomous UAV Tracking System Using GPS and GPRS. In: Progress in Advanced Computing and Intelligent Engineering – Proceedings of ICACIE 2017. 2019. vol. 714. p. 433-439. http://doi.org/10.1007/978-981-13-0224-4_39
33. THOMAS, Peter. Bespoke automation of medical workforce rostering using Google’s free cloud applications. In: Journal Of Innovation in Health Informatics. 2017. vol. 24, no. 4. p. 334-338. http://doi.org/10.14236/jhi.v24i4.885
34. TORRES-VELANDIA, Serafín Ángel; BARONA-RÍOS, César; GARCÍA-PONCE-DE-LEÓN, Omar. Infraestructura tecnológica y apropiación de las TIC en la Universidad Autónoma del Estado de Morelos. Estudio de caso. En: Perfiles Educativos. 2010. vol. 32, no. 127. p. 125-127. http://doi.org/10.22201/iisue.24486167e.2010.127.18881
35. UMNG, Anuario Estadístico Institucional UMNG 2022, Bogotá, 2022. Universidad Militar Nueva Granada. https://umng.edu.co/gestion-estadistica/
36. VELÁSQUEZ-GUEVARA, Sebastian; PEDRAZA, Gilberto; CHAVARRIAGA, Jaime. Multi-SPLOT: Supporting Multi-user Configurations with Constraint Programming. In: Applied Informatics. ICAI 2018. Communications in Computer and Information Science. 2018. Vol. 942. p. 364-378. http://doi.org/10.1007/978-3-030-01535-0_27
37. WARD, Anthony. An example of the use of Google Suite Apps to monitor student engagement in a complex delivery situation. In: 2021 30th Annual Conference of The European Association for Education in Electrical and Information Engineering (EAEEIE). 2021. p. 1-5. http://doi.org/10.1109/eaeeie50507.2021.9530855
38. WHITE, Laurie; ALLEN, Robert. Using Google apps script for classroom management and more. In: Journal Of Computing Sciences in Colleges. 2014. vol. 30, no. 2. p. 171-173. https://dl.acm.org/doi/abs/10.5555/2667432.2667456
39. WIBISONO, Yusuf., WARDHANA, Mada; PAMUNGKAS, Wisnu. Design of Google Apps-based helpdesk ticketing system at University using extreme programming approach. In: The 2nd International Conference of Science and Information Technology in Smart Administration. 2022. vol. 2658, no. 1. https://doi.org/10.1063/5.0106944
Published
Issue
Section
License
Copyright (c) 2026 Entramado
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
