Informatics Practices Submitted by Submitted to Shubham Malra Mrs. Harpreet Kaur +2 (Science) (PGT Computer Science) ,
PROJECT REPORT
STUDENT RECORD MANAGEMENT SYSTEM
Submitted to Central Board of Secondary Education, New Delhi
Submitted By: - Project Guide: -
Name: Shubham Malra Mrs Harpreet Kaur
Board Roll No:
SACRED SOUL CONVENT SNR SEC SCHOOL, LUDHIANA
SOFTWARE FOR STUDENT RECORD MANAGEMENT SYSTEM
Tools Used
Front End: - PYTHON
Back End: - CSV FILE
Developed At
SACRED SOUL CONVENT SNR SEC SCHOOL
CERTIFICATE
This to certify that the project report entitled “SOFTWARE
FOR SCHOOL RECORD MANAGEMENT SYSTEM” submitted by Shubham Malra during the academic year 2023-2024 is a benefited piece of work conducted under my supervision and guidance. The data sources have been duly acknowledged. I wish him/her success in all his/her future endeavours.
SUPERVISED BY
(Principal) (Project Guide)
ACKNOWLEDGEMENT
I take this opportunity to express my profound sense of
gratitude and respect to all those who helped me throughout this venture.
I owe my regards to Mr/Ms/Mrs Poonam Malhotra Principal of my
School for his/her cooperation and valuable support and for giving us the opportunity to undertake this project work and providing the necessary infrastructure.
I would like to express my heartfelt thanks to my revered
teacher Mr/Ms/Mrs. Harpreet Kaur for his/her valuable guidance, encouragement. This project is his visualization and owes a lot of its functionality to him.
Last but not the least, I owe my overwhelming gratitude to my
family and friends who gave me constant support and motivation to continue with this endeavour.
Name of Student Shubham Malra PREFACE The computers have gained a lot of importance in the past five decades. Most of our day-to-day jobs are being influenced by the use of computers. Now a day, computers are used for performing almost every function, which were performed by humans in the past. In some areas such as science and technology, targets can’t be achieved without the use of computers. The characteristics that make the computer so important include its extra ordinary speed, large storage capacity, accuracy and consistency.
Today computers play a great role in various industries
and a large number of industries are using computers for various application such as maintaining cashbook, sales book, purchase book and other books of accounts. Computers can also be used for the designing of various products. Computers provide many options for the designing of products. The analysis of the project has been undertaken with utmost sincerity and honesty and we will be extremely satisfied if the effort is appreciated INDEX
1. Requirements Analysis
2. Feasibility Study
3. Coding
4. Output Screen
5. System Specifications
6. Conclusion
7. Bibliography Requirement Analysis Proposed system
All the four activities of systems have been automated and efforts have been made to minimize the manual working.
Benefits Of Purposed System: -
1. Less Paper Work
The paper work is reduced to minimal level. Computer prepares the lists of customers.
2. No Manual Work.
There is no manual work. All the processes are done through computer.
3. Record of Schools.
There is record of all the Schools who got registered.
4. Register Maintenance is Easier
Register can now easily be maintained by producing a report with a format of adding Schools’ records.
5. Data Is Not Scattered
Data is now stored at one place. Any information regarding anything can be easily available to the user.
6. User-friendly Software
The software is be menu-driven and is very easy to use.
7. Flexibility
The system is more flexible than the manual system being used presently.
8. Beneficial
The system is easy to use and reduces the user’s workload a lot. It provides timely and accurate information and there is automatic generation of reports. FEASIBILITY STUDY
During the course of completion of this project work, the complete analysis of proposed system was done. In the analysis task, a complete care about the feasibility of the proposed system was taken. The following feasibility analyses were carried out during the course of this project work on call management system for customer care:
Economic Feasibility: - Economic analysis is the most frequently used method for evaluating the effectiveness of a candidate system. The proposed system is economically feasible because the benefits and the savings that are expected from a candidate system outweigh the cost incurred. In this case we are getting the intangible benefits in terms of low cost of maintenance of data, less redundancy and getting the quick results.
Technical Feasibility: -
The existing Hardware and Software facilities support the proposed system. Computer and storage media are available and software can be developed.
Hardware configuration: a) Processor : i3 b) Memory : 2 GB RAM c) HD capacity : 1 TB
Software configuration: - a) Operating system : Windows 10 b) Back end : csv files c) Front end : Python There is nothing which is not technically feasible. Operational feasibility: -
As in the case of present system the entire work is being
done manually. So, the data being scattered, information retrieval becomes difficult and maintaining database is also very tedious. In case of proposed system, entire work will be done automatically. So, the above details regarding the feasibility study show that the design of the proposed system is very effective. CODING import csv import os
CSV_FILE = 'student_records.csv'
def create_csv_file(): with open(CSV_FILE, 'w', newline='') as file: writer = csv.writer(file) writer.writerow(['StudentID', 'StudentName', 'Course', 'Marks'])
def display_menu(): print("\n" + "="*40) print("==== STUDENT RECORD MANAGEMENT SYSTEM ====".center(40)) print("="*40)
def modify_student(): student_id = input("Enter Student ID to modify: ") new_marks = input("Enter new Marks: ")
with open(CSV_FILE, 'r', newline='') as file:
reader = csv.reader(file) rows = list(reader) for row in rows: if row and row[0] == student_id: row[3] = new_marks break
with open(CSV_FILE, 'w', newline='') as file:
writer = csv.writer(file) writer.writerows(rows) print("Student record modified successfully!")
def delete_student(): student_id = input("Enter Student ID to delete: ")
with open(CSV_FILE, 'r', newline='') as file:
reader = csv.reader(file) rows = list(reader) for row in rows: if row and row[0] == student_id: rows.remove(row) break
with open(CSV_FILE, 'w', newline='') as file:
writer = csv.writer(file) writer.writerows(rows) print("Student record deleted successfully!")
def search_student(): student_id = input("Enter Student ID to search: ")
with open(CSV_FILE, 'r', newline='') as file:
reader = csv.reader(file) for row in reader: if row and row[0] == student_id: print("Student ID:", row[0]) print("Student Name:", row[1]) print("Course:", row[2]) print("Marks:", row[3]) break else: print("Student not found!")
def display_all_records(): with open(CSV_FILE, 'r', newline='') as file: reader = csv.reader(file) for row in reader: print("Student ID:", row[0]) print("Student Name:", row[1]) print("Course:", row[2]) print("Marks:", row[3]) print("-" * 40)
def main(): if not os.path.exists(CSV_FILE): create_csv_file()
while True: display_menu() choice = input("Enter your choice (1-6): ")
if choice == '1': add_student() elif choice == '2': modify_student() elif choice == '3': delete_student() elif choice == '4': search_student() elif choice == '5': display_all_records() elif choice == '6': print("Thank you for using the Student Record Management System. Exiting...") break else: print("Invalid choice. Please enter a valid option (1-6).")
if __name__ == "__main__": main() OUTPUT SCREENS SYSTEM SPECIFICATIONS
HARDWARE SPECIFICATIONS The following is the hardware specification of the system on which the software has been developed: -
Operating System : Windows 7/10
Machine Used : intel(R) Core (TM) i5-4310U CPU @ 2.00GHz 2.60 GHz, 8 GB RAM, 256 GB SSD
SOFTWARE SPECIFICATIONS Front End Used : python
Backend Used : Data Files
CONCLUSION
This project was completed on time and is found working effectively
under all circumstances that may arise in real environment. The program objective specifies on the requirement is believed to be met. Using the facilities and functionalities of python and mysql , the program has been developed in neat manner.
This program is simple and user friendly. The speed and accuracy are maintained in proper way. Testing of the program has given good result.
The program is done with an insight into necessary modifications that
