REVIEWER: Key Points from PowerPoint Lessons
--------------------------------------------------
1. INTEGRATING IMAGES AND EXTERNAL MATERIALS
KINDS OF MATERIALS
1. PICTURES
- .JPG: Full color, compressed, no transparency.
- .GIF: 256 colors, supports transparency and animation.
- .PNG: Good for internet, supports transparency.
2. CLIP ART: Line art, .GIF type, generic representation of ideas.
3. SHAPES: Printable objects for enhancing appearance or tool for composing ideas.
4. SMART ART: Predefined grouped shapes for organizational/structural visuals.
5. CHART: Represents data characteristics and trends graphically.
6. SCREENSHOT: Realistic images, used in manuals/reports. Shortcut: PrtSC or Win + PrtSC.
TEXT/IMAGE WRAPPING OPTIONS
Text wrapping controls how images are positioned with text. This helps create visually appealing
documents by wrapping text around images in various styles.
1. In Line with Text: Treats image like text, aligned with text line.
2. Square: Text forms a square boundary around the image.
3. Tight: Text hugs the shape of the image closely.
4. Through: Text flows through the image's contours.
5. Top and Bottom: Text appears only above and below the image.
6. Behind Text: Image appears behind the text.
7. In Front of Text: Image overlays the text.
--------------------------------------------------
2. ADVANCED SPREADSHEET SKILLS
Microsoft Excel: Spreadsheet application for calculations, graphing, pivot tables, macros.
Key Terms
- ACCOUNTING NUMBER FORMAT: Format used for accounting.
- ORIENTATION: Display angle (portrait/landscape).
- COUNT: Counts cells with content.
- SUM: Adds values in a range.
- AVERAGE: Computes average of range.
- RANGE: Group of cells used in functions.
- CRITERIA: Condition to be met.
- AVERAGE RANGE: Range to be averaged.
Conditional Functions
- SUMIF: Adds range if condition is met.
- COUNTIF: Counts cells that meet condition.
- AVERAGEIF: Averages cells that meet condition.
To Compute Total Points
- Use AutoSum or create a formula manually (e.g., =SUM(A1:A5)).
--------------------------------------------------
3. MICROSOFT WORD & MAIL MERGE
Microsoft Word & Word Processing
- Word Processor: Software for creating, editing, printing text documents.
- Microsoft Word: Created by Microsoft (Oct. 25, 1983); used for formatting, composing, spell
checking, etc.
- Can create documents like calendars, newsletters, and invitations.
Mail Merge Overview
- Purpose: To generate multiple personalized documents using one template and a list of recipients.
- Common uses:
- Promotional letters
- Labels
- Certificates
- Notices
Key Components of Mail Merge
1. Form Document
- The main template (e.g., invitation, certificate)
2. List/Data File
- Info about recipients (e.g., names, addresses)
- Usually created in Excel or CSV format
Requirements for Mail Merge
- A form document
- A data file with recipient information
Steps in Mail Merge
1. Open Microsoft Word and your form template
2. Insert placeholders (for name, address, etc.)
3. Connect to your data file
4. Preview merged results
5. Finish & Merge to create personalized documents
--------------------------------------------------
4. ADVANCED PRESENTATION SKILLS
Microsoft PowerPoint: Presentation software for creating slide shows with multimedia.
Effective Presentation Tips
1. MINIMIZE: Keep slides minimal.
2. CLARITY: Easy-to-read font, size 72 = 10 feet visibility.
3. SIMPLICITY: Use bullets or short sentences, follow 6x7 rule.
4. VISUALS: Use graphics, but not too many.
5. CONSISTENCY: Uniform font and design.
6. CONTRAST: Use light font on dark background and vice versa.
Using Hyperlinks in PowerPoint
- Insert tab > Links group > Hyperlink > Choose target > OK.
- Links to other slides, web pages, or email addresses.
Quote:
"Technology is just a tool. In terms of getting the kids working together and motivating them, the
teacher is the most important." - Bill Gates
