Key Applications - IC3 Training Solution

Training Provided by Online Training Directory Covers one of three tested areas of IC3 (Internet and Computing Core Certification) - Key Applications. This covers the skills outlined in the Key Applications portion of the IC3 Certification Exam, which addresses the skills and functions common to Microsoft Windows applications. It focuses on applying these common skills and functions using Microsoft Word and Microsoft Excel. Some of the skills covered include starting applications; opening, saving, and closing files; identifying and using common on-screen elements; accessing online help; formatting text, documents, and spreadsheets; editing documents and spreadsheets; using automatic formatting tools; performing common print functions; adding tables and graphics to documents; modifying worksheet data; sorting and manipulating data; and adding pictures and charts to worksheets.

Key Applications - IC3 Training Solution Outcomes
Upon completion of this course, students will be able to: --Recognize the similarities among the concepts, skills, and elements of Windows applications --Know where to go to find help on Windows applications --Create effective documents and spreadsheets --Select, cut, copy, paste, replace, and edit text --Format text, paragraphs, documents, and worksheets --Insert and format tables, graphics, cells, and charts --Work with formulas, sorts, references, and functions --Print documents, worksheets, and selections.
Assessment
Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery.

Key Applications Chapter 1 - Understanding Common Elements --Understand Personalized Toolbars And Menus --Use the Office Assistant? --Understand Common Elements --Explore Task Panes --Launch Microsoft Word 2002 --Hide and display toolbars --Examine The Working Screen Key Applications??

Chapter 2 - Opening, Closing, And Navigating Within Documents --Close Documents And The Application --Open Documents --Navigate Documents --Use The Zoom Feature --Switch Between Open Documents --Explore Document Views In Word Key Applications? Chapter 3 - Exploring Various Sources Of Help And Resolving Problems --Identify Help Resources --Explore Help Contents And Index --Use The Answer Wizard ?--Identify And Solve Common Problems --Ask Help A Question --Obtain Help Online --Examine The Ask A Question Feature Key Applications?? Chapter 4 - Working With Documents And Text --Select Multiple Text Blocks --Use the Undo, Redo, and Repeat command --Cut And Paste Text --Entering Text In Word --Save To A Floppy Disk --Select And Replace Text --Use Save As --Examine Cut, Copy, and Paste --Save Documents --Delete Text --Create Documents From Templates --Copy And Paste Text --Create New Documents Key Applications?? Chapter 5 - Formatting Text --Adjust Font Size --Apply Text Formattin --Understand Fonts --Change Fonts --Apply Character Effects Key Applications Chapter 6 - Formatting Paragraphs --Add Shading --Apply Borders --Set Left And Right Indents --Add Hanging And First Line Indents --Align Tex --Apply Automatic Numbering --Set Line And Paragraph Spacing Options --Understand Alignment --Insert Bullets Key Applications Chapter 7 - Using Automatic Formatting Tools --Copy formats using the Format Painter --Apply AutoFormats --Design New Character Styles --Apply Paragraph Styles --Add Entries To AutoText --Create New Paragraph Styles Key Applications?? Chapter 8 - Improving Document Layout --Work With Tabs --Insert Page Breaks --Add Placeholders To Headers And Footers? --Create Headers And Footers --Understand Sections --Create and modify page numbers --Insert Section Breaks --Insert Symbols --Understand Tab Stops Key Applications? Chapter 9 - Working With Tables --Insert And Delete Rows And Columns --Adjust Columns And Rows --Insert Text Into Tables --Merge And Split Cells --Insert Tables --Draw And AutoFormat Tables --Apply Borders And Shading To Tables --Understand Tables Key Applications? Chapter 10 - Inserting Pictures And Drawn Objects --Use The Drawing Canvas --Layer, Group, and UnGroup Drawn Objects --Understand And Use The Drawing Toolbar --Insert ClipArt --Format Graphics With Text --Insert Graphics --Adjust Graphics Key Applications? Chapter 11 - Getting Ready To Print And Printing --Check Spelling And Grammar --Preview Documents --Examine The Print Dialog Box --Change Margins --Experiment With Page Orientation And Size --Find And Replace Text --Print Documents --Understand The Spelling Feature --Identify And Solve Common Printing Problems Key Applications? Chapter 12 - Getting Started With Excel --Open Workbooks --View Worksheets --Examine The Excel Window --Go To Specific Cells --Open Excel Key Applications -? Chapter 13 - Modifying Worksheet Data And Structure --Insert And Delete Worksheets --Insert And Delete Cells --Hide And Unhide Rows And Columns --Insert And Delete Columns And Rows --Fill A Series --Understand Fills --Enter Cell Content --Rename Worksheets --Modify Column Width And Row Height --Edit Cell Content Key Applications -? Chapter 14 - Manipulating Data Using Sorts And Formulas --Understand Formulas --Understanding Lists --Use references (absolute and relative) --Understand Cell References --Copy And Edit Formulas --Use Cell References In Formulas --Using Mixed Addresses --Enter A Formula In The Formula Bar --Perform single and multi-level sorts Key Applications? Chapter 15 - Using Functions? --Use AutoSum And AutoCalculate --Understand Functions --Calculate Averages Using The Insert Function --Calculate Sums Using The Insert Function --Create Minimum Functions --Understand The Importance Of Checking Data --Create Maximum Functions --Use Multiple Functions Within Formulas --Build Functions Key Applications -? Chapter 16 - Formatting Worksheets? --Apply Cell Borders --Format Numbers --Apply Shading --Rotate Text --Understand Date And Number Formatting --Modify Text Appearance --Wrap Text Within Cells --Change Text Alignment --Use The Format Painter Key Applications? Chapter 17 - Using Advanced Formatting Features --Apply AutoFormats --Understand AutoFormatting --Define Styles --Apply And Remove Styles Key Applications? Chapter 18 - Adding Charts And Pictures --Change Chart Types --Elevate, Rotate, Resize, And Position Charts? --Insert Graphics --Use The Chart Wizard --Edit And Resize Chart Titles --Move And Delete Graphics --Examine Charts --Create And Modify Lines And Graphics Key Applications? Chapter 19 - Finalizing And Printing Worksheets? --Print Worksheets And Workbooks --Create Headers And Footers In Worksheets --Print Selections --Change Page Orientation And Scaling --Select Print Options --Set, Print, And Clear Print Areas --Understand Printing --Insert Page BreaksIC3 Overview --Benefits of IC3 Certification --IC3 Certification Promotional Ad --IC3 Certification Promo --IC3 Certification Roadmap

Contact Hours: 24

About The Training Provider: Online Training Directory

More IC3 Internet and Computing Core Certification Training from Online Training Directory

• Computing Fundamentals - IC3 Training Solution
• IC3 Training Solution Bundle
• Living Online - IC3 Training Solution