SBV NO.

2 MANDAWALI DELHI
SCHOOL ID :- 1002367

INFORMATION TECHNOLOGY(402)
PRACTICAL FILE — CLASS X
Academic Session: 2025–26

STUDENT DETAILS
Name: PrinceDixit
Class & Section: 10th A
Roll Number: 10104

Subject Teacher: Manjeet Sir

 CERTIFICATE

This is to certify that Prince Dixit studying in Class 10th, Section-A, Roll
No. 10104, has successfully completed his Information Technology
Practical File during the academic
year 2025-2026.

The practical work contained in this file has been completed and verified
as per the prescribed syllabus of CBSE (Skill Education) and under the
guidance of Mr. Manjeet Singh, PGT Computer Science.

Teacher’s Signature:

Teacher Name:
Date: 24/01/2026 Manjeet sir
 ACKNOWLEDGEMENT

I am sincerely grateful to my teacher Mr. Manjeet Singh for their valuable

guidance, support, and encouragement throughout the completion of this
Information Technology practical file. His constant help has played an
important role in enhancing my understanding of the subject. I would also
like to thank our respected Principal sir and the school administration for
providing the necessary facilities and a learning environment.
Lastly, I express my heartfelt gratitude to my parents and classmates for
their support and motivation during the preparation of this practical file.
This project has helped me learn and understand important concepts of
Information Technology, and I am thankful for the opportunity.

Signatures

Student Name: Prince Dixit

Class: 10th-A Roll No.: 10104

 INDEX

S. No. Practical Title Page No.

UNIT 1- Digital Documentation (Advanced) Using LibreOffice Writer

1 Understanding Styles categories

2 Fill Format Styles in LibreOffice Writer
3 Working with Images in LibreOffice Writer
4 Inserting Table of Content in LibreOffice Writer Document

5 Creating Template in LibreOffice Writer

UNIT 2- Electronic Spreadsheet(Advanced) Using LibreOffice Calc

67 Data Consolidation in LibreOffice Calc

89 Using Goal-seek in Spreadsheet

10 Using Subtotal feature in sales report

Using What-If Scenarios in worksheet
Recording Macros in Spreadsheet

UNIT 3- Database Management System Using LibreOffice Base

Fields, Records, Primary key, Alternate key, Foreign key in
11 a Database Table
12 Creating Table in LibreOffice Base using Design view
13 Referential Integrity in related Table

14 Creating For ms us ing Wi zard

15 Adding Calendar in date field of a Form
 UNIT 1- Digital Documentation (Advanced)
Using LibreOffice Writer
Understanding Styles categories
Practical Q1
Apply an existing Heading style, from Paragraph Styles.
Step 1. Create a new document named ‘[Link]’ with the text
as shown in Fig. 1.6.
Step 2. Add a title, ‘Noise Pollution’ on top.

Step 3. Select the Tile – Noise Pollution

Step 4. Open Styles Menu using Sidebar and go to Headings
option.
Step 5. Double click on Heading 4 to apply. Observe that the
Fig. 1.7 shows the Heading 4 style is applied to the
heading ‘Noise Pollution’.

Using predefined Heading Style, allow you to use them

as a Book Mark for browsing the document
Practical Q2 Fill Format Styles in LibreOffice Writer
Use Fill Formattochange appearanceof paragraphs at different
places in the document using paragraph formatting. A file
‘[Link]’ with at least 5 pages of text is used for
the activity.
Step 1. Open a file ‘[Link]’ having 5 pages of text.
Observe the indented sentences in second page in
Fig. 1.10.

Step 2. Go to Style Menu from sidebar and click on Paragraph

