productivity tools objectives 1! - western illinois … tools.pdfproductivity tools objectives ! 2!...

8

Click here to load reader

Upload: hakhuong

Post on 05-Sep-2018

212 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Productivity Tools Objectives 1! - Western Illinois … Tools.pdfProductivity Tools Objectives ! 2! Word 2007 Upon completing this course, the participant will be able to: • Examine

Productivity Tools Objectives  

1  

Word 2003 Upon completing this course, the participant will be able to:

• Understand Microsoft Office Word 2003 • Launch Microsoft Office Word 2003 • Open Documents • Understand The Working Screen • Experiment With The Working Screen • Navigate Documents • Close Documents And The Application • Create New Documents • Save Documents • Select And Replace Text • Delete Text • Examine Cut, Copy, And Paste • Look At The Clipboard Task Pane • Copy And Paste Text • Select Multiple Sections • Cut And Paste Text • Create Documents From Templates • Understand Fonts • Understand Formatting, Character Effects, And

Styles • Change Fonts • Adjust Font Size • Apply Text Formatting • Copy Formatting • Apply Character Effects • Format Text As Hidden • Highlight Text • Use Character Styles For Quick Formatting • Clear Styles From Text • Understand Alignment • Align Text • Apply Borders • Add Shading • Understand Shortcut Menus • Insert Bullets • Apply Automatic Numbering • Customize Bullets • Create Headers And Footers • Insert And Format Page Numbers • Add Placeholders To Headers And Footers • Modify Date And Time Placeholders • Find And Replace Text • Understand The Spelling Feature • Check Spelling And Grammar • Use The Thesaurus • Undo And Redo Changes • Use AutoCorrect For Common Errors • Check Word, Paragraph, And Character Counts • Review Document Properties • Work With Tabs • Understand Sections • Change Margins • Experiment With Page Orientation • Insert And Remove Page Breaks • Understand Breaks • Insert Newsletter-style Columns • Insert Column Breaks • Modify Column Settings

• Create New Folders • Use Save As • Preview Documents • Examine The Print Dialog Box • Print Documents • Examine The Help Task Pane • Use The Ask A Question Feature • Look At The Office Assistant • Understand Paragraph Formatting • Reveal Non-printing Characters And Text

Boundaries • Adjust Graphics • Understand The Drawing Toolbar • Use The Drawing Canvas • Understand Tables • Insert Tables • Insert Text Into Tables • Insert Rows And Columns • Use AutoFormat • Delete Rows From Tables • Delete Columns From Tables • Merge Cells • Define And Apply Table Styles • Create Tables From Text • Understand Charts • Create Charts • Set Chart Options • Modify Charts • Use The Table AutoFormat Feature • Add Diagrams • Create Envelopes/Prepare And Print Labels • Explore Web Issues • Use Paste Special • Apply Text Effects • Preview Web Layouts • Save Documents As Web Pages • Insert And Modify Hyperlinks • Look At Revision Tools • Insert Comments Into Documents • Hide And Show Comments • Edit Comments • Send Documents For Review • Activate The Track Changes Feature • Make Tracked Document Changes • Accept Or Reject Changes • Compare And Merge Documents • Set Left And Right Indents • Add Hanging And First Line Indents • Set Line Spacing • Modify Character Spacing • Understand Tab Stops • Insert Text From Other Files • Apply Paragraph Styles • Insert Symbols • Create AutoText • Create Outline Numbered Lists • Add Information With The Research Task Pane • Understand The Research Task Pane • Insert Clip Art • Insert Graphics

   

Page 2: Productivity Tools Objectives 1! - Western Illinois … Tools.pdfProductivity Tools Objectives ! 2! Word 2007 Upon completing this course, the participant will be able to: • Examine

Productivity Tools Objectives  

2  

Word 2007 Upon completing this course, the participant will be able to:

• Examine The Ribbon • Understand The Mini Toolbar • Add Animation To Text And Graphics • Add Clip Art To Slides • Add Titles And Subtitles In The Outline Tab • Apply Slide Transitions • Check Spelling • Close PowerPoint Presentations • Copy And Move Slides In Slide Sorter View • Create Basic Shapes • Create Notes In Notes Page View • Create Shapes • Create WordArt • Crop Pictures • Delete Slides • Demote And Promote Text In The Slide Pane • Examine The Microsoft Office PowerPoint 2007

