ABSTRACT

In summer internship program, acquired the knowledge about the python programming with data
science. Understood how basic concepts like class, objects, inheritance, data abstraction, data
encapsulation were implemented.
Student
is helpfulData
for students
Management
as well
System
as theisschool
a software Student Management System is software which
A Student Management System is an environment that manages all the data of the students, which
is helpful for students as well as the school authorities. It mainly deals with various activities
related to the student.

It reduces the manual effort of data entry by automatically transferring data from one entry to
another. It simplifies administrative processes and promotes digital management.

1
 SUPERVISOR EVALUATION OF INTERN

Student Name: APARNA SASIDHARAN

Work Supervisor: SABARINATHAN M

Title: PYTHON WITH DATA SCIENCE

Company/Organization: GATEWAY SOFTWARE SOLUTION

Internship Address:
HEAD OFFICE ADDRESS
No.138, First Floor,
9th Street, Opp to Lakshmi Complex, Gandhipuram-641012, Tamil Nadu, India.

Dates of Internship: From 8.06.2023 To 23.06.2023

2
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-1 DATE 08.06.2023

Time of
Time of arrival 5:00 PM 07:00 PM Remarks
Departure

CS WITH DATA Name of finished KNOWLEDGE ABOUT

Dept./Division
ANALYTICS Product PYTHON

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

 PYTHON PROGRAMMING
 IDE SETUP
Main points of the day  OVERVIEW CAPABILITIES OF PYTHON

3
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-2 DATE 09.06.2023

Time of
Time of arrival 5:00PM 7:00PM Remarks
Departure

CS WITH DATA Name of finished

Dept./Division PYTHON BASICS
ANALYTICS Product

Name of HOD/
Supervisor SABARINATHAN M
With e-mail id sabari@gatewaysoftwaresolutions.com -

PYTHON BASICS
 VARIABLES
 LOOPS AND FUNCTONS
Main points of the
day  DATA STRUCTURES
 DATA IMPORT AND
EXPORT(CSV,EXCEL)
 DATABASE
CONNECTIVITY(SQL)

4
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-3 DATE 10.06.2023

Time of
Time of arrival 05:00 PM 07:00 PM Remarks
Departure

Name of
CS WITH DATA
Dept./Division finished FUNCTIONAL PROGRAMMING
ANALYTICS
Product

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

FUNCTIONAL PROGRAMMING IN PYTHON

Main points of
the day

5
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-4 DATE 11.06.2023

Time of
Time of arrival 05:00 PM 07:00 PM Remarks
Departure

Name of
CS WITH DATA OOPs CONCEPT IN PYTHON
Dept./Division finished
ANALYTICS
Product

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

OBJECT ORIENTED PROGRAMMING IN PYTHON

Main points of
the day

6
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-5 DATE 12.06.2023

Time of
Time of arrival 05:00 PM 07:00 PM Remarks
Departure

CS WITH Name of
INTRODUCTION TO NumPy
Dept./Division DATA finished
AND PANDAS
ANALYTICS Product

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

NumPy, PANDAS

Main points of
the day

7
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-6 DATE 13.06.2023

Time of
Time of arrival 05:00 PM 07:00 PM Remarks
Departure

Name of
CS WITH DATA STATISTICAL
Dept./Division finished
ANALYTICS PROGRAMMING
Product

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

STATISTICAL PROGRAMMING

Main points of
the day

8
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-7 DATE 15.06.2023

Time of
Time of arrival 05:00 PM 07:00 PM Remarks
Departure

Name of
CS WITH DATA
Dept./Division finished DATA IMPORT
ANALYTICS
Product

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

DATA IMPORT
Main points of
the day

9
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-8 DATE 16.06.2023

Time of Time of 07:00

05:00 PM Remarks
arrival Departure PM

Name of NATURAL
Dept./Division CS WITH DATA ANALYTICS finished LANGUAGE
Product PROCESSING

Name of HOD/
Supervisor
SABARINATHAN M
With e-mail
sabari@gatewaysoftwaresolutions.com
id

NATURAL LANGUAGE
PROCESSING

Main points of
the day

10
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-9 DATE 17.06.2023