category, and select List Paragraph from the drop down
list as shown in Fig. 1.11.
Step 3. Click at the beginning of the sentence to be styled using
List Paragraph.
Step 4. Now click on Fill button, keep on doing same to apply
the style for all sentences using desired format. Observe
in Fig. 1.12 that how the indented list items look after
applying the Fill Format button.
Step 5. Press ‘Esc’ key to disable Fill button.
Practical Q3 Working with Images in LibreOffice Writer
Insert an image using Insert Imagedialog box inthefile
“[Link]” created in previous chapter.
Step 1. Ensure that you have an image file on your computer
hard disk. Otherwise download a relevant image from
Internet.
Step 2. Open “[Link]” file created in Practical Activity 1.2 of
Chapter 1.
Step 3. Place the cursor to the next line of the text to insert the
image file, and then click on Insert menu from the
menu bar as shown in Fig. 2.1.

Step 4. Click on Image option, opens Insert Image browsing

window to select an image. Select desired image as
shown in Fig. 2.2.

Step 5. Click Open button. The image appears at desired place

as shown in Fig. 2.3.
PracticalQ4Inserting Table of Content in LibreOffice Writer Document

Rimjhim has created a report on Environmental Pollution

in LibreOffice Writer. She has applied proper heading styles
to all section headings of the document. Now, to add table of
contents to the document with the heading as Rimjhim’s Table
of Contents, follow the steps given below.
Step 1. Open the document in LibreOffice Writer.
Step 2. Select Insert > Table of Contents and Index > Table
of Contents, Index or Bibliography. The Table of
Contents, Index and Bibliography dialog box will be
displayed.
Step 3. In the Type the Titles text box, type Rimjhim’s Table of
Contents.
Step 4. Click OK. The Table of Contents will be inserted in
Rimjhim’s document.
Practical Q5 Creating Template in LibreOffice Writer
Niaz works in a garment factory. He has to give the report of each
garment being designed and stitched in his factory. His manager
wants the same type of report for each garment. Instead of typing
every time, he has been suggested to use the template feature
of Writer. He wants to create his own default template and then
use it to create multiple reports with same format and style. Give
the solution to complete this task.
Procedure
Follow the following steps to create and save a template in Writer.
Step 1. Create or open the document 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 in
Fig. 3.17.
Step 3. Type the name of the new template (Niaz_template) in
the Template Name text box.
Step 4. Select the category of the template (Business
Correspondence)
Step 5. Click and select Set as default template check box.
Step 6. Click Save button to save the template with an extension
.ott.
Now follow the steps given below to use the template.
Step 1. Select File > Templates > Manage Templates.
Step 2. Select the desired template, (Niaz_template) from the
Templates dialog box.
Step 3. Click on Open button. The new document with
name as Untitled, will be opened with the same
content, appearance and formatting effects as the
saved template.
Step 4. Make the desired changes and save the file.
 UNIT 2- Electronic Spreadsheet(Advanced)
Using LibreOffice Calc
Practical Q6 Data Consolidation in LibreOffice Calc
Letus takean example that we have two branchesof our
shop namely ABC and XYZ. We have the Sales records for the
month of January and February of both the branches in two
different sheets named ABC_Branch and XYZ_Branch. Now we
have to consolidate these two sheets to get the sum of both the
sheets monthly to get the insight about the sale as per product
and branch.
Now let us create the following sheets in a spreadsheet sales.

Now let us use the two sheets ‘ABC_Branch’ and ‘XYZ_Branch’

ofa spreadsheet [Link] which will be consolidated using the
following steps:
Step 1. Add a new sheet and rename it as Consolidate
Step 2. Click on Data > Consolidate or use the keyboard
shortcut key ALT+D, the Consolidate dialog window
will open as shown in Fig. 4.6.

Step 3. In the Function box, choose Sum function from the drop
down as we want to add the data from all the sheets.
Step 4. Click in the Source data ranges box and then click
on the worksheet ABC_Branch and select the area to
be consolidated and then click on the Add button will
add the copy reference in the consolidation ranges
(Fig. 4.7).
Step 5. Click on the sheet XYZ_Branch and select the area to
be consolidated and then click on ADD will add the
next consolidation range (Fig. 4.8).
Step 6. Click on the ‘+’ sign next to Options in the Consolidate
dialog window to change the settings.
‘Consolidate by’ has two options Row labels and Column labels.
Check row label or column label or both if you want to consolidate
it by matching the label.
If Link to source data is checked, then it will keep on updating
the data of the Consolidate sheet automatically if there is any
change made in the selected ranges.

