student-attendence-system

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.

LandingStudent Registration ModuleAdmin DashboardLogin ModuleAttendance PercentageAttendance ManagementTeacher and Subject ManagementAttendance ReportsLow Attendance AlertAttendance Records
Landing

Comments (0)

No comments yet. Be the first!

Project Tasks

120 tasks
#1

Generate system requirement document

1m 6s0.05 cr used
Done
#2

Generate personas & user flows

0m 8s0.05 cr used
Done
#5

Architecture

0m 21s0.05 cr used
Done
#6

Workspace task plan

1m 48s0.05 cr used
Done
#7

Create flow for Admin

0m 5sCredits in parent
Done
#8

Create flow for Teacher

0m 5sCredits in parent
Done
#9

Landing

2m 2sCredits in subtasks
Done
#10

Login Module

1m 58sCredits in subtasks
Done
#11

Admin Dashboard

2m 40sCredits in subtasks
Done
#12

Student Registration Module

6m 0sCredits in subtasks
Done
#13

Teacher and Subject Management

8m 51sCredits in subtasks
Done
#14

Attendance Management

6m 28sCredits in subtasks
Done
#15

Attendance Records

6m 23sCredits in subtasks
Done
#16

Attendance Percentage

9m 25sCredits in subtasks
Done
#17

Low Attendance Alert

8m 2sCredits in subtasks
Done
#18

Attendance Reports

10m 31sCredits in subtasks
Done
#19

Landing / Split Hero

0m 24s0.85 cr used
Done
#20

Landing / Module Summary

0m 22s0.85 cr used
Done
#21

Landing / Navigation

0m 0s0.85 cr used
Done
#22

Landing / Footer

0m 0s0.85 cr used
Done
#23

Navigation

0m 14sCredits in parent
Done
#24

Footer

0m 12sCredits in parent
Done
#25

Login Module / Login Navigation Slot

0m 0s0.85 cr used
Done
#26

Login Module / Login Split Panel

0m 31s0.85 cr used
Done
#27

Login Module / Login Footer Slot

0m 0s0.85 cr used
Done
#28

Admin Dashboard / Sidebar

0m 0s0.85 cr used
Done
#29

Admin Dashboard / Top Bar

0m 24s0.85 cr used
Done
#30

Admin Dashboard / Stat Cards

0m 30s0.85 cr used
Done
#31

Admin Dashboard / Footer

0m 0s0.85 cr used
Done
#32

Admin Dashboard Sidebar

0m 20sCredits in parent
Done
#33

Student Registration Module / Student Registration Sidebar

0m 0s0.85 cr used
Done
#34

Student Registration Module / Student Registration Top Bar

0m 1s0.85 cr used
Done
#35

Student Registration Module / Student Registration Workspace

0m 37s0.85 cr used
Done
#36

Student Registration Module / Student Registration Footer

0m 0s0.85 cr used
Done
#37

Teacher and Subject Management / Teacher Subject Sidebar Slot

0m 0s0.85 cr used
Done
#38

Teacher and Subject Management / Teacher Subject Top Bar Slot

0m 1s0.85 cr used
Done
#39

Teacher and Subject Management / Teacher Subject Page Intro

0m 16s0.85 cr used
Done
#40

Teacher and Subject Management / Teacher Subject Teacher Panel

0m 38s0.85 cr used
Done
#41

Teacher and Subject Management / Teacher Subject Subject Panel

0m 32s0.85 cr used
Done
#42

Teacher and Subject Management / Teacher Subject Assignment Panel

0m 41s0.85 cr used
Done
#43

Teacher and Subject Management / Teacher Subject Footer Slot

0m 0s0.85 cr used
Done
#44

Attendance Management / Sidebar

0m 1s0.85 cr used
Done
#45

Attendance Management / Top Bar

0m 0s0.85 cr used
Done
#46

Attendance Management / Roster

0m 30s0.85 cr used
Done
#47

Attendance Management / Footer

0m 0s0.85 cr used
Done
#48

Attendance Records / Sidebar

0m 1s0.85 cr used
Done
#49

Attendance Records / Top Bar

0m 2s0.85 cr used
Done
#50

