Information Technology – 402

1. Creating styles in OO Writer

Aim : To create a style in Open Office Writer
Tools Required:
Computer with window OS
Open office writer
Steps to be followed:
Step 1. Click on Format — Styles and Formatting option to activate styles gallery.
Step 2. Click on Create New Style from Selection option, a new drop down menu will
appear with following options:
1. New Style from Selection: Allows to create new style
2. Update Style: Allows to update existing style
3. Load Style: Load Style from another template
A small window will appear with the title “Create Style“.
Step 3. Type desired style name and click on OK button. A newly created style will take
place into style gallery.
Step 4. Select the newly created style and right click on it. Select Modify option to apply
various formatting.
Step 5. Select appropriate formatting from the opened window and click on when
finished.
Result:
Thus a newly created style added into style gallery.
OUTPUT

2. Inserting an image
Aim : To Insert an image into document and format the contents
Tools Required:
 Computer with window OS
Open office writer
Steps to be followed:
Step 1. Click on the Open Office document where we want the image to appear.
Step 2: Choose Insert > Picture > From File from the menu bar.
Step 3: On the Insert Picture dialog, navigate to the file to be inserted, select it, and click
Open.
Step 4: Resize the picture as it fits in our document.
Step 5: Crop image 2 and remove unwanted part.
Result:
Thus an image is being inserted and formatted successfully using OO writer.

OUTPUT

3. Creating A Template From A Document

Aim : To create a template from a document and prepare an invoice report for a
company.

Tools Required:
Computer with window OS
Open office

Steps to be followed:
Step 1: Open a new or existing document of the type you want to make into a template (text
document, spreadsheet, drawing, presentation).
Step 2: Add the content for creating the invoice and styles that are needed
step3: From the main menu, choose

File > Templates > Save.

Step 4: The Templates dialog opens. In the New template field, type a name for the new
template.
Step 5: In the Categories list, click the category to which you want to assign the template.
The category you choose has no effect on the template itself; it is simply the folder in which
you save the template. Choosing an appropriate category makes it easier to find the template
when you want to use it.
Step 6:. Click OK to save the new template.
Step 7: Prepare invoice report using that template and save the OO document with name
“invoice report”.

Result:
Thus a new template added to the template list and the invoice report is generated
successfully.
OUTPUT

4. Inserting shapes in OO Writer

Aim: To Insert shapes in a Open Office Writer document
Tools Required:
Computer with window OS
Open office writer

Steps to be followed:
Step 1. Click on Show draw functions icon on standard toolbar.
Step 2. Now drawing toolbar will appear the screen with some basic shapes.
Step 3. Select desired drawing object and draw at desired location in the document.
Step 4: Create a types of communication using the desired shapes.
Step 5: Save the document with name “communication ”
Result:
Thus the shapes are inserted and types of communication is created using OO Writer
successfully.

OUTPUT:

Draw function in standard toolbar

Drawing toolbar in OO Writer

5. Create a Mail Merge Document: Letter
Aim: To create a Mail Merge Document – Letter using OO Writer
Tools Required:
Computer with window OS
Open office writer

Steps to be followed:
Step 1:Type a letter for informing the employees of a company about their appreciation.
Your letter will serve as your form letter. Save your letter as Mail Merge Letter.
Step 2: Format the letter as left aligned (block letter) with .5” or 1” margins depending on the
length.
Step 3: Make sure your address is listed at the top of the document. Then insert two blank
lines and put the date in the month, date, year format. Then enter four blank lines and leave
space for your merge fields. Example:
Title First Name Last Name Address 1 City, State
Step 4: Create a data source with the names and addresses of at least five families in which
you wish to mail the letters. Create fields such as: title, first name, last name, address 1,city,
state. Or make appropriate field names of your choice but make sure you include the address
information. Save your data source as Mail Merge Data.
Step 5: Now, return to your main document (Mail Merge Letter) and set it as the form
document and identify your data source.
Step 6: Enter your merge fields into your main document. Merge fields should be used for
the recipients address and after Dear.
Step 7: After your merge fields are entered merge the document and save it. Save the
merged document as Mail Merge Merged.
Step 8: Create labels inserting your merge fields for the recipient’s name and address. Save
the merged labels as Mail Merge Labels.
Step 9: Print your form letter, one merged letter, and one label.

Result:
Thus the mail merge for letter is created using OO writer document

OUTPUT
6. Consolidating data
Aim: To consolidate data from separate worksheets into a master worksheet for generating
sales report for a year.
Tools Required:
Computer with window OS
Open office Calc

Steps to be followed:

Step 1: Open the worksheet that contains the cell ranges to be consolidated for sales report
generation for the year 2020 to 2021
Step 2: Choose the Consolidate option under the Data menu
Step 3: If the Source data range list contains named ranges, you can select a source cell
range to consolidate with other areas.
If the source range is not named, click in the field to the right and either type a reference for
the first source data range or use the mouse to select the range on the sheet
Step 4: Click Add. The selected range now appears on the Consolidation ranges list.
Step 5: Select additional ranges and click Add after each selection.
Step 6: Specify where you want to display the result by selecting a target range from the
Copy results to box. If the target range is not named, click in the field next to Copy results to
and enter the reference of the target range or select the range using the mouse or position the
cursor in the top left cell of the target range.
Step 7: Select a function from the Function list.
Step 8: Optionally click More in the Consolidate dialog to display additional settings.
• Select Link to source data to insert the formulas. This generates the results in the target
range instead of the actual results. If you link the data, any values modified in the source
range are automatically updated in the target range.
Step 9: Click OK to consolidate the ranges.

RESULT
Thus the data from the consolidation ranges and target range for sales report are generated
using open office calc

OUTPUT
 7. Creating Subtotals using Calc

Aim: To insert subtotal values into a worksheet for calculating subtotals of employees in
a company.
Tools Required:
Computer with window OS
Open office Calc

Steps to be followed:
Steps to insert subtotal values into a sheet:

Step 1: Ensure that the columns have labels.

Step 2: Select the range of cells that you want to calculate subtotals for, and then choose
Data -> Subtotals.
Step 3: In the Subtotals dialog (Figure 2.4), in the Group by box, select the column that you
want to add the subtotals to. If the contents of the selected column change, the subtotals are
automatically recalculated.
Step 4: In the Calculate subtotals for box, select the columns containing the values that you
want to subtotal.
Step 5: In the Use function box, select the function that you want to use to calculate the
subtotals.
Step 6: Click OK.

Result:
The subtotal for given data is calculated using open office calc

OUTPUT