CENTRAL BOARD OF SECONDARY EDUCATION, NEW DELHI

BHAGWATI INTERNATIONAL PUBLIC SCHOOL, PATAN

Dr. Indu Dayal Meshri Primary English School

“ School Management”

“Information Technology”

Guided By: Mrs. Komal Trivedi

Submitted By:
Class:
Roll No. :
 Certificate

This is to certify that ___________________ is the student of

class X, ExamNo. submitted the project titled
“School Management" held in the BHAGWATI
INTERNATIONAL PUBLIC SCHOOL , PATAN for the academic
year 2023-24.

The student has worked sincerely under the guidance of the

subject teacher and completed this project. This original work is
carried out by the stated student and thankfully acknowledges
the references that have been taken for the study

Signature Signature

(Subject Teacher) (Principal)

 Acknowledgement

First of all, I convey my sincere gratitude to the Almighty God

and owe a deep sense of gratitude to my parents.

I took this opportunity to express my gratitude to the people

who have been instrumental in the successful completion of
this project.

I am thankful to DR.CHIRAG PATEL, the principal of BHAGWATI

INTERNATIONAL PUBLIC SCHOOL,PATAN. I would like to
convey my greatest appreciation to my mentor teacher MRS.
KOMAL TRIVEDI. I feel motivated and encouraged every time
,when I attend the class of my mentor. Without the
encouragement and guidance of my mentor, this project
could not have been materialized.

I am also thankful to my classmates for their moral support

and encouragement
 INTRODUCTION

I have taken a case study for the school to maintain the staff

details in an organized way. I have selected 2 tables to do this

project work.

1. Departments

2. Staff

To prepare a summarized report for the case I have used the

following concepts of OO base.

1. Create Table

2. Insert data

3. Operations on tables

4. Queries

5. Forms

6. Reports

My OO Base Project Work includes the following reports:

All staff members and department details

1. All staff member & All department details

2. Department location wise

3. Staff according to department

4. Staff according to designation

5. Staff according to type of appointment

6. Staff report on the level of seniority

7. Staff report subject wise

The structure of these two tables are as follows:

The departments' table has 3 main fields as follows:

1) Department Table

Data
Field Constraint Description
Type
Integer Primary
Dep_ID Holds a unique id for each department
(Auto) Key
DepName Text Store department name
Store the location of the department
DepLoation Text
like senior setion, middle section etc.
2) Emp Table

Data Constrai
Field Description
Type nt
Integer( Primary
Staff_ID Holds unique if for each staff member
Auto) Key
StaffName Text Holds the staff member name
DateofJoining Date Holds the date of joining
Holds the status out of regular,
Status Text
probation, contractual etc.
Subject Text Holds the subject taught by a teacher
Qualification Text Holds qualification of teacher
Department_ID Integer Holds department id of the staff
 Objective of the Project

My consideration while developing this project was to

achieve the following goals:-

1. This project is for any school. Which provide staff

management facility.

2. It also saves the valuable time of the admins and lots of

paper works.

3. This will save lots of effort of the user. He/She is able to

manage lots

of information after using this project and also able for

seeing in

different angles.

4. User can manage all the records very easily and can

generate all

kinds of reports for management.

 Steps to create a database
1. Click on Start → All Apps.

2. Scroll down for Open Office 4.1.7 → OpenOffice Base

3. A Database Wizard will appear.

4. Select Create a new database option.

5. Click on Next.

6. Select the option for register database if you wish to

register, click on “Yes, Register the database for me”
otherwise click on “No, do not register the database”.

7. Now select the option Open the database for editing.

8. Click on Finish.

9. Saved database with name “Employee”.

10. Now the database is ready for the project.

Steps to create tables

1. Select Tables from left pane.

2. Now click on Create Table in Design view... option.

3. Specify the columns and data types for the columns along
with description.

4. Assign primary key by right click on the field name.

5. Save the table.
 Insert data into table

1. Double click on table.

2. Type the required data.

3. Save the table.

Staff Table

Creating Data Entry Form

1. Click on Forms button in the left pane.

2. Click on Use Wizard to Create Form... option.

3. Select the required fields, here I need all fields. So I have

clicked on >> button.

4. Now click on Next button for the next step.

5. This step is for setting up a subform. Here it is not required,

so click on next.

6. Now arrange the controls as per the need. I have selected

first option Columnar – Labels Left.

7. Now click on Next.

8. Now select the option to Data Entry form.

9. Select the option – The form is to be used for entering new

data only. Existing data will not be displayed.

10. Click on Next.

 11. Now Apply the styles for the form.

12. Click on Next and Give name for the form.

Use save record button to save data.

Add new record for new data entry.

Now create form for data manipulation as modification or

deletion. The steps are same as above in the last only select the
option “The form is used to view all data”. Do not select the
option to “Do not allow addition of new data” as I have made
Data Entry form separately.
 Creating Reports

1. All staff members and department Details

Steps:

1. Click Reports button from left pane.

2. Select the fields Query : All from Staff and Dept.

3. Click on >> button to shift all fields. Click on Next.

4. Choose labels and click on Next.

5. No need to select grouping here. Click on Next.

6. If sorting needed choose the fields and Click on Next. I

have not sorted the records.

7. Select the layout as per the need.

8. Name the report and click on Finish Button.

Output:

2. Department Location Wise

 The steps are almost same, here the records are grouped
according to location.

3. Staff According to department

4. Staff according to designation

5. Staff report according to type of appointment

6. Staff report on the level of seniority

7. Staff report subject wise
 References

1. CBSE Study Material

2. www.tutorialaicsip.com

3. www.openoffice.org