Class X – IT (402)
Boards Practical File
Sunbea
m
Maharajganj ,
Ghazipur
Session – 2025-26
Submitted by - Anupam Anand
Class & section - X/B
Roll no. - 30
Submitted to - Nagendra Sir
Teacher’s Sing -
ACKNOWLEDGEM
ENT
I Would like to
express my
special thanks of
gratitude to my
teacher Mr.
Nagendra Gupta ,
who gave me this
opportunity to do
this wonderful
project of
Information
Technology.
I am really
Certificate
This experiments entered in
this Practical File have been
satisfactorily performed by
Master :Anupam Anand
Studying in: Sunbeam School Maharajganj
Class: X div: b Roll no: 12
During the academic year: 2025-26
Teacher’s Signature Principal signature
Table of Content
INDEX
Sl. No Assignment Date of Signature
Submissio
n
Unit 1: Digital Document (Advance)
1. Open the Styles and Formatting window in
a document using LibreOffice writer and
apply at least three different style
categories (e.g., Paragraph, Character,
Page) in the document. Explain all three
different styles including steps and paste
the screenshot of the style and formatting
window.
2. What do you mean by the Fill Format tool
in LibreOffice Writer and how you will
apply the same style to multiple sections
quickly. Choose character style and apply
the same style in multiple sections in the
document.
3. What is a Table of Contents (ToC) and
why is it important in a document?
Imagine you are preparing a project report
that has several sections and
subsections. You have been asked to add
a ToC to make it more organized and
easier to navigate. Write steps to create
Table of Content in LibreOffice Writer and
can you share a real life scenario where
you will use a table of content in a
document.
4. What do you mean by track change and
why track change options are used in
documents? Write some content in the
document and enable the track changes
option and describe to others how accept
or reject the changes option is used for
the specific section.
5. Write the steps for inserting image in the
LibreOffice Writer and write the difference
between resize image and text wrapping
option in the document.
Unit 2: Electronic Spreadsheet (Advance)
6. You have the following data of students' and their
marks for Pre Mid Term, Mid Term and Post Mid
Term stored in three different worksheets in the
same workbook. How you will use it to consolidate
data features in LibreOffice calc to summarize the
data in a single worksheet that will show the
average marks of each student.
7. You have the following sales report, you need to
calculate the total quantity sold for each category
using the subtotal feature in LibreOffice Calc. Write
steps to apply subtotals in LibreOffice Calc.
8. What do you mean by Macro? Write the steps to
record Macro in LibreOffice calc.
9. You want to create a yearly budget and you want to
see how different monthly savings can affect your
total savings at the end of the year. Explain the
steps how you will create What-if Scenarios in
LibreOffice Calc.
Unit 3: Database Management System
10. Consider the following table: Students
11. Identify the difference between fields, records and
tables in the database using the student database.
12. What are the different types of keys in the database
and explain their roles and importance.
13. Explain how you will create relationships between
two tables. What is the difference between one-to-
many, many-to-many and one-to-one relationships?
14. What do you mean by Query in LibreOffice Base.