Window • Examine The Outline Tab • Explore Notes And Handouts • Group Objects • Insert Hyperlinks • Insert Pictures And Omit Background Graphics • Insert Slides And Change Layouts • Open Existing PowerPoint Presentations • Open Microsoft Office PowerPoint • Print Presentations • Publish And Save Presentations As Web Pages • Resize And Move Clip Art • Save Presentations • Understand Bullets • Understand Microsoft Office PowerPoint 2007 • Understand Slide Layouts • Arrange Shapes • Make Annotations In Slide Show Mode • Modify Background Shading • Resize And Move Pictures • Understand Slide Masters • Exit PowerPoint

Word 2010 Upon completing this course, the participant will be able to:

• Examine The Ribbon • Understand The Mini Toolbar • Add Animation To Text And Graphics • Add Clip Art To Slides • Add Titles And Subtitles In The Outline Tab • Apply Slide Transitions • Check Spelling • Close PowerPoint Presentations • Copy And Move Slides In Slide Sorter View • Create Basic Shapes • Create Notes In Notes Page View • Create Shapes • Create WordArt • Crop Pictures • Delete Slides • Demote And Promote Text In The Slide Pane • Examine The Microsoft Office PowerPoint 2007

Window • Examine The Outline Tab • Explore Notes And Handouts • Group Objects • Insert Hyperlinks • Insert Pictures And Omit Background Graphics • Insert Slides And Change Layouts • Open Existing PowerPoint Presentations • Open Microsoft Office PowerPoint • Print Presentations • Publish And Save Presentations As Web Pages • Resize And Move Clip Art • Save Presentations • Understand Bullets • Understand Microsoft Office PowerPoint 2007 • Understand Slide Layouts • Arrange Shapes • Make Annotations In Slide Show Mode • Modify Background Shading • Resize And Move Pictures • Understand Slide Masters • Exit PowerPoint

   

Page 3: Productivity Tools Objectives 1! - Western Illinois … Tools.pdfProductivity Tools Objectives ! 2! Word 2007 Upon completing this course, the participant will be able to: • Examine

Productivity Tools Objectives  

3  

Powerpoint 2003 Upon completing this course, the participant will be able to:

• Add Clip Art to Slides • Resize and Move Images • Change Clip Art Colors • Insert Screenshots • Insert Pictures and Omit Background

Graphics • Crop Pictures • Edit Photo Albums • Modify Pictures and Graphics • Insert Slides and Change Layouts • Delete Slides • Rearrange Slides • Organize Large Presentations into Sections • Format and Organize Slides • Change Slide Layouts • Understand Themes • Apply Themes • Modify Theme Colors, Fonts, and Effects • Modify Slide Backgrounds • Modify Font Colors and Shading • Save Slide Designs as New Themes • Create Presentations Manually • Create Presentations Using Templates • Create Presentations from Documents • Create Photo Albums • Create Action Buttons • Create a Hyperlinks • Save Versions of Presentations

Automatically • Edit and Format Text in Presentations • Create Bulleted and Numbered Lists • Use Format Painter to Format Text • Look at the PowerPoint 2010 Working

Screen • Explore Backstage View • Navigate Through Presentations • Create WordArt • Modify WordArt Styles • Change WordArt Colors • Create Effects For WordArt • Animate WordArt • Create Shapes • Work with Shapes • Arrange Shapes and Other Objects • Rotate Graphics • Create SmartArt • Add and Modify Text in Shapes • Group Objects • Insert Charts • Create PowerPoint Tables • Merge Cells and Delete Rows • Apply Styles to Tables

Powerpoint 2007 Upon completing this course, the participant will be able to:

• Examine The Ribbon • Understand The Mini Toolbar • Add Animation To Text And Graphics • Add Clip Art To Slides • Add Titles And Subtitles In The Outline Tab • Apply Slide Transitions • Check Spelling • Close PowerPoint Presentations • Copy And Move Slides In Slide Sorter View • Create Basic Shapes • Create Notes In Notes Page View • Create Shapes • Create WordArt • Crop Pictures • Delete Slides • Demote And Promote Text In The Slide

