student-attendence-management

bysarvesh gadage

MINI PROJECT DEVELOPMENT PROMPT Build a complete, beginner-friendly mini project called Student Attendance Management System based on the 10 weekly mini-project reports I have provided. Project Objective Create a web-based application to digitally manage student attendance, maintain student records, calculate attendance percentages, and generate attendance reports. Technology Stack - Frontend: HTML5, CSS3, Bootstrap - Backend: Python Flask - Database: MySQL - IDE: Visual Studio Code Required Modules 1. Login Module - Admin login - Teacher login - Username and password authentication - Role-based dashboard access - Logout functionality 2. Student Registration Module - Add student - Roll number - Student name - Class - Department - Semester - Edit student details - Delete student details - Validate inputs 3. Admin Dashboard - Total students - Total teachers - Total subjects - Total attendance records - Clean dashboard with statistic cards 4. Attendance Management - Select class - Select subject - Select attendance date - Display students - Mark students as Present or Absent - Save attendance in the database - Prevent duplicate attendance records for the same student, subject and date 5. Attendance Records - View attendance history - Search using roll number - Filter by date - Filter by subject - Display records in a table 6. Attendance Percentage Calculate the attendance percentage using: Attendance Percentage = (Total Present Classes / Total Conducted Classes) × 100 Display each student's attendance percentage. 7. Low Attendance Alert - Identify students having attendance below 75% - Display a warning message - Show the students in a low-attendance list 8. Attendance Reports - Student-wise attendance report - Subject-wise attendance report - Total present and absent count - Attendance percentage - Print report option 9. Teacher and Subject Management - Add teachers - Add subjects - Assign subjects to teachers - Manage basic teacher details Database Create MySQL database "attendance_db" with appropriate tables such as: - users - students - teachers - subjects - attendance Use proper primary keys, foreign keys and relationships. UI Design Create a modern, professional college project dashboard. Design requirements: - Sidebar navigation - Top navigation bar - Dashboard statistic cards - Clean tables - Search box - Responsive design - Attractive blue and white color theme - Professional login page - Easy navigation between modules Development Requirements 1. Generate a complete working project, not just sample code. 2. Create all required Python, HTML, CSS and SQL files. 3. Use Flask for backend development. 4. Connect the application to MySQL. 5. Include sample students, teachers and subjects. 6. Create a default admin account for demonstration. 7. Make all buttons and forms functional. 8. Handle errors and invalid inputs. 9. Keep the code simple enough for a second-year engineering student to understand and explain. 10. Do not use unnecessary advanced technologies. Deliverables Provide: - Complete project folder structure - All source code files - MySQL database setup script - requirements.txt - README.md - Installation instructions - How to run the project in VS Code - Sample login credentials - Test cases - Project abstract - Future scope - Conclusion IMPORTANT I have very little time to complete this mini project. Prioritize a fully functional, simple project that can run locally. Build the core modules first and avoid complicated features. Provide every file with complete code and exact setup steps. Do not leave unfinished placeholders or missing functions.

LandingLogin ModuleAdmin DashboardTeacher and Subject ManagementStudent Registration ModuleAttendance ManagementAttendance PercentageAttendance ReportsAttendance RecordsLow Attendance Alert
Landing

Comments (0)

No comments yet. Be the first!

Live
Attendance Reports design preview

Landing: Open landing page

Login Module: 1. Submit admin credentials

Login Module: 2. Retry after invalid credentials

Admin Dashboard: 1. Read statistic totals

Admin Dashboard: 2. Retry loading totals

Student Registration Module: 1. Add student details

Student Registration Module: 2. Correct validation errors

Student Registration Module: Edit student row

Student Registration Module: Delete student with confirmation

Student Registration Module: Search student table

Teacher and Subject Management: Add teacher with credentials

Teacher and Subject Management: Add subject

Teacher and Subject Management: 1. Assign subject to teacher

Teacher and Subject Management: 2. Correct duplicate assignment

Teacher and Subject Management: Edit teacher details

Teacher and Subject Management: Delete teacher or subject

Attendance Management: Select class, subject and date

Attendance Management: Mark students present or absent

Attendance Management: 1. Save attendance

Attendance Management: 2. Adjust selection after duplicate

Attendance Records: View attendance history

Attendance Records: Search by roll number

Attendance Records: Filter by date and subject

Attendance Percentage: Read student percentages

Low Attendance Alert: Read warning and low list

Attendance Reports: Generate student-wise report

Attendance Reports: Switch to subject-wise report

Attendance Reports: Print report

Login Module: Log out and return to login

Live
Landing design preview

Landing: Open landing page

Login Module: 1. Submit admin credentials

Login Module: 2. Retry after invalid credentials

Admin Dashboard: 1. Read statistic totals

Admin Dashboard: 2. Retry loading totals

Student Registration Module: 1. Add student details

Student Registration Module: 2. Correct validation errors

Student Registration Module: Edit student row

Student Registration Module: Delete student with confirmation

Student Registration Module: Search student table

Teacher and Subject Management: Add teacher with credentials

Teacher and Subject Management: Add subject

Teacher and Subject Management: 1. Assign subject to teacher

Teacher and Subject Management: 2. Correct duplicate assignment

Teacher and Subject Management: Edit teacher details

Teacher and Subject Management: Delete teacher or subject

Attendance Management: Select class, subject and date

Attendance Management: Mark students present or absent

Attendance Management: 1. Save attendance

Attendance Management: 2. Adjust selection after duplicate

Attendance Records: View attendance history

Attendance Records: Search by roll number

Attendance Records: Filter by date and subject

Attendance Percentage: Read student percentages

Low Attendance Alert: Read warning and low list

Attendance Reports: Generate student-wise report

Attendance Reports: Switch to subject-wise report

Attendance Reports: Print report

Login Module: Log out and return to login