Step 7. Click on ‘Copy

results to’ and
then click on any
of the cell in the
Consolidate sheet
where you want to
copy the final result
after consolidation.
Step 8. Click on OK button.
Fig. 4.9 will display
the Consolidate
sheet with data after
consolidation.

The consolidated sheet will have all the consolidated data along
with the original data. You can view the original data of both the
sheets and by clicking on the ‘+’ sign in front of the consolidated
row. Fig. 4.10 shows the original data and consolidated data.
 Practical Q7 Using Goal-seek in Spreadsheet
Letus take a very simple exampleto performthe backward
calculation to find out an input depending upon the specific
output. A student has received marks in 4 subjects and has to
appear for the 5th subject and plans an aggregate as 70. So, he
can use goal seek tool to check how many marks he has to score
in the 5th subject to get the required percentage. Follow the
following steps to perform this task.
Step 1. Create the marksheet as shown below in the
Fig. 4.28. Enter the average function in cell B7 as =
Average(B2:B6)
Step 2. Click on Tools > Goal Seek will display the Goal seek
dialog window as shown in Fig. 4.29.

Step 4. Write the cell address of the formula, i.e. B7 in the

Formula cell box.
Step 5. Write the cell address of the cell which is to be
generated by the system in the Variable cell box. In
this example, it is cell B6 which we want to be filled as
per the average marks needed.
Step 6. Enter the result in the Target value box. As per our
question, we have to get minimum 70 aggregate so we
will write 70 in the target value.
Step 7. Clicking on OK will display an error as LibreOffice
Calc will not accept the Variable cell to be empty. So,
this error dialog window will prompt to add 0 value in
the variable cell as shown in Fig. 4.30.

Step 8. Click on Yes and then repeat the step 2 will display the
dialog window and prompts whether to change the cell
with the calculated value as shown in Fig. 4.31.

Step 9. Click on Yes will change the value with the calculated
one in the sheet as shown in the Fig. 4.32.
Practical Q8 Using Subtotal feature in sales report
Let ustake an example to store marksin various subjects by
students of Class X as shown in the table given in Fig. 4.13. To
take out the average of the subjects scored in each class, use the
subtotal tool which automatically group the data on a particular
column and perform the selected function on any of the column.
To solve this, perform the following steps:
Step 1. Create a sheet as shown in the Fig. 4.13 to take the
marks for students in a term for a class.
Step 2. Now, to calculate the average marks scored by the
students of each class in each subject, i.e. class-wise
and subject analysis.
Step 3. To do so, click on Data > Subtotal, the subtotal dialog
as shown in Fig. 4.14 will open.

Step 4. Choose the column i.e. Class under Group by in the 1st
Group on which we need to group the whole data. Also, select
the subjects i.e. English, Hindi, Maths, Science and Social
Science under Calculate subtotals for. For each subject click
on the Average under Use function individually otherwise Sum
function will be used by default. Step 5. Click OK and the sheet
will look like as shown in the Fig. 4.15
 Practical Q9 Using What-If Scenarios in worksheet
Let us take an example to get the insight of the EMI, Total Amount
paid and Total Interest paid on the Loan Amount (Principal)
taken for a fixed Rate of Interest for a number of time period. So,
now we want to see what will be the EMI and how much is the
total interest paid for different loan amount and time period. To
do so, let us use the Scenario tool by using the following steps:
Step 1. Create the following sheet (Fig. 4.18) and remember to
put the formula to calculate EMI in B3 as
= ABS(PMT(B2/1200,E1*12,B1))
Total Amount in B4
= B3*E1*12
Total Interest in B8
= B4-B1

