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!

Project Tasks

128 tasks
#1

Generate system requirement document

0m 54s0.05 cr used
Done
#2

Generate personas & user flows

0m 10s0.05 cr used
Done
#5

Architecture

0m 23s0.05 cr used
Done
#6

Workspace task plan

2m 1s0.05 cr used
Done
#7

Create flow for Admin

0m 8sCredits in parent
Done
#8

Create flow for Teacher

0m 8sCredits in parent
Done
#9

Landing

5m 1sCredits in subtasks
Done
#10

Login Module

5m 25sCredits in subtasks
Done
#11

Admin Dashboard

4m 41sCredits in subtasks
Done
#12

Student Registration Module

7m 30sCredits in subtasks
Done
#13

Teacher and Subject Management

8m 21sCredits in subtasks
Done
#14

Attendance Management

8m 31sCredits in subtasks
Done
#15

Attendance Records

9m 24sCredits in subtasks
Done
#16

Attendance Percentage

7m 47sCredits in subtasks
Done
#17

Low Attendance Alert

10m 13sCredits in subtasks
Done
#18

Attendance Reports

9m 56sCredits in subtasks
Done
#19

Landing / Hero Split

0m 21s0.85 cr used
Done
#20

Landing / Product Summary

0m 19s0.85 cr used
Done
#21

Landing / Module List

0m 18s0.85 cr used
Done
#22

Landing / Footer

0m 18s0.85 cr used
Done
#23

Landing / Navigation

0m 0s0.85 cr used
Done
#24

Navigation

0m 16sCredits in parent
Done
#25

Login Module / Navigation

0m 1s0.85 cr used
Done
#26

Login Module / Footer

0m 0s0.85 cr used
Done
#27

Login Module / Login Split Intro

0m 21s0.85 cr used
Done
#28

Login Module / Login Form Card

0m 31s0.85 cr used
Done
#29

Admin Dashboard / Header

0m 0s0.85 cr used
Done
#30

Admin Dashboard / Totals

0m 53s0.85 cr used
Done
#31

Admin Dashboard / Footer

0m 0s0.85 cr used
Done
#32

Admin Dashboard / Sidebar

0m 1s0.85 cr used
Done
#33

Admin Dashboard Sidebar

0m 17sCredits in parent
Done
#34

Fix Login Module: Tablet layout leaves half the viewport unused and confines the login content and footer…

2m 56sCredits unavailable
Done
#35

Fix Login Module review finding: Tablet layout leaves half the viewport unused and confines…

0m 31s0 cr used
Done
#36

Student Registration Module / Student Registration Navigation

0m 1s0.85 cr used
Done
#37

Student Registration Module / Student Registration Sidebar

0m 0s0.85 cr used
Done
#38

Student Registration Module / Student Registration Workspace

0m 54s0.85 cr used
Done
#39

Student Registration Module / Student Registration Footer

0m 1s0.85 cr used
Done
#40

Teacher and Subject Management / Teacher Subject Navigation

0m 2s0.85 cr used
Done
#41

Teacher and Subject Management / Teacher Subject Sidebar

0m 2s0.85 cr used
Done
#42

Teacher and Subject Management / Teacher Subject Page Intro

0m 14s0.85 cr used
Done
#43

Teacher and Subject Management / Teacher Subject Teacher Registry

0m 48s0.85 cr used
Done
#44

Teacher and Subject Management / Teacher Subject Subject Registry

0m 49s0.85 cr used
Done
#45

Teacher and Subject Management / Teacher Subject Assignment

0m 33s0.85 cr used
Done
#46

Teacher and Subject Management / Teacher Subject Footer

0m 1s0.85 cr used
Done
#47

