CBSE | DEPARTMENT OF SKILL
EDUCATION
AIR FORCE SCHOOL
BAGDOGRA
Information Technology (SUBJECT CODE - 402)
Class X
Board Practical File
Session ________
Student Name: ______________
Class & Division: __________
Roll No: _________
1|Page
ACKNOWLEDGEMENT
I would like to express my sincere gratitude to my teacher {Name of the
Teacher} 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 {Name of the Principal} 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.
2|Page
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
3|Page
Table of Content
INDEX
Sl. Assignment Date of Signature of
No Submission Teacher
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)
4|Page
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
5|Page
INFORMATION TECHNOLOGY
SUBJECT CODE - 402
Roll No Class Name
Student X Practical FileMarks
Aggregate Question Paper
1 Student A 96
Digital Documentation using LibreOffice Writer
2 Student B 98
1. How
3 you will open Cthe Styles and
Student 95 Formatting window in a document using
LibreOffice writer and how you will apply the style in the document. Explain
4 Student D 97
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.
6|Page
5 Student E 99
Worksheet 1 - Pre Mid Term (Student Marks)
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
7|Page
Electronic Desktop Computer 96
Electronic Mouse 37
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.
Database Management System using LibreOffice Base
[Link] 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.
8|Page
(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.
[Link] the difference between fields, records and tables in the database using
the student database.
[Link] are the different types of keys in the database and explain their roles and
importance.
[Link] how you will create relationships between two tables. What is the
difference between one-to-many, many-to-many and one-to-one relationships?
[Link] do you mean by Query in LibreOffice Base?
--
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.
Answer: LibreOffice Writer provides different types of tools to apply
predefined style or formatting in a document. This style or formatting helps to
maintain uniformity in font size, font face, spacing, heading or overall layout in
the documents. There are six different types of Styles in LibreOffice Writer: (a)
9|Page
Paragraph Styles, (b) Character Styles, (c) Page Styles, (d) Frame Styles, (e)
List Styles and (f) Table Styles.
There are several ways to open Style and Formatting window in LibreOffice –
Click on Format > Styles > Manage Style
To open style and formatting window press F11
Using Sidebar Menu
Using Style Drop Down list box from toolbar
Employability skills training
Page Styles – Page style is used to define basic page layout like page size,
border, background or footnote etc. You can apply many page styles in a
document. If the page style is not declared then the user can define the
default page style.
Paragraph Style – Paragraph style helps to organize the content in paragraphs.
Paragraphs formatting includes border, tab stops, text alignment and line
spacing etc. It also includes character style attributes.
Character style – This style is used to change the appearance of the
characters. This style includes text color, highlighting text, text size and
emphasizing it.
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.
Answer: Fill format is a quick method to apply the same style in different
locations in the document. In Manual formatting every time we have to select
the text and we have to apply the style which takes a lot of time. Instead of
manual method we can use the Fill Format method to apply the style quickly.
Apply the same style to multiple sections quickly using following steps –
Step 1: Open LibreOffice Writer
Step 2: Open Style window
Step 3: Select the paragraph where the style will be copy
Step 4: Click on Fill Format button
Step 5: Take the mouse pointer to the desired location and apply the
style.
Step 6: Repeat step 5 until all the changes have been made
10 | P a g e
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.
Answer: Table of content is used to create a list of topics and subtopics that
have been covered in the book along with page number, this table of content
you can define with different types of heading. This table of contents can be
inserted automatically in the document. Hyperlink can navigate directly to the
selected topic in the document.
Steps to create a Table of Content in LibreOffice Writer are –
To create a Table of content in the document first you have to use paragraph
styles for headings such as main sections will be Heading 1, subsections will be
Heading 2 vice versa.
Step 1: Click on Insert > Table of Contents and Index
Step 2: Select Table of Contents, Index or Bibliography
Step 3: Click on Entries options in ToC
Step 4: Customize Structure and Formatting
Step 5: Click on 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.
Answer: Track Changes is used when multiple people are working on a single
document and helps to keep a track of the editing being done by other users.
Track change ensures transparency about the person who made the changes, It
makes it easy for authors to see the suggestions without losing the original text
and the accept and reject change option can be used for canceling or accepting
any changes in the document.
We can use following steps to accept or reject the changes in the documents –
Step 1: Click on Accept Track Change/ Reject Track Change button
11 | P a g e
Step 2: To navigate between the changes, Click on Previous Track
Changes and Next Track Changes.
Step 3: Select Accept All Tracked Changes / Reject All Tracked Changes
button respectively.
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.
Answer: LibreOffice Writer allows to insert image, charts, diagrams and shapes
using various tools. In LibreOffice writer can insert images using various ways
such as using drag and drop, using dialog box or using cut and copy option.
Inserting Image using image option are –
Step 1: Click on Insert > Image from menu bar
Step 2: Select the image file
Step 3: Click on Open button to insert image
Resize Image – Resizing Image allows to change the dimensions of the
image (height and width), resizing image can maintain aspect ration.
Text Wrapping – It allows the text to flows around the image and
manage the positioning of the image to the text.
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.
Answer: Consolidate data feature allows to combine data from different sheets
and summarize into one place.
Steps to use consolidate data feature in LibreOffice calc are –
Step 1: Open a Workbook
Step 2: Create a new sheet where the data has to combine
Step 3: Click on Data > Consolidate option
Step 4: Select the function from drop down menu
12 | P a g e
Step 5: Add Source data ranges
Step 6: Click on check button “Copy results to”
Step 7: Click on “Copy result to” and specify the address where you want
to copy the result
Step 8: Click on “Ok” button
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.
Answer: Subtotals is used to find the subtotals of three arrays arranged in
labeled columns in LibreOffice Calc and sorts the data automatically.
Steps for using subtotal are –
Step 1: Click on Data > Subtotals
Step 2: Select Column a column where you want to apply subtotal
Step 3: Select any functions like sum, count, min, max or average etc.
Step 4: Click Ok
8. What do you mean by Macro? Write the steps to record Macro in
LibreOffice calc.
Answer: Macro is used to performe the same task multiple times using
formulas. Macros helps to use to do the same task multiple times.
Follow the following steps to record a macro –
Step 1: Click on Tools > Macros > Record Macro
Step 2: Start doing actions which you want to record
Step 3: After completion of your actions, Click on Save Macro
Step 4: Change the name of Macro
Stet 5: Click on Save button
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.
Answer: What if scenarios is used to compare different alternatives depending
on the changing conditions.
13 | P a g e
Steps for creating Scenarios in LibreOffice Calc are –
Step 1: Select the cells where you want to apply scenarios
Step 2: Click Tools > Scenarios
Step 3: Enter name of Scenarios
Step 4: Click Ok Button
Unit 3: Database Management System
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.
Answer: (a) Above field which is used to store the student’s information is –
Admission_no, Class, Student_name, Address
14 | P a g e
(b) The “Admission_no” from the table can be used for primary key, primary
key ensure that the duplication will be not allowed in the table, and the
column will be not blank.
(c) Alternate key is a field that can be uniquely identify the record beside the
primary key, the student’s name field could use as a primary key only if there
is guarantee that the student’s name should be not repeated.
(d) If we want to integrate the students table with another table for storing fee
details then relationship can be used as primary key from the student table and
foreign key from another table, the relationship between two table will be
one-to-many.
11. Identify the difference between fields, records and tables in the
database using the student database.
Answer: The difference between fields, records and tables in the database are
–
Field – A field is the smallest entity in the database for example name,
phone number or address, field is a fundamental building blocks of the
database.
Record – Record is a collection of fields, this collection of records makes
a table.
Tables – Table is a collection of records or logically related records,
table are organized in the form of row and column.
12. What are the different types of keys in the database and explain their
roles and importance.
Answer: The different types of keys in a database are –
1. Primary Key – Primary key is field or set of fields which is uniquely
identify in the table. A primary key must be unique and cannot contain
null values.
2. Composite Primary Key – A composite primary key consists of two or
more field uniquely identify each record in the table.
3. Foreign Key – Foreign key is used to link one table to another table using
referencing It is used to make relationship between two tables.
15 | P a g e
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?
Answer: To create a relationship between two table then the parent table will
will contain “Primary key” and the child table will contain “Foreign key”.
14. What do you mean by Query in LibreOffice Base.
Answer: Query helps to retrieve and display data from one or more table using
set of instruction.
16 | P a g e