Unit 1: Digital Documentation (Advanced)

Learning Outcome - Create and apply styles in digital document

Assignment 1
Objective: Using various commands to create styles in OO 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: DreamQuot

Solution:

1|Page
Solution:

2|Page
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. Insert some shapes and write additional text into the shapes.

Solution:

Steps:

3|Page
Learning Outcome - Create and use template
Assignment 3
Objective: Creating templates in OO Writer and saving for distribution.
Task:
• Prepare a template for the application writing format.
• Apply formatting as required.
• Set this template as a default template.
• Change the default template to custom template. Change the formatting as you wish.

4|Page
Solution

5|Page
Learning Outcome – Create and Customize Table of Contents
Assignment 4
Objective: Create and Customize Table of Contents

Task: Prepare a document with different headings and apply a table of contents to it.

6|Page
Solution:

7|Page
 Learning Outcome – Implement the mail merge
Assignment 5
Objective: Implement mail merge
Task: Write a letter to invite your parents and other guests to attend the annual day function of
your school and merge them. Create a data source with at least 10 addresses.

8|Page
\

9|Page
10 | P a g e
11 | P a g e
 Unit 2: Electronic Spreadsheet (Advanced)
Learning Outcome Analyze data using scenarios and goal seek
Assignment 1
Objective: Applying Data Consolidation in OO Calc
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.

12 | P a g e
Solution:

13 | P a g e
14 | P a g e
Assignment 2

Objective: Applying subtotal in OO Calc

Task: Prepare a worksheet as following

Solution:

15 | P a g e
16 | P a g e
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:

17 | P a g e
Setting up worksheets

Creating Reference

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

18 | P a g e
 Learning Outcome – Share and review a spreadsheet
Assignment 4
Objective: Setting up a spreadsheet for sharing.

Task: Create a new file in spreadsheet software and enable sharing.

1. Create a new worksheet, enter data as you wish.

2. Save your worksheet with your desired name.

3. Enable sharing for your worksheet.

Solution

19 | P a g e
20 | P a g e
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.

English Maths Science

PT 1 72 63 54
Term 1 70 69 80
Find out how many marks should she obtain in term 2 to secure distinction.
Solution:

21 | P a g e
 Unit 3
Database Management System

Learning Outcome – Create and edit tables using wizard

Assignment 1

Objective: Steps to create a table using table wizard

Task: Create a table using wizard

Create any table in OO base using table wizard.

Solution

22 | P a g e
23 | P a g e
1. Click on Next and select field types and all if you want to change it. Click on Next.

24 | P a g e
25 | P a g e
 Learning Outcome – Retrieve data using query

Assignment 2

Objective: Query creation using wizard

Task: Create table Marksheet (Using SQL Command )and perform the bellow given queries

using wizard and design view.

Field Name Data Type Size

Stud_No Integer 2

Name Text 15

RollNo Integer 3

Sub101 Decimal 3,2

Sub102 Decimal 3,2

Sub103 Decimal 3,2

1. In the Database file Add these Fields: (Total: Datatype- Number 3 digits, Percentage:

Datatype - Number 3 digits with 2 decimal places, Grade: Datatype- Char with 2 letters)

2. Insert more 3 records in MARKSHEET using SQL mode.

3. Display name, rollno, marks of 3 subjects, total and percentage using design view.

4. Display name, rollno, grades from the marksheet table using query wizard.

5. Display the maximum marks for Sub101 and minimum marks for Sub102 using design

view.

26 | P a g e
6. Display the rollno, name and percentage whose percentage are more than 70 using design

view.

7. Display all the record in ascending order of names using design view.

Solution

Create table command

Output

27 | P a g e
Queries

28 | P a g e
Output

29 | P a g e
30 | P a g e
Output

31 | P a g e
Output

32 | P a g e
 Learning Outcome – Create Forms and Reports using wizard

Assignment 3

Objective: Creating form using wizard

Task: Create table a form using wizard by selecting all the fields for the table - Marksheet

Solution

33 | P a g e
34 | P a g e
1. Type new name for the form and click on work with the form. Click on Finish

35 | P a g e
Assignment 4

Objective: Creating report using wizard

Task: Create table a report using wizard by selecting all the fields for the table - Marksheet

Solution

36 | P a g e
37 | P a g e
Output

38 | P a g e