Pane • Examine The Microsoft Office PowerPoint

2007 Window • Examine The Outline Tab • Explore Notes And Handouts • Group Objects • Insert Hyperlinks • Insert Pictures And Omit Background

Graphics • Insert Slides And Change Layouts • Open Existing PowerPoint Presentations • Open Microsoft Office PowerPoint • Print Presentations • Publish And Save Presentations As Web

Pages • Resize And Move Clip Art • Save Presentations • Understand Bullets • Understand Microsoft Office PowerPoint

2007 • Understand Slide Layouts • Arrange Shapes • Make Annotations In Slide Show Mode • Modify Background Shading • Resize And Move Pictures • Understand Slide Masters • Exit PowerPoint

   

Page 4: Productivity Tools Objectives 1! - Western Illinois … Tools.pdfProductivity Tools Objectives ! 2! Word 2007 Upon completing this course, the participant will be able to: • Examine

Productivity Tools Objectives  

4  

Powerpoint 2010 Upon completing this course, the participant will be able to:

• Add Clip Art to Slides • Resize and Move Images • Change Clip Art Colors • Insert Screenshots • Insert Pictures and Omit Background Graphics • Crop Pictures • Edit Photo Albums • Modify Pictures and Graphics • Insert Slides and Change Layouts • Delete Slides • Rearrange Slides • Organize Large Presentations into Sections • Format and Organize Slides • Change Slide Layouts • Understand Themes • Apply Themes • Modify Theme Colors, Fonts, and Effects • Modify Slide Backgrounds • Modify Font Colors and Shading • Save Slide Designs as New Themes • Create Presentations Manually • Create Presentations Using Templates • Create Presentations from Documents • Create Photo Albums • Create Action Buttons • Create a Hyperlinks • Save Versions of Presentations Automatically • Edit and Format Text in Presentations • Create Bulleted and Numbered Lists • Use Format Painter to Format Text • Look at the PowerPoint 2010 Working Screen • Explore Backstage View • Navigate Through Presentations • Create WordArt • Modify WordArt Styles • Change WordArt Colors • Create Effects For WordArt • Animate WordArt • Create Shapes • Work with Shapes • Arrange Shapes and Other Objects • Rotate Graphics • Create SmartArt • Add and Modify Text in Shapes • Group Objects • Insert Charts • Create PowerPoint Tables • Merge Cells and Delete Rows • Apply Styles to Tables

Excel 2003 Upon completing this course, the participant will be able to:

• Apply Conditional Formatting • Apply Shading • Build Functions • Calculate Averages Using The Insert Function • Calculate Sums Using The Insert Function • Change Chart Types • Change Page Orientation And Scaling • Change Text Alignment • Close Workbooks • Copy And Edit Formulas • Copy And Paste Data • Create And Edit Hyperlinks • Create And Remove Custom Filters • Create Headers And Footers • Create Named Ranges • Edit And Resize Chart Titles • Edit Cell Content • Enter A Formula In The Formula Bar • Enter Cell Content • Fill A Series • Fill By Example • Format Numbers • Freeze And Unfreeze Columns & Rows • Go To Specific Cells • Insert And Delete Columns And Rows Insert And

Preview Page Breaks • Locate Errors In Formulas • Modify Column Width And Row Height • Modify Text Appearance • Open Microsoft Office Excel 2003 • Open Workbooks • Preview Worksheets • Print Worksheets And Workbooks • Protect And Unprotect Cells And Worksheets • Rename Worksheets • Set Page Margins And Alignment • Understand Cell References • Understand Filters • Understand Formulas • Understand Inserting Functions • Understand Microsoft Office Excel 2003 • Use AutoFilter • Use AutoSum And Auto Calculate • Use Border Drawing • Use Named Ranges In Formulas • Use The Chart Wizard

   