Attendance Records / Page Intro

0m 17s0.85 cr used
Done
#51

Attendance Records / History

0m 45s0.85 cr used
Done
#52

Attendance Records / Footer

0m 1s0.85 cr used
Done
#53

Fix Student Registration Module: Student list columns are inaccessible at mobile width because the table overflows its…

1m 16sCredits unavailable
Done
#54

Fix Student Registration Module review finding: Student list columns are inaccessible at mobile width…

0m 17s0 cr used
Done
#55

Fix Teacher and Subject Management: Mobile subject and assignment tables are clipped horizontally; the table wrappers do not…

3m 57sCredits unavailable
Done
#56

Attendance Percentage / Sidebar

0m 1s0.85 cr used
Done
#57

Attendance Percentage / Top Bar

0m 0s0.85 cr used
Done
#58

Attendance Percentage / Page Intro

0m 15s0.85 cr used
Done
#59

Attendance Percentage / Table

0m 39s0.85 cr used
Done
#60

Attendance Percentage / Footer

0m 0s0.85 cr used
Done
#61

Fix Teacher and Subject Management review finding: Mobile subject and assignment tables are clipped…

0m 32s0 cr used
Done
#62

Fix Attendance Management: The shared top bar hardcodes the page title () and eyebrow , so on the Attendance…

1m 3sCredits unavailable
Error
#63

Low Attendance Alert / Sidebar

0m 0s0.85 cr used
Done
#64

Low Attendance Alert / Top Bar

0m 0s0.85 cr used
Done
#65

Low Attendance Alert / Intro

0m 19s0.85 cr used
Done
#66

Low Attendance Alert / List

1m 7s0.85 cr used
Done
#67

Low Attendance Alert / Footer

0m 0s0.85 cr used
Done
#68

Fix Attendance Management review finding: frontend/src/components/Admin Dashboard Top Bar.jsx: the…

4m 53s0 cr used
Paused
#69

Attendance Reports / Sidebar

0m 0s0.85 cr used
Done
#70

Attendance Reports / Top Bar

0m 0s0.85 cr used
Done
#71

Attendance Reports / Intro

0m 15s0.85 cr used
Done
#72

Attendance Reports / Workspace

1m 14s0.85 cr used
Done
#73

Attendance Reports / Footer

0m 0s0.85 cr used
Done
#74

Fix Attendance Percentage: The mobile table requires horizontal scrolling, but the screenshot shows its right-side…

2m 33sCredits unavailable
Done
#75

Fix Teacher and Subject Management review finding: Mobile subject and assignment tables are clipped…

0m 59s0 cr used
Done
#76

Fix Attendance Percentage review finding: The mobile table requires horizontal scrolling, but the…

0m 40s0 cr used
Done
#77

Fix Attendance Reports: The print control never produces a print view of the current report only (FR-22). only…

0m 55sCredits unavailable
Done
#78

Fix Attendance Reports: The button is disabled until a report is generated (), yet the always-visible note and…

1m 32sCredits unavailable
Error
#79

Fix Attendance Reports review findings: frontend/src/components/Attendance Reports Workspace.jsx… (+1 more)

0m 42s0 cr used
Done
#80

Fix Attendance Reports review finding: frontend/src/components/Attendance Reports Workspace.jsx…

0m 22s0 cr used
Error
#81

Create backend_modules diagram

0m 15sCredits in parent
Done
#82

Create er_diagram diagram

0m 16sCredits in parent
Done
#83

Create frontend_modules diagram

0m 16sCredits in parent
Done
#84

Create sequence diagram

0m 16sCredits in parent
Done
#85

Create service_network diagram

0m 16sCredits in parent
Done
#86

Mark and save class attendance with duplicate protection

120 cr estimated
To Do
#87

Database setup, seeded demo data, and role-based sign-in

120 cr estimated
To Do
#88

Admin dashboard totals and signed-in user display

80 cr estimated
To Do
#89

Select class, subject and date to load the student roster

80 cr estimated
To Do
#90

Attendance percentage page with per-student gauges

100 cr estimated
To Do
#91

Student-wise and subject-wise attendance reports

100 cr estimated
To Do
#92

