Session:2024-2025

-
NOTRE DAME OF HOLY CROSS SCHOOL,SALEM

CONTENTS

S.No. Date Topic Marks Teacher's

Signature
1 Drawing
objects
2 Table of
Contents
3 Templates
4 Applying Styles

5 Font formatting
6 Fill format mode
7 Subtotal

8 Consolidate
9 Scenario
10 Hyperlinks

11 Multiple
operations
12 Goal seek

13 Forms

14 Tables

15 Reports
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

1. Create Drawing Objects and Perform the Following Objects in

Libre Office:
(i) Coloring
(ii) Two Graphical Properties

AIM:
To Color and apply two graphical properties for drawing objects

PROCEDURE:
Step1: Open, Libre Office writer. In that Click "Symbol Shapes"
which is shown below.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step2: Click suitable object you want as shown below.

[Your opinion to choose any object]

COLORING:
Step 1: To color the object, select the object which you want to color.
Step 2: Click On Fill Color Option on 'Properties' toolbar
Step 3: Select your color of your own.
Step 4: It gets colored as shown below.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

2. GRAPHICAL PROPERTIES

Step 1: For Graphical Properties select the object which you want to
apply graphical Properties.
Step 2: Click "Style" > Properties option as shown below.

Step 3: Click Style option and choose your style as of your wish.
Step 4: Click 'start' and end arrowheads for lines option in
Properties Toolbar.
Step 5: Select your Arrows as of your wish.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

2. Create a table of content and Perform the Following Functions.

i. Apply styles
ii. Change color
AIM:
To apply styles to the table of contents
PROCEDURE:
Step 1: Create a table of content and right click anywhere on the TOC
[table of contents] and choose edit option from the pop-up menu.

Step 2: Table of contents, index or bibliography dialogue box appears,

choose desired style from the style tab
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 3: Click on OK BUTTON, the style gets applied.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT:
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

AIM:
To change the color of table of contents.

PROCEDURE :

Step 1: Right click anywhere on the TOC [table of contents] and choose
edit option from the pop-up menu.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 2: Table of contents, index or bibliography dialogue box appears,

choose the desired color in the background tab, from the color palette.

Step 3: click OK BUTTON. The color gets changed.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT:
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

3. Creating a Template

AIM:
To create a template using Libre Office writer.
PROCEDURE:

Step 1: Open the document in Libre Office Writer whose

template is to be created.

Step 2: From main menu bar, select File > Templates > Save. The Save
As Template dialog box appears as shown below.
Step 3: Type the name of the new template (IT ASSIGNMENT 1) in
Template Name text box.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

From main menu bar, select File>Templates >Manage Templates.

The template dialog box as shown below.

Step 4: Select the category of the template being created. A

category is just like a folder.
Step 5: Click Save button to save the template.
Step 6: From the main menu bar of Libre Office Writer, Select
File>Templates>Manage Templates.
Step 7: Templates dialog box will be displayed as shown in the
below figure. Observe the small circular icon Browse Online
Templates in the lower left corner above the Help button.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 8: Click on Browse Online Templates button on the bottom

