Scribd
Upload
9 views26 pages

School Management System Project Report

Uploaded by

mudit.yadav.9309
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views26 pages

School Management System Project Report

Uploaded by

mudit.yadav.9309
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Information Technology

Project report on
“School management system”

logo of School

Name:

Roll no :
CERTIFI
CATE

This is to certify that Class: X, Name of Session:2025-26 has prepared

the Project File as per the prescribed Syllabus of INFORMATION

TECHNOLOGY SUB. Under my supervision, I am completely satisfied by

the performance. I wish all the success in life.

Principal’s Signature Subject Teacher’s Signature


INDEX
ACKNOWLEDGMENT
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 gratefully

acknowledge the contribution of the individuals who contributed in bringing

this project up to this level, who continues to look after me despite my flaws, I

express my deep sense of gratitude to the luminary The Principal, (VISHAL

BHARTI SR SEC SCHOOL C.B.S.E) who has been continuously motivating

and extending their helping hand to us. My sincere thanks to In-charge, A

guide, Mentor all the above a friend, 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.


INTRODUCTION OF THE PROJECT

Impact of computers and internet, on our lives today is probably much more

than we really Getting information and quickly turning it into a product that

consumers want is the essential key to staying in business and all of this is done

nowadays using computers and applications or information stems. And the

information systems will continue to change businesses and the way we live.

Many corporate leaders are using technology to manage every aspect of their

organization, from product creation to customer service. It has brought

evolution in almost every field, it changed the ways of teaching, administration

of activities such as e-learning, e-library and online portals where teachers and

students communicate, and sharing of information has never been better.

Student result declaration and management are amongst the most important

activities within a School or any educational institution, since all other activities

depend on it. Hence implementing an Information system can be declared a

significance result.
OBJECTIVE OF PROJECT

Libre office project: Student Result Management System

The main objective of this research is to enhance and automate the management
and declaration of students’ results using a computerized system. Its provide the
examination result to the student in a simple way. This project is useful for
institutions for getting the results in simple manner.

Hardware And Software Requirement


Specification:-
OS: Microsoft Windows (Windows XP, Windows 2003, Windows Vista,
Windows 7, Windows 8”)
RAM: 256 Megabytes RAM (512 MB RAM recommended)
At least 650 Megabytes available disk space for a default install (including a
JRE) vía download. After installation and deletion of temporary installation
files Apache LibreOffice will use approximately 440 Megabytes disk space.
MONITOR:-1024×768 or higher resolution with at least 256
colours Software:- LibreOffice

MAIN COMPONENTS OF STUDENTS MANAGEMENT SYSTEM:


Student Result Management System will have the following components.
Marks Table:- This table will store the results of the students of a class. Student
Contact Table:- This table will store the address and contact details of the
students of a class .
Relationship:- Both the tables (Marks Tab and Student Contact) will be linked
to each other using Relationships.
PROJECT IMPLEMENTATION
1) DATABASE CREATION
• Open LibreOffice Base.
• Select New Database and click Next.
• In the next dialogue, select Yes to register the database. Ensure
that Open the database for editing is also selected.
• You may choose to Create tables using the table wizard to
immediately set up a table in the new database. Alternatively, this
can be done later.
• Click Finish. LibreOffice Base will prompt you to save the
database to your local computer. Provide a name for the database file
and save it.
The LibreOffice Base file format is .odb, which stands for
OpenDocument Database (ODB) file format.
2) TABLE CREATION
Open your database in LibreOffice Base.
Go to the Tables section.
Select Create Table in Design View to manually define your
table structure, or choose Use Wizard to Create Table for a guided
setup.
In the design view, enter a Field Name, Field Type, and optional
Description for each column.
Right-click the field you want as the Primary Key and set it as
such.
Click Save or press Ctrl + S to save the table, then provide a name
for it.
Open the table from the Tables section to start entering data
directly.
ESTABLISH RELATIONSHIPS
Go to the Tools menu and select Relationships.
In the Relationships window, click Add Tables. Choose the tables
you want to relate and click Add for each. When finished, click
Close.
Drag a field from one table to the matching field in another table to
create a relationship (e.g., CustomerID in a Customers table to
CustomerID in an Orders table).
The Relations dialogue will appear, allowing you to set the
relationship type and enforce referential integrity by checking options
like Update Cascade or Delete Cascade if needed.
Click OK to save the relationship.
Close the Relationships window and save the changes.
Creating forms
Open your database and go to the Forms section in the left-hand
menu.
Click on Use Wizard to Create Form.
In the Form Wizard, select the table or query you want to use for
the form.
Choose the fields to include in the form by moving them from
Available Fields to Fields in the Form.
Click Next and follow the prompts to configure additional settings,
such as form layout, data entry options, and navigation controls.
After customizing the form, click Finish.
Provide a name for the form and save it.
Adding sample data via SQL
Creating Query
Open the database, and on the left-hand menu, click “Queries”. Here
you have three options:
▪ Create a query in the design view
▪ Create using wizard
▪ Create using SQL
QUERIES:
LIMITATIONS