Step 2. Select the cells B1 and E1 using Ctrl + Click on these

cells as these two are the variables in this situation
Step 3. Choose Tools > Scenario will display the Create
Scenario dialog window as shown in Fig. 4.19.

Step 4. Write the name of the Scenario and click on OK button

will add this in the scenario list. Step 5. Let us create two more
scenarios as LAmt_2 and LAmt_3 with Loan Amount as
2500000, No. of years as 12 and Loan Amount as 2500000, No.
of years as 10 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 in the Fig. 4.20

Step 6. Click on the navigator icon in the toolbar and then

click on scenarios. Click on the scenario name will
display all the details as per that scenario.
Practical Q10 Recording Macros in Spreadsheet

Record a macro to apply the following style to the Heading “Data

Analysis” in the cell A1.
The font style should be “Times New Roman”
The font size should be “14”
The font colour should be “Blue”
Cells from A1 to G1 should be merged and centred
Procedure
Step 1. Create the spreadsheet. Write the heading “Data
Analysis” in cell A1.
Step 2. Choose Tools > Macros > Record Macro. Perform the
actions mentioned above in Practical Activity 5.1 in
the spreadsheet.
Step 3. Click Stop Recording to stop the Macro Recorder.
Step 4. The Basic Macro dialog appears as shown in Fig. 5.4,
in which you can save and run the macro.
Step 5. A Standard library is present by default when a
spreadsheet is created and saved.
Step 6. To save the macro, first select the object where you
want to save the macro in the Save macro in list
box. Fig. 5.5 shows that the Main macro is saved by
default in the Standard Library in Module1. You can
change the name of the macro. Here, we have named
the macro as FormatHeading.
 UNIT 3- Database Management System Using
LibreOffice Base
Practical Q11 Fields, Records, Primary key, Alternate key,
Foreign key in a Database Tab
•Field or Columns or attributes – A field is the
smallest entity in the database. A collection of
fields make a record, a collection of records make
aFields
table are
andindividual
a collection of tables
record make a database.
characteristics and
are presented as columns within a table. Data
values are stored in a database as fields. A field
holds thepersons.
several data values of one type
For example, of data
in the for
Employee
table the field “Emp Name” will hold the names of
employees of an organisation.
•Record or Row – The data values for all the fields
related to a person or object is called a record. It is
presented as rows within a table. A record holds
the data values of all the fields for a single person
or object in a table. For example, in the Employee
table with the field names as Name, Designation,
Department, the data values of all the fields for an
employee may be (‘Abhinav’, ‘Manager’, ‘Finance’)
and this forms one record.
•Primary Key – A primary key or simply a key is
a field that uniquely identifies a row in a table.
column or of multiple columns. The primary key
is a unique identifier for the table. The column or
combinations of columns that form the primary
key have unique values. At any time, no two rows
in the table can neither have same values for the
primary key nor can data value for such field be
left blank. For example, in a student table, each
student has a unique roll no., which forms the
primary key. If, in a table we use more than one
fields to identify a record, it is known as a composite
key. For example, we may form a composite key
consisting of fields roll no. and name.
•Foreign Key – If a field or a combination of fields
of one table can be used to uniquely identify
records of another table, then that particular field
is known as the foreign key. This foreign key helps
to build a relation between two tables. Consider
the example given below.

• Alternate Key – Out of the candidate keys, one