Time of
Time of arrival 05:00 PM 07:00 PM Remarks
Departure

Name of
CS WITH DATA
Dept./Division finished MACHINE LEARNING
ANALYTICS
Product

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

Main points of INTRODUCTION TO MACHINE LEARNING

the day

11
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-10 DATE 18.06.2023

Time of
Time of arrival 05:00 PM 07:00 PM Remarks
Departure

Name of DATA VISUALIZATION

CS WITH DATA
Dept./Division finished  MATPLOTLIB
ANALYTICS
Product

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

Main points of
the day INTRODUCTION TO DATA VISUALIZATION

12
 STUDENT’S DAILY DIARY/ DAILY LOG

DAY-11 DATE 22.06.2023

Time of
Time of arrival 05:00 PM 07:00 PM Remarks
Departure

Name of
CS WITH DATA
Dept./Division finished SQL BASICS
ANALYTICS
Product

Name of HOD/
Supervisor
SABARINATHAN M sabari@gatewaysoftwaresolutions.com
With e-mail id

INTRODUCTION TO SQL
Main points of
the day

13
DESCRIPTION OF THE COMPANY

Gateway software solutions is service based software Development Company mainly focusing on
business consulting, software engineering, information technology, training (academic and
corporate level) and consultancy.
Our areas of expertise in development include ERP, CRP, HRM, POS, Website Development and
Web Hosting.

Our areas of expertise in training include JAVA, J2EE, DOTNET, PHP, PYTHON, TESTING,
AI, ML, CYBER SECURITY, CLOUD COMPUTING and so on. A team of technical expertise
will be managing the training with regularly updated syllabus. Pre employment program
(Internship) is provided throughout the year for the upcoming graduates for more exposure
towards the industry.

14
PROJECT TITLE: Student Data Management System using CSV files

INTRODUCTION

The Student Database Management System With CSV is a desktop application coded in
a Python programming language. The project contains basic function that help us to manage
student information more

conveniently. This project is created to safely store the student’s record. This eventually helps you
to the monitor total students. This Student Database Management System With CSV is a simple
project that can benefit student who are studying IT related courses. It is helpful for them if they
are looking a project that related to Management System.

BASIC INFORMATION

Language used: Python

Coding Tool used: Built-in Python IDLE

Type: Desktop Application

Database used: CSV

FEATURES

 Add New Student

 Display Student Record
 Can Update Existing Student Record
 Can Search Current Student Record
 Can Delete Current Student Record

15
CODING
import os
import csv
def addrecord():
print("Add a new Record")
print("================")
f=open('students.csv','a',newline='\r\n')
s=csv.writer(f)
rollno=int(input('Enter rollno='))
name=input('Enter name=')
marks=float(input('Enter marks='))
rec=[rollno,name,marks]
s.writerow(rec)
f.close()
print("Record Saved")
input("Press any key to continue..")

def modifyrecord():
print("Modify a Record")
print("================")
f=open('students.csv','r',newline='\r\n')
f1=open('temp.csv','w',newline='\r\n')
f1=open('temp.csv','a',newline='\r\n')
r=input('Enter rollno you want to modify')
s=csv.reader(f)
s1=csv.writer(f1)
for rec in s:
if rec[0]==r:
print("Rollno=",rec[0])
print("Name=",rec[1])
print("Marks=",rec[2])
choice=input("Do you want to modify this record(y/n)")
if choice=='y' or choice=='Y':

16
 rollno=int(input('Enter New rollno='))
name=input('Enter new name=')
marks=float(input('Enter new marks='))
rec=[rollno,name,marks]
s1.writerow(rec)
print("Record Modified")
else:
s1.writerow(rec)
else:
s1.writerow(rec)
f.close()
f1.close()
os.remove("students.csv")
os.rename("temp.csv","students.csv")

input("Press any key to continue..")

def deleterecord():
f=open('students.csv','r',newline='\r\n')
f1=open('temp.csv','w',newline='\r\n')
f1=open('temp.csv','a',newline='\r\n')
r=input('Enter rollno you want to delete')
s=csv.reader(f)
s1=csv.writer(f1)
for rec in s:
if rec[0]==r:
print("Rollno=",rec[0])
print("Name=",rec[1])
print("Marks=",rec[2])
choice=input("Do you want to delete this record(y/n)")
if choice=='y' or choice=='Y':
pass
print("Record Deleted")

