Word Processors & Productivity

• Advancement and technology play a pivotal role in a business's productivity.
• Hodgetts & Kuratko observed productivity is a significant factor for success in an organization and in a competitive situation.
• Higher productivity means a business can do more with less time/resources, and make more profit.

Applied Productivity Tools with Advanced Application Techniques

• A Word Processor is a software program to create, edit, format, and print text-based documents.
• Microsoft Word is the most popular word processor.
• Examples of word processors: Microsoft Word, Google Docs, WPS Writer, LibreOffice Writer, Apple Pages

Integrating Images and External Material in Word Processor

• A valuable feature in word processors is the ability to show images in a document.
• Images can be added as a watermark in the background.
• Common image file extensions:
• .JPG/.JPEG widely used image file format (Joint Photographic Experts Group); use for photos and images where small file size is important; slight loss in quality when edited repeatedly.
• .GIF stands for Graphics Interchange Format; capable of displaying simple animation.
• .PNG stands for Portable Network Graphics; for transporting images on the Internet; use for graphics with clear lines, text, or transparent backgrounds; maintains original quality even after editing.
• .SVG (Scalable Vector Graphics) is a vector file format to display two-dimensional graphics, charts, and illustrations on websites; known for its ability to scale up or down without losing.
• .TIFF/.TIF (Tag Image File Format) is popular with graphic designers and photographers for their flexibility, high quality, and near-universal compatibility; a great choice when high quality is your goal, especially when it comes to printing.

Embedded Files and Data

• The process of incorporating a file or data object into another file or platform, making it a self-contained part of the host, rather than a separate, linked entity.
• Embedded files can include videos, music, tables, and data.

Mail Merge

• A tool to create letters and mailing labels by linking main documents to a data source.
• Considered productive for sending a letter, label, and/or envelope to multiple persons at once.
• Two components:
• Form Document which contains the main body of the message.
• Data File where the individual information/data to be plugged into form documents is placed.

PowerPoint's Rules of Seven

• Follow the "Seven-by-Seven rule" use no more than 7 words per line and no more than 7 lines per visual.
• Use font size 24+ for titles and 20+ for body; no more than two fonts per slide.
• Use easy-to-read fonts such as Arial and Times New Roman.
• Limit each visual to one idea, one concept, or one main point.
• Use images that relate to and support your presentation.
• Leave out the sound effects and background music, unless it's related to the content being presented.
• Keep presentations under 20 minutes.

Accessing Animation Tools

1. Select the object (text, image, shape, etc.).
2. Go to the "Animations" tab.
3. Click "Animations pane”.
4. Click "Add Animation” and choose from options.

Timing and Duration

• Use the start dropdown in the timing tab to control when the animation begins.
• Add a delay before the animation starts using the “Delay” box in the timing tab.
• Set the animation's duration using the duration box in the timing tab.
• Consider using timing functions to make the motion more natural.

Hyperlinking in Presentation

• A hyperlink can run a program, play a sound/video, or link the viewers to another PowerPoint slide or web page.
• Hyperlinks are used to easily navigate slides and can link to other documents or websites.

Integrating Image Processor

• Showing images in a document occupies the attention of the reader as well as aiding the writer to visualize their paper.
• Steps to insert a Hyperlink:
• Select/Click an object or highlight a text.
• On Insert tab, click Link.
• OR right-click the object or the highlighted text and choose Hyperlink on the menu that will appear.
• An Insert Hyperlink dialog box will appear where you can choose the object or text to be linked.

Advanced and Complex Formulas

• Excel is a spreadsheet application that helps monitor and maintain data and calculate & analyze numerical information.
• Excel can calculate complex formulas.
• Complex formulas use two or more operations.

Other Functions

• =ABS(x) – returns the absolute value of x
• =AVERAGE(x,y) – returns the average of x and y
• =CONCATENATE(x,y) – joins x and y
• =IF(Condition, x, y) – returns x if the condition is true, else it returns y
• =ISEVEN(x) – returns true if x is an even number
• =ISODD(x) – returns true if x is an odd number
• =COUNT(range) – counts the number of cells containing a number within a range

Basic, Advanced, and Complex Formulas

• Excel is an application for spreadsheets, it helps monitor and maintain data.
• One of Excel's key features is the ability to calculate complex formulas and organize data in rows and columns.

Key Terms in MS Excel

• Row - horizontal line of entries in a table. The maximum number of rows on a worksheet in Excel is 1,048,576.
• Column - vertical line of entries in a table. The maximum number of columns is 16,384.
• Cell - the location where information is held in a spreadsheet
• Active Cell - the selected cell
• Column Heading – the box at the top of each column containing a letter
• Row Heading – the row number
• Cell Reference – the cell address combines letter and number (ex. A1, B4, C2)
• Merge - combining/joining two or more cells
• Formula – an expression that calculates the value of a cell.
• Functions are predefined formulas already available in Excel
• Formula Bar – displays the contents of a cell

Basic Math Operations

• =SUM(x,y) or =SUM(range) – returns the sum of x and y (or all the numbers within the range)
• =PRODUCT(x,y) – returns the product of x and y
• =QUOTIENT(x,y) – returns the quotient of x divided by y
• =x+y - returns the sum of x and y
• =x*y - returns the product of x and y
• =x/y - returns the quotient of x divided by y
• =x-y - returns the difference of x subtracted by y