Digital Documentation

PRACTICAL 1- Create and apply styles in digital document

Objective: Using various commands to create styles in Libre Office Writer.
Task: Type a paragraph with at least 100 words and create below given styles as
instructed:

1. Heading: Font name: Font name: Times New Roman, Size: 24 , Colour: Red. Give
the style name: Dream Heading (Use create style from selection command to create
style)
2. Paragraph: Apply Style Text Body from the Style Gallery
3. Quote: Font Name: Broadway, Size:16, Colour: Blue, Alignment: Center. Give the
style name: DreamQuote

Solution:

Solution:

1. Creating styles for Heading and Quote

 ➢ Open Styles and Formatting dialog box by clicking Format → Styles and

Formatting ➢ Click on New Style From Selection from the dialog box.

➢ Type the desired names. For example Dream Heading for heading and
DreamQuote for Quote

➢ Now right click on the particular style to change the format.

➢ Select the given formatting from the update style dialog box.

➢ Click on OK

2. Applying styles from Gallery (Text Body to paragraph)

➢ Select the paragraph

➢ Open Styles and Formatting Dialog box

➢ Select the Text Body style

➢ Now select the fill format icon from the dialog box

➢ Drag over the selected paragraph

Learning Outcome – Insert and Use Images in digital document

Assignment 2

Objective: Inserting images and shapes and rearranging them

Task:
1. Create a new document in OO Writer and Type a paragraph.
2. Insert a picture of your choice.
3. Adjust the picture at top left to the paragraph.
4.
5. Insert some shapes and write additional text into the shapes.
Steps:

1. Open libre Office Writer and Type the paragraph.

2. Click on Insert → Picture → From File.

3. Select the picture to insert.

4. Resize the picture according to the need.

5. Go to the picture properties and select Wrap → Parallel option.

6. Insert shape and insert the desired text.

7. Right Click on the shape and choose Wrap → Optimal Page Wrap option.

Electronic Spreadsheet
Learning Outcome Analyze data using scenarios and goal seek
Assignment 1
Objective: Applying Data Consolidation in Libre Office
Spreadsheet
Task:
1. Create a new file in spreadsheet software and enter data for 10 salesmen.
2. Add two worksheets in the file and modify the data for all 3 quarters.
3. Rename all worksheets like sheet1 - 2018, sheet2 - 2019 and sheet3 - 2020.
4. Now add one more worksheet at the end and rename as consolidated sheet.
5. Now type the serial no and names as displayed, use sum function to add data for 2018, 2019
and 2020 in respective cells using consolidation.
Solution:

1. Create a new spreadsheet in OO Calc.

2. Enter the data for Sheet 1 and rename sheet as 2018. To rename the worksheet
right click on sheet tab then type the desired name. Press enter key to accept the
name.
 1. Follow the same instructions for next two worksheets.
2. Add one more worksheet to display the consolidation result and rename as
Consolidated.
3. Select the cell ranges where results needs to appear.

1. Click on Data ⇢ Consolidate option. A consolidate dialog box will appear.

2. Select your desired function (Sum here) and add references to the cells by
selecting ranges.
 3. Move the cursor on 2018 work sheet and select the range. Click on Add button.

4. Repeat the same for 2019 and 2020 worksheet respectively.

5. Click on OK button.

Assignment 2
Objective: Applying subtotal in OO Calc
Task: Prepare a worksheet as following
Solution:

1. Open spreadsheet software and enter the data as following:

Click on Data

5. Click on OK button.
Assignment 3
Objective: Link data and Spreadsheet
Task: Prepare a worksheet as following

1. Enter the data such as Roll no, GR NO, First Name, Last Name, Date of Birth, Father Name,
Mother Name. Enter records for at least 10 students.
2. Rename this worksheet as "Student Profile".
3. Insert 3 new worksheets and rename as "Periodic Test I", "Periodic Test II" and "Periodic
Test III" respectively.
4. In the Periodic Test I worksheet create a reference for Roll No, First Name, and Last Name
columns from Student Profile by using the keyboard.
5. In the Periodic Test II worksheet create a reference for Roll No, First Name, and Last Name
columns from Student Profile by using the mouse.
6. In the Periodic Test III worksheet create a reference for Roll No, First Name, and Last
Name columns from Student Profile as you wish.

Solution:
Setting up worksheets
1. Open spreadsheet software and type the required data as given in the
question.

2. Right click on Sheet tab, choose rename option. Now type “Student
Profile”.

3. Click on Insert Sheet option three times and rename them respectively.

Creating Reference

1. Open Periodic Test I worksheet and place the cursor in the first cell.

2. Now type =.

3. Then move or select the student profile and select the cell where roll no is
written.

Repeat these steps for all worksheets, to link other cells.

Assignment 5
Objective: Goal seek Application
Task: A student is planning her goals about the marks she should attain in the

forthcoming examinations in order to achieve a distinction (75%). Assuming that the

examination of each subject is for 100 marks, her marks of PT 1 and Term 1 are given

as under.
1. Enter data as given in the question itself.

2. Place the cursor to get the result for the marks of term 2.

3. Place the cursor in B5 and write avergae() formula.

4. Now click on Tools → Goal Seek option.

5. Check the formula cell (it should be B5 only).

6. Now write the target value i.e. 75.

7. Select the cell B4 to see the value to adjust the marks.

8. Repeat the same steps Maths and Science as well.

Assignment 4
Objective: Creating report using wizard
Task: Create table a report using wizard by selecting all the fields for the table -
Marksheet
Solution
1. Click on Reports → Use Wizard to Create report. The report wizard will open in
the new window.
2. Select the table and add fields.
3. Now change the label text that you want in the report. I have changed the label
Stud_no into Adm. No. Click on Next.

4. I have skipped groping and sorting options by click on Next button.

5. Now choose the layout. I have selected Outline-Elegant as Layout of Data,

Landscape

Orientation, and Bubbles Layout of Headers and Footers. Click on Next.

6. Now type the title of the report and select dynamic report → Create report now
option.

7. Now click on finish.

Output