Project Report

Project Report
on
Information
Technology - 402
Submitted by:
Aaditya Mishra
Roll No.- 1
Class- 10th B
Session- 2022-2023
Table of Contents
Content
 Acknowledgement
 Certificate
 Introduction of Open Office and Open office base
 Project 1- Open Office project
1. Create a STUDENT table in Open Office Base
2. Forms for data entry
3. Report Creation
 Project 2
1. Goal seek
2. Scenario
 Bibliography
Introduction of Open Office and Open office base (Using Writer)
Open Office- OpenOffice is the leading open-source office software suite for word
processing, spreadsheets, presentations, graphics, databases and more. It is available in
many languages and works on all common computers. It stores all your data in an
International open standard format and can also read and write files from other common
office software packages. OpenOffice is easy to learn.
OpenOffice is a productive office suite with a collection of different software packages such
as
· OpenOffice Writer - Word Processor to create text documents
· OpenOffice Calc - Spreadsheet to create worksheets
· OpenOffice Base - Database
· OpenOffice Impress - Presentation software
· OpenOffice Draw - Drawing Software
· OpenOffice Formula - Create formula and equations
Open Office Base- it is a fully featured desktop database management system, designed
to meet the needs of a broad array of users, from tracking a personal CD collections, to
producing a corporate monthly departmental sales reports.
Base offers wizards to help users new to database design (or Base) to create Tables, Queries,
Forms and Reports, along with a set of predefined table definitions for tracking Assets,
Customers, Sales Orders, Invoices and much more.
When a personal use database is all you need, Base offers the full HSQL relational database
engine, configured for single user, with the data stored right in the Base file, as well as native
support for dBase flat files.
For power users in the enterprise, Base delivers native support drivers for a variety of multi-
user database engines: MySQL, Adabas D, MS Access and PostgreSQL. In addition, support
for JDBC and ODBC standard drivers allows you to connect to virtually any database.
Base integrates seamlessly into the rest of the Apache OpenOffice suite applications, for
example:
 Supplying address book data for mail merge in Writer using the industry standard
LDAP protocol, or common address book formats such as Microsoft Outlook,
Microsoft Windows and Mozilla;
 Creating linked data ranges in Calc files for data pilot analysis or as the basis for
charts.
OpenOffice Writer- OpenOffice Writer is the word processor component of OpenOffice.
In addition to the usual features of a word processor (spelling check, thesaurus,
hyphenation, autocorrect, find and replace, automatic generation of tables of contents and
indexes, mail merge and others), Writer provides these important features:
· Templates and styles.
· Page layout methods, including frames, columns, and tables.
· Embedding or linking of graphics, spreadsheets, and other objects.
· Built-in drawing tools.
· Master documents-to group a collection of documents into a single document.
· Change tracking during revisions.
· Database integration, including a bibliography database.
· Export to PDF.
Project 1 - Open Office project
Problem- Create a STUDENT table in Open Office Base in design mode with at least 5 fields
and 10 records.
Summarized data reports of same can be presented in base.
Input should be taken using forms and output should be done using reports using base.
1. Create a STUDENT table in Open Office Base
Create Table in Design View
Enter Table Name and Save

2. Forms for data entry
Form Wizard
Arrange Controls- select first arrangement

Form ready for data entry
Enter data in form one by one record, Add 10 records.

Select Data source as table icon
Save the data

3. Report Creation
Reports Wizard -> Select Fields for report
Labelling of Fields to be shown in report

Report: - Roll No in ascending order
Project 2 – Goal seek and scenario
Problem- Goal seek and scenario

1. Goal Seek
Finding Simple interest where, Principal = 1500, Rate of interest =15%, Time= 6
Now we need to change principal so that we get Interest as 1500
Opening Goal Seek dialog box

Getting the value of interest as 1500 by changing the principal
Goal seek changed the value of principal to get the value of interest as 1500
Bibliography
1. An Introduction to OpenOffice Writer (brainkart.com)

2. https://www.openoffice.org/documentation/manuals/userguide3/0101GS3-
IntroducingOOo.pdf
3. https://www.openoffice.org/product/base.html
Acknowledgement
I would like to express my profound gratitude to Ms Shilpi Arora, IT

department for her contributions, time and efforts to the completion of my
project. Your useful advice and suggestions were really helpful to me
during the project’s completion. In this aspect, I am eternally grateful to
you.
I would also like to thank our Principal, Mr. Ganesh Sharma, for
providing me with this opportunity to work on this project.
I would like to acknowledge that this project was completed entirely
by me and not by someone else.
Yours Obediently,
Aaditya Mishra
Roll No. 1
Class- 10th B
Certificate
25.01.2023
This is to certify that Aaditya Mishra of Class 10th

B, Session 2022-2023, of GIIS (Noida) has done project
work on ‘Open Office’ Under guidance of Ms. Shilpi
Arora, IT Deptt, Global India International School.
Shilpi Arora
IT Deptt, GIIS

Project Report

Uploaded by

Copyright:

Available Formats

Project Report

Uploaded by

Document Information

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

Project Report

Uploaded by

Copyright:

Available Formats

Project Report

Create Table in Design View

Enter Table Name and Save

Arrange Controls- select first arrangement

Enter data in form one by one record, Add 10 records.

Save the data

Reports Wizard -> Select Fields for report

Labelling of Fields to be shown in report

Problem- Goal seek and scenario

Now we need to change principal so that we get Interest as 1500

Opening Goal Seek dialog box

1. An Introduction to OpenOffice Writer (brainkart.com)

I would like to express my profound gratitude to Ms Shilpi Arora, IT

This is to certify that Aaditya Mishra of Class 10th

You might also like