Shreyash Tiwari Projectclass12-C

Name : Shreyash Tiwari
ROLL NO : 26
CLASS : XII - C
Subject : Computer science (083)
SCHOOL : The Lucknow Public Collegiate
SESSION : 2022 -23

Table of contents
• Lab Certificate
• Acknowledgement
• Introduction
• Objectives of the project
• Proposed system
• System Development Life Cycle (SDLC)
• Phases of System Development Life Cycle
• Hardware And Software requirement
• Description of the project
• Functions& methods and their objectives
• Code
• Output
• Bibliography
CERTIFICATE
This is to certify that Shreyash Tiwari of class 12th has

completed this project titled “Teacher’s Helper” under
my guidance and this project may be considered as the
part of the Practical exam of AISSCE conducted by
CBSE.
Subject teacher:
Mrs. Santwana Srivastava
External Examiner:
_______________________
ACKNOWLEDGEMENT
Apart from the efforts of me, the success of any project depends largely on the
encouragement and guidelines of many others. I take this opportunity to express my
gratitude to the people who have been instrumental in the successful completion of
this project.
I express deep sense of gratitude to almighty God for giving me strength for the
successful completion of the project.
I express my heartfelt gratitude to my parents for constant encouragement while
carrying out this project.
I express my deep sense of gratitude to the luminary The Principal, Dr Jawaid
Alam Khan who has been continuously motivating and extending their helping hand
to us.
My sincere thanks to Ms Santwana Srivastava, Master In-charge, A guide,
Mentor, who critically reviewed my project and helped in solving each and every
problem, occurred during implementation of the project
The guidance and support received from all the members who contributed and
who are contributing to this project, was vital for the success of the project. I am
grateful for their constant support and help.
Shreyash Tiwari
Teacher’s Helper
Introduction
The “Teacher’s Helper” is basically a database project done with
help of python language. This project is very useful to Add
student data , Display student Data, Update Students data, Add
student’s marks details, Generate Student/Students Report Card.\
OBJECTIVES OF THE PROJECT
The objective of this project is to let the students apply the

programming knowledge into a real- world situation/problem and
exposed the students how programming skills helps in developing
a good software.
• Write programs utilizing modern software tools.
• Write effective procedural code to solve small to medium sized
problems.
• Students will demonstrate a breadth of knowledge in computer
science, as exemplified in the areas of systems, theory and
software development.
• Students will demonstrate ability to conduct research or applied
Computer Science project, requiring writing and presentation
skills which exemplify scholarly style in computer science.
PROPOSED SYSTEM
Software helps in making the organizations work easier and efficiently.

Data management initially had to maintain a lot of ledgers and a lot of
paper work has to be done but now software product of this organization
has made their work faster and easier. Now only this software has to be
loaded on the computer and work can be done.
This prevents a lot of time and money. The work becomes fully
automated and any information regarding the organization can be
obtained by clicking the button. Moreover, now it’s an age of computers
of and automating such an organization gives the better look.
SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)
The systems development life cycle is a project management technique that divides
complex projects into smaller, more easily managed segments or phases.
Software development projects typically include initiation, planning, design,

development, testing, implementation, and maintenance phases.
PICTORIAL REPRESENTATION OF SDLC:
HARDWARE AND SOFTWARE REQUIREMENTS

HARDWARE REQUIREMENTS:
I. PROCESSOR : PENTIUM(ANY) OR AMD
ATHALON(3800+- 4200+ DUAL CORE)
II. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI
K9MM-V VIA K8M800+8237R PLUS
CHIPSET FOR AMD ATHALON
III. RAM : 512MB+
IV. Hard disk : SATA 40 GB OR ABOVE
V. MONITOR 14.1 or 15 -17 inch
VI. Key board and mouse
VII Printer :
SOFTWARE REQUIREMENTS:
• Windows OS
• Python
• MySQL connector module
Description Of the Project
This project is designed to help teachers keep and manage records of the students
It is created to manage different operation on students data.
The project consists of Nine(9) options -
• Add Student
• Display student’s Data
• Update student’s Data
• Add student’s Marks Detail
• Generate All Student’s Report Card
• Generate Student Wise Report Card
• Exit
• WORK IS COMPLETE
• Help.
Functions & methods and their objectives
• BUILT-IN Functions & methods
input() : Reads a line entered on a console by an input

device and convert it into a string and return it.
int() : int() converts the specified value in to integer
number.
print() : Prints the specified message on the screen.
commit() : commit() method sends a commit statement to

