Unit 1: Digital

Documentation
(Advanced)
Activity-1

Learning Outcome - Create and apply styles in digital

document
Objective: Using various commands to create styles in
LibreOffice 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
creates 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:

Page | 1
1. Creating styles for Heading and Quote
o Open Styles and Formatting dialog box by clicking
Format → Styles and Formatting or pressing F11
o Click on New Style from Selection from the dialog box.
o Type the desired names. For example Dream Heading
for heading and DreamQuot for Quote
o Now right click on the particular style to change the
format.
o Select the given formatting from the update style dialog
box.
o Click on OK

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

o Select the paragraph
o Open Styles and Formatting Dialog box
o Select the Text Body style
Page | 2
 o Now select the fill format icon from the dialog box
o Drag over the selected paragraph

Activity-2

Learning Outcome – Insert and Use Images in digital

document
Objective: Inserting images and shapes and rearranging
them.
Task:
1. Create a new document in LibreOffice 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:

Page | 3
Steps:
1. Open LibreOffice Writer and Type the paragraph.
2. Click on Insert → Image.
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.

Activity-3
Learning Outcome - Create and use template
Objective: Creating templates in LibreOffice Writer and
saving for distribution.
Page | 4
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

Solution:

 Application Letter Template Contents

 Insert the shape for school logo.
 Type School Name and Address as displayed in the
screen shot.
 Type Subject line.
Page | 5
  Type the matter required for the application as
displayed in above screen shot.
 Apply formatting as your wish.
 Click on File → Templates→ Save as Template
 Save the file.
 Set up a custom default template in LibreOffice writer
 Click on File → Templates → Manage Templates.
 Choose the folder of template.
 Select desired template to set as default template.

Activity-4
Learning Outcome – Create and Customize Table of
Contents
Objective: Create and Customize Table of Contents.
Task: Prepare a document with different headings and
apply a table of contents to it
Page | 6
Solution:

1. Type the contents.

2. Apply appropriate level of headings from the Styles
and Formatting window.
3. Click on Insert → Table of Contents and Index → Table
of Contents, Index and Bibliography.
4. Select and apply the styles for the Table of Contents.
5. Click on OK

Page | 7
 Unit 2: Electronic
Spreadsheet (Advanced)
Activity-1
Learning Outcome - Analyze data using scenarios and goal
seek
Objective: Applying Data Consolidation in LibreOffice 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

Page | 8
Solution:

Page | 9
1) Create a new spreadsheet in LibreOffice 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.
3) Follow the same instructions for next two worksheets.
4) Add one more worksheet to display the consolidation
result and rename as Consolidated.
5) Select the cell ranges where results needs to appear.
6) Click on Data ⇢ Consolidate option. A consolidate
dialog box will appear.
7) Select your desired function (Sum here) and add
references to the cells by selecting ranges.

Page | 10
 8) Move the cursor on 2018 work sheet and select the
range. Click on Add button.
9) Repeat the same for 2019 and 2020 worksheet
respectively.
10) Click on OK button.

Activity-2

Learning Outcome - Analyze data using scenarios and goal

seek
Objective: Applying subtotal in LibreOffice Calc.
Task: Prepare a worksheet as following

Solution:
Page | 11
1. Open spreadsheet software and enter the data as
following:

2. Select the data. Needs to be grouped using subtotal.

3. Click on Data → Subtotal. The Subtotal dialog box appears
4. Select column in Group By option then mark the column to
count the frequency for the category and finally select the
count function as displayed the following screenshot.

Page | 12
5. Click on OK button.

Activity-3

Learning Outcome – Link Data and Spreadsheet

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.

Page | 13
 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 Using Keyboard
1) Open Periodic Test I worksheet and Select the
required Cell
2) Now type =’Student Profile’.A1.

Page | 14
3) Click Enter
4) From Cell A1 Press Shift and Down Arrow to Cell
A11

5) Click Ctrl + D to give other Values

6) Repeat this for Cell C1 and D1

Page | 15
 Creating Reference Using Mouse
1) Open Periodic Test II worksheet and Select the
required Cell
2) Now Type =
3) Go to Student Profile Worksheet and Select the
Cells to reference

4) Click Enter
Page | 16
5) Drag Down the square box at the end of the cell
to show other values

6) Repeat this for Cell C1 and D1

Page | 17
Activity-4

Learning Outcome – Share and review a spreadsheet

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:
1. Create a new worksheet and enter data.
2. Click on File → Save and Use proper name for the
worksheet.
3. Click on Tools → Share Document.
4. The Share Document dialog box will appear. Click
on Share this spreadsheet with other users

Page | 18
 5. Click OK button.

Activity-5

Learning Outcome – Appling Goal Seek in LibreOffice Calc

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

Page | 19
Find out how many marks should she obtain in term 2 to
secure distinction.
Solution:
1. Enter data as given in the question itself.
2. Place the cursor to get the result for the marks of term
3. Place the cursor in B5 and write average () 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.
Page | 20
8. Repeat the same steps Math’s and Science as well.

