jolly-idea

byPunya Shree

PRD: Smart Faculty Assistant & Student Management System 1. Project Overview Product Name EduTrack Pro Product Type Faculty Management and Student Monitoring Web Application Purpose A centralized platform that helps faculty members manage: Attendance Assignment tracking Google Classroom monitoring Student performance tracking Attendance shortage alerts Automated email notifications CIE & SEE marks management Excel report generation The system should reduce manual work and automate repetitive academic tasks. 2. User Roles Faculty/Admin Can: Create Courses Create Sections Add Students Record Attendance Upload Assignment Information View Analytics Download Excel Reports Send Notifications Enter CIE & SEE Marks Student Can: View Attendance View Attendance Percentage View Assignments Receive Email Alerts Receive Attendance Warning Emails View Marks 3. Academic Structure Courses B.Tech Sections: A B C D E F G H I B.Sc Sections: A B BCA Sections: A B 4. Student Database Each student record should contain: Field Description Student Name Full Name USN Unique Student Number Email College Email Phone Number Optional Course B.Tech/B.Sc/BCA Section A-I Semester Current Semester Admission Year Year Status Active/Inactive 5. Attendance Management Module Attendance Entry Faculty selects: Course Section Date Daily Sessions For each date: Session 1 Options: Present Absent Medical Leave Session 2 Options: Present Absent Medical Leave Session 3 Options: Present Absent Medical Leave Example Date S1 S2 S3 12/06/26 P A P 6. Attendance Analytics Automatically calculate: Total Classes Total Present Total Absent Medical Leave Count Attendance % Formula: Attendance % = (Present Sessions ÷ Total Sessions) × 100 7. Attendance Shortage Detection At course completion: System automatically identifies students below: 75% Yellow Warning 65% Orange Warning 50% Red Warning Below 50% Critical Warning 8. Automated Attendance Emails Trigger When attendance drops below: 50% Email Schedule If attendance remains below 50%: Day 1 Warning Email Day 2 Reminder Email Day 5 Parent/Guardian Copy (optional) Sample Email Subject: Attendance Shortage Alert Dear Student, Your attendance has fallen below 50%. Current Attendance: 48% Please attend classes regularly to avoid detention. Regards, Faculty Department 9. Assignment Tracking Module Faculty creates assignment. Fields: Assignment Name Subject Deadline Google Classroom Link System checks: By Student Name Uploaded / Not Uploaded By USN Uploaded / Not Uploaded Dashboard: Student USN Status Ravi 001 Uploaded Kiran 002 Missing 10. Assignment Notification System When new assignment is uploaded: Automatic Email Sent To: Entire Section Entire Course Selected Students Email contains: Assignment Name Due Date Classroom Link 11. Google Classroom Integration Connect Google Classroom API. System checks: Assignment Uploaded Yes / No Video Uploaded Yes / No Submission Status Completed / Pending Missing Assignments Generate report automatically. 12. Marks Management Module Based on the reference Excel sheet. CIE 1 (20 Marks) a b c Total Auto Total: a+b+c CIE 2 (25 Marks) Part A Q1 Q2 Q3 Q4 Q5 1 mark each Part B Q1 Q2 Q3 Q4 5 marks each Auto Total: Part A + Part B CIE 3 (25 Marks) d e f Total Auto Calculation SEE (30 Marks) SEE Grand Total Formula: CIE1 + CIE2 + CIE3 + SEE Maximum: 100 Marks 13. Attendance Sheet Layout Exactly similar to your uploaded Excel format. Columns: Student Name USN Course Section Date 1 S1 S2 S3 Date 2 S1 S2 S3 Date 3 S1 S2 S3 ... Attendance % CIE1 CIE2 CIE3 SEE Grand Total 14. Excel Export Download anytime as: Excel (.xlsx) CSV PDF Export contains: Attendance Marks Assignment Status Attendance Percentage 15. Dashboard Faculty Dashboard Cards: Total Students Present Today Absent Today Medical Leaves Students Below 50% Pending Assignments Uploaded Videos Charts: Attendance Trend Assignment Completion % Marks Distribution Course-wise Analytics 16. Student Dashboard Shows: Attendance % Assignment Status CIE Marks SEE Marks Grand Total Notifications 17. Search & Filter Search by: Student Name USN Course Section Filters: Attendance Below 50% Missing Assignments Low Marks Medical Leave 18. Technology Stack Frontend React.js Tailwind CSS Material UI Backend Node.js Express.js Database PostgreSQL Authentication Google Login College Email Login Email Service EmailJS Gmail SMTP SendGrid APIs Google Classroom API Google Sheets API Google Drive API 19. Future AI Features AI Attendance Predictor Predict future shortage. AI Marks Predictor Predict SEE performance. AI Assignment Reminder Automatically remind weak students. AI Faculty Assistant Ask: "Show students below 50% attendance in B.Tech Section C" and get results instantly.