PROJECT FILE-
STUDENT RESULT &
GRADE
MANAGEMENT
SYSTEM
Name:Shlok Joshi
Class: 12-A(Science)
Subject: Computer Science (083)
Session: 2025-26
School:Dav Public School,Sector 8C,Chandigarh
1
CERTIFICAT
E
This is to certify that Shlok Joshi, a student of Class XII –
Non-Medical at DAV Public School, Sector 8-C,
Chandigarh, has successfully completed the Computer
Science Project File for the academic session 2025–
26, as prescribed by the Central Board of Secondary
Education (CBSE).
The practical file includes Python programs, MySQL
queries, and Python–MySQL connectivity programs as
per the CBSE curriculum and guidelines.
It is further certified that this work is the original work
of the student and has been duly checked and verified.
Internal Examiner : External Examiner :
PRINCIPAL:
2
3
ACKNOWLEDGEMENT
I express my deep sense of gratitude to my
Computer Science teacher, Ms. Sangita
Sardana, for her valuable guidance,
suggestions, and constant encouragement
during the development of this project.
I am thankful to our Principal, Mr. Mantoshpal
Singh, for providing all the necessary
resources and an excellent academic
atmosphere.
I also acknowledge the support of my parents
and classmates, whose motivation and
cooperation played a significant role in the
successful completion of this project.
4
INDEX
[Link]. TOPIC PAGE NO
1. Certificate 2.
2. Acknowledgement 3.
3. Index 4.
4. Introduction 5.
5. Python 7.
6. System Implementation 9.
7. Python Source Code 10.
8. MySQL DATABASE 18.
9. Outputs 23.
10. References 26.
11. Thank You 27.
4
INTRODUCTION
In the present digital era, technology has
become an integral part of the education
system. Educational institutions deal with a
large amount of student data such as
personal details, marks, grades, and results.
Managing this information manually through
registers and files is time-consuming, difficult
to maintain, and prone to errors. Therefore,
there is a need for a computerized system
that can manage student academic records
efficiently, accurately, and securely.
The Student Result & Grade Manager is
a Python-based application developed to
automate the process of storing and
managing student exam5 ination results. This
project uses Python programming along with
MySQL database connectivity to store student
details, calculate total marks and percentages,
assign grades, and display results in an organized
manner. The system reduces manual work,
minimizes calculation errors, and saves time
for teachers and administrators by providing
quick access to student performance data.
This project has been designed according to
the Class 12 Computer Science curriculum and
provides practical knowledge of Python–MySQL
connectivity and database management systems.
It helps students understand how programming
concepts can be applied to solve real-life problems
in the education sector. The Student Result &
Grade Manager is a simple, user-friendly, and
effective solution that demonstrates the
importance of automation and technology in
modern educational administration.
6
PYTHON
Python is a versatile and widely used
programming language with features that
make it a favorite among beginners and
professionals alike. Here’s why Python stands
out:
1. Simplicity and Readability:
Python’s clean syntax emphasizes
readability, making it easy to learn
and write.
Ideal for beginners, as the code structure
is intuitive and less complex than many
other languages.
2. Wide Range of Applications:
Used in web development, data
science, artificial intelligence, machine
learning,
7
automation, and game development.
Supports a variety of domains with
specialized libraries like Django,
NumPy, Pandas, and TensorFlow.
3. Flexibility in Programming Paradigms:
Allows procedural, object-oriented, and
functional programming, catering to
diverse problem-solving approaches.
4. Extensive Library and Community Support:
Comes with a robust standard
library, reducing the need to write
code from
scratch for many tasks. o Backed by a large
and active community, ensuring continuous
updates, resources, and troubleshooting
assistance.
5. Efficiency and Productivity:
Speeds up development with features
like dynamic typing and
8
automatic
memory
management.
SYSTEM
IMPLEMENTATION
Hardware Used:
➢ PC (Processor: Intel Pentium G3240,
RAM: 4.00 GB)
➢ Laptop
Software Used:
➢ Operating System: Microsoft Windows® 10
➢ Python IDLE (Latest Version)
➢ MySQL
➢ MySQL Connector for Python
➢ Web Browser
9
PYTHON
SOURCE CODE
10
11
12
import [Link] as
con
db = [Link](
host="localhost",
user="root",
password="Shlok302615",
database="student_result_system"
)
cursor = [Link]()
[Link]("""
CREATE TABLE IF NOT EXISTS student_result
(
roll_no INT PRIMARY
KEY,
name VARCHAR(30),
marks1 INT,
marks2 INT,
marks3 INT,
total
INT,
percentage FLOAT,
grade CHAR(2)
)
13
""")
def calculate_grade(p):
if p >= 90:
return 'A+'
elif p >= 75:
return 'A'
elif p >= 60:
return 'B'
elif p >= 45:
return 'C'
else:
return 'F'
def add_student():
print("\n******** ADD STUDENT DETAILS
********")
r = int(input("Enter Roll Number:
"))
n = input("Enter Name: ")
m1 = int(input("Enter Marks 1: "))
m2 = int(input("Enter Marks 2: "))
m3 = int(input("Enter Marks 3: "))
total = m1 + m2 + m3
per = total / 14
3
grade = calculate_grade(per)
[Link](
"INSERT INTO student_result VALUES (%s,%s,%s,%s,%s,%s,%s,%s)",
(r, n, m1, m2, m3, total, per,
grade)
)
[Link]()
print("Student record added successfully")
def view_result():
print("\n******** VIEW STUDENT RESULT
********")
r = int(input("Enter Roll Number:
"))
[Link]("SELECT * FROM student_result WHERE roll_no=
%s",
(r,))
data = [Link]()
if data:
print(data)
else:
print("Record not
found")
def delete_student():
print("\n******** DELETE STUDENT ********")
r = int(input("Enter Roll Number to15delete: "))
[Link]("DELETE FROM student_result WHERE
roll_no=%s", (r,))
[Link]()
print("Record deleted successfully")
while True:
print("\n" + "*"*65)
print("WELCOME TO STUDENT
MANAGEMENT".center(65))
print("*"*65)
print("1. Add student
details")
print("2. View student
result")
print("3. Delete student
details")
print("4. Exit")
choice = int(input("your choice: "))
if choice == 1:
add_student() 16
elif choice == 2:
view_result()
elif choice == 3:
delete_student()
elif choice == 4:
print("Thank you for using the
system")
break
else:
print("Invalid choice")
17
MYSQL
DATABASE
18
CREATING DATABASE
CREATING TABLE
19
INSERTING VALUES
STUDENTS DETAILS TABLE
ADD A NEW STUDENT
20
VIEWING STUDENT DETAILS
USING ADMISSION NUMBER
UPDATE STUDENT STREAM
UPDATE STUDENT CLASS
DELETE STUDENT BY ADMISSION
NUMBER
DELETE STUDENT BY NAME
21
FINAL TABLE DISPLAY
22
OUTPUTS
23
OUTPUT 1: MAIN MENU
OUTPUT 2: ADD STUDENT DETAILS
OUTPUT 3: VIEW STUDENT RESULT
24
OUTPUT 4: DELETE STUDENT
OUTPUT 5: EXIT
25
REFERENCES
1. NCERT Computer Science Textbook (Class
XII), Central Board of Secondary Education
(CBSE).
2. Python Software Foundation.
Python Documentation.
[Link]
3. Oracle Corporation. MySQL 8.0
Reference Manual.
[Link]
4. W3Schools. Python MySQL Tutorial.
[Link]
[Link]
5. GeeksforGeeks. Python Programming
and MySQL Connectivity.
[Link]
6. Class notes and guidance provided by
26
the Computer Science teacher.
27
THAN
K
YOU
28