LibreOffice Writer(Digital Documentation)
1. Create a Document with Proper Formatting
Task:
Create a document with the title “Importance of Cleanliness,” apply proper formatting, and save the document.
Steps:
Open LibreOffice Writer.
Type the title “Importance of Cleanliness” at the top of the document.
Select the title and apply the following formatting:
Font: Times New Roman
Size: 16
Style: Bold
Alignment: Center
Below the title, type a paragraph of 4-5 lines about the importance of cleanliness.
Format the paragraph:
Font: Arial
Size: 12
Line Spacing: 1.5
Alignment: Justified
Save the document as “Cleanliness.odt.”
2. Insert and Format an Image
Task:
Insert an image into a document and wrap text around it.
Steps:
Open a new LibreOffice Writer document.
Go to Insert > Image and select an image from your computer.
Click on the inserted image to select it.
Use the toolbar to resize the image to an appropriate size.
Right-click on the image and select Properties or Wrap.
Choose the Wrap option as “Page Wrap” or “Optimal Page Wrap.”
Save the document as “ImageFormatting.odt.”
3. Create a Table
Task:
Create a table of 4 columns and 5 rows to display student details (Name, Class, Roll Number, Marks).
Steps:
Open LibreOffice Writer.
Place the cursor where you want to insert the table.
Go to Table > Insert Table.
Set Columns to 4 and Rows to 5.
Click OK to insert the table.
Enter the following headings in the first row: Name, Class, Roll Number, Marks.
Enter sample data in the remaining rows.
Format the table:
Select the table and choose Table Properties.
Apply a border and shading to the table.
Save the document as “StudentDetailsTable.odt.”
4. Apply Styles and Templates
Task:
Use pre-defined styles to format a document and apply a template.
Steps:
Open a new LibreOffice Writer document.
Type the heading “Healthy Lifestyle” and a paragraph below it.
Go to Styles > Manage Styles or press F11.
Apply the “Heading 1” style to the heading.
Apply the “Text Body” style to the paragraph.
Go to File > Templates > Manage Templates.
Choose a template and apply it to the document.
Save the document as “HealthyLifestyle.odt.”
5. Create a Table of Contents
Task:
Generate a table of contents for a document with multiple headings.
Steps:
Open a document with multiple headings.
Ensure each heading is assigned a style (e.g., Heading 1, Heading 2).
Place the cursor where you want the table of contents.
Go to Insert > Table of Contents and Index > Table of Contents, Index or Bibliography.
Click OK to generate the table of contents.
Save the document as “TableOfContents.odt.”
6. Use Find and Replace
Task:
Find and replace specific words in a document.
Steps:
Open a document in LibreOffice Writer.
Press Ctrl + F to open the Find toolbar.
Click on the drop-down arrow and select Find & Replace.
In the Find box, type the word to search for.
In the Replace box, type the replacement word.
Click Replace All to make changes throughout the document.
Save the document as “FindReplace.odt.”
LibreOffice Electronic Spreadsheet
1. Create a Simple Spreadsheet
Task:
Create a spreadsheet with student marks and calculate the total and average.
Steps:
Open LibreOffice Calc.
Enter the following data:
Column A: Student Names
Column B: Subject 1 Marks
Column C: Subject 2 Marks
Column D: Subject 3 Marks
In Column E, calculate the Total Marks:
Select the first cell in Column E (e.g., E2).
Type the formula =B2+C2+D2 and press Enter.
Drag the formula down for all rows.
In Column F, calculate the Average Marks:
Select the first cell in Column F (e.g., F2).
Type the formula =E2/3 and press Enter.
Drag the formula down for all rows.
Save the spreadsheet as “StudentMarks.ods.”
2. Use Functions in a Spreadsheet
Task:
Use functions like SUM, AVERAGE, MIN, and MAX in a spreadsheet.
Steps:
Open a new LibreOffice Calc spreadsheet.
Enter a column of numbers (e.g., Sales data for 10 days).
In a blank cell, use the following functions:
SUM: =SUM(A1:A10) to calculate the total.
AVERAGE: =AVERAGE(A1:A10) to calculate the average.
MIN: =MIN(A1:A10) to find the minimum value.
MAX: =MAX(A1:A10) to find the maximum value.
Save the spreadsheet as “FunctionsDemo.ods.”
3. Use Conditional Formatting
Task:
Highlight marks greater than 75 in green and less than 40 in red.
Steps:
Open a spreadsheet with marks data.
Select the range of marks.
Go to Format > Conditional Formatting > Condition.
Set the conditions:
For marks > 75: Choose “Cell Value is > 75” and apply green formatting.
For marks < 40: Choose “Cell Value is < 40” and apply red formatting.
Click OK to apply the formatting.
Save the spreadsheet as “ConditionalFormatting.ods.”
4. Data Consolidation
Task:
Consolidate data from multiple sheets into one.
Steps:
Open a spreadsheet with multiple sheets containing similar data (e.g., monthly sales).
Go to a new sheet.
Select the cell where you want to consolidate the data.
Go to Data > Consolidate.
Add the ranges from the other sheets.
Choose the function (e.g., SUM or AVERAGE).
Click OK.
Save the spreadsheet as “DataConsolidation.ods.”
5. Perform Goal Seek
Task:
Determine the marks needed to achieve a total of 250.
Steps:
Open a spreadsheet with marks data and total calculation.
Go to Tools > Goal Seek.
In the dialog box:
Set the target cell to the Total Marks cell.
Set the target value to 250.
Set the variable cell to one of the subject marks.
Click OK to get the result.
Save the spreadsheet as “GoalSeek.ods.”
6. Link Data Between Sheets
Task:
Link data from one sheet to another.
Steps:
Open a spreadsheet with multiple sheets.
In a cell in Sheet2, type = and navigate to Sheet1.
Click on the cell in Sheet1 that you want to link and press Enter.
The value from Sheet1 will appear in Sheet2 and update automatically when changed.
Save the spreadsheet as “DataLinking.ods.”
LibreOffice Database management System
1. Create a Database
Task:
Create a database to manage student records.
Steps:
Open LibreOffice Base.
Select Create a New Database and click Next.
Choose “Yes, register the database” and click Finish.
Save the database as “StudentRecords.odb.”
2. Create a Table
Task:
Create a table to store student details.
Steps:
In LibreOffice Base, go to the Tables section.
Click Create Table in Design View.
Add the following fields:
StudentID (Data Type: Integer, Primary Key)
Name (Data Type: Text [VARCHAR])
Class (Data Type: Text [VARCHAR])
Marks (Data Type: Decimal)
Right-click the row for StudentID and select Primary Key.
Save the table as “StudentDetails.”
3. Create a Query
Task:
Create a query to display students scoring above 80 marks.
Steps:
Go to the Queries section and click Create Query in Design View.
Add the “StudentDetails” table.
Drag the required fields (e.g., StudentID, Name, Marks) to the query grid.
Under the “Marks” column, set the criteria to >80.
Save the query as “HighScorers.”
Run the query to view the results.
4. Create a Form
Task:
Create a form to input student details.
Steps:
Go to the Forms section and click Use Wizard to Create Form.
Select the “StudentDetails” table.
Choose the fields to include in the form.
Follow the wizard steps to customize the layout and style.
Save the form as “StudentForm.”
Open the form and enter a new record.
5. Create a Report
Task:
Generate a report of all student records.
Steps:
Go to the Reports section and click Use Wizard to Create Report.
Select the “StudentDetails” table or the “HighScorers” query.
Choose the fields to include in the report.
Customize the report title, page layout, and grouping (if required).
Save the report as “StudentReport.”
View the report in Print Preview mode.
5. Sort Data
Task:
Sort the student records by marks in descending order.
Steps:
Open the “StudentDetails” table or query.
Click on the “Marks” column header.
Choose the Sort Descending option.
Save the changes.
Sir Thank You So Much😁