A Python-based attendance management system designed to streamline attendance tracking for the Victoria Junior College Robotics and Makers' Club (VRMC).
The Victoria Junior College Robotics and Makers' Club (VRMC) faced challenges in efficiently tracking attendance, particularly when members were absent without prior notification or a valid reason (VR). To address this, I developed this bot to automate the process.
This system works by reading responses from a designated "Reason For Absence" form. It intelligently interprets the provided reasons to determine their validity and subsequently updates the attendance sheet. Furthermore, to simplify the leave approval process, the bot automatically sends out email notifications:
- Members with a valid reason (VR) receive an approval confirmation.
- Members absent without a valid reason are notified of their unauthorized absence and instructed to approach the Teachers-In-Charge for further clarification.
- Automated Attendance Recording: Records and updates attendance based on submitted forms.
- Reason Validity Assessment: Interprets student responses to determine if reasons for absence are valid.
- Automated Email Notifications: Sends personalized emails to students regarding the status of their absence reasons.
- Replace Spreadsheet and Form: Update the code to link to your preferred attendance spreadsheet and absence submission form.
- Edit Gemini Prompt: Modify the prompt given to the Gemini API to better suit your criteria for valid absence reasons.
- Run the Bot: Run the Bot.py file
Though this project was created for Victoria Junior College, Robotics and Makers' Club, you can contact me at vijai.adithya24@gmail.com to raise any issues/collaboration, etc.
To get started with the Attendance Tracker, follow these steps:
git clone [https://github.com/VJ2408/VJC-Robotics.git](https://github.com/VJ2408/VJC-Robotics.git)
cd VJC-Robotics
pip install -r requirements.txt