JAYPEE PUBLIC
SCHOOL,NOIDA
Information Technology (SUBJECT CODE - 402)
Class X
CBSE Board Practical File
Session:-2024-2025
Student Name: _____________
Class & Division: __________
Roll No: _________
ACKNOWLEDGEMENT
I would like to express my sincere gratitude to my teacher Ms Swati
Sharma who gave me the golden opportunity to do this wonderful IT
project. I offer my sincere appreciation for the learning opportunities
provided by my principal Mrs Anjali Malik which also helped me in
doing a lot of research and I came to know about so many new
things. I am really thankful to them. I would also like to thank my
parents and friends who helped me a lot in finalizing this project
within the limited time frame.
Certificate
This experiments entered in this Practical File have been
satisfactorily performed by
Master/ Miss:
______________________________________________________________________________
Studying in: ____________________________ School, Class: _________ Div. __________ Roll No:
________
During the academic year: ___________.
Teacher’s Signature Principal’s
Signature
Date: School Stamp
Table of Content
INDEX
Sl. Assignment Date of Signature
No Submission
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.
INFORMATION TECHNOLOGY
SUBJECT CODE - 402
Class X Practical File
Digital Documentation using LibreOffice Writer
1. How you will open the Styles and Formatting window in a document using LibreOffice writer and
how you will apply the style in the document. Explain any three different types of styles and
paste the screenshot of the style and formatting window.
2. What do you mean by the Fill Format method in LibreOffice Writer and how you will apply the
same style to multiple sections quickly and paste the screenshot of the fill format mode icon.
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 a Table of
Content in LibreOffice Writer.
4. What do you mean by track change and why track change options are used in documents? How
you will use accept or reject the changes option in LibreOffice Writer.
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.
Electronic Spreadsheets using LibreOffice Calc
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.
Worksheet 1 - Pre Mid Term (Student Marks)
Roll No Student Name Aggregate Marks
1 Student A 96
2 Student B 98
3 Student C 95
4 Student D 97
5 Student E 99
Worksheet 2 - Midterm (Student Marks)
Roll No Student Name Aggregate Marks
1 Student A 99
2 Student B 97
3 Student C 96
4 Student D 95
5 Student E 96
Worksheet 3 - Post Mid Term (Student Marks)
Roll No Student Name Aggregate Marks
1 Student A 95
2 Student B 98
3 Student C 94
4 Student D 99
5 Student E 92
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.
Sales Report
Category Item Quantity Sold
Electronic TV 95
Electronic Laptop 456
Electronic TV 87
Electronic TV 71
Electronic Desktop Computer 96
Electronic Mouse 37
8. What do you mean by Macro? Write the steps to record Macro in Libre Office 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 Libre Office Calc.
Database Management System using LibreOffice Base
10. Consider the following table: Students
Admission_No Class Student_Name Address
S1234 X Student A Bandra, Mumbai
S1235 IX Student B Dharavi, Mumbai
S1236 X Student C Girgaon, Mumbai
S1237 IX Student D Worli, Mumbai
S1238 X Student E Bandra, Mumbai
(a) You want to design a student database in your school, based on the above table, identify the
fields, which of the above fields you will use to store information of each record.
(b) The database administrator needs to ensure that each student has a unique identifier. Which
of the above fields in the table would be used to make a primary key and why.
(c) After reviewing the student database you realize that there should be another field apart from
the primary key which will uniquely identify a record. Identify the above field and justify why it
could be used as an alternate key.
(d) If you want to integrate the student table with another table which will store the students fee
details. Justify how you will use the primary key from the students table and a foreign key in the
Fees collection table to create a relationship between the two tables. Explain with examples.
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.