left of the Templates window the official templates page of Libre
Office Writer (https:// extensions.libreoffice.org/templates)will
Open in the browser as shown in the figure.

FINAL OUTPUT:
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

4. Create the header with your name and a footer with the page no.

AIM:
To create the header and footer.

PROCEDURE:
Before you insert chapter information into a header or footer, you
must first set the chapter numbering options for the paragraph style
that you want to use for chapter titles.

1. To Prepare a Paragraph Style for ‘Your Name’

Step 1: Choose Tools - Chapter Numbering tab.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 2: In the Level box, select the given level which we need from
the following example.

Step 3 : In the Paragraph style box, select the paragraph style that
you want to use for ‘your name’, for example
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:
Step 4: Click OK.

FINAL OUTPUT:
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:
2. To Insert the Chapter Name and Number in a Header or a Footer

Step 1: Apply the paragraph style that you defined to ‘your name’ in
your document.

Step 2: Choose Insert - Header and Footer – use header/footer

menu and then select the page style for the current page from the sub-
menu.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:
Step 3: Click the header or footer.

Step 4 – Type your name in the header and the page no. in the footer.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT

The header on every page that uses the current page style
automatically displays the name and number.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

5. Use the formatting tools to change the font, size and

color of the text.
AIM:
To change the font, size and color of the text.

PROCEDURE:

1. Changing Font and Size

Step 1: Select the text you want to format.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 2: Select the ‘Format’ tab present on the ‘Menu Bar’

Step 3: Now, select the Character option form the drop-down list. The
Character dialog box appears.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 4: Select the character styles for the text. For example, select
the desired font name and font size from font and size tab
respectively. For example, (Calibri, 15 pt.)
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

2. Changing Color

Step 1: Select the text you want to format.

Step 2 – Select the Font Color icon from the Menu Bar.

Now, the color of the text is changed, you can also change the color as
desired.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT

The font, size and color of the text has been changed.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

6. Use fill format to change the appearance of paragraphs at

different places in the document using Paragraph formatting.
AIM:
To use fill format to change the appearance of paragraphs.

PROCEDURE:
Step 1: Open the document that needs to be formatted in Libre Office
Writer.

Step 2: Select Styles and click on New Style from the selection.

Step 3: New style from selection dialog box will appear.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 4: Select list paragraph and click OK.

Step 5: Select fill format mode.

Step 6: Select the desired paragraph style and click on the paragraph
that needs to be formatted.

Step 7: The selected style will be applied to the paragraph.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

7. RPS Distributers distributes product in different areas.

Calculate the area wise distribution of products using
SUBTOTAL in Libre Office calc .
AIM:
To calculate subtotal according to the given question.
PROCEDURE:

Step: 1- Open, Libre Office calc and input the values in the
spreadsheet.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 2: Select the range of cells which you want to subtotal

Step 3: Select the DATA > SUBTOTALS option from the menu
bar.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 4: Fill the box with a tick mark and choose the operation to
Subtotal.

Step 5: Click OK .
FINAL OUTPUT
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

8. To Consolidate the Data

AIM:
To Consolidate the data on sales figures of three regions in three
separate sheets to find the total sales figures.

PROCEDURE:

Step 1: Open the worksheet of sheet 1, sheet 2 and sheet 3 which contains
the cell ranges to be consolidated.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 2: Click DATA > Consolidate

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 3: Click on ‘copy results to’ area box to give the target cell
range.

Step 4: Click on more button and then click link to data source check
box.
Step 5: Click on OK button to consolidate the ranges.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

9. Creating a scenario to get the insight of the EMI, Total amount

paid and total interest paid on the loan amount taken for a fixed
Rate of Interest for a number of time period.
AIM:
To prepare a scenario to get the insight of the EMI, Total amount paid
and total interest paid on the loan amount taken for a fixed Rate of
Interest for a number of time period.

PROCEDURE:
STEP 1: Create the following sheet and remember to put the following
formulas
To calculate EMI in B3 -=ABS(PMT(B2/1200,E1*12,B1))
To calculate Total amount in B4 - =B3*E1*12
To calculate Total interest in B5 - = B4-B1
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

STEP 2: Select the cells B1 and E1 using Ctrl+Click on these cells as

these two are the variables in this situation.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

STEP 3: Choose Tools > Scenario will display the create scenario
dialog window as shown below.

Step 4: Write the name of the Scenario and click on OK button will
add this in the scenario List. Here we have given the name as
test scenario.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 5: Let us create two more scenarios as test scenarios 2 and

test scenarios 3 with loan Amount as 2000000, No. of years
as 15 and Loan amount as 2500000, No. of years as 20
respectively. We can define different scenarios to do so on
the same sheet, each with some different values in the
defined cells. Click on tools >scenario, write the name of
the scenario and click on OK. The loan sheet will look like
as shown below.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 6 : Click on the navigator icon in the toolbar and then click
scenarios. Clicking on the scenario name will display all
details as per that scenario.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Here you can see the names of all 3 scenarios that we have created

FINAL OUTPUT

The results displayed as per the scenario name is shown below for all
scenarios we created
Test scenario 1:
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:
Test Scenario 2:

Test Scenario 3:
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

10. Create new document with hyperlink.

AIM:
To create new document using hyperlink

PROCEDURE:
Step 1: Open Libre Office Calc and select the cell where you want to
create hyperlink.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 2: Click insert and choose hyperlink

Step 3: Select new document and click select path to store the
location of the new file.

Step 4: Click Ok
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 5: Select the desired file type and give name for the text name.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

11. Calculate Simple Interest using one variable using multiple

operations in the Libre Office Calc.
 Interest for different amount [one variable]
AIM:
To Calculate Simple Interest using one variable by using multiple
operations.
PROCEDURE:
Step 1: Give your data for Principal Amount, Rate of Interest and
No. of. Years.

Step 2: To calculate Simple Interest use the formula

=(P*N*R)/100 [if % not written]
or
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

=(P*N*R) [if % written]

Note: Give P, N and R cell reference not P, N and R.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 3: Simple Interest appears.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 4: Use Auto fill method by dragging for other data.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

12. To Find Goal Seek

AIM:
To find the unknown mark of 5th subject through goal seek.

PROCEDURE:
To determine the unknown mark.
Step 1: Open Libre Office Calc from your computer.

Step 2: Input the marks for the first four subjects into the spreadsheet
as shown in the table.

Step 3: Calculate the Average: In the cell below the marks (e.g., Cell
B7), use the formula `=AVERAGE(B2:B6)` to calculate the average.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 4: Open Goal Seek: Navigate to Tool> Goal Seek in your

spreadsheet application.

Step 5: Set Target Value: In the Goal Seek dialog box:

- Set the cell with the average formula as the 'Set cell' (e.g., Cell B7).
- Set the target value to 70.
- Select the cell corresponding to the 5th subject’s marks (e.g., Cell
B6) as the variable to adjust.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 6: Run Goal Seek: Click 'OK' to let Goal Seek calculate the
required marks in the 5ᵗʰ subject
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

13. Libre Office Base (Form)

AIM:
Create a form using wizard.
PROCEDURE:
Step 1: Click Use Wizard to create a Form in forms.
Step 2: Give your table queries and click option and click next.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 3: Don’t select anything to set sub forms and give next.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 4: Give your alignment and click next.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:
Step 5: Select the form is to display all data and click next.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 6: Give your field border and apply your styles and give next.

Step 7: Set your form name and choose modify the form.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

14. To Create Table using Design View Libre Office Base

i. Create a Student table with attributes Roll no, [ set Primary
key], Name, Class and Total using SQL.
ii. Insert records into the Student table.
iii. Display all records.
AIM:
To create a Student Table by performing the following operations.
PROCEDURE:
Step 1: Click Create Table in design view in Tables.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 2: Give Roll no. in the field name and change text (varchar)
into Number (numeric). Right click the green arrow and choose
Primary key.

Step 3: Give name and Class in the next field names and keep as text
(varchar).
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 4: Give total at last field name and change text (varchar) to
Decimal (decimal).
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 5: Save the database.

 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

ii. Open your database and give your data.

FINAL OUTPUT
iii. In my data I have done four records. If you need to see one by one, click next arrow
at the bottom of 1,2,3 of 4.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

15. Libre Office Base (Report)

AIM:
To generate a report using wizard.
PROCEDURE:
Step 1: Click Use Wizard to create a Report in Reports.
Step 2: Choose your Table or queries in Field Selection and click ->
option. Then click next.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 3: Check your labels in the labeling fields and click next.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 4: If you want to group, group by clicking > option or else click
next.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 5: Sort your data on your wish by ascending or descending and

click next.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 6: Choose your layout or else keep as default. After choosing

click next.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

Step 7: Give your report a Title, choose your kind of report a Static
or Dynamic and choose Create report view.
 NOTRE DAME OF HOLY CROSS SCHOOL
Date: Page No:

FINAL OUTPUT