Bio Track-Smart Attendance with Excel & SMS Integration
Asst. Prof Renuka Kelapure1, Onkar Dande2, Tejaswini Patil3 , Abhishek Rahinj3
1Asst. Prof. Department of Electrical Engineering, Trinity College of Engineering & Research, Pune-411048
234Student Department of Electrical Engineering, Trinity College of Engineering & Research, Pune-411048
ABSTRACT - This paper summarizes design and implementation of an Arduino-based smart biometric attendance system which combines Excel reporting and SMS (WhatsApp) notifications. By automating student tracking through authorization with fingerprints, real-time data logging, and automated communication, the system resolves the inefficiencies associated with traditional attendance methods. An Arduino microcontroller, a fingerprint (FP) sensor for biometric verification, an I2C module interfaced with a 16x2 LCD for user interaction, and an SMPS for a steady power supply make up the hardware setup. Student attendance is automatically entered into an Excel spread sheet via serial communication immediately following a fingerprint scan, removing the requirement of human entry. Students who arrive late are automatically marked absent as part of the system's rule-based attendance policy, which increases accountability. Summarized attendance reports are created in Excel at the end of each day and sent to teachers via email for their consideration. Additionally, the system uses software-based integration to notify parents via WhatsApp each weekend about their child's absences, replacing traditional GSM-based notifications with internet-based communication. This hybrid strategy lowers expenses, improves dependability, and makes integrating with current school administration systems easier. Through a low-cost, scalable system appropriate for educational institutions, the suggested solution aims to improve transparency, automate administrative workload, and ensure accurate attendance tracking.
Key Words: Biometric attendance, Arduino, Excel integration, WhatsApp notification, fingerprint sensor, automated reporting, python script.