or two are made as primary keys. The others are
the alternate keys. Hence, if Roll Number is made
as the primary key, Admission Number is the
Alternate key.
Practical Q12 Creating Table in LibreOffice Base using Design view
Creating Table in Design View
Creating the table using wizard
restricts us to use the same fields in the
per-designed tables. It may not solve
the purpose in real scenario, as we
may require to create a table with the
different fields for our purpose. Creating
tables using Design View gives us more
flexibility to do our work.
To create table using Design View, in
main Database window, click on the
option Create Table in Design View
in the Tasks Pane and Table Design
Window will be opened as shown in
• Field Type – It allows to assign a data type to the Fig. 9.13.
field. The screen is broadly divided into
• Description – It allows to describe the purpose two sections or horizontal panes.
of the field. It is not the part of database table, The upper half consists of a grid
but it is meant for the user to understand the structure with three columns Field
purpose of the field. We may or may not enter Name, Field Type and Description.
field description. • Field Name – It is the name of the
The Field Properties pane is located at the bottom half field assigned at the time of creation of
of the window. It displays the field properties assigned
by the database designer. These properties can also be
changed as per the requirement and are
used to control and validate the data that
is to be entered.
Let us help Ruhi to create a table
named Events using in the option Create
Table in Design view in the Sports Day
database. Follow the follow the following
steps to do so.
Step 1. Type the first field name (EventId)
in the Field Name column. Press
Tab key. The cursor moves to the
second column i.e. Field Type.
Step 2. The Field Type column contains
a list box. As you click on the
down arrow, it appears and we
can select the desired data type
from the list box. Select the
datatype (Varchar).
Step 3. Observe that certain properties
appear in the Field Properties
Pane as the data type is selected.
Some of the properties are Entry
required, Length, Default value,
Format example. Set the desired
properties for the entered field.
Step 4. Press Tab key to move to the next
column. Add any description if
you want in the third column.
Step 5. Once the properties for the field
are set, press Tab key to move to
next row.
Fig. 9.14: Selecting data type for field
Fig. 9.15: Fields entered using Creating Table
in Design View
Step 6. Enter the next field by repeating steps 1,2 and
3. Repeat the process for adding all fields in the
table. Fig. 9.15 shows the Design View with all
the fields.
Practical Q13 Referential Integrity in related Table
LibreOffice Base gives us following four options
to choose from to maintain referential integrity in
such cases.
• No action – This is the default option. This option
states that a user should not be allowed to update
or delete any record in the master table if any
related record exists in the transaction table.
• Update cascade – This option allows the user to
delete or update the referenced field but along with
it all the related records in any of the transaction
tables will also be deleted or updated.
• Set NULL – This option assigns NULL value to all
the related fields if the master record is deleted or
updated.
• Set default – This option assigns any fixed default
value to all the related fields if the
master record is deleted or updated.
To set the relationship properties
double click on the relation line joining the
two tables, Events and EventCategory. A
Relations dialog box will open as shown in
Fig. 10.16.
By default the radio button with No
action option will be selected. Choose any
of the desired option and click OK to set the
referential integrity between the two tables
 Practical Q14 Creating Forms using Wizard
Creating a Form Using a Wizard This is the simplest way
to create a form. To explain how to create a form using a
wizard, we will get back to the Sports Day database
created in the previous chapters. To create a form using
wizard, follow the following steps. Step 1. Open the
Sports Day database created in LibreOffice, and click the
Form icon on the Database Pane as shown in Fig. 12.1.
Practical Q15 Adding Calendar in date field of a Form
While filling up a form on a computer, mostlya calendar
is displayed. This is because it is easy to choose a date
rather than typing it. To add the calendar to the date
field in the form, follow the steps given below:
Step 1. Place the mouse pointer over the Date text box
and press Ctrl+Click to select it.
Step 2. Right click and select Control Properties….
option.
Step 3. In the Properties: Date Field dialog box, scroll
down for Date Format property. By default,
Standard (short) format will be displayed.
Step 4. Click to open the list box and select Standard
(long) format.
Step 5. Scroll down further till you find the DropDown
property. By default its value will be No. Select
Yes. The control properties set is shown in
Fig. [Link] your text

Step 6. Close the dialog box. The selected date control

text box on the form changes to a list box with
an arrow being displayed in the extreme right
as shown in Fig. 12.21