COMPUTER SCIENCE PROJECT

INDEX

S. No. Content

1 Acknowledgement

2 Certificate

3 Introduction about Topic

4 Introduction about Python

5 Introduction about MySQL

6 Hardware & Software Requirements

7 Coding

8 Database Tables

9 Output Screen

10 Future Scope

11 Bibliography

Topic: Student Academic Management System based on NEP 2020

1. Acknowledgement

I would like to express my sincere gratitude to my Computer Science teacher Mrs. Achi Sharma for her
valuable guidance, encouragement, and continuous support throughout the development of this project.
Her clear explanations and motivation helped me understand the concepts of Python programming and
database management using MySQL in a practical manner.

I am also thankful to the Principal and management of Blue Bells Public School, Jhansi, for providing the
necessary infrastructure, computer lab facilities, and academic environment required to successfully
complete this project. I would like to thank my parents for their constant moral support and
encouragement, which motivated me to complete this work on time.

Lastly, I thank my friends and classmates for their cooperation, suggestions, and help whenever required.
This project has helped me enhance my practical knowledge and confidence in Computer Science.

1
2. Certificate

This is to certify that Brahmdutt Mishra, a student of Class XII, Blue Bells Public School, Jhansi, has
successfully completed the Computer Science project titled "Student Academic Management System
based on NEP 2020" using Python and MySQL during the academic year 2025–26, under the guidance of
Mrs. Achi Sharma.

This project is an original piece of work carried out by the student and has not been copied from any
source. The project fulfills the practical requirements prescribed by the CBSE curriculum for Class XII
Computer Science. We wish him success in his future academic endeavors.

3. Introduction about Topic

The Student Academic Management System is a computer-based application developed to store, manage,
and process student academic records efficiently. With the increasing number of students and courses,
manual record-keeping becomes difficult and time-consuming. This project provides a digital solution to
manage academic data accurately and securely.

The project is based on the principles of the New Education Policy (NEP) 2020, which emphasizes
flexibility, skill-based education, multiple entry and exit options, and a credit-based system. Using this
system, students can earn credits for different courses, and their academic progress can be tracked through
the Academic Bank of Credits (ABC) concept.

Python is used as the front-end programming language to create a menu-driven interface, while MySQL is
used as the back-end database to store student details, course information, enrollment records, marks,
grades, and credits.

4. Introduction about Python

Python is a high-level, interpreted, and object-oriented programming language known for its simplicity and
readability. It is widely used in fields such as software development, data science, artificial intelligence, web
development, and database management.

One of the main advantages of Python is its easy syntax, which makes it suitable for beginners as well as
professionals. Python provides various libraries and modules that simplify complex tasks. In this project,
Python is used to connect with the MySQL database, accept user input, perform calculations, assign grades,
and display results.

Python also supports file handling, which is used in this project to export academic records into a CSV file.
Thus, Python plays a crucial role in implementing the logic of the Student Academic Management System.

2
5. Introduction about MySQL

MySQL is an open-source Relational Database Management System (RDBMS) that uses Structured Query
Language (SQL) to manage data. It stores data in the form of tables consisting of rows and columns,
making data storage systematic and efficient.

In this project, MySQL is used to create and manage the database college_nep, which stores student
information, course details, and enrollment records. Relationships between tables are established using
primary keys and foreign keys to maintain data integrity.

MySQL ensures fast data retrieval, security, and reliability. It is widely used in real-world applications such as
school management systems, banking systems, and e-commerce platforms.

6. Hardware & Software Requirements

Hardware Requirements: - Computer or Laptop - Minimum 4 GB RAM - Intel/AMD Processor - Keyboard

and Mouse - Internet Connection (optional)

Software Requirements: - Operating System: Windows / Linux - Python 3.x - MySQL Server - MySQL
Connector for Python - Python IDE (IDLE / VS Code)

These requirements ensure smooth execution of the Python program and proper database connectivity.

7. Coding

The project is developed using Python and SQL. Below is the complete SQL and Python code used in the
project.

SQL Code (Database Creation and Tables):

CREATE DATABASE college_nep;

USE college_nep;

CREATE TABLE students (

student_id INT PRIMARY KEY,
name VARCHAR(50),
semester INT
);

CREATE TABLE courses (

course_id INT PRIMARY KEY,
course_name VARCHAR(50),
course_type VARCHAR(20),
credits INT

3
 );

CREATE TABLE enrollment (

student_id INT,
course_id INT,
marks INT,
grade VARCHAR(2),
FOREIGN KEY (student_id) REFERENCES students(student_id),
FOREIGN KEY (course_id) REFERENCES courses(course_id)
);

