DIGITAL DOCUMENTATION

Objective: Using various commands to create styles in Libre

office Writer.
Task: Type a paragraph with at least 10 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 stylename: 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 DreamQuot 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
 DIGITAL DOCUMENTATION

Objective: Inserting images and shapes and rearranging

them
Task:
1. Create a new document in Libre office 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 in the right side of the paragraph
and write additional text into the shapes.

1 Open 0O 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.
 DIGITAL DOCUMENTATION

Objective: Creating a sports certificate templates in Libre

office 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.

SOLUTION:

1 Open a new or existing document of the type you want

to make into a template (text document, spreadsheet,
drawing, presentation).
2. Add the content and styles that you want.
3. From the main menu, choose File > Templates >Save.
The Templates dialog opens
1. In the New template field, type a name for the new
template.
2. 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; ti is simply the folder in
which you save the template. Choosing
an appropriate category makes ti easier to find the
template when you want to use it. For example, you might
save Impress templates under
the Presentations category.
3. Click OK to save the new template.
If you create a document by choosing File > New > Text
Document
(or Spreadsheet, Presentation, or Drawing) from the main
menu, Open Office creates the document from the
Default template for that type of
document. You can, however, set a custom template to be
the default. You can reset the default later fi you choose.
 DIGITAL DOCUMENTATION

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

1. Type a letter. Click on Tools - Mail Merge wizard. A mail

merge dialog box appears.
2. Select Letter option. And click on Next.
3. For inserting address list just click on the select different
address list option, select the address list you have prepared,
click on Next.
4. Create salutation click on desire salutation click on the next
tab.

5. IF you want to adjust your content you adjust you increase

the left and the top bar. Click on next button.
6. ClickFinish and the output is:
 DIGITAL DOCUMENTATION

Objective:Create and Customize Table of Contents.

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

Solution:
1. Type the contents.
2. Apply appropriate level of headings from the Styles and
Formatting window.
3. Click on Insert→Indexes and Tables→Indexes and
Tables.
4. Select and apply the styles for the Table of Contents.
5. Click on OK.

ELECTRONIC SPREADSHEET
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
three quarters.
3. Rename all worksheets like sheet 1- 2021, sheet 2 - 2022,
sheet 3- 2023.
4. Now at one more worksheet at the end and rename as
consolidated sheet.
Now type the serial no and names as displayed, you some
function to add data for 2021,2022, and 2023 and respective
cells using consolidation.
Solution:
1. Create a new spreadsheet in OO calc.
2. Enter the data for sheet 1 and remain the sheet as 2021. To
rename the worksheet right click on sheet tape then tied
desired name. Press enter key to accept the name.
3. Follow the same instructions for next two worksheets.
4. Add one more worksheet display the consolidation result and
rename as consolidated.
5. Select the cell ranges were research needs to appear.
6. Click on data→consolidate option. A consolidate dialogue box
will appear.
7. Select your decided function (sum here) and references to
the cells by selecting ranges.
8. Move the cursor on 2021 worksheet and select the range.
Click on add button.

9. Repeat the same for 2022 and 2023 worksheet respectively.

10.ClickonOK button.
 ELECTRONIC SPREADSHEET
Objective: applying subtotal in OO calc.
Task: prepare a worksheet as following

Solution:
1. Open spreadsheets software and enter data as following:
2. Select the data. Needs to be grouped using subtotal.
3. Click data→ subtotal. The sub to dialogue box appears.
4. Select column Group By option then mark the column to
count the frequency for the Amount and finally select the count
function as display the following screenshot.

5. Click OK.
The result:
 LINK DATA AND SPREADSHEET
Objective: To create macros:

Solution:
1. Open a new spreadsheet. 2. Enter numbers into a
sheet.
3. Select cell A3, which contains the number 3, and copy
the value to the clipboard.
4. Select the range A1:C3.
5. Use Tools > Macros > Record Macro to start the macro
recorder. The Record Macro dialog is displayed with a
stop recording button.
6. Use Edit > Paste Special to open the Paste Special
dialog.
7. Set the operation to multiply and click OK. The cells are
now multiplied by 3.
8. Click Stop recording to stop the macro recorder. The
OpenOffice.orgBasic Macros dialog opens.
9. Select the current worksheet. For this example, the
current Calc worksheet is Untitled
10. Existing worksheets show a library named Standard.
This library is not created until the worksheet is saved, or
the library is needed, so at this point your new worksheet
does not contain a library. You can create a new library to
contain the macro, but this is not necessary. the steps to
record formatting in Macro using pen office calc.
 GOAL SEEK APPLICATION
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.

Find out how many marks should she obtain in term

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 average () formula.
4. Now click on Tools Goal Seek <goal seek
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. 2 to
secure distinction
 DATABASE MANAGEMENT SYSTEM
Objective: Query creation using wizard
Task: Create table Employee using wizard and design
view.
Create the EMPLOYEE table given below in Design View:

Inserting the following employee details in the

EMPLOYEE table.

WRITE SQL STATEMENTS TO:

1. Display all records in increasing order of
experience.
2. Update the salary of people by adding 10,000 having
experience more than 10 years.
3. Display employees that Belong to Sales
Department.
 4. Display the details of employees where experience
