Collage StudentManagement system
BACSE101 Problem Solving using Python
PROJECT REPORT
on
Collage Student
Management system
Prepared by
Nithin Balaji Bharath - 23BCE23
Srivathsan.K.S - 23BCE2363
Sourish.K - 23BCE2353
Under the supervision of
GOWTHAM.M
School of Computer Science and Engineering
Vellore Institute of Technology, Vellore.
October 26, 2025
1
Collage StudentManagement system
Table of Contents
Abstract
1. Introduction
2. Problem Statement and Objectives
3. Implementation Code
4. Demo Screenshots
5. Conclusion
2
Collage StudentManagement system
Abstract
The Student Management System is a robust, Python-based application
integrated with a MySQL relational database, developed to efficiently manage and
maintain academic records of college students. This system is designed to
facilitate administrators, faculty members, and educational institutions in storing,
updating, and analyzing student information in a centralized and organized
manner, eliminating the inefficiencies associated with manual record-keeping.
The system manages essential student data such as personal information,
semester marks, attendance percentages, cumulative GPA (CGPA), weighted
CGPA, and grades. It supports both manual data entry and bulk import of records
via CSV files, making it suitable for large-scale data management. The system
automatically computes CGPA, weighted CGPA, and assigns grades based on
predefined academic criteria, ensuring accuracy, consistency, and fairness in
academic evaluation.
Advanced functionalities of the system include identifying top performers in each
subject, issuing low attendance warnings, and performing statistical analysis and
visualization of academic performance. Interactive visualizations such as CGPA
distribution histograms, attendance bar charts, and top performer charts provide
administrators with a clear and immediate understanding of students’ overall
performance trends.
This project emphasizes the integration of Python programming, MySQL database
management, and data visualization tools to create a user-friendly and
interactive application. It demonstrates practical applications of database
operations such as insertion, deletion, updating, and querying while maintaining
data integrity and security through relational constraints. The system is scalable,
adaptable, and can be extended to include additional academic parameters or
modules, making it a comprehensive solution for educational institutions seeking
to modernize their student record management process.
By combining automation, analytics, and visualization, the system not only
reduces administrative workload but also provides insights to enhance academic
planning, performance monitoring, and decision-making within the institution.
3
Collage StudentManagement system
[Link]
1.1 Domain Information:
1.2 Software Libraries Used:
[Link]
SQLAlchemy
Pandas
Matplotlib
Python Standard Libraries
1.3 Contributions by Team Members:
Nithin Balaji Bharath :- Function creation
Srivathsan.K.S :- mysql,python code,editing
Sourish.K:-mysql,python code,editing
1.4 Challenges Faced:
4
Collage StudentManagement system
[Link] Statement
Educational institutions, such as colleges and universities, often face challenges
in efficiently managing and maintaining student academic records, including
personal details, semester marks, attendance, and overall performance.
Traditional manual record-keeping is time-consuming, prone to errors, and
difficult to analyze, especially when dealing with a large number of students.
The goal of this project is to develop a Student Management System that
automates the process of storing, updating, and retrieving student information
using Python and MySQL. The system should be able to:
1. Maintain student personal details, semester marks, attendance
percentage, CGPA, weighted CGPA, and grades.
2. Allow manual entry as well as bulk import of student records from CSV
files.
3. Automatically compute CGPA, weighted CGPA, and assign grades based on
marks.
4. Identify top performers in each subject and track students with low
attendance.
5. Provide data visualization tools for administrators, such as CGPA
distribution, attendance analysis, and top-performing students.
6. Ensure data integrity, consistency, and secure management of student
records using a relational database.
This project addresses the problem of inefficient academic record management
by providing a centralized, automated, and user-friendly system that supports
data-driven decision-making and reduces administrative workload while
improving accuracy and accessibility of student performance data
5
Collage StudentManagement system
Objectives of the Project
The main objective of the Python-MySQL Student Management System is to
provide an efficient, reliable, and automated platform for managing student
academic records. The specific objectives include:
1. Centralized Student Data Management:
o To maintain all student-related information, including personal
details, semester marks, attendance percentage, CGPA, weighted
CGPA, and grades, in a single database for easy access and
management.
2. Automation of Academic Calculations:
o To automatically compute CGPA, weighted CGPA, and assign grades
based on marks, eliminating manual calculations and reducing
errors.
3. Bulk Data Handling:
o To support the import of student records and marks from CSV files,
enabling easy management of large datasets and saving time.
4. Performance Analysis:
o To identify top performers in each subject and provide low
attendance warnings, helping administrators take necessary
academic actions.
5. Data Visualization:
o To generate graphical representations such as histograms and bar
charts for CGPA distribution, attendance analysis, and top-
performing students, providing insightful, visual understanding of
student performance.
6. Ease of Updates and Maintenance:
o To allow administrators to update student information and marks
conveniently while maintaining data integrity using a relational
database.
7. Secure and Reliable Database Management:
o To ensure secure, consistent, and accurate storage of student
records using MySQL with relational constraints and proper
transaction handling.
8. User-Friendly Interface:
o To create an interactive menu-driven system that is easy to use for
administrators, requiring minimal technical knowledge.
6
Collage StudentManagement system
[Link]
3.1Add Student (with Marks):
3.2 View All Students:
3.3 Update Marks:
3.4 Delete Student:
3.5 Update Student Info:
3.6 View Student by ID:
3.7 Low Attendance Warning:
3.8 Top 3 Performers in Each Subject:
3.9 Plot CGPA Distribution:
3.10 Plot Attendance Analysis:
3.11 Plot Top 3 Performers:
7
Collage StudentManagement system
4. Demo Screenshots
8
Collage StudentManagement system
5. Conclusion
The Python-MySQL Student Management System successfully addresses the
challenges associated with manual record-keeping in educational institutions by
providing a centralized, automated, and user-friendly platform for managing
student academic data. The system enables efficient storage, retrieval, and
updating of student information, including personal details, semester marks,
attendance, CGPA, weighted CGPA, and grades.
Through automation of calculations, such as CGPA and grade assignment, the
system reduces human error and ensures accurate academic evaluation. The
inclusion of bulk import via CSV and real-time updates makes it scalable for
institutions with a large number of students. Advanced functionalities, such as
identifying top performers, issuing low attendance warnings, and generating
visual data analysis through charts and graphs, provide administrators with
actionable insights for decision-making and academic planning.
By integrating Python programming, MySQL database management, and data
visualization tools, the project demonstrates the practical application of modern
technologies in educational administration. The system not only enhances
operational efficiency but also ensures data integrity, security, and accessibility.
In conclusion, this project is a comprehensive solution for academic record
management, combining automation, analytics, and visualization. It is highly
adaptable, scalable, and can be further extended to include additional academic
modules, making it a valuable tool for educational institutions striving for digital
transformation and data-driven administration.