SIVANANDA RAJARAM SENIOR SECONDARY SCHOOL

(Affiliated to CBSE Board, Affiliation No: 1930754)

INFORMATION
TECHNOLOGY
SUBJECT CODE: 402
 TABLE OF CONTENTS
1. CREATE AND APPLY STYLES IN DIGITAL DOCUMENT .................. 2

2. WORKING WITH IMAGES IN DIGITAL DOCUMENT ........................ 4

3. CREATE AND USE TEMPLATE .............................................................. 6

4. CREATE TABLE OF CONTENTS ............................................................ 7

5. WORKING WITH MACROS IN LIBREOFFICE WRITER .......... Error!

Bookmark not defined.

6. CONSOLIDATING DATA ......................................................................... 9

7. OUTCOME SUBTOTAL .......................................................................... 10

8. CREATING CELL REFERENCING IN SPREADSHEET ...................... 11

9. HYPERLINK IN SPREADSHEET .......................................................... 12

10. GOAL SEEK ........................................................................................... 14

11. CREATE AND EDIT TABLES USING WIZARD................................. 15

12. RETRIEVE DATA USING QUERY ....................................................... 16

13. QUERY USING CRITERION AND SORTING .................................... 20

14. CREATE FORMS USING WIZARD ..................................................... 21

15. CREATE REPORTS USING WIZARD ................................................. 22

1
 PROGRAM 1
CREATE AND APPLY STYLES IN DIGITAL DOCUMENT

AIM:

To create and apply custom styles in LibreOffice Writer to format a

document systematically.

PROCEDURE:

Preparing document
Step1. Click on Start > All Apps > LibreOffice 24.2 > LibreOffice Writer.
Step 2. Type required text.
Creating styles
Title (Using Drag and Drop)
Step 1. Select the title “Generative Artificial Intelligence”.
Step 2. Apply the desired formatting.
Step 3. Now click on Styles > Manage Styles option.
Step 4. Select the title “Generative Artificial Intelligence” and drag over the
Styles pane present on the screen.
Step 5. New Style from Selection dialog box will appear with a prompt to enter
New Style Name. Type name as “Title AI”. Step 6. Click on OK button.
Headings (Create Style using New Style from Selection option)
Step 1. Select first heading – “Introduction”.
Step 2. Apply the desired formatting for style as per instructions given in the
question.
Step 3. Click on Styles > Manage Styles option. A styles pane will appear.
Step 4. Click on Style Actions button and choose New Style from Selection
option.

2
Step 5. New Style from Selection dialog box appears. Type Style name as –
“My Heading”.
Step 6. Click on OK.
Applying Styles

➢ Using double click

Step 1. Select the heading “Technology”.
Step 2. Now Find the newly created styles “My Heading”.
Step 3. Double Click on it.

➢ Using Fill Format

Step 1. Click on Fill Format icon on Styles pane.
Step 2. A fill format mode will be activated and mouse cursor changes to Fill
Format mode icon.
Step 3. Select “My Heading” style from Styles pane.
Step 4. Drag it over to the headings to apply “My Heading” style.
Step 5. Save the file as “Practical 1 – Create and apply styles”.
Load styles
Step 1. Open new blank document.
Step 2. Activate Styles pane from side bar or any other option.
Step 3. Click on Style Actions button and choose “Load Styles from Template”.
Step 4. Find the button From File and click on it.
Step 5. Choose the previously saved file.
Step 6. Click on Open button.
Step 7. The styles from selected document will be added into the Style gallery.
Step 8. Save the file.
RESULT:
The document was successfully formatted using predefined and custom
styles, improving readability and presentation.

3
PROGRAM 2

WORKING WITH IMAGES IN DIGITAL DOCUMENT

AIM:

To insert and manipulate images, shapes, and text in LibreOffice Writer to

create an advertisement.

PROCEDURE:

Add Page background