17
 else:
s1.writerow(rec)
else:
s1.writerow(rec)
f.close()
f1.close()
os.remove("students.csv")
os.rename("temp.csv","students.csv")

input("Press any key to continue..")

def search():
print("Search a Record")
print("===================")
f=open('students.csv','r',newline='\r\n') #Remove new line character from output
r=input('Enter rollno you want to search')
s=csv.reader(f)
for rec in s:
if rec[0]==r:
print("Rollno=",rec[0])
print("Name=",rec[1])
print("Marks=",rec[2])
f.close()
input("Press any key to continue..")
def viewall():
print("List of All Records")
print("===================")
f=open('students.csv','r',newline='\r\n') #Remove new line character from output
s=csv.reader(f)
i=1
for rec in s:
print(rec[0],end="\t\t")
print(rec[1],end="\t\t")

18
 print(rec[2])
i+=1
f.close()
input("Press any key to continue..")

def mainmenu():
choice=0
while choice!=6:
print("\n")
print("Main Menu")
print("==========")
print("1. Add a new Record")
print("2. Modify Existing Record")
print("3. Delete Existing Record")
print("4. Search a Record")
print("5. List all Records")
print("6.Exit")
choice=int(input('Enter your choice'))
if choice==1:
addrecord()
elif choice==2:
modifyrecord()
elif choice==3:
deleterecord()
elif choice==4:
search()
elif choice==5:
viewall()
elif choice==6:
print("Software Terminated")
break;
mainmenu()

19
OUTPUT:

Main Menu

==========

1. Add a new Record

2. Modify Existing Record

3. Delete Existing Record

4. Search a Record

5. List all Records

6.Exit

Enter your choice1

Add a new Record

================

Enter rollno=10

Enter name=priyesh

Enter marks=60

Record Saved

Press any key to continue..

Main Menu

20
==========

1. Add a new Record

2. Modify Existing Record

3. Delete Existing Record

4. Search a Record

5. List all Records

6.Exit

Enter your choice5

List of All Records

===================

Rollno Name marks (500)

1 APARNA 450

2 ARCHANA 340

3 SUNITA 470

4 OM 490

5 JAY 356

6 SAKSHI 444

7 NEHA 345

8 PANKAG 456

9 ARUN 467

10 ASHOK 478

21
10 PRIYESH 470

Press any key to continue..

Main Menu

==========

1. Add a new Record

2. Modify Existing Record

3. Delete Existing Record

4. Search a Record

5. List all Records

6.Exit

Enter your choice 2

Modify a Record

================

Enter rollno you want to modify 3

Press any key to continue.

Main Menu

==========

1. Add a new Record

2. Modify Existing Record

3. Delete Existing Record

22
4. Search a Record

5. List all Records

6.Exit

Enter your choice4

Search a Record

===================

Enter rollno you want to search7

Rollno= 7

Name= NEHA

Marks= 345

Press any key to continue..

Main Menu

==========

1. Add a new Record

2. Modify Existing Record

3. Delete Existing Record

4. Search a Record

5. List all Records

6.Exit

23
Enter your choice6

Software Terminated

24
 CONCLUSION:

Student Management System can be used by educational institutions to maintain their student
records easily. Achieving this objective is difficult using the manual system as the information is
scattered, can be redundant, and collecting relevant information may be very time-consuming. All
these problems are solved by this project.

This system helps in maintaining the information of pupils of the organization. It can be easily
accessed by the manager and kept safe for a long period of time without any changes.

REFERENCE BOOKS:

1. Jake vanderplas, Python Data Science Handbook – Essential tools for working with Data,
O’ReilyMedia, Inc, 2016.
2. Zhung.Y, An Introduction to python and computer programming, Springer publications
2016.

REFERENCE WEBSITES:

1. http://www.w3schools.com/python/
2. http://www.javatpoint.com/python-tutorial

25