Page 5: Productivity Tools Objectives 1! - Western Illinois … Tools.pdfProductivity Tools Objectives ! 2! Word 2007 Upon completing this course, the participant will be able to: • Examine

Productivity Tools Objectives  

5  

Excel 2007 Upon completing this course, the participant will be able to:

• Apply Conditional Formatting • Apply Shading • Build Functions • Calculate Averages Using The Insert Function • Calculate Sums Using The Insert Function • Change Chart Types • Change Page Orientation And Scaling • Change Text Alignment • Close Workbooks • Copy And Edit Formulas • Copy And Paste Data • Create And Edit Hyperlinks • Create And Remove Custom Filters • Create Headers And Footers • Create Named Ranges • Edit And Resize Chart Titles • Edit Cell Content • Enter A Formula In The Formula Bar • Enter Cell Content • Fill A Series • Fill By Example • Format Numbers • Freeze And Unfreeze Columns & Rows • Go To Specific Cells • Insert And Delete Columns And Rows • Insert And Preview Page Breaks • Locate Errors In Formulas • Modify Column Width And Row Height • Modify Text Appearance • Open Microsoft Office Excel 2003 • Open Workbooks • Preview Worksheets • Print Worksheets And Workbooks • Protect And Unprotect Cells And Worksheets • Rename Worksheets • Set Page Margins And Alignment • Understand Cell References • Understand Filters • Understand Formulas • Understand Inserting Functions • Understand Microsoft Office Excel 2003 • Use AutoFilter • Use AutoSum And Auto Calculate • Use Border Drawing • Use Named Ranges In Formulas • Use The Chart Wizard

Excel 2010 Upon completing this course, the participant will be able to:

• Apply Conditional Formatting • Apply Shading • Build Functions • Calculate Averages Using The Insert Function • Calculate Sums Using The Insert Function • Change Chart Types • Change Page Orientation And Scaling • Change Text Alignment • Close Workbooks • Copy And Edit Formulas • Copy And Paste Data • Create And Edit Hyperlinks • Create And Remove Custom Filters • Create Headers And Footers • Create Named Ranges • Edit And Resize Chart Titles • Edit Cell Content • Enter A Formula In The Formula Bar • Enter Cell Content • Fill A Series • Fill By Example • Format Numbers • Freeze And Unfreeze Columns & Rows • Go To Specific Cells • Insert And Delete Columns And Rows • Insert And Preview Page Breaks • Locate Errors In Formulas • Modify Column Width And Row Height • Modify Text Appearance • Open Microsoft Office Excel 2003 • Open Workbooks • Preview Worksheets • Print Worksheets And Workbooks • Protect And Unprotect Cells And Worksheets • Rename Worksheets • Set Page Margins And Alignment • Understand Cell References • Understand Filters • Understand Formulas • Understand Inserting Functions • Understand Microsoft Office Excel 2003 • Use AutoFilter • Use AutoSum And Auto Calculate • Use Border Drawing • Use Named Ranges In Formulas • Use The Chart Wizard

   

Page 6: Productivity Tools Objectives 1! - Western Illinois … Tools.pdfProductivity Tools Objectives ! 2! Word 2007 Upon completing this course, the participant will be able to: • Examine

Productivity Tools Objectives  

6  

Access 2003 Upon completing this course, the participant will be able to:

• Launch Microsoft Office Access 2003 • Edit Existing Relationships • Organize And Print Relationships • Understand Forms • Create AutoForms • Create Forms Using The Form Wizard • Navigate Among Records • Enter Data Using A Form • Look At Form Design View • Move And Delete Controls • Align And Space Controls • Understand Filters • Use Filter By Selection And Sort Records • Use Filter By Form • Understand Queries • Create Single-table Queries In Query Design

View • Create Select Queries Using A Wizard • Find Duplicate Records • Find Unmatched Records • Delete, Move, And Hide Query Fields • Understand Reports • Create And Save AutoReports • Navigate In and Understand Reports • Create And Save AutoReports • Navigate In Reports • Create Reports Using A Wizard • Preview and Print Report Pages • Open Access Databases And Examine The