Step 1. Open LibreOffice Writer and Background from Format > Page Style >
Area > Gradient.
Step 2. Choose Sundown gradient for page background and Click on Apply and
OK.
Add Page border
Step 1. Click on Format > Page Style > Borders.
Step 2. Click on All four borders option.
3. Choose the line style from Style.
Step 4. Click on Apply and OK button.
Add font work
Step 1. Click on View > Toolbar > Drawing.
Step 2. Click on Insert Font Text icon from the Drawing Toolbar.
Step 3. Select Gold Wave style.
Step 4. Type the text Learn Coding and change color.
Step 5. Press enter when you finished.
Add font work (Alternative method)
Step 1. Click on Insert Font Text icon from the Drawing Toolbar.
Step 2. Select relevant style for Font Text.
Step 3. Type the desired text and change the color.

4
Step 4. Press enter when you finished.
Insert Image
Step 1. Place the cursor where image is required.
Step 2. Click Insert > Image option. An Insert Image dialog box will appear.
Step 3. Select the image from the dialog box.
Step 4. Click on open button.
Applying border to image
Step 1. Select an image to apply border.
Step 2. Click on Borders icon on the Image toolbar and select Outer Border
(Only).
Add Textbox to insert courses
Step 1. Select rectangle box from Drawing toolbar.
Step 2. Draw the rectangle in the document.
Applying background colour to box
Step 1. Select the box.
Step 2. Choose the Fill Colour icon from drawing properties toolbar.
Step 3. Select Yellow color from the Fill Colour icon.
Step 4. Add the desired text. Similarly add remaining shapes, apply the desired
formatting and text. Save the file.
RESULT:
An advertisement was successfully created by incorporating images, text
effects, and shapes in LibreOffice Writer.

5
 3 CREATE AND USE TEMPLATE

AIM:

To create a reusable document template in LibreOffice Writer for standardized

formatting.

PROCEDURE:

Step 1. Create a new document in LibreOffice Writer.

Step 2. Click on Format > Page Style option.
Step 3. A page style dialog box will appear.
Step 4. Select Area > Image > Add/Import option.
Step 5. Apply desired options for background and click on OK button.
Step 6. Insert table for time table and format it as per your choice.

Saving file as template

Step 1. Click on File > Templates > Save as Template option.
Step 2. A Save As Template dialog box will appear.
Step 3. “Time Table ” as Template Name in Enter Template Name dialog box.
Step 4. Select Template Category as MyTemplate.
Step 5. Click on Set as default template option.
Step 6. Click on Save button.

Reset default template

Step 1. Click on File > Templates > Manage Templates option.
Step 2. A manage template dialog box will appear.
Step 3. Click on Manage > Reset Default Text Document option.

6
Step 4. Click on Close button.

RESULT:

A template was successfully designed and saved for future use, enabling
consistency in document formatting.

PROGRAM 4

CREATE TABLE OF CONTENTS

AIM:

To generate a structured table of contents using headings in LibreOffice

Writer.

PROCEDURE:

Step 1. Type the contents.

Step 2. Apply appropriate level of headings from the Styles window.
Step 3. Place the cursor at the beginning of document to insert Table of
Content.
Step 4. Click on Insert → Table of contents and index → Table of contents,
index or Bibliography option. The Table of contents, index or Bibliography
will appear.
Step 5. Select and apply the styles for the Table of Contents. 3. Click on OK.
RESULT:
A dynamic Table of Contents was successfully created, allowing quick
navigation through the document.

7
 5. CREATING AND GROUPING DRAWING OBJECTS

AIM:

To create two or more drawing objects and group them into a single object.

PROCEDURE:

Step 1. Open a Writer document where you want to draw an object.

Step 2. Select the required shape from the Drawing toolbar.
Step 3. The mouse pointer changes to a drawing-function pointer.
Step 4. Draw two or more drawing objects.
Step 5. Click on the Select tool on the Drawing toolbar.
Step 6. Drag it over the objects to select them.
Step 7. Once all the objects are selected, click on the Group button on the
Drawing Object Properties toolbar.
Step 8. All the selected objects will be grouped.

RESULT:
Thus, the drawing objects were created and grouped successfully.

8
 PROGRAM 6

CONSOLIDATING DATA

AIM:

To consolidate data from multiple worksheets into a single summary sheet in

LibreOffice Calc.

PROCEDURE:

Preparing sheets for Data Consolidation

