For introductory courses in computer literacy. Written to provide all students with an opportunity to learn and demonstrate computer and Internet literacy. Computer Literary for IC3 was written to align with a certification called “Internet and Computing Core Certification (IC3)”.  This certification is for users who want to demonstrate critical computer and Internet skills valued in today’s academic and professional environments.  The Computer Literacy for IC3 text is written to meet the certification standards and provide students with a broad understanding of the key components of computer literacy in order to prepare for the exam. This certification has 3 units: •    Unit 1:  Computing Fundamentals (computer concepts) •    Unit 2:  Using Productivity Software •    Unit 3:  Living Online (the Internet) Each of these units is available as a separate Computer Literacy for IC3 text. This text contains: Unit 2: Using Productivity Software– Microsoft Office and covers productivity software based on Microsoft Office including common program functions, word processing functions, spreadsheet functions, and presentation software functions. The second edition of Computer Literacy for IC3 has been revised to keep up with the IC3 program’s evolution, which reflects the recent changes in computers and technology. Instead of publishing one large, comprehensive text, the three units are now available as separate, smaller texts.

Table of Contents:
IC3-2009 Unit 2—Using Productivity SoftwareOutline   Chapter 1—Starting with Office Applications   Lesson 1: Start an Application and Identify Common On-Screen Elements Lesson 2: Open and Save a File, and Close Applications Lesson 3: Navigate a Document and Insert, Select, and Edit Text Lesson 4: Use Buttons and Dialog Boxes Lesson 5: Check Spelling and Grammar Lesson 6: Select and Format Text Lesson 7: Copy, Paste, Cut and Move Text Lesson 8: Use Galleries, Contextual Tabs, and the Quick Access Toolbar Lesson 9: Print Documents Lesson 10: Use Help   Chapter 2: Creating a New Word Document and Inserting Graphics and Tables   Lesson 1: Create a Document Lesson 2: Create and Modify a Bulleted List Lesson 3: Format, Align and Indent Text Lesson 4: Create a Title with WordArt Lesson 5: Insert and Modify Clip Art Lesson 6: Insert and Modify Pictures Lesson 7: Insert Tables Lesson 8: Format Tables Lesson 9 Insert a Header or Footer in a Document Lesson 10: Create a Document from a Template   Chapter 3: Format and Organize Paragraphs and Documents   Lesson 1: Import and Modify Text Lesson 2: Create, Apply, and Modify Styles Lesson 3: Use Language Tools Lesson 4: Create Footnotes Lesson 5: Manage Citations Lesson 6: Prepare Document for Printing   Chapter 4: Formatting Informational Documents   Lesson 1: Insert Data from Another Document Lesson 2: Format a Multi-Column Document Lesson 3: Save a Document as a Template  Lesson 4: Insert Data from Excel Lesson 5: Create a Tabbed List Lesson 6: Use the Format Painter Lesson 7:  Save a Document as a PDF Fil Lesson 8:  Save a File as a Web Page   Chapter 5: Work with Collaborative Tools   Lesson 1: Insert Comments into a Document Lesson 2: Track Changes in a Document Lesson 3: Review and Consolidate Changes Lesson 4: Create a Document Template for Merging Lesson 5: Insert Merge Fields into a Document Lesson 6: Merge Document with a Data Source Lesson 7: Transmit Files Electronically   Chapter 6:  Creating a Formatting a Worksheet   Lesson 1: Navigate a Workbook, Select Cells, and Enter Text and Data Lesson 2: Adjust Column Widths Lesson 3: Insert or Delete Rows or Columns Lesson 4: Sum a Column of Numbers Lesson 5: Format Numbers and Dates Lesson 6: Align Text Lesson 7: Add Emphasis, Colors, Shading and Borders Lesson 8: Open, Copy, Insert, and Delete Worksheets Lesson 9: Format, Sort, and Filter Tables Lesson 10: Document and Print Worksheets   Chapter 7: Managing Money Using Formulas and Functions   Lesson 1: Fill Labels and Use Worksheet Functions Lesson 2: Use the Payment Function Lesson 3: Fill a Sequence of Numbers as Labels and Format Them as Text Lesson 4: Use References to Cells in Other Worksheets and Relative Cell References Lesson 5: Calculate a Percentage Increase and Decrease Using Absolute Cell References Lesson 6: Use a Cash Flow Analysis Lesson 7: Calculate a Simple Payment Using a Hidden Row, the IF Function and Conditional Formatting Lesson 8: Use the Internal Rate of Return Function Lesson 9: Print Large Worksheets   Chapter 8: Giving Meaning to Data Using Charts   Lesson 1: Create a Column Chart Lesson 2: Edit Chart Elements Lesson 3: Use a Pie Chart Lesson 4: Chart a Trend with a Line Chart Lesson 5: Format Axis Labels and Add a Trendline Lesson 6: Document the Chart and Worksheets     Chapter 9:  Creating a Presentation   Lesson 1: Create a Presentation and Work in Different Views Lesson 2: Add Slides to a Presentation Lesson 3: Add Graphic Elements Lesson 4: Add a Design Lesson 5: Animate a Presentation Lesson 6: Create Handouts   Chapter 10: Enhancing a Presentation   Lesson 1: Import Slides into a Presentation Lesson 2: Add Data Elements to a Presentation Lesson 3: Control Design Elements Lesson 4: Add Headers and Footers Lesson 5: Add Timings to a Presentation Lesson 6: Create and Print Speaker Notes Lesson 7: Preview and Navigate a Slide Show   Chapter 11: Creating a Customized Database   Lesson 1: Open and Navigate a Database Lesson 2: Create a Database and Add Tables Lesson 3: Change Table  Field Properties Lesson 4: Create Table Relationships Lesson 5: Add and Delete Records Lesson 6: Create a Form Using the Form Wizard Lesson 7: Create a Report Using the Report Wizard   Chapter 12: Retrieving Information from Your Database   Lesson 1: Find Records Lesson 2: Sort Records Lesson 3: Filter Records Lesson 4: Create Select Queries Lesson 5: Create Compound Queries and Use Comparison Operators Lesson 6: Create a Query Based on Two Tables Lesson 7: Use a Wildcard to Locate Data