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 and paste
the screenshot.
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 and
paste the screenshot.
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 and paste the screenshot.
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 and paste the screenshot.
Unit 2: Electronic Spreadsheet (Advance)
6. Prepare the following worksheet and display the sum of
items according to items and then regions.
7. 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 and paste the screenshot.
8. 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 and paste the screenshot.
9. What do you mean by Macro? Write the steps to record
Macro in LibreOffice calc.
10 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 and paste the
screenshot.
Unit 3: Database Management System
11. Consider the following table: Students
12. Identify the difference between fields, records and tables in
the database using the student database.
13 What are the different types of keys in the database and
explain their roles and importance.
14 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?
15 What do you mean by Query in LibreOffice Base.
CBSE | DEPARTMENT OF SKILL
EDUCATION
INFORMATION TECHNOLOGY
SUBJECT CODE - 402
Class X Practical File Question
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. Prepare the following worksheet and display the sum of items according to items and then
regions.
Your output should be like this:
7. 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
8. 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
9. What do you mean by Macro? Write the steps to record Macro in LibreOffice calc.
10. 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
11. 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.
12. Identify the difference between fields, records and tables in the database using the student
database.
13. What are the different types of keys in the database and explain their roles and importance.
14. 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?
15. What do you mean by Query in LibreOffice Base.
********__********
