APPLIED PRODUCTIVITY TOOLS WITH ADVANCED
APPLICATION TECHNIQUES
Gabalda, Mallo, Patiño, Patosa, Carnaje, Patricio, Alasian, Guillen
Mail Merge and Label Generation
Letters
Envelopes
Form Letter
Word Processing
Spreadsheet
Database
WordStar
WordPerfect
Microsoft Word
Mailing
LETTER
-
A written message from one party to another containing
information
ENVELOPE
-
The Postal Service and Express mail carriers have large mailing
envelopes for their express services.
FORM LETTER-A letter written from a template, rather than being
specifically composed for a specific recipient.
WORD PROCESSOR-An electronic device or computer software application,
that performs the task of composition, editing, formatting, printing of
documents
SPREADSHEET-An interactive computer application for organisation,
analysis and storage of data in tubular form.
DATABASE-An organised collection of data
WORD STAR-a word processor application that had a dominant market
share during the early- to mid- 1980s.
WORDPERFECT-A word processing application owned by Corel with a long
history on personal computer platforms.
MICROSOFT WORD-A word processor developed by Microsoft.
MAIL MERGE-Process to create personalised letters and pre-addressed
envelope or mailing labels for mass mailings from a form letter
•
PowerPoint Animation
•
Custom Animation
•
Animation Trigger
•
Transitions
POWERPOINT ANIMATION-A form of animation which uses Microsoft
PowerPoint and similar programs to create a game or movie.
CUTOM ANIMATION-Set of effects which can be applied to objects in
PowerPoint so that they will animate the Slide Show Power Point.
ANIMATION TRIGGER-Another feature introduced in Microsoft PowerPoint
2002/XP and the later versions. This feature allows animators to apply effects
that can be triggered when a specific object on the Slide Show is clicked. This
feature is the basis for the majority of PowerPoint games, which usually
involve in clicking objects to advance.
TRANSITIONS-Determines how your presentations move from one slide to
the next.
SETTING CUSTOM TIMING-Default timings for animations may not be
exactly what you want.
You can change the time of how long the animation would last.
TRANSITION-DURATION PROPERTY-Is simple to understand. It defines the
total duration of a transition from State A to State B, whether the transition
involves scaling, distorting, rotating or modifying the style of an element.
TRANSITION-TIMING DURATION-Is more difficult as it defines the rate
which the transition is carried out, which can involve speeding up and
slowing down
Embedding Data and Files
KEYWORDS Embedding Linking Embedded Object Linked Object Object Linking & Embedding (OLE) Embedded Files
EMBEDDING
a term used in computer and web programming that means to enclose or to make something an integral part of it
adding a source data for an item to a document
In computer programming, the material (image or file/document) is enclosed in the program itself.
In web programming, an embedded file or image is created as an integral part of the page and the image or file is uploaded in a page to make it a part of it.
LINKING
adding a link to the source data for an item to a document
establishes a connection between two objects, and embedding facilitates application data insertion.
When a link to an object is inserted in a compound document, the source data or link source, continues to reside wherever it was initially created, usually in another document.
Activating a link runs the link source's server application, which the user requires in order to edit or otherwise manipulate the link data.
COMPOUND OBJECT
something like a display desktop that can contain visual and information objects of all kinds: text, calendars, animations, sound, motion video, 3-D, continually updated news, controls, and so forth
Each desktop object is an independent program entity that can interact with a user and also communicate with other objects on the desktop.
EMBEDDED OBJECT
an object created with one application and embedded into a
document created by another application. Embedding the object ensures that the object retains its original format
a separate file not created in the program that is placed into the program. For example, when using a word processor program, you paste a movie clip into the word processor document; this would be considered an embedded object. on the Internet or an Internet web page, an embedded object is any external
media that has been included in a web page using the HTML <embed>
command. For example, when sharing a YouTube video on your web page that video can be shown using the HTML embed code provided by YouTube
LINKED OBJECT
an object that is inserted into a document but still exists in the source file. When information is linked, the new document is updated automatically if the
information in the original document changes. If the original document is on your computer, changes that you make to the linked information will also appear in the original document.
OBJECT LINKING AND EMBEDDING
an object that is inserted into a document but still exists in the source file. When information is linked, the new document is updated automatically if the
your computer, changes that you make to the linked information will also appear in the original document.
OLE object may display as actual contents, such as a graph or chart. For example, an external application chart, such as an Excel spreadsheet, may be inserted into a Word application. When the chart is activated in the Word document, the chart's user interface loads, and the user is able to manipulate the external chart's data inside the Word document.
Advanced and Complex Formulas and Computations
KEYWORDS
Formula - A mathematical relationship or rule expressed in symbols. Advanced - far on or ahead in development or progress.
Complex - consisting of many different and connected parts. Computation - the action of mathematical calculation.
Formulas and Equations can perform many different computations. These formulas can help make our lives and jobs less complicated compared in the past.
Formulas and can help alleviate the stress of having to input things and solve equations by hand.
Complex formulas have more than one mathematical operation, such as 5+5-2. When there is more than one operation in a formula, the order of operations tells us which operation to calculate first. To use Excel to calculate complex formulas, you'll need to understand the order of operations.
1. First, Excel will calculate the amount sold in
parentheses: (19*1.99)=37.81 White Pete Lily seeds and(33*1.99)=65.67 Total Pete Lily seeds.
2. Second, it will divide the White Pete Lily seeds amount by the Total Pete Lily seeds amount:37.81/65.67=.5758.
3. Last, it will multiply the result by 100 to obtain the value as a percent: .5758*100=57.58.
CREATING COMPLEX FORMULAS
1. Click the cell where you want the formula result to appear (F11, for example). 2. Type the equals sign (=).
3. Type an open parenthesis, then click the cell that contains the first value you want in the formula (F4, for example).
4. Type the first mathematical operator (the addition sign, for example).
5. Click the cell that contains the
second value you want in the formula
(F5, for example), then type a closed parenthesis.
6. Type the next mathematical operator (the multiplication sign, for example).
7. Type the next value in the formula (0.055 for 5.5% tax, for example). 8. Click Enter to calculate your formula. The results show that $2.12 is the tax
for the nursery order. CELL REFERENCES
• In order to maintain accurate formulas, it is necessary to understand how cell references respond when you copy or fill them to new cells in the worksheet. • There are 2 types of cell references, Relative or Absolute. Cell references are
relative references by default.
• Relative References - When copied or filled, they change based on the relative position of rows and columns.
• Absolute References - Do not change when they are copied or filled and are used when you want the values to stay the same.
RELATIVE REFERENCES
• Relative references can save you time when you're repeating the same type of calculation across multiple rows or columns.
• Press Enter. The formula will be calculated.
• Select the cell you want to copy (B4, for example), then click the Copy command from the Home tab
• Select the cells where you want to paste the formula, then click
the Paste command from the Home tab. You can also drag the fill handle to fill cells.
ABSOLUTE REFERENCES
• You can use an absolute reference to keep a row and/or column constant in the formula.
• An absolute reference is designated in the formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both. • Type the dollar sign ($), then enter the row number of the same cell you
are making an absolute reference to (1, for example). • Press Enter to calculate the formula.
• Select the cell you want to copy (C4, for example), then click the Copy command from the Home tab
• Select the cells where you want to paste the formula, then click
the Paste command from the Home tab. You can also drag the fill handle to fill cells.
