Practical Questions to be performed at home.

And get the printout of the individual

practical along with question.
Advanced Documentation
Ch 1 Introduction to Styles
Practical 1: Applying Predefined Styles
Objective: To understand and apply built-in styles in a document.
Tasks:
• Open a blank document.
• Type a short article titled "Importance of Healthy Eating".
• Apply the Heading 1 style to the title.
• Apply Heading 2 to subheadings like "Benefits", "Examples", "Tips".
• Apply the Text Body style to the paragraph content.
• Save the document as [Link].
Style Organizer and Load Styles from Template
Objective: Use the Style Organizer and import styles from another document.
Tasks:
• Open or create a formatted document (e.g., [Link]) with custom styles.
• Now open a new document.
• Go to Styles → Load Styles and import from [Link].
• Apply imported styles to the new document content.
• Save as [Link].
Ch 2 Working with Images
Practical 1: Inserting an Image
Objective: Learn how to insert an image from file and from gallery.
Tasks:
• Open a new Writer document.
• Insert an image from your computer (e.g., a nature photo).
 • Insert a second image from the Gallery.
• Resize both images proportionally using the corner handles.
• Save the file as [Link].
Practical 2: Formatting Images
Objective: Use formatting tools to enhance an image’s appearance.
Tasks:
• Insert an image into the document.
• Apply the following formatting:
o Set alignment: Center
o Wrap text: Page Wrap or Optimal Page Wrap
o Add a border (line) to the image.
o Apply shadow and crop part of the image.
• Save the file as [Link].
Ch 3 Advanced features of Writer
Practical 1: Creating and Using a Template
Objective: Learn to create and reuse a document template.
Tasks:
• Create a document layout for "School Newsletter":
o Add title, subheading, 2-column layout.
o Insert placeholder text.
o Add footer with page number.
• Save it as a template (.ott format).
• Use this template to create a new document named Newsletter_August.odt.

Practical 2: Applying a Predefined Template

Objective: Use a built-in Writer template for quick document creation.

Tasks:
• Go to File > Templates > Manage Templates.
 • Choose a built-in template (e.g., Resume, Business Letter, etc.).
• Fill it with your own content.
• Save the file as [Link].
Practical 3: Track Changes – Recording and Accepting Edits
Objective: Learn to use Track Changes for collaborative editing.
Tasks:
• Type a paragraph titled "My Favorite Festival".
• Turn on Edit → Track Changes → Record.
• Make some edits in the paragraph (add/delete/replace words).
• View the changes in a different color.
• Accept or reject each change.
• Save the file as [Link].
 Advanced Spreadsheets
Ch 4 Analyze Data using Scenarios and Goal Seek
Practical 1:Create a simple case of evaluation of rate of interest given by a bank
based on principal, time(in number of years) and interest calculated. Assume that
the interest is simple interest.

Task:

• Enter the data as given above in LibreOffice Calc

• Put the formula in the formula cell here D3. The formula is =(p*r*t)/100
• Choose tools→goal seek. The goal seek dialog box opens up. And enter the target
value as 15000, 55000, 1000, 65000, 20000 respectively for all the principal
amount.

Amount after interest is calculated by applying the formula =(principal + simple

interest calculated).

1. Create a spreadsheet showing the monthly income and expenses of a family.

o Income = ₹45,000, Expenses = Rent ₹15,000, Food ₹10,000, Transport
₹5,000, Miscellaneous ₹7,000.
o Use Scenarios to compare:
a) Increase income by 10%
b) Reduce food expenses by 20%
▪ Show the effect on savings.
Chapter 2 – Using Macros in a Spreadsheet
1. Create a spreadsheet with marks of 5 students in 3 subjects.
o Write a macro to calculate the total marks and percentage of each student.

Task:

2. Record a macro that:

o Changes the font style to Bold
o Changes the background color to Yellow
o Increases font size to 14 for the selected cells.
o Task
Chapter 3 – Linking Spreadsheet Data
1. Create two spreadsheets:
o File 1: [Link] with product names and sales figures.
o File 2: [Link] that links data from [Link] to calculate the total
sales.
Task :

Link other cells → use =SUM(linked cells) for total sales.

2. In a workbook, create two sheets:

o Sheet1: Marks of students
o Sheet2: Fetch data of marks from Sheet1 using linking.
o Create a formula in Sheet2 to calculate the average marks.

Chapter 4 – Share and Review a Spreadsheet

1. Insert comments in a spreadsheet for improvement suggestions on student
performance.
o Show how to navigate between different comments.
2. Track changes in a shared spreadsheet where two users update marks.
o Accept or reject changes after review.
 Database Management System (Advanced)

Ch 11. Queries in Base

1. Prakasan lives in Happy Home Society. He has created the following tables in his
database so as to store and manage the maintenance dues received from flat owners of the
society.
Table: Residents Details Table: Maintenance Dues
Flat no Receipt_Id
Owner Name Flat No
Contact No Date
Flat Category Amount

Task:
1. Design the above given tables with proper Data Type and assign primary key to
both the tables. You have to take print out of each table design showing field names
and field type along with primary key and also the print out of the table displaying
records. There should be atleast 10 records in each table. For example:
Table Design:

Table displaying records:

2. Create a query to display the following information
Flat No Owner Receipt _Id Date Amount

Display the output in the tabular format.

Ch 12. Forms and Reports in Base

Create a form on Residents Details Table and take a colour print out of the generated form
displaying the first record.

Create a report on the above generated query and take a colour print out of the report
created.