Database Window • Close Access Databases And Exit Access • Understand Tables • Navigate In Tables • Modify Columns And Rows • View Multiple Tables • Enter Data In Datasheet View • Use AutoCorrect • Modify Table Data • Find Records • Sort Table Data • Delete Table Data • Create Blank Databases From Scratch • Understand Data Types • Create Tables In Design View And Set Primary

Keys • Examine Primary Keys • Switch Between Views • Use The Table Wizard • Understand Relationships • Add Tables To The Relationships Window • Create Table Relationships • Examine The Help Task Pane • Move And Delete Fields • Format Calculated Fields • Understand Form Sections • Add Headers And Footers To Forms • Understand Controls • Change Form Properties • Understand Report Sections • Create Reports In Design View • Create Hyperlinks In Data Access Pages • Print Database Objects • Compact And Repair Databases

Access 2007 Upon completing this course, the participant will be able to:

• Open Access Databases • Examine The Ribbon • Understand Contextual Tabs • Look At The Navigation Pane • Understand and Navigate Tables • Modify Columns And Rows • Open Multiple Tables • Enter Data In Datasheet View • Modify, Sort and Delete Table Data • Find Records • Understand Database Design • Create Databases Using Templates • Create Blank Databases • Create Tables Using Templates • Understand Primary Keys • Look At Data Types • Create Tables In Design View • Switch Between Views • Understand Relationships • Add Tables To The Relationships • Create Table Relationships • Enforce And Test Referential Integrity • Edit Existing Relationships • Create A Relationship Report • Understand Forms • Create Forms With The Form Wizard • Navigate Among Records • Enter Data Using A Form • Look At Form Design View • Modify Control Properties • Move And Delete Controls • Align And Space Controls • Understand Filters • Use Filter By Form • Use Filter By Selection And Sort Records • Create Single-table Queries In Design View • Create Select Queries Using A Wizard • Delete, Move, And Hide Query Fields • Find Duplicate Records • Find Unmatched Records • Understand and Navigate Reports • Create Reports Using A Wizard • Preview and Print Report Pages • Modify Page Orientation And Margins • Use Help In Microsoft Access • Move And Delete Fields • Modify Multiple Data Types • Create And Use Hyperlinks In Tables • Understand The Lookup Wizard • Create And Use Lookup Lists • Generate And Use Value Lists • Understand, Apply and Use Input Masks • Understand Field Properties • Add Captions To Fields • Add Default Values • Propagate Field Properties • Specify Field Size And Format • Understand Indexes • Examine Importing And Exporting • Import Data To Existing Tables • Export Data To Other Applications • Create Multi-table Queries

Page 7: Productivity Tools Objectives 1! - Western Illinois … Tools.pdfProductivity Tools Objectives ! 2! Word 2007 Upon completing this course, the participant will be able to: • Examine

Productivity Tools Objectives  

7  

• Back Up Database Files In Microsoft Office Access 2003

• Create And Use Hyperlinks In Tables • Understand The Lookup Wizard • Create And Use Lookup Lists • Generate And Use Value Lists • Understand Input Masks • Apply And Use Input Masks • Understand Field Properties • Add Captions To Fields • Add Default Values • Specify Field Size And Format • Examine Importing And Exporting • Import Data To Existing Tables • Export Data From Access To Other Applications • Create Multi-table Queries • Specify Criteria • Understand Database Design • Establish One-to-one Relationships • Find Records Based On Several Criteria • Apply Filters To Queries • Create Forms In Design View • Create And Use Toggle Buttons • Look At Relationship Joins

• Examine Operators And Expressions • Specify Criteria • Create Crosstab Queries • Understand Form Sections • Add Headers And Footers To Forms • Understand Controls • Add Bound Controls To Forms • Use Layout View • Understand Report Sections • Create Reports In Design View • Format Controls In Reports • Look At Reports In Layout View • Align, Resize, And Space Controls • Print Database Objects • Compact And Repair Databases • Back Up Database Files

Access 2010 Upon completing this course, the participant will be able to:

• Open Access Databases • Examine The Ribbon • Understand Contextual Tabs • Look At The Navigation Pane • Understand and Navigate Tables • Modify Columns And Rows • Open Multiple Tables • Enter Data In Datasheet View • Modify, Sort and Delete Table Data • Find Records • Understand Database Design • Create Databases Using Templates • Create Blank Databases • Create Tables Using Templates • Understand Primary Keys • Look At Data Types • Create Tables In Design View • Switch Between Views • Understand Relationships • Add Tables To The Relationships • Create Table Relationships • Enforce And Test Referential Integrity • Edit Existing Relationships • Create A Relationship Report • Understand Forms • Create Forms With The Form Wizard • Navigate Among Records • Enter Data Using A Form • Look At Form Design View • Modify Control Properties • Align And Space Controls • Understand Filters • Use Filter By Selection And Sort Records • Create Single-table Queries In Design View • Create Select Queries Using A Wizard

• Find Duplicate/Unmatched Records • Understand and Navigate Reports • Create Reports Using A Wizard • Preview and Print Report Pages • Modify Page Orientation And Margins • Move And Delete Fields • Modify Multiple Data Types • Create And Use Hyperlinks In Tables • Understand The Lookup Wizard • Create And Use Lookup Lists • Generate And Use Value Lists • Understand, Apply and Use Input Masks • Understand Field Properties • Add Captions To Fields • Add Default Values • Propagate Field Properties • Specify Field Size And Format • Understand Indexes • Examine Importing And Exporting • Import Data To Existing Tables • Export Data To Other Applications • Create Multi-table Queries • Examine Operators And Expressions • Specify Criteria • Create Crosstab Queries • Understand Form Sections • Add Headers And Footers To Forms • Understand Controls • Add Bound Controls To Forms • Use Layout View • Understand Report Sections • Create Reports In Design View • Format Controls In Reports • Look At Reports In Layout View • Align, Resize, And Space Controls • Print Database Objects • Compact, Repair and Backup Databases • Delete, Move, And Hide Query Fields

Page 8: Productivity Tools Objectives 1! - Western Illinois … Tools.pdfProductivity Tools Objectives ! 2! Word 2007 Upon completing this course, the participant will be able to: • Examine

Productivity Tools Objectives  

8  

Publisher 2010 Upon completing this course, the participant will be able to:

• Select a Publication Type and Template o Discusses how to choose a publication type

and pick a template for a publication o Shows how to save a Publisher file

• Add and Modify Text in Placeholders o Shows how to add or replace text in a

placeholder o Teaches how to modify fonts and formatting

of placeholder text • Delete Placeholders

o Discusses the reasons for deleting placeholder from templates

o Covers the process of deleting a placeholder • Insert and Format Text Boxes

o Discusses ways to add images and illustrations to publications

o Looks at how to add and edit images

Outlook 2010 Upon completing this course, the participant will be able to:

• Get Started with Microsoft Outlook 2010 o Look at the Outlook Working Screen o Examine Backstage View in Outlook o Use the Navigation Pane

• Send and Receiving E-Mail Messages o Address, Compose, and Send E-mail

Messages o View and Resend Sent Items o Use Reply and Reply to All o Forward E-mail Messages o Explore Recalling E-mail Messages o Attach files to E-mail Messages o Preview, Open, and Save Attachments

• View E-mails o Use the Navigation Pane o Examine Conversation View o Change the Pane Layout o Arrange the Message List o Customize the View

• Explore E-mail Message Options o Set Message Importance and Sensitivity o Request Delivery and Read Receipts o Create E-mail Polls o Use the Quick Click Flags Feature o Create and Format Signatures o Use the Automatic Replies Feature o Managing E-mail Messages o Ignore a Conversation o Clean Up a Conversation o Delete E-mail Messages o Mark Messages As Not Junk o Understand and Use Quick Steps

• Organize E-mail with Folders o Create New Mail Folders o Specify Safe and Blocked Senders o Create Rules for Messages o Manage Rules and Alerts

• Work with Contacts o View and Add New Contacts o Address Messages Using the Address Book o Look at the Outlook Social Connector

• Understand Calendar Appointments and Events o Schedule Appointments and Add Reminders o Create Appointments from Messages o Reschedule Appointments and Recurring

Events o Mark Calendar Items As Private