Step 1. Create a new file in spreadsheet software and enter data for 5 products.
Step 2. Add two worksheets in the file and modify the data for all. Click on
Sheet tab and + icon there,
Step 3. Rename all worksheets like sheet1 - Ahmedabad, sheet2 - Surat and
sheet3 - Rajkot. Select the sheets respectively and do right click on Sheet tab >
Rename Sheet option, Type the sheet name and Click on OK button.
Step 4. Now add one more worksheet at the end and rename as Consolidated as
similar as step 2 and 3.
Perform Data Consolidation
Step 1. Place the cursor in cell B2 in Consolidated sheet.
Step 2. Click on Data > Consolidate option.
Step 3. The Consolidate dialog box will appear.
Step 4. Choose the Sum function.
Step 5. Select Data Source ranges respectively and click on Add button.
Step 6. Click on OK button.

RESULT: Data from different sheets was successfully merged into one
consolidated report using the Data Consolidation tool.

9
 PROGRAM 7

OUTCOME SUBTOTAL

AIM:

To use the Subtotal function in LibreOffice Calc to categorize and summarize

data.

PROCEDURE:

Step 1. Open spreadsheet software and enter the data.

Step 2. Select the data.
Step 3. Click on Data → Subtotal. The Subtotal dialog box appears. Step
4. Select column Project Name in Group By option.
Step 5. Now mark the column to Days Required to count the no. of days
required for each project.
Step 6. Select the sum function sum from Use Function option.
Step 7. Click on OK button.
RESULT:
The subtotal function was successfully applied, providing an organized
summary of grouped data.

PROGRAM 8

10
 CREATING CELL REFERENCING IN SPREADSHEET

AIM:

To link and reference data across multiple worksheets in LibreOffice Calc.

PROCEDURE:

Step 1. Open LibreOffice Calc and create a new workbook.

Step 2. In the first worksheet, enter the data.

Step 3. Right-click on the sheet tab (usually named “Sheet1”).

Step 4. Select “Rename” and change the name to “Student Profile”.

Step 5. Insert three new worksheets by clicking the “+” icon at the bottom.

Step 6. Rename them to “PT1”, “PT2”, and “PT3” respectively.

Step 7. Go to the “PT1” worksheet.

Step 8. In cell A1, type =Student Profile!A1 to reference the Roll No from the
“Student Profile” sheet.

Step 9. Drag the fill handle to copy the formula down for all 10 students.

Step 10. Repeat the process for First Name and Last Name columns.

Step 11. Go to the “PT2” worksheet.

Step12. Click on cell A1, type =, then navigate to the “Student Profile” sheet
and click on cell A1. 15

Step 13. Press Enter to create the reference.

11
Step 14. Drag the fill handle to copy the formula down for all 10 students.

Step 15. Repeat the process for First Name and Last Name columns.

Step 16. Go to the “PT3” worksheet.

Step 17. You can use either the keyboard or mouse method to create references
for Roll No, First Name, and Last Name columns from the “Student Profile”
sheet.

RESULT:
Cell references were successfully created, enabling dynamic updates
between sheets.

PROGRAM 9

HYPERLINK IN SPREADSHEET

AIM:

To insert and manage hyperlinks to external websites, email addresses,

and local files in LibreOffice Calc.

PROCEDURE:

Insert Hyperlink from the internet

Step 1. Type the text – NCERT Solution IT Class 10.
Step 2. Click on Insert > Hyperlink option. Hyperlink dialog box will open.

12
Step 3. Click on Internet and type the URL.
Step 4. Set the behaviour of link by selecting frame and target.
Step 5. Click on OK button.

Insert Hyperlink Email

Step 1. Type the text – Gmail in the cell.
Step 2. Click on Insert > Hyperlink option.
Step 3. Select Mail option.
Step 4. Type the recipient mail id in Recipient box.
Step 5. Type Subject in Subject box.
Step 6. Set the behaviour of link by selecting Frame, Target and Name.
Step 7. Click on Apply and OK button.

Insert hyperlink of existing file

Step 1. Type the text: File – Document
Step 2. Click on Insert > Hyperlink option.
Step 3. Choose Document button.
Step 4. Select the file from Path option. Either type the path or select the file
using browse button.
Step 5. Set target of link.
Step 6. Apply settings required such as Frame, Name and Text. 17
Step 7. Click on Apply and OK button.

Inserting Hyperlink of New Document

