CBSE | DEPARTMENT OF SKILL

EDUCATION

SBV JJ COLONY KHICHRIPUR

(1002369)
Information Technology (SUBJECT CODE - 402)

Class X
Board Practical File
Session 2025-26

Student Name: ____________________

Class & Section: _______________
Roll No: ____________________
 ACKNOWLEDGEMENT

I would like to express my sincere gratitude to my teacher

MR. TARUN KUMAR JAKHAR (PGT COMPUTER
SCIENCE) 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 MR.
ARVIND KUMAR JAIN 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

Student Name:
___________________________________________________________________________

Studying in: SBV JJ COLONY KHICHRIPUR , Class: _________ Sec. __________

Roll No: ________

During the academic year: 2025-26

Teacher’s Signature

Date:
 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.

 CBSE | DEPARTMENT OF SKILL
EDUCATION
INFORMATION TECHNOLOGY
SUBJECT CODE - 402
Class X Practical File Question Paper
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.

Styles and Formatting Window

How to open

 Press F11
OR
 Click Format → Styles and Formatting

How to apply a style

 Select text → Open Styles & Formatting → Click the style name.

Any three styles

1. Paragraph Style – For whole paragraph (alignment/spacing).

2. Character Style – For selected text (font/color).
3. Page Style – For page layout (margins/header/footer).
 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.

Fill Format Method

Meaning

 A tool to copy a style and apply it to many places quickly.

How to apply

 Open Styles & Formatting → Click Fill Format Mode (paint bucket) → Click on text
where you want to apply the same style.
 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.

Table of Contents (ToC)

Meaning

 A list of document headings with page numbers.

Importance

 Makes long documents organized, easy to navigate.

Steps to create ToC

1. Write headings using Heading Styles (Heading 1, 2, 3).

2. Place cursor where ToC is needed.
3. Click Insert → Table of Contents and Index → Table of Contents.
4. Click OK.
 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.

Track Changes

Meaning

 Feature that shows edits made in the document.

Why used

 Useful for reviewing, editing, and collaboration.

How to accept/reject changes

1. Turn on track changes: Edit → Track Changes → Record.

2. Open review list: Edit → Track Changes → Manage.
3. Select a change → Click Accept or Reject.
 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.

Insert Image + Difference

Steps to insert image

1. Place cursor → Click Insert → Image.

2. Choose file → Click Open.

Resize vs Text Wrapping

 Resize Image – Changes size of image.

 Text Wrapping – Controls how text flows around the image (side, above, below).
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

Consolidate Data (Average Marks of Students)

Steps

1. Keep all three sheets (Pre-Mid, Mid, Post-Mid) in the same workbook.
2. Create a new sheet → Data → Consolidate.
3. Function: Average.
4. Select the range from Sheet1 → Add.
5. Select the range from Sheet2 → Add.
6. Select the range from Sheet3 → Add.
7. Tick Top Row and Left Column (for labels).
8. Click OK → All students’ average marks appear in one sheet.

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
Using Subtotals (Total Quantity by Category)

Steps

1. Sort data by Category.

2. Go to Data → Subtotals.
3. Group by: Category.
4. Calculate: Sum.
5. Select field: Quantity Sold.
6. Click OK → Subtotal (total quantity per category) appears automatically.

8. What do you mean by Macro? Write the steps to record Macro in

LibreOffice calc.

Meaning

 Macro = A tool that records steps and automates repeated tasks.

Steps to Record

1. Go to Tools → Macros → Record Macro.

2. Perform the actions you want to automate.
3. Click Stop Recording.
4. Save the macro with a name.
5. Run anytime from Tools → Macros → Run Macro.

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.

Meaning

 What-if scenario shows different outcomes when you change input values.
 Steps

1. Enter monthly savings and total savings formula.

2. Go to Tools → Scenarios.
3. Select the cells whose values you want to change (e.g., monthly savings).
4. Click Add → Give a name (Low Saving, Medium, High).
5. Enter different savings values for each scenario.
6. Switch between scenarios to see how yearly total changes.

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.

From the table:

Field Name What it stores (for each student/record)

Admission_No The admission number of the student (ID code).
Class The class in which the student is studying (IX, X etc.).
Student_Name The name of the student.
Address The address of the student (area and city).

So, for each record (each row / each student), the database will store:
  Admission_No
 Class
 Student_Name
 Address

All four fields are used to store information for every student.