Unit 3 Database
Management System
Activity-1

Learning Outcome – Create and edit tables using wizard

Objective: Steps to create a table using table wizard.
Task: Create a table using wizard
Create any table in LibreOffice base using table wizard.
Solution
Page | 21
1. Click on Start → All Programs → Libre Office 4.1.7 →
Libre Office Base.
2. LO Base window will open with Database Wizard. Select
or create the database to work upon it. I have selected
existing database db1. Click on Finish button.

3. Now click on Tables button from Left panel and chose

Use Wizard to Create Table… option from the tasks
window.
4. The Table Wizard will open. Follow wizard steps to
create a table.
5. In first step of wizard select the Category either Business
or Personal, Table from list of sample tables, and fields
from available fields. Click on Finish button.

Page | 22
6. Click on Next and select field types and all if you want to
change it.

7. Set a primary key for your table in this step. I have

selected EmployeeID as Primary key.

Page | 23
8. If you wish to change the table name then type new
name for the table and click on Insert Data immediately,
and click on Finish.

9. Insert data

Page | 24
Activity-2

Learning Outcome – Retrieve data using query

Objective: Query creation using wizard
Task: Create table Marksheet (Using SQL Command) and
perform the below given queries using wizard and design
view.
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.
Page | 25
 5) Display the maximum marks for Sub101 and
minimum marks for Sub102 using design view.
6) Display the rollno, name and percentage whose
percentages are more than 70 using design view.
7) Display all the record in ascending order of names
using design view.

Solution:
 Create table command
create table “marksheet” (“Stud_no” tinyint primary
key, “Name” varchar(15), “RollNo” tinyint, “Sub101”
decimal(5,2), “Sub102” decimal(5,2), “Sub103”
decimal(5,2))
Output

Page | 26
Queries
 Add Columns
1) Add column Total → alter table "marksheet"
add column "Total" tinyint
2) Add column Percentage → alter table
"marksheet" add column "Percentage"
decimal (5, 2)
3) Add column grade → alter table "marksheet"
add column "Grade" char (2)

 Insert records
4) Insert into "marksheet" values (101, 'Sagar',
105, 27, 25, 28, 80, 88, 'B1')

Page | 27
 Steps to perform a query using design view
5) Click Queries → Create Query in Design
View….
6) The query design window will open.

Page | 28
7) Select the marksheet table and click on Add
button.

8) Now select fields given in the question like

name, rollno, marks, Sub101, Sub102, Sub103,
Total and Percentage.

9) Save the query.

Page | 29
  Query Wizard Steps
10) Click on Queries → Use Wizard to Create
Query…
11) Query Wizard opens.
12) Select the table marksheet and Select the
fields given in the question.

13) Click on finish.

Output

Page | 30
 Display maximum marks and minimum marks for
the fields given in the question, using design view.
14) Click Queries → Create Query in Design
View….
15) The query design window will open.
16) Select the marksheet table and click on Add
button.
17) Now select the field Sub101 and Sub102.
18) Chose the function maximum under Sub101
and Minimum under Sub102.

Page | 31
 19) Save the query and check the result

 Display the rollno, name and percentage whose

percentages are more than 70 using design view
20) Click Queries → Create Query in Design
View….
21) The query design window will open.
22) Select the marksheet table and click on Add
button.
23) Select columns given in the question i.e.
Rollno, Name and Percentage.
24) Type >70 in the front of criteria under the
percentage field.

Page | 32
 25) Save the query and check the result.

Output

 Display all the record in ascending order of names

using design view.
26) Click Queries → Create Query in Design View….
27) The query design window will open.
28) Select the marksheet table and click on Add
button.
29) Select markesheet.* and name in the column
list
30) Select sort → ascending under name field.
31) Now click on visible checkbox to hide the name
column in result.

Page | 33
 32) Save the query and check the result.
Output

Activity-3

Learning Outcome – Create Forms and Reports using wizard

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
a. Click on Forms → Use Wizard to Create Form…
b. A Form Wizard appears.
c. Select the table from Tables or Queries then add all
the fields.

Page | 34
d. Click on Next button. Ignore step 3 and step 4.
e. Select the first option i.e. Columnar – Labels Left
then click on the next button.

f. Now set data entry step will be there. Ignore this

step and click on Next. Chose the styles for the
form interface and click on next.
Page | 35
 g. Type new name for the form and click on work with
the form. Click on Finish

Activity-4

Learning Outcome – Create Forms and Reports using wizard

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.

Page | 36
2) Select the table and add fields.

3) Now change the label text that you want in the

report. I have changed the label Name into
FirstName. Click Next.

Page | 37
 4) I have skipped groping and sorting options by
clicking 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 Next.

6) Now type the title of the report and select

dynamic report → Create report now option.
7) Now click on finish.
Output

Page | 38
Page | 39