greater than 15.
5. Delete the record of employee id =103.
6. Display the record of “Janvi”.

ANSWERS:
Display all records in increasing order of experience.
7. Click Queries create query in design view.
8. The query design window will open.
9. Select the employee table and click add on button.
10. Select experience and name in the column list.
11. Select sort ascending under name field.
12. Now click on visible checkbox to hide the name
column in result.
13. Save the query and check the result.
OUPUT:

Update the salary of people by adding 10,000 having

experience more than
10 years.
14. Click queries create query in SQL view.
15. A window appears.
16. Type the command as shown in fig and press run
query at the top.
 Display employees that Belong to Sales Department.
17. Click queries create query in SQL view.
18. A window appears.
19. Type the command as shown in fig and press run
query at the top.

Display the details of employees where experience

greater than 15.
20. Click Queries create query in design view.
21. The query design window will open.
22. Select the employee table and click add on button.
23. Select id, name, dept, experience and salary in the
column list.
24. Give criterion for employee “ > 15 “.
 25. Now click on visible checkbox to hide the name
column in result.
26. Save the query and check the result.

Display the record of “Janvi”.

27. Click queries create query in SQL view.
28. A window appears.
29. Type the command as shown in fig and press run
query at the top.

Display employees that Belong to Sales Department.

17. Click queries create query in SQL view.
 18. A window appears.
19. Type the command as shown in fig and press run
query at the top.

DATABASE MANAGEMENT SYSTEM

 Objective: Creating Report using wizard
Task: Create table a Report using wizard by selecting all
the fields for the table -
Employee

STEPS:

• Click on Reports section under Database in the

OpenOffice base application.
• Once you select the option, you should see a window
similar to the one
displayed below.

• Now we can generate the report for the table created

earlier.
• Click on Use Wizard to Create Report… option
available under Tasks.
• Once you select the Use Wizard to Create Report…
option.
 • You should see a window similar to one displayed
below.

• You have to select all the table fields by selecting the

>> button, once you click the button >> you should see a
dialog box similar to the one displayed below.

• Once you click Next>.you should see a dialog box

similar to the one displayed below.
 •You can redefine the label of the fields in the reports
or else you can set the default name.

• Once you click Next >, you should see a dialog box
similar to the one displayed below.

• You can sort the field variables in the report by

selecting the appropriate field and sorting method.
• Once you click Next >, you should see a dialog box
similar to the one displayed below.
 • You can define a name for the report or you can use
the name of the table itself for the report also.
• Click Finish.
• Once you click Finish you should see a window
similar to the one displayed below with the report.
 DATA BASE MANAGEMENT SYSTEM

Objective: Creating form using wizard

Task: Create table a form using wizard by selecting all

the fields for the table - Employee

STEP:

• Click Use Wizard to Create Form… option under Tasks

group. The Form Wizard dialog box appears as shown
below.

•You can select selective fields to be sent onto the form

by selecting the field name and clicking >button. You can
select individual fields in a database or all fields in a
database.
 • To use all the fields in the table in a form, click the >>
button.
• Notice the fields displayed under Fields in the forms
section.
• Click Next >. You see the Set up a sub form step
dialog box of the wizard as shown below.

• You can select the option Add Subform if you need to

insert the contents in the table in a separate form. Click
Next>.
• Now you need to arrange selected fields in a form.
You can use different styles from the list displayed below:
 • Once you have selected a style, click Next >
• A dialog box appears where in you can select the
data entry model.
• Click Next >. You should see a dialog box wherein
you can specify the styles to be used in the form.

• Click Next >. You see a dialog box where you can
specify the name of the form. Click Finish.
 • A form window appears. Notice that the records in
the table are displayed automatically within the form that
you just created.
 WEB APPLICATION

Task: Create an account in Google and launch Google Talk

and Signing in with the account

1. Openyourbrowserandgotowww.google.com
2. Find the Sign In button present at the top right corner
of the browser screen. 3.
Entertheemailidyouhavecreated,thenClickonNextbutton
4. Nowenteryourpassword.AndClickonNextbutton.
5. NowyouwillgetthescreenofGoogleagain.ClickonGmail.
6. Scroll down to the Hangouts. Some usernames are
available there, pick anyone of them to start your
chatting.
 WEB APPLICATION

Objective: Creating a blog using blogger

Task: Create a blog on blogger using your Google account.

Create Home, About Us. Contact Us pages for the blog.
Write one article of your choice as a post.

1. Open your browser and type www.blogger.com

2. Click on Create Your Blog button or Sign in button. Enter
username and Password for your Google
account.
3. Give the appropriate title for your blog. And click on
Next.
4. Now choose an appropriate URL for your
5. Now type display name for your blog and the setup is
complete.
6. Click on Finish button. 7. The blog is ready to add the
contents.
8. Click on Pages option as displayed in the previous
screenshot.
9. The NEW POST button will change to NEW PAGE. Click
on it.
10. Now the new page interface will open. Give
appropriate Title for your Page and insert contents like
text, images and all. When you finish content typing and
all, click on Finish button. Similarly you
can add posts and other pages.