Step 1. Type the Text – New Document.
Step 2. Select option as Edit Now.
Step 3. Type Filename in File box.

13
Step 4. Select File Type as Text Document.
Step 5. Apply settings such as Frame, Name etc.
Step 6. Click Apply and OK button.
RESULT:

Various types of hyperlinks were successfully added, allowing easy

navigation between documents and web resources.

PROGRAM 10

GOAL SEEK

AIM:

To use the Goal Seek tool in LibreOffice Calc to determine the required
value for achieving a target result.
Month Gross Profit Net

April 20000 12% 2400

May 30000 14% 4200

June 40000 11% 4400

July 25000 15% 3750

August 35000 18% 6300

Total 21050

PROCEDURE:

Step 1. Enter data and prepare the spreadsheet along with formula.
Step 2. Place the cursor in D7 cell.

14
Step 3. Click on Tools > Goal Seek option. The Goal Seek dialog box will
appear.
Step 4. Move the cursor in Target Value box and enter the value – 23000.
Step 5. Now select the cell as a variable cell.
Step 6. Click on OK.
Step 7. It will display the value obtained by Goal seek. If you wish to insert it in
the spreadsheet click on Yes, otherwise No.

RESULT:

Goal Seek was successfully applied to modify values dynamically to

achieve the desired financial target.

PROGRAM 11

CREATE AND EDIT TABLES USING WIZARD

AIM:

To create a database table using the Table Wizard in LibreOffice Base.

PROCEDURE:

Step 1. Click on Start → All Programs → LibreOffice 24.2 → LibreOffice

Base. 24.2 LibreOffice Base window will open with Database Wizard.
Step 2. Click on Create a new database option.
Step 3. Click on Next button.
Step 4. Select the database Register option either Yes, or No.
Step 5. Check on Open database for editing.
Step 6. Click on Finish button.

15
Step 7. It will prompt to save the database.
Step 8. Type the desired name and save it. I have given db1.
Step 9. Now click on Tables button from Left pane and choose the option - Use
Wizard to Create Table… from the tasks window.
Step 10. The Table Wizard will open. Follow wizard steps to create a table.
Step 11. In first step of wizard select the Category either Business or Personal.
Step 12. Now choose a table from list of table. As I have selected Employees
table.
Step 13. Click on Next and select field types and all if you want to change it.
Click on Next. I have selected EmployeeID, Firstname, Lastname, Salary,
Datehired.
Step 14. Set a primary key for your table in this step. Click on Use an existing
field as a Primary Key. I have selected EmployeeID as Primary key. Click on
Next.
Step 15. If you wish to change the table name then type new name for the table
and click on Insert. 20 Data immediately, and click on Finish.
Step 16. Enter data now.

RESULT:

A database table was successfully designed, created, and populated with

structured data.

PROGRAM 12

RETRIEVE DATA USING QUERY

AIM:

16
 To retrieve and manipulate data from a database using SQL queries in
LibreOffice Base.
Field_Name Data_Type Size
Stud_No Integer 2
Name Text 15
RollNo Integer 3
Sub101 Decimal 3,2
Sub102 Decimal 3,2
Sub103 Decimal 3,2

PROCEDURE:

Step 1. In the Database file Add these Fields: (Total: Datatype- Number 3 digits,
Percentage: Datatype - Number 3 digits with 2 decimal places, Grade: Datatype-
Char with 2 letters)
Step 2. Insert more 3 records in MARKSHEET using SQL mode.
Step 3. Display name, rollno, marks of 3 subjects, total and percentage using
design view.
Step 4. Display name, rollno, grades from the marksheet table using query
wizard.
Step 5. Display the maximum marks for Sub101 and minimum marks for
Sub102 using design view.
Step 6. Display the rollno, name and percentage whose percentage are more
than 70 using design view.
Step 7. Display all the record in ascending order of names using design view.

create table “marksheet” (

“Stud_no” tinyint primary key,

“Name” varchar(15),

17
“RollNo” tinyint,
“Sub101” decimal(5,2),
“Sub102” decimal(5,2),
“Sub103” decimal(5,2)) ;