Manage teachers, subjects and subject-teacher assignments

100 cr estimated
To Do
#93

Calculate and display each student's attendance percentage

60 cr estimated
To Do
#94

Search attendance by roll number with date and subject filters

100 cr estimated
To Do
#95

Filter attendance history by subject and date

80 cr estimated
To Do
#96

Attendance history table with roll-number search and date filter

80 cr estimated
To Do
#97

Low attendance alert listing students below 75%

100 cr estimated
To Do
#98

Admin adds, edits and deletes students with validation

120 cr estimated
To Do
#99

Admin manages teachers, subjects and subject assignments

120 cr estimated
To Do
#100

Teacher marks and saves attendance without duplicates

140 cr estimated
To Do
#101

Printable student-wise and subject-wise attendance reports

100 cr estimated
To Do
#102

Sign-in, role-based sessions, logout and the attendance_db schema

140 cr estimated
To Do
#103

Student registration submission with validation and list refresh

100 cr estimated
To Do
#104

Add, edit, search and delete students with integrity protection

100 cr estimated
To Do
#105

Admin dashboard totals and sidebar navigation to management pages

80 cr estimated
To Do
#106

Teacher and subject management with assignment and edit

100 cr estimated
To Do
#107

Run all pages from one local Flask process backed by My SQL

80 cr estimated
To Do
#108

Application-owned sign-in gate for protected pages

100 cr estimated
To Do
#109

Role separation between Admin and Teacher pages

100 cr estimated
To Do
#110

Seed demo students, teachers, subjects and a default admin

80 cr estimated
To Do
#111

Instant 120ms state feedback on buttons and toggles

60 cr estimated
To Do
#112

Sign in with username and password and open the matching role dashboard

120 cr estimated
To Do
#113

Make student registration fully live: add, edit, delete and validate

120 cr estimated
To Do
#114

Wire the login page to real authentication, roles and logout

140 cr estimated
To Do
#115

Live Admin Dashboard totals, navigation and logout

100 cr estimated
To Do
#116

Live attendance history with roll number search and date and subject filters

100 cr estimated
To Do
#117

Live student-wise and subject-wise reports with print

100 cr estimated
To Do
#118

Show live attendance percentages per student

100 cr estimated
To Do
#119

Mark and save class attendance without duplicates

120 cr estimated
To Do
#120

Manage teachers, subjects and assignments live

100 cr estimated
To Do
#121

Flag students below 75% attendance

80 cr estimated
To Do
#122

Route visitors from the landing page to sign in

40 cr estimated
To Do
Live
Landing design preview

Landing: Open dashboard

Login Module: Enter admin credentials

Login Module: 1. Select Admin role and submit

Login Module: 2. Correct credentials after error

Admin Dashboard: 1. Read statistic cards

Admin Dashboard: 2. Retry failed count

Student Registration Module: 1. Add student details

Student Registration Module: 2. Correct validation errors

Student Registration Module: Edit student record

Student Registration Module: Delete student with confirmation

Student Registration Module: Cancel blocked deletion

Teacher and Subject Management: Add teacher

Teacher and Subject Management: Add subject

Teacher and Subject Management: 1. Assign subject to teacher

Teacher and Subject Management: 2. Correct invalid entry

Teacher and Subject Management: Edit teacher details

Admin Dashboard: Verify updated totals

Login Module: Return after logout

Live
Landing design preview

Landing: Open dashboard

Login Module: Enter admin credentials

Login Module: 1. Select Admin role and submit

Login Module: 2. Correct credentials after error

Admin Dashboard: 1. Read statistic cards

Admin Dashboard: 2. Retry failed count

Student Registration Module: 1. Add student details

Student Registration Module: 2. Correct validation errors

Student Registration Module: Edit student record

Student Registration Module: Delete student with confirmation

Student Registration Module: Cancel blocked deletion

Teacher and Subject Management: Add teacher

Teacher and Subject Management: Add subject

Teacher and Subject Management: 1. Assign subject to teacher

Teacher and Subject Management: 2. Correct invalid entry

Teacher and Subject Management: Edit teacher details

Admin Dashboard: Verify updated totals

Login Module: Return after logout