DESIGNING A "NO CODE" ATTENDANCE APPLICATION FOR EXTRACURRICULAR CLASSES

Bùi Minh Tân; Lương Trần Ngọc Khiết; Đinh Tin; Lê Thị Hồng Tuyết; Lương Trần Hy Hiến; Lê Minh Triết

doi:10.34238/tnu-jst.12429

DESIGNING A "NO CODE" ATTENDANCE APPLICATION FOR EXTRACURRICULAR CLASSES

About this article

Received: 31/03/25 Revised: 26/06/25 Published: 28/06/25

Authors

1. Bui Minh Tan, Ho Chi Minh City University of Education
2. Luong Tran Ngoc Khiet , Ho Chi Minh City University of Education
3. Dinh Tin, Ho Chi Minh City University of Education
4. Le Thi Hong Tuyet, Ho Chi Minh City University of Education
5. Luong Tran Hy Hien, Ho Chi Minh City University of Education
6. Le Minh Triet, Ho Chi Minh City University of Education

Abstract

Managing attendance in extracurricular classes poses challenges due to flexible schedules and locations, often leading to errors and potential fraud. This paper presents the design, implementation, and evaluation of a no code electronic attendance system developed using AppSheet with Google Sheets as the backend. The global positioning system is used to verify student location within a 100 m radius, requires real-time photo capture during check-in, and applies session-based controls to prevent late or fraudulent submissions. The methodology includes system architecture design, technical criteria definition, and a one-month pilot with classes of around 30 students at Ho Chi Minh City University of Education. Data such as timestamps, images, and coordinates are automatically recorded and verified. Results show a 75% reduction in attendance errors and a 72% decrease in check-in time, cutting manual roll calls from 6–8 minutes to 1–2 minutes per session. User feedback highlights system stability and satisfaction, confirming the feasibility and scalability of no code solutions for flexible education and related fields.

Keywords

No-code; Low-code; Attendance; Classroom management; Global positioning system

Full Text:

PDF (Tiếng Việt)

References

[1] P. S. Gagare, P. A. Sathe, V. T. Pawaskar, and S. S. Bhave, "Smart attendance system," International Journal on Recent and Innovation Trends in Computing and Communication, vol. 2, no. 1, pp. 124-127, 2014.

[2] N. Rahayu, F. Fauziah, and N. Hayati, "Online attendance system design to reduce the potential of COVID-19 distribution," Jurnal Mantik, vol. 4, no. 1, pp. 921-925, 2020.

[3] O. A. Akinola, S. O. Olopade, and A. S. Afolabi, “Development of mobile and desktop applications for a fingerprint-based attendance management system,” Indones. J. Electr. Eng. Comput. Sci, vol. 24, no. 1, pp. 570-580, 2021.

[4] M. S. M. Alburaiki, G. M. Johar, R. A. A. Helmi, and M. H. Alkawaz, “Mobile based attendance system: face recognition and location detection using machine learning,” in 2021 IEEE 12th Control and System Graduate Research Colloquium (ICSGRC), August 2021, pp. 177-182.

[5] B. Benyo, B. Sodor, T. Doktor, and G. Fördős, “Student attendance monitoring at the university using NFC,” in Wireless Telecommunications Symposium, 2012, pp. 1-5.

[6] N. Petrović, M. Radenković, and V. Nejković, "Data-driven mobile applications based on AppSheet as support in COVID-19 crisis," in IcETRAN 2020, 2020, pp. 1-6.

[7] N. Petrović, V. Roblek, M. Radenković, and V. Nejković, "Approach to rapid development of data-driven applications for smart cities using AppSheet and Apps Script," in AIIT 2020 International Conference on Applied Internet and Information Technologies, Oct. 2020, pp. 77-81.

[8] K. Tsuji, S. Gurjar, and T. Miyai, Democratizing Application Development with AppSheet: A Citizen Developer’s Guide to Building Rapid Low-Code Applications with Powerful Features of AppSheet. Packt Publishing, 2023.

[9] Sheetsformarketers, "How secure is Google Sheets?," Sheets for Marketers, Oct. 31, 2023. [Online]. Available: https://sheetsformarketers.com/how-secure-is-google-sheets. [Accessed Mar. 31, 2025].

[10] W. Nurharjadmo, M. A. Khadija, and T. Wahyuning, "Modern no-code software development Android inventory system for micro, small, and medium enterprises," in 2022 IEEE International Conference on Cybernetics and Computational Intelligence (CyberneticsCom), Jun. 2022, pp. 191-195.

11] Google Docs Editors Help, "How to use Google Sheets - Computer - Google Docs Editors Help," 2025. [Online]. Available: https://support.google.com/docs/answer/6000292?hl=vi&ref_topic=9055343. [Accessed Mar. 31, 2025].

[12] Ben, "How to use Google Sheets: The Complete Beginner’s Guide," Mar. 30, 2022. [Online]. Available: https://www.benlcollins.com/spreadsheets/how-to-use-google-sheets/. [Accessed Mar. 31, 2025].

[13] Google Cloud, "AppSheet Pricing," 2024. [Online]. Available: https://about.appsheet.com/pricing/ [Accessed Dec. 15, 2024].

DOI: https://doi.org/10.34238/tnu-jst.12429

Refbacks

There are currently no refbacks.



Remember me