(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.

The best field for primary key is: Admission_No

Reason:

 A primary key must be unique for each student.

 No two students should have the same admission number.
 Admission_No does not repeat and does not change frequently.

So, Admission_No is used as the primary key because it uniquely identifies each student.

(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.

An alternate key is another field (or set of fields) that can also uniquely identify a record, but
is not chosen as the primary key.

From the table, we can take:

 Student_Name as an alternate key (in this example).

Reason (for this question):

 In this sample data, each Student_Name is different (Student A, Student B, etc.).

 So, each name can also identify a single student.
 We are not using it as primary key, but it can be used as another unique field, so it is an
alternate key.
(In real life, sometimes two students can have the same name, but for this question, we assume
names are unique in the school.)

(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.

Suppose we create another table named Fees to store fee details.

Example structure of Fees table:

Admission_No Month Fee_Amount Status

S1234 April 3000 Paid
S1234 May 3000 Unpaid
S1235 April 2800 Paid

 In the Students table:

o Admission_No is the primary key.
 In the Fees table:
o We also add Admission_No as a field.
o Here, Admission_No in Fees table will be a foreign key.
o This foreign key will refer to Admission_No in the Students table.

How the relationship works:

 The database will know that every Admission_No in the Fees table must exist in the
Students table.
 This creates a relationship between the two tables:
o One student (one Admission_No in Students)
↔ Many fee records (many rows for same Admission_No in Fees)

This is called a one-to-many relationship:

 One student
 Many fee entries (for different months, years, etc.)

Example:
  Student with Admission_No S1234 in Students table:
o Name: Student A
o Class: X
o Address: Bandra, Mumbai

In Fees table:

 S1234, April, 3000, Paid

 S1234, May, 3000, Unpaid

Because of the primary key (in Students) and foreign key (in Fees):

 We can easily see which fee records belong to which student.

 The database maintains correct links between students and their fees.

11. Identify the difference between fields, records and tables in the database
using the student database.

Difference between Fields, Records and Tables

1. Fields

 Fields are individual pieces of information (columns) stored about each student.
 They describe what type of data will be stored.

Example (from student database):

 Admission_No
 Class
 Student_Name
 Address

These are all fields.

👉 Fields = headings or columns in a table.

2. Records

 A record is a complete set of data about one student.

 One record contains values for all fields.

Example (one student record):

Admission_No Class Student_Name Address

S1234 X Student A Bandra, Mumbai

This row is one record.

👉 Records = rows of the table.

3. Table

 A table is a collection of related records arranged under common fields.

 It stores complete information about a group of items—in this case, students.

Example: Student Table

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

👉 Table = collection of many rows (records) arranged in columns (fields).

Summary Table
Term Meaning Example from Student Database
Field Column heading Student_Name, Admission_No
 Term Meaning Example from Student Database
Record One complete entry S1234, X, Student A, Bandra
Table Whole data set All 5 students listed together

✔ Fields describe the type of data

✔ Records store actual student details
✔ Table contains multiple records and fields combined

12. What are the different types of keys in the database and explain their roles and
importance.

Types of Keys in Database and Their Roles

In a database, different types of keys are used to uniquely identify records and make
relationships between tables.

1. Primary Key

Meaning:

 A field that uniquely identifies each record in a table.

 Two records cannot have the same primary key.
 It cannot be blank (NULL).

Example:

In the Student table,

Admission_No is a primary key.

Importance:

 Helps in identifying each record uniquely.

 Prevents duplicate records.
  Makes searching fast.

2. Candidate Key

Meaning:

 A field or group of fields that can become a primary key.

 Among these keys, one is selected as primary key.

Example:

If a student table has:

 Admission_No
 Student_Email

Both are unique, so both are candidate keys.

But only Admission_No is chosen as primary key.

Importance:

 Provides alternatives if the primary key needs to be changed.

3. Alternate Key

Meaning:

 A candidate key that is not chosen as the primary key.

Example:

From above,
If Admission_No is primary key,
then Student_Email becomes alternate key.

Importance:

 Useful when primary key is unavailable.

 Helps maintain accuracy and uniqueness.

4. Foreign Key

Meaning:

 A key that links two tables.

 It is a field in another table that refers to the primary key of the main table.

Example:

Student Table

Admission_No Name
S1234 Amit

Fee Table

Fee_ID Admission_No Amount

F01 S1234 3000

Here:

 Admission_No in Fee table is a foreign key

 Admission_No in Student table is primary key
Importance:

 Creates relationships between tables.

 Maintains data consistency.

5. Composite Key

Meaning:

 A key made using two or more fields together.

 Used when a single field cannot uniquely identify a record.

Example:
Student_ID Subject Marks
101 Maths 78
101 Science 82

Here:

 Student_ID is not unique

 Subject is not unique

But Student_ID + Subject becomes unique.

Importance:

 Useful in many-to-many relationships.

 Ensures combined uniqueness.
6. Unique Key

Meaning:

 A field that must have unique values.

 But unlike primary key, it can have NULL value.

Example:

Student_Email field (emails are unique but can sometimes be blank)

Importance:

 Avoids duplicate values

 Maintains correctness of data

Conclusion
Key Type Main Purpose
Primary Key Uniquely identifies a record
Candidate Key Possible choices for primary key
Alternate Key Remaining candidate keys except primary key
Foreign Key Connects two tables
Composite Key Combination of fields to uniquely identify a record
Unique Key Keeps values unique but allows blank

👉 Keys are important because they:

 Reduce duplicate data

 Improve search efficiency
 Maintain data accuracy
 Help link related tables
This is why keys play a very important role in any database.

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?

How to Create Relationships Between Two Tables

To create a relationship, we need:

 A Primary Key in the first table

 A Foreign Key in the second table

Example:

Table 1: Students
Admission_No (PK) Name Class
S1234 Arun X
S1235 Sunil IX

Admission_No is the Primary Key.

Table 2: Fees
Fee_ID Admission_No (FK) Month Amount
F001 S1234 April 3000
F002 S1234 May 3000
F003 S1235 April 2800

Admission_No here is a Foreign Key.

Steps to Create Relationship:

1. Decide the table having the primary key

→ Students (Primary Key = Admission_No)
2. Add the same field in the next table as a foreign key
→ Admission_No in Fees Table
3. Link Primary Key to Foreign Key

This creates a relationship so that:

 Every fee record belongs to a valid student.

 Student details and fee records become connected.

Types of Relationships

1. One-to-Many Relationship

Meaning:

One record in Table A is connected to many records in Table B.

Example:

 One student → Many fee payments

Students Table

Admission_No
S1234

Fees Table

Admission_No Month
Admission_No Month
S1234 April
S1234 May

Reason:
One student pays fees many times.

👉 This is the most commonly used relationship.

2. Many-to-Many Relationship

Meaning:

Many records in Table A connect with many records in Table B.

Example:

Students and Subjects

One student studies many subjects

One subject is taught to many students

To manage this, we need a third table (junction table).

Example:

Students Table

Student_ID Name
101 Ravi
102 Mohit

Subjects Table
Subject_ID Subject
SB001 Maths
SB002 Science

Student_Subject Table (relation table)

Student_ID Subject_ID
101 SB001
101 SB002
102 SB001

This third table breaks many-to-many into two one-to-many links.

3. One-to-One Relationship

Meaning:

One record in Table A connects with only one record in Table B.

Example:

Student and Aadhaar Card Information

Students Table

Admission_No Name
S1234 Arun

Student_Aadhaar Table

Admission_No Aadhaar_No
S1234 5678901234

Here:

 One student has only one Aadhaar record

  Aadhaar belongs to only that student
So it is one-to-one

Summary Table of Differences

Relationship Type Meaning Example
One-to-One One record → One record Student ↔ Aadhaar
One-to-Many One record → Many records Student ↔ Fee payments
Many-to-Many Many records ↔ Many records Students ↔ Subjects

Importance of Relationships:

✔ Avoids repeating same data

✔ Connects tables meaningfully
✔ Helps in searching related information
✔ Maintains data correctness

This is how relationships are created and how different types of relationships differ from each
other.

14. What do you mean by Query in LibreOffice Base.

A Query in LibreOffice Base is a tool used to search, filter, and display specific information
from one or more tables in the database.

In simple words:

👉 A query helps you ask questions from the database

👉 And shows only the information that matches your need
Why do we use Query?

We use queries to:

✔ Find specific records

✔ Filter data based on conditions
✔ Calculate totals, averages, minimum or maximum values
✔ Display selected fields only
✔ Combine data from multiple tables

Examples:

Example 1:

If your student table contains:

Admission_No Class Name City

S1234 X Rohan Mumbai
S1235 IX Aarya Delhi

If you want to see only students of Class X:

You create a query with condition:

Class = 'X'

Result will show only Class X students.

Example 2:

If you want to see only the name and city, instead of full record:

Query will show:

Name City
Rohan Mumbai

Types of Queries

1. Simple Query – shows selected fields

2. Query with conditions – like Class = 'IX'
3. Query based on multiple tables
4. Query with calculations – e.g. SUM(Fee_Amount)

Conclusion

A Query is used to extract meaningful and specific information from a database.

Instead of checking the entire table manually, a query helps us get the exact result quickly and
easily.

-OoOoO-