Python Code:

import [Link]
import csv

conn = [Link](
host="localhost",
user="root",
password="your_password",
database="college_nep"
)

cursor = [Link]()

def add_student():
sid = int(input("Student ID: "))
name = input("Name: ")
sem = int(input("Semester: "))
[Link]("INSERT INTO students VALUES (%s,%s,%s)", (sid, name, sem))
[Link]()

def add_course():
cid = int(input("Course ID: "))
cname = input("Course Name: ")
ctype = input("Type (Core/Skill/Elective): ")
credits = int(input("Credits: "))
[Link]("INSERT INTO courses VALUES (%s,%s,%s,%s)", (cid, cname,
ctype, credits))
[Link]()

def enroll_student():
sid = int(input("Student ID: "))
cid = int(input("Course ID: "))
marks = int(input("Marks: "))

4
 if marks >= 90:
grade = 'A+'
elif marks >= 75:
grade = 'A'
elif marks >= 60:
grade = 'B'
elif marks >= 45:
grade = 'C'
else:
grade = 'F'

[Link]("INSERT INTO enrollment VALUES (%s,%s,%s,%s)", (sid, cid,

marks, grade))
[Link]()

def calculate_credits():
sid = int(input("Student ID: "))
[Link]("SELECT SUM([Link]) FROM enrollment e JOIN courses c ON
e.course_id=c.course_id WHERE e.student_id=%s AND [Link]!='F'", (sid,))
total = [Link]()[0]
print("Total Credits Earned:", total)

def export_record():
[Link]("SELECT s.student_id, [Link], c.course_name, [Link], [Link]
FROM students s JOIN enrollment e ON s.student_id=e.student_id JOIN courses c ON
e.course_id=c.course_id")
rows = [Link]()
with open("academic_record.csv", "w", newline="") as f:
writer = [Link](f)
[Link](["ID","Name","Course","Marks","Grade"])
[Link](rows)

while True:
print("[Link] Student [Link] Course [Link] Student [Link] Credits
[Link] Record [Link]")
ch = input("Enter Choice: ")
if ch == '1': add_student()
elif ch == '2': add_course()
elif ch == '3': enroll_student()
elif ch == '4': calculate_credits()
elif ch == '5': export_record()
elif ch == '6': break

[Link]()

5
8. Database Tables

The project uses three main database tables. The structure and sample output of each table are shown
below.

1. Students Table Output:

+------------+--------------+----------+
| student_id | name | semester |
+------------+--------------+----------+
| 101 | Rahul Sharma | 1 |
| 102 | Ankit Verma | 2 |
+------------+--------------+----------+

2. Courses Table Output:

+-----------+----------------+-------------+---------+
| course_id | course_name | course_type | credits |
+-----------+----------------+-------------+---------+
| 201 | Python | Core | 4 |
| 202 | Data Analysis | Skill | 3 |
+-----------+----------------+-------------+---------+

3. Enrollment Table Output:

+------------+-----------+-------+-------+
| student_id | course_id | marks | grade |
+------------+-----------+-------+-------+
| 101 | 201 | 85 | A |
| 102 | 202 | 72 | B |
+------------+-----------+-------+-------+

These tables are connected using foreign keys and follow the NEP 2020 credit-based system.

9. Output Screen

The following are sample outputs generated after executing the Python program.

Output 1: Main Menu Display

6
 [Link] Student
[Link] Course
[Link] Student
[Link] Credits
[Link] Record
[Link]

Output 2: Adding a Student

Student ID: 101

Name: Rahul Sharma
Semester: 1
Student Added Successfully

Output 3: Adding a Course

Course ID: 201

Course Name: Python
Type: Core
Credits: 4
Course Added Successfully

Output 4: Credit Calculation (ABC Concept)

Student ID: 101

Total Credits Earned: 4

Output 5: Export Academic Record

Academic Record Exported

File saved as academic_record.csv

These outputs confirm the correct working of the program functions.

7
10. Future Scope

This project can be enhanced by: - Adding a graphical user interface (GUI) - Including login authentication -
Generating report cards automatically - Integrating with web applications - Implementing full Academic
Bank of Credits (ABC) system

11. Bibliography

• NCERT Computer Science Textbook (Class XII)

• [Link]
• [Link]
• CBSE Academic Curriculum

Submitted by:
Name: Brahmdutt Mishra
Class: XII
School: Blue Bells Public School, Jhansi