the MySQL server, committing the current
transaction.
• UDF (User Defined Functions) Functions
newStudent() : For adding data of a new student
displayStudent() : To display specified student’s data
updateStudent() : To update data of already existing student
marksStudent() : To enter marks of a student
reportCardAllStudent () : To get the report card of a student
helpMe() : To get help

CODING
DBMS(Data Base Management System): MySQL
Host : localhost
User: root
Pass: Shreyash@123
Database : students
Table structure: As given below
Table Structure-: student
Table structure -: marks

Python Code
#|__PYTHON CONNCETIVITY WITH MYSQL__|.
import mysql.connector as c
mydb=c.connect(host="localhost",user="root",passwd="Shreyash@123",database="studen
ts")
mycursor=mydb.cursor()
#MODULE FOR NEW ADMISSION

def newStudent():
createTable ="""CREATE TABLE IF NOT EXISTS STUDENT(SROLL_NO
VARCHAR(5),SNAME VARCHAR(30),FNAME VARCHAR(30),MNAME
VARCHAR(30) ,PHONE VARCHAR(12),
ADDRESS VARCHAR(100),SCLASS VARCHAR(5),SSECTION VARCHAR(5),
SADMISSION_NO VARCHAR(10) PRIMARY KEY)"""
mycursor.execute(createTable)
sroll_no=input(" ENTER ROLL_NO : ")
sname=input("\n ENTER STUDENT'S NAME : ")
fname=input(" ENTER FATHER'S NAME : ")
mname=input(" ENTER MOTHER'S NAME : ")
phone=input(" ENTER CONTACT NO. : ")
address=input(" ENTER ADDRESS : ")
sclass =input(" ENTER CLASS : ")
ssection=input(" ENTER SECTION : ")
sadmission_no=input(" ENTER ADMISSION_NO : ")
sql="insert into student
(sroll_no,sname,fname,mname,phone,address,sclass,ssection,sadmission_no)
VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
values=(sroll_no,sname,fname,mname,phone,address
,sclass,ssection,sadmission_no)
mycursor.execute(sql,values)
mycursor.execute("COMMIT")
#MODULE TO DISPLAY STUDENT'S DATA

def displayStudent():
mycursor.execute("SELECT * FROM student")
data=mycursor.fetchall()
print(data)
#MODULE TO UPDATE STUDENT'S RECORD
def updateStudent():
admission_no=input("ENTER ADMISSION NO :")
sql="SELECT * FROM student WHERE sadmission_no= %s"
mycursor.execute(sql,(admission_no,))
if data:
print("PRESS 1 FOR NAME")
print("PRESS 2 FOR CLASS")
print("PRESS 3 FOR ROLL NO")
choice=int(input("Enter Your Choice"))
if choice==1:
name=input("ENTER NAME OF THE STUDENT :")
sql="UPDATE student SET sname= %s WHERE sadmission_no =%s"
mycursor.execute(sql,(name,admission_no))
print("NAME UPDATED")
elif choice == 2:
std=input("ENTER CLASS OF THE STUDENT :")
sql="UPDATE student SET sclass= %s WHERE sadmission_no=%s"
mycursor.execute(sql,(std,admission_no))
print("CLASS UPDATED")
elif choice==3:
roll_no=int(input("ENTER ROLL NO OF THE STUDENT :"))
sql="UPDATE student SET sroll_no= %s WHERE sadmission_no =
%s"
mycursor.execute(sql,(roll_no,admission_no))
print("ROLL NO UPDATED")
else:
print("Record Not Found Try Again !")
else:
print("\nSomthing Went Wrong ,Please Try Again !")
#MODULE TO ENTER MARKS OF THE STUDENT

def marksStudent () :
createTable ="""CREATE TABLE IF NOT EXISTS MARKS(SADMISSION_NO
VARCHAR(10) PRIMARY KEY,HINDI INT,ENGLISH INT ,MATH INT ,SCIENCE
INT,SOCIAL INT,COMPUTER INT,TOTAL INT ,AVERAGE DECIMAL)"""
mycursor.execute(createTable)
admission_no=input("ENTER ADMISSION NO OF THE STUDENT :")
hindi=int(input("\n ENTER MARKS OF HINDI : "))
english=int(input("\n ENTER MARKS OF ENGLISH : "))
math=int(input("\n ENTER MARKS OF MATH : "))
science=int(input("\n ENTER MARKS OF SCIENCE : "))
social=int(input("\n ENTER MARKS OF SOCIAL : "))
computer =int(input("\n ENTER MARKS OF COMPUTER : "))
total = hindi + english + math + science + social + computer
average = total/6
sql="INSERT INTOMARKS (SADMISSION_NO, HINDI, ENGLISH, MATH, SCIENCE,
SOCIAL,COMPUTER, TOTAL,AVERAGE) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
values=(admission_no, hindi, english, math, science, social, computer , total,
average)
mycursor.execute(sql,values)
print("\nMarks of the Student Entered Successfully !")
def reportCardAllStudent () :
mycursor.execute("SELECT * FROM MARKS")
print(data)
#MODULE TO GENERATE REPORT CARD OF ONE STUDENTS