Fix Admin Dashboard: Mobile sidebar navigation clips module links; implicated files: and (.ads-panel…

0m 49sCredits unavailable
Done
#48

Fix Admin Dashboard review finding: Mobile sidebar navigation clips module links;

0m 14s0 cr used
Done
#49

Fix Login Module review finding: Tablet layout leaves half the viewport unused and confines…

0m 32s0 cr used
Done
#50

Attendance Management / Navigation

0m 1s0.85 cr used
Done
#51

Attendance Management / Sidebar

0m 4s0.85 cr used
Done
#52

Attendance Management / Intro

0m 16s0.85 cr used
Done
#53

Attendance Management / Workspace

0m 50s0.85 cr used
Done
#54

Attendance Management / Footer

0m 2s0.85 cr used
Done
#55

Attendance Records / Navigation

0m 1s0.85 cr used
Done
#56

Attendance Records / Sidebar

0m 1s0.85 cr used
Done
#57

Attendance Records / Intro

0m 10s0.85 cr used
Done
#58

Attendance Records / Workspace

0m 44s0.85 cr used
Done
#59

Attendance Records / Footer

0m 1s0.85 cr used
Done
#60

Attendance Percentage / Navigation

0m 1s0.85 cr used
Done
#61

Attendance Percentage / Sidebar

0m 1s0.85 cr used
Done
#62

Attendance Percentage / Intro

0m 10s0.85 cr used
Done
#63

Attendance Percentage / Table

0m 40s0.85 cr used
Done
#64

Attendance Percentage / Footer

0m 1s0.85 cr used
Done
#65

Low Attendance Alert / Navigation

0m 0s0.85 cr used
Done
#66

Low Attendance Alert / Admin Dashboard Sidebar

0m 0s0.85 cr used
Done
#67

Low Attendance Alert / Intro

0m 14s0.85 cr used
Done
#68

Low Attendance Alert / Workspace

0m 35s0.85 cr used
Done
#69

Low Attendance Alert / Landing Footer

0m 0s0.85 cr used
Done
#70

Fix Student Registration Module: The page's primary content is gated behind a client-side session check ( reading ). With…

0m 24sCredits unavailable
Error
#71

Fix Student Registration Module review finding: frontend/src/components/Student Registration Workspace.jsx…

0m 20s0 cr used
Error
#72

Fix Attendance Management: Roster table is clipped horizontally on mobile; the Status column is not fully visible.…

1m 21sCredits unavailable
Done
#73

Fix Teacher and Subject Management: Teacher registry overflows horizontally on mobile, hiding its remaining columns and…

1m 4sCredits unavailable
Error
#74

Fix Attendance Records: Mobile attendance table hides record columns beyond the viewport

1m 50sCredits unavailable
Done
#75

Fix Attendance Management review finding: Roster table is clipped horizontally on mobile;

0m 18s0 cr used
Done
#76

Attendance Reports / Navigation

0m 0s0.85 cr used
Done
#77

Attendance Reports / Sidebar

0m 0s0.85 cr used
Done
#78

Attendance Reports / Intro

0m 17s0.85 cr used
Done
#79

Attendance Reports / Workspace

1m 19s0.85 cr used
Done
#80

Attendance Reports / Footer

0m 0s0.85 cr used
Done
#81

Fix Teacher and Subject Management review finding: Teacher registry overflows horizontally on mobile, hiding…

0m 21s0 cr used
Error
#82

Fix Attendance Records review finding: Mobile attendance table hides record columns beyond the…

0m 21s0 cr used
Done
#83

Fix Low Attendance Alert: Tablet sidebar navigation is clipped by its panel. In , .lo-layout-1 gives the sidebar a…

1m 5sCredits unavailable
Done
#84

Fix Low Attendance Alert review finding: Tablet sidebar navigation is clipped by its panel

0m 23s0 cr used
Done
#85

Fix Landing: Mobile navbar links overflow the viewport; see (, ).

3m 16sCredits unavailable
Done
#86

Create backend_modules diagram

0m 18sCredits in parent
Done
#87

Create er_diagram diagram

0m 17sCredits in parent
Done
#88

Create frontend_modules diagram

0m 17sCredits in parent
Done
#89

Create sequence diagram

0m 17sCredits in parent
Done
#90

Create service_network diagram

0m 17sCredits in parent
Done
#91

Role-based login, session enforcement and logout

120 cr estimated
To Do
#92

Attendance history table with roll number search and date/subject filters

80 cr estimated
To Do
#93

Low attendance alert with 75% threshold and positive empty state

80 cr estimated
To Do
#94

Teacher and subject management with assignment, edit and delete

100 cr estimated
To Do
#95

Mark attendance with atomic save and duplicate prevention

120 cr estimated
To Do
#96

Per-student attendance percentage table

80 cr estimated
To Do
#97

Student registration with search, edit, delete and validation

100 cr estimated
To Do
#98

Low attendance list of students below 75%

60 cr estimated
To Do
#99

Show attendance percentages and low-attendance warnings

100 cr estimated
To Do
#100

Admin dashboard totals with role-based sidebar navigation

100 cr estimated
To Do
#101

and print student-wise and subject-wise attendance reports

100 cr estimated
To Do
#102

Add, edit and delete student records with validation

100 cr estimated
To Do
#103

Mark attendance by class, subject and date with duplicate prevention

120 cr estimated
To Do
#104

Browse, search and filter attendance history

100 cr estimated
To Do
#105

Manage teachers, subjects, assignments and teacher login accounts

120 cr estimated
To Do
#106

Search the student table and edit student details

80 cr estimated
To Do
#107

Seed sample data and default admin via setup script

80 cr estimated
To Do
#108

Admin manages teachers, subjects and assignments

100 cr estimated
To Do
#109

Admin manages student records with search and duplicate checks

100 cr estimated
To Do
#110

Mark and save attendance with duplicate prevention

120 cr estimated
To Do
#111

Teacher attendance session with roster loading and duplicate guard

100 cr estimated
To Do
#112

student-wise and subject-wise attendance reports

100 cr estimated
To Do
#113

Admin dashboard totals, admin-only access and logout

100 cr estimated
To Do
#114

Username and password login with role-based routing

120 cr estimated
To Do
#115

Search and filter attendance history by roll number, date and subject

100 cr estimated
To Do
#116

Admin adds teachers, assigns subjects and edits teacher details

100 cr estimated
To Do
#117

Username and password login with role-based routing

100 cr estimated
To Do
#118

Role-based access to admin-only and shared attendance modules

100 cr estimated
To Do
#119

Admin institutional setup data and totals dashboard

100 cr estimated
To Do
#120

Attendance Reports: student-wise and subject-wise reports with print

100 cr estimated
To Do
#121

Admin Dashboard live totals, sidebar navigation and logout

100 cr estimated
To Do
#122

Student Registration: add, edit, delete and search student records

100 cr estimated
To Do
#123

Wire login, role routing, and logout to live sessions

120 cr estimated
To Do
#124

Make attendance history searchable and filterable

100 cr estimated
To Do
#125

Show live low-attendance warning and list

100 cr estimated
To Do
#126

Compute and display live attendance percentages

100 cr estimated
To Do
#127

Enable live attendance marking with duplicate protection

120 cr estimated
To Do
#128

Connect teacher and subject management to live records

120 cr estimated
To Do
#129

Create the Landing page with login call to action

80 cr estimated
To Do
#130

Fix Login Module: Mobile page has horizontal overflow: the layout is twice the viewport width, leaving the…

228m 15sCredits unavailable
AI In Progress
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

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