Productivity Tools

Productivity Tools

by DOMINIC MASCARIÑAS

​Lesson Objectives

1.     Use common productivity tools effectively by maximizing advanced application techniques.

2.     Create an original or derivative ICT content to effectively communicate or present data or information related to specific professional tracks.​

​What is productivity tools?

Productivity Tools also known as productivity software are software that people use to create and produce professional quality documents, presentations, databases, charts, graphs, and more (http://productive.tools/why-should-you-use-productivity-tools/).​

​The three basic functions of these three productivity tools are:

​1.     Microsoft Word – writing skills

2.     Microsoft Excel – numeracy skills

3.     Microsoft PowerPoint – presentation skills

​Check your prior knowledge...

Multiple Choice

1.     What program is used to create spreadsheets which can later be used to analyze statistical tool?

• MS Excel

• MS Word   

• MS  Publisher

• MS OneNote

Multiple Choice

What MS Excel function adds a range of cells?

• ADD

• PLUS

• SUM

• TOTAL

Multiple Select

Which of the following objects can be inserted in your document?

• Pictures

• Sound

• Chart

• Shapes

Multiple Choice

Which of the following is NOT an animation type?

• Entrance

• Exit

• Emphasis

• Encore

Advance Techniques in Word Processor​

​Integrating Illustrations in Word Processor

An illustration in MS Word is a visualization or drawing that is in the form of pictures, clip art, shapes, SmartArt, charts, or screen clippings.​

​Steps on Inserting Illustrations in MS Word

• ​Picture from a File

• ​Shape

• ​SmartArt

• ​Chart

​Activity: Let's Practice!

1. ​ Inserting and Editing Shapes: Digital Art

2. ​Inserting and Editing Pictures: Travelogue

Advance Techniques in PowerPoint​

​Animation and Timing in PowerPoint

​Animation is the process of making the illusion of motion and the illusion of change by means of the rapid succession of sequential images that minimally differ from each other.

​Animation styles in different categories

• Entrance

• Exits

• ​Emphasis

• ​Motion Paths

​Inserting Hyperlinks

A hyperlink which is frequently stated as “links” is a text or image on the screen that you can click on to jump to another file or within the existing file. When you hover your pointer over a hyperlink, either it is text or an image, the arrow changes into a small pointing hand, called hyperlink cursor. It is usually activated by clicking on the text or image. Text hyperlinks are usually in color blue and underlined​

​Activity for Powerpoint

DIRECTIONS: Adapt a Filipino legend story and create a storyboard using PowerPoint presentation. Place pictures and animations in your story. Place texts as descriptions for the storyboard or dialogue cloud for the conversation of characters. Save you’re your using this file name: PPTLEGEND_FAMILY NAME_FIRST NAME_GRADE & SECTION. Check the rubrics on how you will be graded. Send your work through your teacher’s email address.​

Advance Techniques in Excel​

Advance and Complex Calculations in Excel​

Complex formula is the combination of more than two simple formulas. One of the key features of excel is the ability to calculate complex formulas. There are four basic computation uses in excel. Namely addition, subtraction, multiplication, and division. When solving complex problems, Excel follows the PEMDAS. PEMDAS is an acronym for the words: parenthesis, exponents, multiplication, division, addition, and subtraction.​

​Relative Reference

• All cell references are called relative references.

• When copied across multiple cells, they change based on the relative position of rows and columns.​

​Absolute Reference

​

​​Absolute Reference

• ​ These are cell references that do not change when copied or filled.

   You can use an absolute reference to keep a row and/or column constant.

  These reference cells can be made constant by inserting $ sign in between or before the row and column.

Functions​

These are predefined formula that performs calculations using specific values in a particular order.

​

Function Library​

​ IF formula in Excel

The IF function can perform a logical test and return one value for a TRUE result, and another for FALSE result. More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR.​

Syntax: =IF(logical_test,[value_if_true],[value_if_false])​

• logical_test is a value or logical expression that can be evaluated as TRUE or FALSE.

• value_if_true (optional) is the value to return when logical_test evaluates to TRUE.

• value_if_false (optional) is the value to return when logical_test evaluates to FALSE

​VLOOKUP

​The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position.

​The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function in Excel. As a worksheet function, the VLOOKUP function can be entered as part of a formula in a cell of a worksheet

​Syntax:

​=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])

​What I have learned

Productivity Tools also known as productivity software are software that people use to create and produce professional quality documents, presentations, databases, charts, graphs, and more.​

​QUIZ

​

Multiple Choice

What do you call the cells that do not change?

• Constant cells

• Relative Reference

• Absolute Reference

• Single cells

Multiple Choice

What type of Excel function searches for a specific value in your data using the spreadsheet columns and a unique identifier within those columns?

• VLOOKUP

• IF Function

• COUNTIF

• Absolute Reference

Multiple Choice

What are hyperlinks in PowerPoint?

• A tool that you use to navigate from one slide to another.

• A tool that you use to play in PowerPoint.

• A tool that you use to save a file and slide.

• A tool that you point to another image in the PowerPoint.

Multiple Choice

What do you call the software that people use to create and produce professional quality documents, presentations, databases, charts, and graphs?

• Production Tools

• Productivity Tools

• Professional Tools

• Advanced Application Tools