How arijit-006/student-attendance-management- works
This is an Excel-based attendance analytics workbook. The documented workflow organizes student and attendance records, derives student-, subject-, date-, and faculty-level analyses plus attendance categories and exception lists, then presents KPIs and visualizations in a dashboard. The repository contains only the workbook; relationships below follow the README, not inspected worksheet formulas or workbook internals.
Main entry points: Student_Attendance_Management_System_FINAL_FIXED.xlsx Dashboard
Components 11
Attendance Records
- Student Master
Student_Attendance_Management_System_FINAL_FIXED.xlsx - Attendance Data
Student_Attendance_Management_System_FINAL_FIXED.xlsx
Attendance Analysis
- Student Summary
Student_Attendance_Management_System_FINAL_FIXED.xlsx - Subject Analysis
Student_Attendance_Management_System_FINAL_FIXED.xlsx - Daily Analysis
Student_Attendance_Management_System_FINAL_FIXED.xlsx - Faculty Analysis
Student_Attendance_Management_System_FINAL_FIXED.xlsx - Attendance Distribution
Student_Attendance_Management_System_FINAL_FIXED.xlsx - Below Threshold
Student_Attendance_Management_System_FINAL_FIXED.xlsx - Below Average
Student_Attendance_Management_System_FINAL_FIXED.xlsx
Dashboard
- Dashboard
Student_Attendance_Management_System_FINAL_FIXED.xlsx
Other components
- Workbook user
Connections 17
- Workbook user → Attendance Data: records attendance
- Student Master → Student Summary: student details
- Attendance Data → Student Summary: summarizes records
- Attendance Data → Subject Analysis: analyzes by subject
- Attendance Data → Daily Analysis: analyzes by date
- Attendance Data → Faculty Analysis: analyzes by faculty
- Student Summary → Attendance Distribution: categorizes attendance
- Student Summary → Below Threshold: finds below 75%
- Student Summary → Below Average: finds below average
- Student Summary → Dashboard: provides KPIs
- Subject Analysis → Dashboard: provides insights
- Daily Analysis → Dashboard: provides trends
- Faculty Analysis → Dashboard: provides insights
- Attendance Distribution → Dashboard: provides distribution
- Below Threshold → Dashboard: provides exceptions
- Below Average → Dashboard: provides exceptions
- Workbook user → Dashboard: views insights