• There seem to be issues using this app in Windows 10. It

worked fine when we used it on Windows? But after we

upgraded the network with NEW Win 10 computers, it cakes

a very long time to process commands.

• It will not allow any upgrade


• Not the best solution for larger or complex documents
• Doesn’t integrate well with third party software and applications
• Not as good as MS Office for document sharing
and collaboration

• Project works smoothly with less volume of data, but


once increase data it will slow in process

• Poor User Interface


• Project Creation takes times
FUTURE SCOPE

• Listed limitations will overcomes in upcoming versions


• Working on User interface.
• Able to deal with large volume of data

BIBLIOGRAPHY

• Information Technology NCERT Text Book


• Information Technology By Sumita Arora
• Information Technology CBSE Materials.

Common questions

Powered by AI

The integration of a student result management system automates and streamlines the process of result declaration in educational institutions. It provides a computerized system for managing and declaring students' results, making the process straightforward and efficient. This change impacts the speed and accuracy of result announcements, facilitates immediate access for students and administrators, and improves data management and retrieval. Such a system reduces the manual workload and potential errors associated with traditional result management methods .

The hardware requirements include a system with at least 256 MB of RAM, with 512 MB recommended, and a monitor with 1024×768 or higher resolution. Software requirements include having a Microsoft Windows operating system from XP to Windows 8, and LibreOffice suite. These requirements influence deployment by limiting the system to environments that meet or exceed these specifications, potentially restricting use in settings with outdated hardware or software infrastructure .

Project acknowledgments play a vital role in the development and completion of the Student Result Management System by formally recognizing the support and contributions of individuals involved in the project. Acknowledgements highlight the collaborative nature of project development, emphasizing the importance of guidance, encouragement, and resources provided by mentors, educators, and peers. This recognition fosters a positive developmental environment and strengthens partnerships essential for project success .

Creating a database involves opening LibreOffice Base, selecting 'New Database', registering the database, and setting it up for editing. The subsequent steps include defining tables either manually or using a wizard, setting primary keys, and establishing relationships between tables. This foundational process is crucial as it ensures the structural organization of data, facilitates efficient data storage and retrieval, and establishes a robust framework that supports all data-driven functionalities of the Student Result Management System .

Establishing relationships between tables in the database management system contributes to data integrity by ensuring that data is consistently and accurately linked across different tables. These relationships enforce referential integrity, preventing orphan records and ensuring that data updates or deletions are synchronized throughout the system as needed. This systematic approach maintains the cohesion and validity of interconnected datasets, which is essential in managing complex student records efficiently .

The key components of the Student Result Management System include the Marks Table and the Student Contact Table. These tables are interconnected through relationships, which link fields from both tables, facilitating data integration and consistency across the system. This setup enhances data management by allowing effective retrieval, update, and integrity enforcement of student information, particularly for managing comprehensive student records such as academic performance and personal details .

The creation of forms in LibreOffice Base significantly enhances user experience and system functionality by providing an intuitive interface for data entry and retrieval. Forms allow users to interact with the database more efficiently, offering customized layouts and navigation controls that simplify complex processes. This design consideration ensures that users can manage student data effectively, contributing to a streamlined workflow in the result management system .

Implementing computerized systems for student result management is crucial for educational institutions because it enhances efficiency and accuracy in data handling, reduces manual errors, and facilitates faster access to results. Moreover, such systems support comprehensive data management, streamline communication between students and educators, and enable the integration of additional educational technologies. Overall, this adoption optimizes administrative processes and supports institutions in keeping pace with technological advancements .

The identified limitations in the LibreOffice-based Student Result Management System include poor performance on Windows 10, such as slow processing times when managing large data volumes, issues with software upgrades, and inadequate integration with third-party applications. These limitations can severely impact the system's functionality by hindering user experience due to inefficiencies and reduced adaptability, particularly in environments requiring robust processing capabilities or complex integrations .

The future scope of the project includes anticipated improvements such as enhancements in the user interface to make it more intuitive, optimization for handling larger volumes of data, and resolving current issues of integration with third-party software. These improvements aim to address the existing limitations by providing better usability, ensuring system robustness with increased data loads, and facilitating broader application integration, thus making the system more efficient and user-friendly .

You might also like