BETHANY NAVAJEEVAN SENIOR SECONDARY SCHOOL, VENCODE

(Affiliated to CBSE Board, Affiliation No: 1931074)

INFORMATION
TECHNOLOGY
SUBJECT CODE: 402

GRADE X
Program1:
Applying Styles in a Document
Aim:
To create and apply different styles on the document using
Writer.
Procedure:
Step1: select open office writer
Step2: In file menu →select-new→text document
Step3: Type a paragraph.
Step4: To create our own new style→ select format menu →Click
Styles and Formatting.
Step5: From the Styles and formatting pane. Select your desired
styles.
i. Right click on the pane→Select new→paragraph style
window will popup.
ii. select organizer tab→type your style name.
iii. Choose Whatever styles needed (Font, Font Effect, color
etc.).
iv. Click ok, Now Your Style will be added in the pane.
Step6: Choose the paragraph in the document, where you have to
apply your style.
Step7: Select the style you have created and double click it.
Step8: After applying styles Save the document and take printout.

Result:
Thus, different style was created and applied in the document
successfully.

2
Program2:
Inserting An Image in the Document.
Aim:
To insert a picture into a document and crop the picture as
half of the image into the document.

Procedure:
Step1: select open office writer
Step2: In file menu →select-new→text document.
Step3: Choose insert menu→Select Picture-You need from picture
gallery.
Step4: Right click the inserted picture→ a sub menu will pop up in
that select picture.
Step5: In picture window choose the necessary option you need to
format the picture (crop, border and back ground etc).
Step6: Click ok, Now Your picture will be formatted.
Step7: Save the file and Take Print.

Result:
Thus, the image was inserted and cropped into the document
successfully and verified.

3
Program3:
Inserting an Image and Grouping
Insert a smiley face, a rounded rectangle on the document. Include the
three drawing into a single group.
Next, reduce the size of the smiley face and increase the size of the
rounded rectangle and third figure unchanged.

Aim:
To insert a different drawing image and make into a single group,
increase and reduce the size.

Procedure:
Step1: select open office writer
Step2: In file menu →select-new→text document
Step3: In the view menu→Choose toolbar→select drawing.
Step4: Drawing tools will appear on the screen, From that select the
need shapes (Triangle, Square, Circle and Smiley)
Step5: To group the above images- press shift key + select all the
images one by one.
Step6: Go to Format menu→choose group→click group.
Step7: Save the document and take printout.
Step8: Right click on grouped drawing images→choose→click
ungroup.
Step9: Increase the size of the rounded rectangle →Select the image
right click →Choose position and size→Increase the size of
width and height→click ok.
Step9: Reduce the size of the Smiley face →Select the image →click
the corner→reduce the size.
Step10: Save the document and take printout.

Result:
4
Thus, the images were inserted and size was changed successfully and
verified.

Program4:
Creating a Template
Aim:
To Create and Insert a template in the document using
Open Office Writer.

Procedure:
Step 1: Open OpenOffice Writer.
Step 2: Create a New Document. Select the File menu from the top menu bar.
Choose the New option.
Step 3: From the New submenu, select the Templates and Documents option.
Step 4: A Templates and Documents dialog box will appear on the screen.
Step 5: Click on the "Get more templates online" link. This will open a browser
and take you to a website where you can pick online templates.
Step 6: Find the option or link for Writer templates on the web page and click
on it.
Step 7: This will open a screen where you can select and download a template.
Step 8: Click on the desired template and then click on the download template
option. When prompted, choose to save the file with a (ott) extension.
Step 9: Open the saved file.
Step 10: The template will appear in OpenOffice Writer.
Step 11: You can now edit the template and save your changes.
Step 12: Take a printout and attach it to your report file.

Result:
Thus, the template was created successfully and verified.

5
Program5:
Implement Mail Merge
Aim:
To Create and implement mail merge using Open Office
Writer.
Procedure:

Step 1: Open OpenOffice Writer

Step 2: Create a New Document →Select the File menu, then choose New, and
click on Text Document.

Step 3: Open the Mail Merge Wizard→ Go to the Tools menu and select Mail
Merge Wizard.

Step 4: Start the Mail Merge Wizard→ In the Mail Merge Wizard dialog box,
choose Use the current document→Click Next.

Step 5: Select Document Type→ Choose the Letter option as the document
type→Click Next.

Step 6: Insert Address Block→Click on Select Address List to choose or create

your list of recipients. Click on Create to make a new one→ Click on
adding and deleting customized address list→ Click Ok.

Step 7: Create or Select an Address List. If creating a new list, enter the
recipient details one by one using click new menu→Click OK after
selecting or creating your list.

Step 8: Select the Address block→Click More option→select our preferred

address block → Click Ok

Step 9: Match Fields→ Ensure that the fields from your address list match the
required fields in the address block. Click OK.