def reportCardOneStudent():
admission_no=int(input("ENTER ADMISSION NO OF THE STUDENT :"))
sql="SELECT * FROM MARKS WHERE SADMISSION_NO= %s"

mycursor.execute(sql,(admission_no,))
if data:
print(data)
else:
print("Record Not Found , Please Try Again !")
def helpMe():
print("Please, Visit The Offcial Website Of Lucknow Public
Collegiate(https://www.collegiate.in) To Download The Mannual !!!")
print("#############################################################
#######")
#INFINITE LOOP
while(True):
print("|Enter 1 - Add Student.|")
print("|Enter 2 - Display Student's Data.|")
print("|Enter 3 - Update Students's Data.|")
print("|Enter 4 - Add Student's Marks Detail.|")
print("|Enter 5 - Generate All Student's Report Card.|")
print("|Enter 6 - Generate Student Wise Report Card.|")
print("|Enter 7 - Exit.|")
print("|Enter 8 - WORK IS COMPLETE.|")
print("|Enter 0(ZERO) - Help.|")
#Choice to perform (builtin) functions

choice=int(input("PLEASE ENTER YOUR CHOICE : "))
if choice==1:
newStudent()
print("New student entered")
elif choice==2:
displayStudent()
elif choice==3:
updateStudent()
elif choice==4:
marksStudent()
elif choice==5:
reportCardAllStudent()
elif choice==6:
reportCardOneStudent()
elif choice==7:
quit()
elif choice==8:
print("WORK IS COMPLETED")
break
elif choice==0:
helpMe()
break
else:
print("Sorry ,May Be You Are Giving Me Wrong Input, Please Try Again !!! ")
break
mycursor.close()
OUTPUT
2
3
4
5
7
It exits the code
8
0
BIBLIOGRAPHY
• Computer science with Python by Sumita Arora for

class 12.
• Internet

Shreyash Tiwari Projectclass12-C

Uploaded by

Copyright:

Available Formats

Shreyash Tiwari Projectclass12-C

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Shreyash Tiwari Projectclass12-C

Uploaded by

Copyright:

Available Formats

Name : Shreyash Tiwari

SESSION : 2022 -23

This is to certify that Shreyash Tiwari of class 12th has

OBJECTIVES OF THE PROJECT

The objective of this project is to let the students apply the

Software helps in making the organizations work easier and efficiently.

Software development projects typically include initiation, planning, design,

PICTORIAL REPRESENTATION OF SDLC:

HARDWARE AND SOFTWARE REQUIREMENTS

I. PROCESSOR : PENTIUM(ANY) OR AMD

ATHALON(3800+- 4200+ DUAL CORE)

II. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI

K9MM-V VIA K8M800+8237R PLUS

CHIPSET FOR AMD ATHALON

III. RAM : 512MB+

IV. Hard disk : SATA 40 GB OR ABOVE

V. MONITOR 14.1 or 15 -17 inch

VI. Key board and mouse

The project consists of Nine(9) options -

• BUILT-IN Functions & methods

input() : Reads a line entered on a console by an input

commit() : commit() method sends a commit statement to

• UDF (User Defined Functions) Functions

newStudent() : For adding data of a new student

displayStudent() : To display specified student’s data

updateStudent() : To update data of already existing student

marksStudent() : To enter marks of a student

reportCardAllStudent () : To get the report card of a student

helpMe() : To get help

Table Structure-: student

Table structure -: marks

#MODULE FOR NEW ADMISSION

#MODULE TO DISPLAY STUDENT'S DATA

#MODULE TO ENTER MARKS OF THE STUDENT

#MODULE TO GENERATE REPORT CARD OF ONE STUDENTS

sql="SELECT * FROM MARKS WHERE SADMISSION_NO= %s"

#Choice to perform (builtin) functions

• Computer science with Python by Sumita Arora for

You might also like