Practical-1 (Chapter 1: Introduction to styles.
AIM: To create a custom paragraph style ‘myStyle’, using file ‘noise.odt’ .
Procedure: Step 1. Create a new document named ‘noise.odt’ with the text.
Step 2. Add a title, ‘Noise Pollution’ on top.
Step 3. Format the content of the paragraph with Font face – Arial, Font size 12, line spacing 1.5.
Step 4. Select paragraph button.
Step 5. Select Style Action button.
Step 6. Click on New Style from Selection. A Create Style dialog box will appear.
Step 7. Type ‘myStyle’ as style name in the box and click OK. The Style Name (myStyle) will appear in the drop down list under
Paragraph category.
Practical-2 (Chapter-2: Working with images.)
AIM: 1. Draw a family tree with 3 family members, Mr. R K Sharma (Grandfather), Mr. B Sharma (Father), Mrs. Sunita Sharma
(Mother).
2. Group all items of Family tree. Using the group, change the properties of Rectangle (Fill color – lime yellow, border line –
orange with 0.08” width) and Line (color – black, Style – ultrafine dashed) used in Family Tree.
Procedure:
Step 1. Open a new document in LibreOffice Writer. Enable the Drawing toolbar and ensure that it is displayed on the bottom of
the document window as shown.
Step 2. Select Rectangle Round tool from the toolbar. Place the cursor on the location where you want to draw the family tree,
and drag it to create a rectangle. In the same manner, create other two rectangles as shown.
Step 3. Enter the text in all three rectangular boxes. To enter text, select the rectangle and then type the text.
Step 4. Select the type of line (simple line and line with arrow) from Line tool to draw lines showing hierarchical relation.
Step 5. Save the diagram in file “family.odt”.
Step 6. Select all the lines. For this click on the first line, hold the Shift key and keep on selecting other lines to group them.
Step 7. Click on Group tool in Drawing Object Properties toolbar. Observe that all the lines are grouped together as shown. Now
change the color of all lines grouped together to black.
Group
Practical-3 (Chapter-3: Advanced Features of Writer)
AIM: To store a template
Niaz wants to store the template created by him and another one that was imported by Balwinder in a folder named Company_
Templates on the desktop. Follow the steps given below to complete this task.
Procedure:
Step 1. Create a new document in LibreOffice Writer and press Ctrl+Shift+N to open the Templates dialog box.
Step 2. Select the template to be exported.
Step 3. Click Export button in the bottom right of the dialog box. The Save As dialog box appears.
Step 4. Browse for the folder named Company Templates stored on the desktop.
Step 5. Click Select Folder button to export the selected template.
Step 6. Repeat the steps 1 to 5 to import the template Employee ID Badge in the Company Templates folder.
Practical-4 (Chapter-3: Advanced Features of Writer)
Aim: Table of Contents
Rimjhim has edited her document after the ToC was inserted. Now she wants to update the ToC and also
wants a pink coloured background. Write the steps that Rimjhim should follow.
Procedure:
Step 1. Open the document in LibreOffice Writer.
Step 2. Select Insert > Table of Contents and Index > Table of Contents, Index or Bibliography. The
Table of Contents, Index and Bibliography dialog box will be displayed.
Step 3. In the Type the Titles text box, type Rimjhim’s Table of Contents.
Step 4. Click OK. The Table of Contents will be inserted in Rimjhim’s document.
Step 5. Right-click anywhere in the ToC.
Step 6. From the pop-up menu as shown in Fig. 3.11, select Update Index option. Writer updates the ToC
so as to reflect any changes made in the document. The reflected changes in ToC.
Step 7. To apply a coloured background, right click anywhere on the ToC and select Edit Index option
from the popup
menu.
Step 8. From the Table of Contents, Index or Bibliography dialog box, select the Background tab. The
current background color will be displayed in the Active Color window.
Step 9. Click the Color button on the top of the dialog box.
Step 10. Select the desired color from the Colors palette. The selected color will appear in the New color
window.
Step 11. Click OK to apply the desired color to the ToC.
Practical-5 (Chapter-3: Advanced Features of Writer)
AIM: Comparing changes in Writer
After incorporating the reviews, Pradeep mailed the document to his editor with the Track Changes ON. He made certain
changes in the document. Pradeep wants to compare his original document with the reviewed document. The following process
will demonstrate how Pradeep will compare the edited document with the original document.
Procedure:
Step 1. Open the edited document.
Step 2. Select Edit > Track Changes > Compare Documents option.
Step 3. The Compare to dialog box will appear. Browse and select the original file to be compared as shown.
Step 4. The Manage Changes dialog box is displayed as shown.
Step 5. Accept or reject the desired changes.
Step 6. Close the dialog box when done.
Step 7. Save the edited file.
Practical-6 (Chapter-4: Analyse Data using Scenarios and Goal Seek)
AIM: Data Consolidation of two sheets.
Procedure:
Now let us use the two sheets ‘ABC_Branch’ and ‘XYZ_Branch’ of a spreadsheet marks.ods which will be
consolidated using the following steps:
Step 1. Add a new sheet and rename it as Consolidate
Step 2. Click on Data > Consolidate or use the keyboard shortcut key ALT+D, the Consolidate dialog
window will open as shown.
Step 3. In the Function box, choose Sum function from the drop down as we want to add the data from all
the sheets.
Step 4. Click in the Source data ranges box and then click on the worksheet ABC_Branch and select the
area to be consolidated and then click on the Add button will add the copy reference in the consolidation ranges
Step 5. Click on the sheet XYZ_Branch and select the area
to be consolidated and then click on ADD will add the
next consolidation range.
Step 6. Click on the ‘+’ sign next to Options in the
Consolidate dialog window to change the settings. ‘
Consolidate by’ has two options Row labels and Column
labels. Check row label or column label or both if you
want to consolidate it by matching the label. If Link to
source data is checked, then it will keep on updating the
data of the Consolidate sheet automatically if there is any
change made in the selected ranges.
Step 7. Click on ‘Copy results to’ and then click on any of
the cell in the Consolidate sheet where you want to copy
the final result after consolidation.
Step 8. Click on OK button, will display the Consolidate sheet with data after consolidation.
Practical-7: (Analyse data using Scenarios and Goal seek)
AIM: To create Subtotals
Procedure:
Step 1. Create a sheet as shown in libre office.
Step 2. Now, to calculate the average salary of employees department wise.
Step 3. To do so, click on Data > Subtotal, the subtotal dialog as shown will open.
Step 4. Choose the column i.e.
Class under Group by in the 1 st Group on
which we need to group the whole data.
Also, select the department
under Calculate subtotals for. For each
department click on the Average under Use
function individually otherwise Sum
function will be used by default.
Step 5. Click OK and the sheet will look
like as shown.
Practical-8 (Chapter-4: Analyse Data using
Scenarios and Goal Seek)
AIM: GOAL SEEK
Let us take a very simple example to perform the backward calculation to find out an input depending upon
the specific output. A student has received marks in 4 subjects and has to appear for the 5th subject and
plans an aggregate as 70. So, he can use goal seek tool to check how many marks he has to score in the 5th
subject to get the required percentage. Follow the following steps to perform this task.
Procedure:
Step 1. Create the mark sheet as shown. Enter the average function in cell B7 as =Average (B2:B6)
Step 2. Click on Tools > Goal Seek will display the Goal seek dialog window.
Step 4. Write the cell address of the formula, i.e. B7 in the Formula cell box.
Step 5. Write the cell address of the cell which is to be generated by the system in the Variable cell box. In
This example, it is cell B6 which we want to be filled as per the average marks needed.
Step 6. Enter the result in the Target value box. As per
our question, we have to get minimum 75 aggregate so
we will write 70 in the target value.
Step 7. Clicking on OK will display an error as
LibreOffice Calc will not accept the Variable cell to be
empty. So, this error dialog window will prompt to
add 0 value in the variable cell.
Step 8. Click on Yes and then repeat the step 2 will
display the dialog window and prompts whether to
change the cell with the calculated value.
Step 9. Click on Yes will change the value with the
calculated one.
Practical-9(Chapter 5: Using Macros in Spreadsheet)
AIM: To create a simple Macro using BASIC programming instructions that will display Hello in a dialog
box stored in the Standard module
Procedure:
Step 1. Create the spreadsheet. Write the heading “Data Analysis” in cell A1.
Step 2. Choose Tools > Macros > Record Macro.
Step 3. Click Stop Recording to stop the Macro Recorder.
Step 4. The Basic Macro dialog appears as shown, in which
you can save and run the macro when executed.
Step 5. Open the LibreOffice Basic Macro dialog box using
Tools > Macros > Organize Macros > LibreOffice
Basic.
Step 6. From the Basic Macros dialog box select Organizer
Step 7. From Modules tab, select My Macros folder and click
on New button.
Step 8. Give a name to the New Module say ‘Hello’ and click
Ok. You will see Hello under Standard Library in My
Macros Library.
Step 9. Select Hello and click Edit to open the Integrated
Development Environment (IDE). It is a editor that allows you to
create and edit macros. Type Print “Hello” between Sub Main and End sub as shown.
Practical-10 (Chapter -7: Share and Review a Spreadsheet)
AIM: Merge two files
To work on our earlier created spreadsheet Test.ods, save the file Test.ods with another name say
Test1.ods and make some changes in the spreadsheet Test1.ods. Now, we have two files that are to be
merged.
Procedure:
Step 1. Open the spreadsheet file Test.ods. Note the contents of spreadsheet Test.ods. Also note the
contents of spreadsheet Test1.ods before merging.
Step 2. Click on Edit > Track Changes > Merge Document as shown.
Step 3. Select the spreadsheet file Test1.ods from the Merge 0With dialog window to open the spreadsheet
Test1.
ods to merge with Test.ods and Click on Open button as shown.
Step 4. This will open Manage Changes dialog window as shown.
Step 5. Click on Accept All to accept all the changes which is done in the Test1.ods spreadsheet to the
Test.ods.
Step 6. Now open the first spreadsheet Test.ods after merging and observe its contents as shown in Fig.
7.24. Observe that show the contents of Test.ods and Test1.ods merged.
UNIT-III (DATABASE MANAGEMENT SYSTEM)
Practical-11 (Chapter 9: Staring with Libre office)
AIM: To create a table named Events using in the option Create Table in Design
view in the Sports Day database.
Procedure: Follow the following steps to do so.
Step 1. Type the first field name (EventId) in the Field Name column. Press Tab key.
The cursor moves to the second column i.e. Field Type.
Step 2. The Field Type column contains a list box. As you click on the down arrow, it
appears and we can select the desired data type from the list box. Select the datatype
(Varchar).
Step 3. Observe that certain properties appear in the Field Properties Pane as the data
type is selected. Some of the properties are Entry required, Length, Default value,
Format example. Set the desired properties for the entered field.
Step 4. Press Tab key to move to the next column. Add any description if you want in
the third column. Step 5. Once the properties for the field are set, press Tab key to
move to next row.
Step 6. Enter the next field by repeating steps 1, 2 and 3. Repeat the process for
adding all fields in the table shows the Design View with all the fields.
Practical-12(chapter11: Queries in Base)
AIM: To create a query using a wizard
Procedure:
Step 1. Open the Sports Day database. In the Database Design window, click on
Queries button present in the Database Pane on the left.
Step 2. In the Tasks Area, click on Use Wizard to Create Query… option. The
Query Wizard will start, It contains the Steps Pane on the left and the Query
Details Area on the right.
Step 3. The first step of the wizard is to select fields from the respective tables. For
our query, to display Event Name and Winner and the criterion to filter the records
based on CategoryID. All these fields are present in Events table.
Step 4. Select Event Name field from the list box and click the right arrow (>) button. The
field name will appear in the Fields in the Query list box.
Step 5. Clicking on the Next button will display the screen to select the sorting order
as shown, It will set the sorting order.
Step 6. The next step is to set the search conditions or the criteria on the basis of
which records will be filtered from the table.
Step 7. Select Events. Category ID field from Fields drop down list, is equal to from
Condition drop down list and type the value as C001 as shown, and click on Click
Next button.
Step 8. Steps 4, 5 and 6 given in the Steps Pane deal with tasks like summarizing and
performing numerical calculations.
Step 9. The next step to give alias name i.e. the column header name will be displayed
when we run the query. By default the field names will be displayed as column
headers.
Step 10. The last step of the Query wizard displays the entire overview of the query as
shown.
Practical 13 (Creating Relationship between two tables)
Aim: Creating Relationships between Tables
Procedure:
1. From main menu of LibreOffice Base, click on Tools →
Relationships
2. The Relationship Design screen will appear.
In the middle of the screen there is Add Tables dialog box. Both
the tables are listed in the dialog box.
3. In the Add Tables dialog box, click event table and then click
Add button. Similarly, add event category table to the relationship
area.
4. Click Close button to close the Add Tables dialog box.
5. As discussed before, category ID is the common field in the two tables. Hence it will be used to set a
relationship between the two tables. To create a relation between the two tables, we just have to drag
the common field Category ID from the events table and drop it in Event category table. A line
connecting both the tables with common field appears on the screen.
Practical 14 ( Chapter 12: Forms and Reports)
Objective: Creating form using wizard
Task: Create table a form using wizard by selecting all the fields for the table - Marksheet
Solution
Steps to create a form using wizard
1. Click on Forms → Use Wizard to Create Form…
2. A Form Wizard appears.
3. Select the table from Tables or Queries then add all the fields.
4. Click on Next button. Ignore step 3 and step 4 from
wizard.
5. Select the first option i.e. Columnar – Labels Left
then click on the next button.
6. Now set data entry step will be there. Ignore this step and click on Next. Choose the styles
for the form interface and click on next.
7. Type new name for the form and click on work with the form. Click on Finish.
Form Output:
Practical-15 :
AIM: To create a report using the table Events from the Sports Day
database.
Procedure: Follow the following steps to create a report.
Step 1. In the LibreOffice Base User Interface, click on the Reports icon in the
Database Pane. Step 2. From the Tasks Pane, click Use Wizard to Create
Report… option.
Step 3. The Report wizard along with two other windows will be displayed. One of the
window is Report Builder window and the other is Add Field dialog box. We will
confine our study to the wizard.
Step 4. The first step of wizard is to select the table and the corresponding fields that we
want to display in our report. From the Tables or Queries list box, select the table
Events.
Step 5. All the fields of the Events table will be listed in the Available Fields list box.
Click >> button to shift all the fields to Fields in report list box.
Step 6. Click on the Next button. The next step is to label the fields. By default, the
column headers will be displayed as labels or column headers for the field values. As
fields names are generally shortened, to change to more self-explanatory names, type
the new names in the respective text boxes.
Step 7. Click on the Next button. The next step is to group the data based on any of
the fields in the report.
Step 8. The fourth step is to set the Sort options. If the data to be displayed in the
report has to be sorted in either ascending or descending order of a particular field.
Step 9. Click on the Next button to move on to the next step in which the layout of the
report will be selected.
Step 10. A layout is the manner in which the labels, field values and titles will be
displayed in the report. Out of various Layout options given, choose the desired layout, say
Tabular and also the layout of headers and footers (Default). You may also choose the
orientation option Landscape or Portrait in this step.
Step 11. Click on the Next button to move to last step. Here we name the report and to
specify the manner in which we want to proceed after the wizard finishes.
