Student Performance Analytics
STUDENT REGISTER NUMBER : 221030491
STUDENT NAME :Sunil Kumar G S
ABSTRACT
• Analyzes studentt performance using data-driven techniques.
• Helps identify strengths, weaknesses, and trends.
• Aims to improve academic performance through actionable insights.
ABOUT THE PROJECT
• Monitors and evaluates student performance across subjects.
• Provides graphical representation using Power BI for better
understanding.
• Generates reports for teachers, students, and management.
EXISTING SYSTEM
• Manual evaluation using marks sheets and reports.
• Difficult to track trends and analyze performance efficiently.
• Time-consuming and prone to errors.
PROPOSED SYSTEM
• Automated system using Python for data processing.
• Interactive dashboards in Power BI for visualization.
• Quick generation of performance reports and analysis.
SOFTWARE AND HARDWARE REQUIREMENTS
• Hardware: Standard PC / Laptop with internet access.
• Software: Python, Power BI, Excel.
• Data: Student marks, attendance, and other academic records.
ER DIAGRAM / ARCHITECTURE DESIGN
• Input: Student data (marks, attendance, assignments)
• Processing: Python scripts to clean and analyze data
• Output: Power BI dashboards, Excel reports
• Users: Teachers, Students, Management
TABLE DESIGN
Sl No Table Name Fields Description
1 Students ID, Name, Class, Stores student details
Section
2 Marks Student ID, Subject, Stores marks for each subject
Marks
3 Attendance Student ID, Date, Tracks daily attendance
Status
4 Reports Report ID, Student ID, Stores generated reports
Summary
MODULE DESCRIPTION
1. Data Collection: Gather student marks and attendance.
2. Data Pr-processing : Clean and structure data for analysis.
3. Analysis Module: Calculate averages, trends, and statistics.
4. Visualization Module: Create dashboards using Power BI.
5. Report Generation: Generate Excel/PDF reports for stakeholders.
SYSTEM TESTING
• Test data imported and processed correctly.
• Dashboards display accurate results.
• Reports generated match original data.
• Errors handled efficiently.
REPORTS
• Student-wise performance report.
• Class-wise performance trends.
• Subject-wise analysis for improvement.
• Attendance vs. performance correlation report.
CONCLUSION
• System improves efficiency and accuracy of student performance analysis.
• Provides insights for students, teachers, and management.
• Helps in taking informed decisions for academic improvement.
FUTURE ENHANCEMENT
• Include predictive analytics for performance forecasting.
• Integrate with college ERP system for real-time updates.
• Mobile app dashboard for students and parents.
REFERENCES
• Python Official Documentation
• Power BI Guides & Tutorials
• College Academic Records & Reports