6
Step 10: Insert Address Block into Document→Select the desired address block
format and click Next.

Step 11: Create a Greeting Line→Click Next.

Step 11: Adjust the Layout→ Adjust the layout of your document if
necessary→Click Next.

Step 12: Personalize Document→Insert additional fields or make further

adjustments to personalize your document. Click Next.

Step 13: Save, Print, or Send the Merged Documents→Choose whether to save
the merged document, print the documents, or send them as email. Click
Finish to complete the mail merge process.

Step 14: Save the Document And take print out.

Result:

Thus, the mail merge was created successfully.

7
Program6:
Calculating Simple Interest Using Goal Seek
Aim:
To Find the Amount of Simple Interest using the Goal Seek
Method in OpenOffice Calc.

Procedure:

Step 1: Open the OpenOffice Calc Worksheet.

Step 2: Enter values for the principal amount, Year, and Rate of Interest. The
principal amount is 10,000, the Year is 4, and the Rate of Interest is 12%
per annum.
Step 3: In the calculation cell (e.g., C4), enter the formula for simple interest:
=P*R*T/100 (replace P, R, and T with their corresponding cell
references.
Step 4: Choose Tools → Goal Seek. The Goal Seek dialog box will open.
Step 5: In the Goal Seek dialog box, assign the formula cell as the 'Formula
cell', set the target value, and assign the 'Variable cell' (the cell you want
to adjust). Click OK.
Step 6: If the Goal Seek has succeeded, click the Yes button in the dialog box.
Step 7: The Simple Interest is now calculated using the Goal Seek method.
Step 8: Take a printout and attach it to your report file.

Result: Thus, the amount of simple interest was done successfully.

8
Program7:
Finding Average Using Subtotals
STUDENT ID STUDENT NAME SUBJECT MARKS
XJ101 ARAVIND HINDI 85
XL102 SAMEER ENGLISH 84
XR103 MACBIN MATHS 86
XL102 SAMEER MATHS 83
XJ101 ARAVIND ENGLISH 87
XR103 MACBIN HINDI 88
XJ101 ARAVIND MATHS 89
XR103 MACBIN ENGLISH 82
XL102 SAMEER HINDI 81
Find the average marks obtained by students based on above table of data.
Aim:
To create a spreadsheet using subtotals to find out the average marks
obtained by students based on the above table of data.
Procedure:
Step 1: Open the OpenOffice Calc Worksheet.
Step 2: Enter data as specified in question.
Step 3: Select a single cell within the range of cells that you want to calculate
subtotals for and then choose Data → Subtotal.
Step 4: In the Subtotals dialog box: In the "Group by" list, select the column by
which the subtotals need to be grouped. A subtotal will be calculated for
each distinct value in this column.
Step 5: In the "Calculate subtotals for" box: Select the columns containing the
values for which you want to create subtotals. If the contents of the
selected columns change later, the subtotals are automatically
recalculated.
Step 6: In the "Use function" box: Select the function that you want to use to
calculate the subtotals (e.g., Average).
Step 7: Click on Ok.
Step 8: Check the spreadsheet for subtotal calculations.
Step 9: Take a printout and attach it to your report file.

9
Result

Thus, the average marks were calculated successfully using subtotal

Program8:
Creating Table in a Database
Create a table in the database with the following fields:
StudentRollNo, StudentName, Gender, Total-Mark, Average.

Create a query in design view in order to retrieve the tuples from the tables such
that: Either Total-Mark is more than 90 and Average is less than 90. (OR)
Total-Mark is less than 90 and Average is more than 90.

Aim:
To Create table in the database and create a query in design view.

Procedure:

Step 1: Open the OpenOffice base Database.

Step 2: Create a table in design view with the following fields:

Field Name Field Type

StudentRollNo Integer[integer]
StudentName Text(fix)[char]
Gender Text [VARCHAR]
Total-Mark Integer[integer]
Average Integer[integer]

.
Step 3: Enter values into the table in datasheet view.
Step 4: Save the table: Close the datasheet. When prompted to save,
provide a table name (student) and Click Ok.
Step 5: Click on the "Queries" button on the pane of the database screen.
Step 6: Click on "Create Query in Design View." →The "Add Table or
Query" dialog box will appear.
10
Step 7: Select the table you created and click the "Add" button.
Step 8: Click the "Close" button to close the "Add Table or Query" dialog box.
Step 9: In the design grid for the query:

• Choose the fields from the table.

• Specify whether the fields should be visible.
• Enter the search criteria for the query:
o Total-Mark > 90 AND Average < 90
OR
o Total-Mark < 90 AND Average > 90
.
Step 10: Run the query → Click on "Run Query" from the interface or press the F5 key.
Step 11: The output of the query will appear.
Step 12: Take a printout and attach it to your report file.

