Lesson 3

LESSON 3
APPLIED PRODUCTIVITY TOOLS

3.1 – Advanced Word Processing Skills
3.2 – Advanced Spreadsheet Skills
3.3 – Advanced Presentation Skills
LESSON 3.1
Advanced Word Processing
Skills
• Mail merge and label generation
• Integrating images and external
materials
At the end of this lesson, the students should be able to:
1.use some advanced capabilities of Microsoft Word

commonly used to increase productivity and efficiency;
2.effectively use these features to help improve the
productivity of an organization through maximizing the
potential of MS Word;
3.create form letters or documents for distribution to
various recipients;
4.create labels and envelops for distribution; and
5.create media-rich documents for printing or
publishing.
Two Components of Mail Merge:
1. Form Document
The document that contains the main body of
the message we want to convey or send.
2. List or Data File

This is where the individual information or data
that needs to be plugged in (merged) to our form
document is placed and maintained.
Label Generation
It creates a blank form document that

simulates either a blank label or
envelope of pre-defined size and will
use the data file that you selected to
print the information, typically,
individual addresses.
Integrating Images and External
Materials
Kinds of Materials:
1. Pictures. Generally, these are electronic or digital pictures
or photographs you have saved in any local storage device.
2. Clip Art. This is generally a .GIF type; line art drawings or
images used as generic representation for ideas and
objects that you might want to integrate in your
document.
3. Shapes. These are printable objects or materials that you
can integrate in your document to enhance its appearance
or to allow you to have some tools to use for composing
and representing ideas or messages.
4. Smart Art. Generally, these are predefined sets
of different shapes grouped together to form
ideas that are organizational or structural in
nature.
5. Chart. Another type of material that you can
integrate in your Word document that allows you
to represent data characteristics and trends.
6. Screenshot. Sometimes, creating reports or
manuals for training or procedure will require the
integration of a more realistic image of what you
are discussing on your report or manual.
LESSON 3.2
Advanced Spreadsheet
Skills
• Commonly used Microsoft Excel functions
• Conditional functions
• Use of Microsoft Excel in market research
At the end of this lesson, the students should be able to:
1. familiarize with the most commonly used

functions in Microsoft Excel;
2. use several conditional functions available in
Microsoft Excel; and
3. use Microsoft Excel as a viable tool in market
research and product development.
Microsoft Excel
Microsoft Excel provides an automated

way of displaying any statistical data. It
can be used to automatically compute
for several factors that are not easy to
notice especially when faced by a large
data. Microsoft Excel includes several
arithmetic and basic functions that help
you compute faster.
Basic Excel Formulas:
Addition (+)
Subtraction (-)
Multiplication (*)
Division (/)
*type <=> before the formula,

thus: =a1+a2 <then, hit the ENTER
key>
• Average – a function used to compute for the average of
the number of a range.
• COUNTIF – a function used to count the cells with a

specified content within a range.
• SUMIF – a function used to compute for the summation

of a range if a certain condition is met
• AVERAGEIF – a function used to compute for the

average of a range if a certain condition is met
LESSON 3.3
Advanced Presentation
Skills
• Hyperlinks
• Embedding files and data
At the end of this lesson, the students should be
able to:
1. use hyperlinks to improve their PowerPoint

Presentation;
2. embed files and data to their PowerPoint
Presentation; and
3. maximize PowerPoint Presentation as an effective
visual aid tool.
Using Hyperlinks in Microsoft
PowerPoint:
1. Select an object or highlight

a text.
2. Go to Insert >
Hyperlinks (under links
category) or use the
shortcut key Ctrl + K.
The insert Hyperlink
dialog box would
appear.
PowerPoint:
Link to Options:
a. Existing File or Web Page – creates a hyperlink to website or a local file saved
in your hard drive. Just browse your file in the dialog box or type the web
address.
b. Place in This Document – creates a hyperlink that allows you to jump to a

