To search, Click below search items.

 

All Published Papers Search Service

Title

A Non-Invasive Daily Attendance Alert System: An Excel-Based Approach for Enhanced Student Monitoring

Author

Veer Bobade, Sumit Ladwan, Karan Bhute, Lucky Ghai, Pawan Chaudhari, Sanz Wadibhasme

Citation

Vol. 25  No. 10  pp. 69-74

Abstract

Attendance has long been recognized as a critical determinant of student learning outcomes, retention, and overall academic success. However, institutions continue to face challenges in implementing systems that are efficient, affordable, and respectful of privacy. While advanced technologies such as RFID, biometrics, and mobile applications offer automation, they often remain financially prohibitive and intrusive, particularly in resource-constrained educational environments. This study introduces a non-invasive daily attendance alert system developed entirely within Microsoft Excel. By leveraging formula-driven calculations, conditional formatting, and macro-enabled automation, the system streamlines attendance entry, generates real-time absence alerts, and provides customizable reporting dashboards. A semester-long pilot with 120 undergraduate students demonstrated significant efficiency gains (60% reduction in attendance processing time), increased accountability (15% rise in attendance rates), and high adaptability to institutional contexts. Beyond cost-effectiveness, this approach illustrates how widely available software can be repurposed into an innovative tool for educational administration. The paper contributes by presenting the design, implementation, comparative analysis, and pedagogical implications of this low-cost yet scalable solution.

Keywords

Attendance, Security and Privacy,

URL

http://paper.ijcsns.org/07_book/202510/20251008.pdf