PRACTICAL FILE
SESSION (2025-26)
SUBJECT-INFORMATION TECHNOLOGY (402)
Submitted To:
Submitted by :
Class & Sec
Roll No
Content
[Link] Aim
1.
Create and apply different types of Styles in LibreOffice Writer .
2.
Applying Styles Using Fill Format Mode
3. Create a brochure of any tourist place near you using different images of it and using
different
image formatting options available in LibreOffice writer.
4. Create, update, and customize a Table of Contents (TOC) in LibreOffice Writer.
5. Create a certificate for any competition held in school using any template available in
LibreOffice
Writer.
6. Create a consolidated sheet for the two data sheets given in LibreOffice Calc.
7. Create a Subtotal of the a data sheet given in Libre Office Calc.
8. Create three different scenarios of a data given in Libre Office Calc.
9.
Create a table in a database in LibreOffice Base using Wizard .
10. Create a form using wizard by selecting all the fields for the table - Marksheet
PRACTICAL- 1
Aim of the practical:-
Create and apply different types of Styles in LibreOffice Writer .
Activity:-
Write a paragraph and give it a header of your choice and use all types of styles available in
LibreOffice Writer like(page styles, paragraph styles, character styles etc.) to make it look
attractive.
Styles in LibreOffice Writer:-
A style is a set of formats that you can apply to selected pages, text, frames, and other
Elements in our document to quickly change their appearance. When you apply a style, We
apply a whole group of formats at the same time. Styles help improve consistency in a
document. They alsomake major formatting changes easy.
Applying Styles in LibreOffice Writer:-
Using Styles option from menu bar.
Use Style Drop Down List box
Using Fill Format mode
Creating new (custom) styles
Loading styles from a template or document
Creating a New Style from Selection
Step 1: Format Your Text
Step 2: Create the New Style
1. Select the Formatted Text:
Highlight the text that has the formatting you want to save as a new style.
2. Open the Styles Sidebar:
Press F11 or go to View > Styles to open the Styles and Formatting sidebar.
3. Create the New Style from Selection:
In the Styles sidebar, click on the appropriate icon (e.g., Paragraph Styles for
paragraph formatting).Click on the New Style from Selection button (it looks like a
green arrow pointing to a document) at the top of the Styles sidebar.
o In the drop-down menu, select New Style from Selection.
4. Name the New Style:
o A dialog box will appear asking for the name of the new style.
o Enter a name for your new style (e.g., MyCustomStyle).
o Click OK to save the new style.
Steps to apply Styles in LibreOffice Writer:-
For applying any styles, such as Paragraph, Character, Frame, Page, List, Table follow the
given steps:
Step 1. Select the text to be formatted. The selected text may be a collection of characters,
words, lines, paragraph, page, frame or table.
Step 2. To format the selected text, choose appropriate style by clicking the button from the
top of the Styles bar.
Step 3. A list of styles for that category appears. Double click on the desired style to apply
to the selected text.
PRACTICAL- 2
Aim of the practical:-
Applying Styles Using Fill Format Mode
Objective:
Learn how to quickly apply styles to text in a document using the Fill Format Mode.
Fill Format Mode:
Fill Format Mode is a powerful tool in LibreOffice Writer that allows you to apply styles
quickly and efficiently to different parts of your document.
Steps to apply Fill Format Mode:
Step 1: Open LibreOffice Writer: Start by opening LibreOffice Writer.
Step 2: Create a New Document: Create a new document or open an existing one.
Step 3: Open the Styles Window: Go to View > Styles or Press F11 to open the Styles
window.
Ste 4: Select a Style: In the Styles window, click on the style category you want to apply (e.g.,
Paragraph Styles, Character Styles).
Step 5: Choose Fill Format Mode: Click on the Fill Format Mode icon (a paint bucket) in the
Styles window.
Step 6: Apply the Style: Move your mouse pointer to the location in the document where you
want to apply the style. Click to apply the style2.
Step 7: Apply to Multiple Items: To apply the style to multiple items, drag your mouse to
select the items, and then release the mouse button.
Step 8: Finish: Press Esc when you're done applying the style
PRACTICAL- 3
Aim of the Practical
Create a brochure of any tourist place near you using different images of it and using
different image formatting options available in libreOffice writer.
Activity :-
Collect different images of a tourist place you like and save them in a folder in your PC. Then
insert them one by one and create a brochure. Use all types of formatting options available
in LibreOffice Writer that will make it look attractive.
Ways to insert images :-
When the image is in a file stored on the computer, you can insert it into an LibreOffice
Writer document using either of the following methods:
Drag and drop
Insert Picture dialog
from the clipboard
using a scanner
from the Gallery
Ways To Modify An Image :-
When we insert a new image, we may need to modify it to suit the document. The following are
few methods that will help us to do the required modifications in our image.
Using the Picture toolbar
Using the formatting toolbar and Picture dialog
Cropping images
Resizing an image
Rotating a picture
Steps to Create a broucher
Step 1: Gather Your Images
First, collect various images of Karnal, such as:
Karnal Lake
Karna Lake Tourist Complex
Kalander Shah's Tomb
Cantonment Church Tower
Atal Park
Step 2: Open LibreOffice Writer
Open LibreOffice Writer and create a new document.
Step 3: Insert Images
Go to Insert > Image and select the images you gathered.
Place them in the desired locations on your document.
Step 4: Use Image Formatting Options
Resizing Images: Click on an image to select it, then drag the corners to resize it.
Wrapping Text: Right-click on an image, go to Properties, select Wrap, and choose options like
Wrap Off, Page Wrap, Optimal Page Wrap, etc.
Adding Borders and Shadows: Right-click on an image, select Properties, and use the Borders and
Shadow tabs to add effects.
Image Filters: Right-click on an image, go to Properties, and use the Image tab to apply filters like
grayscale, invert, or color filters.
Step 5: Add Text and Styling
Titles and Headings: Use Heading styles for titles and headings.
Paragraph Styles: Use Paragraph styles for body text, such as descriptions and history.
Bullets and Numbering: Go to Format > Bullets and Numbering to create lists of attractions.
Practical-4
Aim or Objective:
Create, update, and customize a Table of Contents (TOC) in LibreOffice Writer.
Activity:
Creating and Managing a Table of Contents in LibreOffice Writer
Steps to Create a TOC:
1. Open LibreOffice Writer: Start by opening your LibreOffice Writer application and create a new
document or open an existing one.
2. Insert Headings: Ensure your document has headings that can be included in the TOC.
Use the predefined heading styles (Heading 1, Heading 2, etc.) for this purpose.
o Go to Styles sidebar (press F11).
o Apply Heading 1 for main titles, Heading 2 for subtitles, and so on.
3. Insert Table of Contents:
o Place your cursor where you want to insert the TOC.
o Go to Insert > Table of Contents and Index > Table of Contents, Index or Bibliography.
o In the dialog box that appears, select the Table of Contents tab.
o Click OK to insert the TOC.
4. Customize Table of Contents:
o Right-click on the TOC and select Edit Index/Table.
o In the dialog box, you can customize the appearance and structure of your TOC.
Entries tab: Define how each entry should appear.
Styles tab: Change the formatting of TOC levels.
Columns tab: Divide the TOC into columns if needed.
5. Update Table of Contents:
o As you make changes to your document, such as adding or deleting headings, you
need to update the TOC.
o Right-click on the TOC and select Update Index/Table.
PRACTICAL- 5
Aim of the practical:-
Create a certificate for any competition held in school using any template available in LibreOffice
Writer.
Document Template:-
◻ A template is a model that you use to create other documents.
◻ Templates can contain anything that regular documents can contain, such as text,
graphics, a set of styles, and user-specific setup information such as measurement
units, language, the default printer, and toolbar and menu customization.
◻ For example, if we want to create a certificate we can use a certificate template and modify
only the sections that require changes.
Steps to create a template
◻ We can create our own templates in two ways:
1. From a document 2. Using a wizard.
Creating a template from a document.
1. First open a new or existing document of the type that we want to make into a
template (text document, spreadsheet, drawing, presentation).
2. Add the content and styles that we want.
3. From the main menu, choose File > Templates > Save as template. The Templates dialog
open.
4. In the New template field, type a name for the new template.
5. In the Categories list, click the category to which we want to assign the template.
6. Choosing an appropriate category makes it easier to find the template when we want to use it.
To create a template using a wizard:
1. From the main menu, choose File > Wizards >[type of template required]
Follow the instructions on the pages of the wizard.
2. In the last section of the wizard, we can specify the name and location for
saving the template.
3. The default location is your user templates directory, but you can choose a different
location if you prefer.
4. Finally, we have the option of creating a new document from your
template immediately, or manually changing the template.
5. For future documents, we can reuse the template created by the wizard, just as we
would use any other template.
Practical-6
Aim of the practical:-
Create a consolidated sheet for the two data sheets given in LibreOffice Calc.
Activity:-
Two sheets given below contains some data in sheet1 and sheet2 and create a sheet3 that contains
the consolidated values of both the sheets.
Consolidating data:-
The Consolidate tool allows you to combine and aggregate data spread across one or
more
worksheets into one place.
This tool is useful if you need to quickly summarize a large, scattered set of data for review.
Steps Consolidating data in LibreOffice Calc:-
1. Open the document containing the cell ranges to be consolidated.
2. Select Data > Consolidate from the Menu bar to open the Consolidate dialog.
3. Click on the Source data ranges field, then type a reference to a source data range,
a named range or select it with the mouse.
4. Use the associated Shrink / Expand button if we want to minimize the dialog while you
select the range. Alternatively, select a named range from the drop-down list to the left of
the field.
5. Click Add. The selected range is added to the Consolidation ranges list.
6. Repeat steps 3 and 4 to add additional source ranges.
7. To delete an entry in the Consolidation ranges list, select it and click Delete. The
deletion is Carried out without further confirmation.
8. Click on the Copy results to field, then type a reference to the first cell of the target
range or select it with the mouse.
9. We can also select a named range from the drop-down list to the left of the field.
10. Select a function to aggregate your data from the Function drop- down list.
11. The default is Sum. Other available functions include Count, Average, Max, Min, Product,
Count (numbers only), StdDev (sample), StDevP (population), Var (sample), and VarP
(population).
12. Click OK to consolidate the ranges. Calc runs the function from step 8 on your
source data ranges and populates the target range with the results.
Practical-7
Aim of the practical:-
Create a Subtotal of the data sheet given in LibreOffice Calc.
Activity:-
◻ There is a sheet given below containing some data create a subtotal of the data sheet
based on the column Sales grouped by Sales executive.
Subtotal :-
Calc offers two methods of creating subtotals:
1. SUBTOTAL function
2. Subtotals tool.
SUBTOTAL Function:-
• The SUBTOTAL function is listed under the Mathematical category of the Function
Wizard, and the Functions List deck of the Sidebar.
• SUBTOTAL is a relatively limited method for generating a subtotal, and
works best if used with only a few categories.
SUBTOTAL tool:-
• Calc offers the Subtotals tool as a more comprehensive alternative
to the SUBTOTAL function.
• In contrast to SUBTOTAL, which only works on a single array, the Subtotals tool can
create subtotals for up to three arrays arranged in labeled columns.
• It also groups subtotals by category and sorts them automatically, thereby
eliminating the need to apply Auto Filters and filter categories by hand.
Practical-8
Aim of the practical:-
Create three different scenarios of a data given in LibreOffice Calc.
Activity:-
◻ Create a Sheet in LibreOffice Calc as given below that contains marks scored by any of
your 5 different friends in PT2 exam and find create three different scenarios of it .
◻ In the first scenario find the total marks in the second scenario find theaverage
score and in the third one find the maximum mark of the 6 subjects.
Scenarios:-
◻ Scenarios are saved, named cell ranges that you can use to answer ―what-if‖
questions about our data.
◻ We can create multiple scenarios for the same calculation set, then quickly swap
between them to view the outcomes of each.
◻ This feature is useful if we need to test the effects of different conditions
on our calculations, but do not want to deal with repetitive manual data entry.
Creating Scenarios:-
➢ Select the cells that contain the values that will change between scenarios.
➢ To select multiple ranges, hold down the Ctrl key as you click.
➢ We must select at least two cells. Choose Tools > Scenarios
from the Menu bar to open the Create Scenario dialog.
➢ Enter a name for the new scenario in the Name of Scenario field.
➢ Optionally, add information to the Comment field.
➢ Click OK to close the dialog. The new scenario is automatically
activated upon creation.
➢ Repeat above steps to create additional scenarios.
➢ We need to select the same cell range that we used for the first
Practical-9
Aim of the practical:-
Create a table in a database in LibreOffice Base using Wizard .
Solution
1. Click on Start -> All Programs ->LibreOffice Base.
2. OO Base window will open with Database Wizard. Select or create the database to work
upon it. I have selected existing database db1. Click on Finish button.
3. Now click on Tables button from Left pane and choose Use Wizard to Create Table…
option from the tasks window.
4. The Table Wizard will open. Follow wizard steps to create a table
5. In first step of wizard select the Category either Business or Personal, Table from list of
sample tables, and fields from available fields. Click on Finish button.
6. Click on Next and select field types and all if you want to change it. Click on Next.
7. Set a primary key for your table in this step. I have selected EmployeeID as Primary key.
8. If you wish to change the table name then type new name for the table and click on Insert
Data immediately, and click on Finish
9. Now insert data in the table.
PRACTICAL- 10
Aim of the practical:-
Creating a form using wizard.
Activity:
Create a form using wizard by selecting all the fields for the table - Marksheet Solution
Steps to create a form using wizard
1. Click on Forms -> Use Wizard to Create Form…
2. A Form Wizard appears
3. Select the table from Tables or Queries then add all the fields.
4. Click on Next button. Ignore step 3 and step 4.
5. Select the first option i.e. Columnar – Labels Left then click on the next button.
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.
7. Type new name for the form and click on work with the form. Click on Finish