Queries
Add Columns
Step 1. Click on Tools → SQL option.
Step 2. Add column Total → alter table "marksheet" add column "Total" tinyint
Step 3. Add column Percentage → alter table "marksheet" add column
"Percentage" decimal(5,2)
Step 4. Add column grade → alter table "marksheet" add column "Grade"
char(2)
Step 5. Click on Execute button.
Step 6. Click on Close button.

Insert records
Step 1. Click on Tools > SQL option.
Step 2. insert into "marksheet" values (101, 'Sagar', 105, 27, 25, 28, 80 , 88 ,
'B1')
Step 3. Click on Execute button.
Step 4. Close the window.
Step 5. Click on View > Refresh Tables option to update data into the table.

Steps to perform a query using design view

Step 1. Click Queries → Create Query in Design View….
Step 2. The query design window will open.

18
Step 3. Select the marksheet table and click on Add button.
Step 4. Now select fields given in the question like name, rollno, marks,Sub101,
Sub102, Sub103, Total and Percentage.
Step 5. Save the query.
Query Wizard Steps
Step 1. Click on Queries → Use Wizard to Create Query… Step
2. Query Wizard opens.
Step 3. Select the table marksheet and select the fields given the question.
Step 4. Click on finish.

Design View
Display maximum marks and minimum marks for the fields given in the
question, using design view.
Step 1. Click Queries → Create Query in Design View….
Step 2. The query design window will open.
Step 3. Select the marksheet table and click on Add button.
Step 4. Now select the field Sub101 and Sub102.
Step 5. Choose the function maximum under Sub101 and Minimum under
Sub102.
Step 6. Save the query and check the result.
RESULT:

Data retrieval and filtering were successfully performed using SQL

queries.

PROGRAM 13

19
 QUERY USING CRITERION AND SORTING

AIM:

To execute database queries with specific conditions and sorting in

LibreOffice Base.

PROCEDURE:

Step 1. Click Queries → Create Query in Design View….

Step 2. The query design window will open.
Step 3. Select the marksheet table and click on Add button.
Step 4. Select columns given in the question i.e. Rollno, Name and Percentage.
Step 5. Type >70 in the front of criterion under the percentage field.
Step 6. Save the query and check the result.

Display all the record in ascending order of names using design view.
Step 1. Click Queries → Create Query in Design View….
Step 2. The query design window will open.
Step 3. Select the marksheet table and click on Add button.
Step 4. Select markesheet.* and name in the column list.
Step 5. Select sort → ascending under name field.
Step 6. Now click on Visible checkbox to hide the name column in result.
Step 7. Save the query and check the result.

RESULT:

Queries were successfully executed to filter and sort data based on

specified criteria.

20
 PROGRAM 14

CREATE FORMS USING WIZARD

AIM:

To design a user-friendly form for data entry in LibreOffice Base using

the Form Wizard.

PROCEDURE:

Steps to create a form using wizard

Step 1. Click on Forms → Use Wizard to Create Form…
Step 2. A Form Wizard appears.
Step 3. Select the table from Tables or Queries then add all the fields.
Step 4. Click on Next button. Ignore step 3 and step 4 from wizard.
Step 5. Select the first option i.e. Columnar – Labels Left then click on the
next button.
Step 6. Now set data entry step will be there. Ignore this step and click on
Next. Choose the styles for the form interface and click on next.
Step 7. Type new name for the form and click on work with the form.

Step 8. Click on Finish

21
RESULT:

A structured form was successfully created, simplifying data entry and

retrieval.

PROGRAM 15

CREATE REPORTS USING WIZARD

AIM:

To generate a formatted report from a database table using the Report

Wizard in LibreOffice Base.

PROCEDURE:

Step 1. Click on Reports → Use Wizard to Create report. The report wizard
will open in the new window.
Step 2. Select the table and add fields.
Step 3. Now change the label text that you want in the report. I have
changed the label Stud_no into Adm. No. Click on Next.
Step 4. I have skipped groping and sorting options by click on Next button.
Step 5. Now choose the layout. I have selected Columnar, Single Column as
Layout of Data, Landscape Orientation and Click on Next.

Now type the title of the report and select dynamic report → Create report
now option.

22
 Step 6. Now click on finish.

RESULT:

A Professional report was successfully generated, presenting data in a

structured format.

23