empowerment technology (Microsoft word )

ET

1. Applied Productivity Tools with Advanced Application Techniques Basic Productivity Tools

2. Word Processing Word Processing is a software program that creates documents using text and/or graphics. An example would be Microsoft Word.

3. Spreadsheets Spreadsheets quickly organize numerical information and allows the creator to input formulas into the spreadsheet for easy calculation. An example would be Microsoft Excel.

4. Presentation Presentation software is used to create slide shows that can be used to present information in an office setting or even as a school project. An example would be Microsoft PowerPoint.

5. Applied Productivity Tools with Advanced Application Techniques Advanced Word Processing Skills MS Word

6. Objectives: define mail merge; create form letters or documents for distribution to various recipients and; value the use of advanced word processing skills on the chosen track.

7. Mail merge a feature within most data processing applications that enables users to send a similar letter or document to multiple recipients.

8. 2 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.

9. Integrating Images and External Materials Kinds of Materials: Pictures . Generally, these are electronic or digital pictures or photographs you have saved in any local storage device. 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.

10. Integrating Images and External Materials Kinds of Materials: 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. Smart Art . Generally, these are predefined sets of different shapes grouped together to form ideas that are organizational or structural in nature.

11. Integrating Images and External Materials Kinds of Materials: Chart . Allows you to represent data characteristics and trends. 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.

12. Applied Productivity Tools with Advanced Application Techniques Advanced Spreadsheet Skills MS Excel

13. Objectives: familiarize with the most commonly used functions in Microsoft Excel; use several conditional functions available in Microsoft Excel and; value the use of advanced spreadsheet skills on the chosen track.

14. Microsoft Excel an application that provides an automated way of displaying any statistical data. It includes several arithmetic and basic functions that help you compute faster.

15. Basic Excel Formulas: Addition ( + ) Subtraction ( - ) Multiplication ( * ) Division ( / )

16. Advanced Excel Formulas: Autosum - adds all the numbers that you specify Average – a function used to compute for the average of the number of a range IF - returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE

17. Applied Productivity Tools with Advanced Application Techniques Advanced Presentation Skills MS PowerPoint

18. Objectives: use hyperlinks to improve their PowerPoint; apply animation to slides and; value the use of advanced presentation skills on the chosen track.

19. Using Hyperlinks in MS PowerPoint: Select an object or highlight a text. Go to Insert > Hyperlinks (under links category) or use the shortcut key Ctrl + K. The insert Hyperlink dialog box would appear.

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

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