specific slide in your presentation.
c. Create a New Document – creates a hyperlink that once clicked, creates a

new document on your specified location.
d. E-mail Address – creates a hyperlink that opens Microsoft Outlook that

automatically adds your specified recipient on a new email.
PowerPoint:
3. When done, click OK to apply your hyperlink.

Embedding Objects in
Microsoft PowerPoint
Embedding objects is easy using

PowerPoint Presentation. With this
option, you can insert an Excel file
that would look like a table to a
PowerPoint Presentation.
Embedding an Excel File to your PowerPoint
Presentation
Options:
1. Go to the Insert tab.
a. Create New – creates a new file from
2. On the Text group, click scratch. You can select on a wide variety
on Object. of files listed.
b. Create from File – creates a file from
3. The Insert Object dialog
an existing file saved on your hard drive;
box would appear: simply browse the file to use it. Putting a
check on the “link” option will allow you
to modify the Excel file inside your
PowerPoint Presentation.
4. Once you are done, click OK.

CREATING AN EFFECTIVE
PRESENTATION
• Minimize – keep slide counts to a minimum to

maintain a clear message and to keep the audience
attentive. Remember that the presentation is just a
visual aid. Most information should still come from
the reporter.
• Clarity – avoid being fancy by using font style that is

easy to read. Make sure that it is also big enough to
be read by the audience.
• Simplicity – Use bullets or short sentences.
Summarize the information on the screen to
have your audience focus on what the speaker is
saying than on reading the slide. Limit the
content to six lines and seven words per line.
This is known as the 6X7 rule.
• Visuals – use graphics to help your presentation

but not too many to distract the audience.
• Consistency – Make your design uniform. Avoid
having different font styles and backgrounds.
• Contrast – Use light font on dark background or

vice versa. This is done so that it is easier to
read. In most instances, it is easier to read on
screen if the background is dark. This is due to
the brightness of the screen.
Now that you know the tips, it is now time to
create the presentation for your bazaar result.
Use the guide on the next slide for this

presentation. Remember that it is only a
guide and it is up to you to make
appropriate changes. It is also wise to place
the information in a Word file before
placing it in a presentation.
Bazaar Results Presentation
Slide No. Content
1 Product/Service Name, Group Name, and Group Members
2 Initial Product/Service Information: What is you product or service? Include a photo if available
3-4 Survey: What were the questions you asked in the sample before the bazaar took place?
5-6 Survey Results: Display the results of the survey and how it affects the product upon its release
(during the bazaar)
7 Bazaar Sale Result: Was your product or service profitable?
8 Improvements: If you were to release the product again, what would be the changes?

Lesson 3 - Applied Productivity Tools

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

Lesson 3 - Applied Productivity Tools

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Lesson 3 - Applied Productivity Tools

Uploaded by

Copyright:

Available Formats

APPLIED PRODUCTIVITY TOOLS

1.use some advanced capabilities of Microsoft Word

2. List or Data File

It creates a blank form document that

1. familiarize with the most commonly used

Microsoft Excel provides an automated

*type <=> before the formula,

• COUNTIF – a function used to count the cells with a

• SUMIF – a function used to compute for the summation

• AVERAGEIF – a function used to compute for the

1. use hyperlinks to improve their PowerPoint

1. Select an object or highlight

b. Place in This Document – creates a hyperlink that allows you to jump to a

c. Create a New Document – creates a hyperlink that once clicked, creates a

d. E-mail Address – creates a hyperlink that opens Microsoft Outlook that

3. When done, click OK to apply your hyperlink.

Embedding objects is easy using

4. Once you are done, click OK.

• Minimize – keep slide counts to a minimum to

• Clarity – avoid being fancy by using font style that is

• Visuals – use graphics to help your presentation

• Contrast – Use light font on dark background or

Use the guide on the next slide for this

Slide No. Content

1 Product/Service Name, Group Name, and Group Members

7 Bazaar Sale Result: Was your product or service profitable?

You might also like