Result: Thus, to create a table in the database and create a query in design
view was successfully.

11
Program9:
Query Execution
Aim:
To create a table, execute a query, and display the query output using SQL
commands in OpenOffice Base.

Procedure:

Step 1: Open the OpenOffice base.

Step 2: Create a new database

Step 3: Open SQL Command Window → Go to the "Tools" menu. Select

"SQL..." to open the SQL command window.

Step 4: Create the Employee Table Using SQL→ Enter the SQL command to
create the employee table:

CREATE TABLE Employee (

EmpID INT PRIMARY KEY,
EmpName VARCHAR(50),
Department VARCHAR(50),
Salary FLOAT
);
Step5: Click "Execute" to run the command

Step 6: Confirm the Table Creation→Close the SQL command window. Go

to the View Click the sub menu Refresh table. "Tables" section to see the
newly created "Employee" table.

Step7: Enter and execute the following SQL commands to insert data into the
employee table.
Insert into Employee values(101,’anu’,’Police’,15000);
Insert into Employee values(101,’anu’,’Police’,15000);
Insert into Employee values(101,’anu’,’Police’,15000);

Step8: Click "Execute" to run the command

12
Step 6: Confirm the inserted values to the table→Close the SQL command
window. Click table from database→ Go to the "Tables" section and
double-click on the "Employee" table to view the inserted data.

Step7: Retrieving Records from the Employee Table.

Step 8: Select Queries from Database→Go to the "Queries" section in

OpenOffice Base→ Click on "Create Query in SQL View".

Step 9: Write and Execute a Query→ SELECT * FROM Employee;

Step 10: Run the query → Click on "Run Query" from the interface or press the F5 key.

Step 11: Save the query from the interface or by pressing Ctrl+S.
Step 12: The output of the query will appear.
Step 13: Take a printout and attach it to your report file.

Result:
Thus, the employee table was created and data was inserted, records were
retrieved successfully using SQL commands in OpenOffice Base.

13
Program10:
Creating Form in a Database
Aim:
To create a table and form in a database, insert records using the form, and
display the inserted records in OpenOffice Base.

Procedure:
Step 1: Open OpenOffice Base

1. Open OpenOffice Base application.

2. Create a new database or open an existing one.

Step 2: Create the Employee Table Using Design View

1. Go to the "Tables" section.

2. Click on "Create Table in Design View".
3. Define the table structure with the following fields:
o EmpID: Integer [Primary Key]
o EmpName: Text [VARCHAR]
o Department: Text [VARCHAR]
o Salary: Number [FLOAT]
4. Save the table with the name "Employee".

Step 3: Confirm the Table Creation

1. Ensure the "Employee" table is visible in the "Tables" section.

Step 4: Create a Form to Insert Records

1. Go to the "Forms" section.

2. Click on "Create Form in Design View".
3. Design the form by adding fields corresponding to the columns in the
"Employee" table: EmpID, EmpName, Department, Salary.
4. Save the form with a suitable name, for example, "EmployeeForm".

Step 5: Insert Records Using the Form

1. Open the form you created.

14
 2. Enter the data into the form fields. For example:
o EmpID: 101
o EmpName: Anu
o Department: Police
o Salary: 15000
3. Save the record. Repeat this step to insert multiple records.

Step 6: Confirm the Inserted Records

1. Close the form.

2. Go to the "Tables" section.
3. Double-click on the "Employee" table to view the inserted records.

Step 7: Retrieving Records from the Employee Table

1. Go to the "Queries" section in OpenOffice Base.

2. Click on "Create Query in SQL View".
3. Write the following SQL query to retrieve all records from the employee
table

SELECT * FROM Employee;

4. Click "Run Query" (the green check mark button) to execute the query.
5. The results of the query will be displayed, showing all records from the
employee table.

Result:

Thus, a table was created using design view, a form was created in the
database, records were inserted using the form, and the inserted records
were successfully displayed.

15
Program11:
Creating a Blog Website
Aim:
To create and write content in a blog website.

Procedure:

Step 1: Open our browser and type www.blogger.com in the address bar.
Step 2: Click on create our Blog button or sign in button. Enter username and
password for our Google Account.
Step 3: Give the appropriate title for our blog and click on Next.
Step 4: Now choose an appropriate URL for our Blog. Click on Next.
Step 5: Now type display name for our blog and the setup is completed.
Click on Finish Button→ The blog is ready to add the contents.
Step 6: Click on page option→ The New Post button will change to NEW
PAGE. Click on it.
Step 7: Now the new page interface will open. Give appropriate Title for our
page and insert contents like text and images.
Step 8: When we finish content typing and all, then click on Finish Button.
Step 9: Take a printout and attach it to your report file.

Result:

Thus, a blog website was created, and content was written and published
successfully.

16