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 covers productivity software based on Microsoft® Office 2010, including word processing, spreadsheets, presentation software, and (new for GS4) databases. 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:
CH 1 Starting with Microsoft® Office 2010 Applications   Lesson 1    Starting an Application and Identifying Common On-Screen Elements  Lesson 2    Opening and Saving a File and Closing Applications    Lesson 3    Navigating a Document and Inserting, Selecting, and Editing Text    Lesson 4    Using Buttons and Dialog Boxes   Lesson 5    Checking Spelling and Grammar   Lesson 6    Selecting and Formatting Text   Lesson 7    Copying, Pasting, Cutting, and Moving Text   Lesson 8    Using Galleries, Contextual Tabs, and the Quick Access Toolbar    Lesson 9    Printing Documents  Lesson 10    Using Help    Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    Fix It   On the Job    Discussion of Advanced Skills or Concepts    On Your Own     CH 2 Creating a New Word Document and Inserting Graphics and Tables Lesson 1    Creating a New Document   Lesson 2    Creating and Modifying a Numbered or Bulleted List    Lesson 3   Formatting, Aligning, and Indenting Text   Lesson 4   Creating a Title with WordArt    Lesson 5   Inserting and Modifying Clip Art   Lesson 6   Inserting and Modifying Pictures Lesson 7   Inserting Tables   Lesson 8   Formatting Tables Lesson 9   Inserting a Header or Footer in a Document   Lesson 10   Creating a Document from a Template    Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    Fix It   On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 3 Formatting and Organizing Paragraphs and Documents Lesson 1    Customizing Word Lesson 2    Importing Text from Another Document   Lesson 3    Creating, Applying, and Modifying Styles   Lesson 4    Using Language Tools Lesson 5    Creating Footnotes   Lesson 6    Managing Citations   Lesson 7    Creating a Bibliography Lesson 8    Preparing a Document for Printing    Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    Fix It   On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 4 Importing Text and Formatting a Newsletter     Lesson 1    Inserting Data from Other Documents Lesson 2    Creating and Formatting a Multicolumn Document Lesson 3    Saving a Document as a Template  Lesson 4    Applying Special Formatting    Lesson 5    Adding Symbols   Lesson 6    Setting and Modifying Tab Stops Lesson 7    Saving a Document Using Different Document Formats  Lesson 8    Adding Hyperlinks and Saving a Document as a Web Page    Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    Fix it On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 5 Working with Collaborative Tools  Lesson 1    Inserting Comments into a Document   Lesson 2    Tracking Changes in a Document   Lesson 3    Responding to Comments and Document Changes Lesson 4    Creating a Main Document for Merging   Lesson 5    Opening a Data Source and Inserting Fields into a Document Lesson 6    Merging a Document with a Data Source   Lesson 7    Using the Mail Merge Wizard to Create Mailing Labels Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    Fix it On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 6 Creating and Formatting a Worksheet Lesson 1    Navigating a Workbook, Selecting Cells, and Entering Text and Data Lesson 2    Adjust Column Widths Lesson 3    Inserting or Deleting Rows or Columns   Lesson 4    Summing a Column of Numbers   Lesson 5    Formatting Numbers and Dates    Lesson 6    Aligning Text Lesson 7    Adding Emphasis, Colors, Shading, and Borders  Lesson 8    Opening, Copying, Inserting, and Deleting Worksheets Lesson 9    Formatting, Sorting, and Filtering Tables  Lesson 10    Documenting and Printing Worksheets   Check Your Work    Key Terms   Assessing Learning Outcomes   Skill Drill    Fix it On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 7 Managing Money Using ­Formulas and Functions Lesson 1    Fill Labels and Use Worksheet Functions  Lesson 2    Using the Payment Function    Lesson 3    Filling a Sequence of Numbers and Formatting Them as Text   Lesson 4    Using References to Cells in Other Worksheets and Relative Cell References  Lesson 5    Calculating a Percentage Increase and Decrease Using Absolute Cell References Lesson 6    Using a Cash Flow Analysis  Lesson 7    Calculating a Simple Payback Using a Hidden Row, the IF Function, and Conditional Formatting    Lesson 8    Using the Internal Rate of Return Function   Lesson 9    Printing Large Worksheets  Check Your Work    Key Terms   Assessing Learning Outcomes Skill Drill    Fix It   On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 8 Giving Meaning to Data Using Charts    Lesson 1    Creating a Column Chart    Lesson 2    Editing Chart Elements    Lesson 3    Using a Pie Chart Lesson 4    Charting a Trend with a Line Chart    Lesson 5    Formatting Axis Labels and Adding a Trendline   Lesson 6    Documenting the Chart and Worksheets   Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    Fix it On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 9 Creating a Presentation   Lesson 1    Creating a Presentation   Lesson 2    Adding Slides to a Presentation and Editing Content Lesson 3    Adding Graphic Elements   Lesson 4    Applying a Theme to a Presentation Lesson 5    Adding Information to the Header and Footer   Lesson 6    Adding Slide Transitions and Viewing a Slide Show    Lesson 7    Creating Speaker Notes and Handouts    Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    Fix it On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 10  Enhancing a Presentation Lesson 1    Importing Text from an Outline    Lesson 2    Applying a Theme and Adding Graphics Lesson 3    Adding Tables to a Presentation   Lesson 4    Adding Charts to a Presentation   Lesson 5    Inserting Diagrams Using SmartArt    Lesson 6    Adding Animations   Lesson 7    Adding Hyperlinks and Saving as a PDF File    Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    Fix It   On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 11  Creating a Customized Database   Lesson 1    Examining the Structure of a Database    Lesson 2    Creating Tables and Setting Field Properties in Design View    Lesson 3    Creating Relationships and Enforcing Referential Integrity   Lesson 4    Adding, Editing, and Deleting Records Lesson 5    Creating a Form Using the Form Wizard   Lesson 6    Creating a Report Using the Report Wizard Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    On the Job    Discussion of Advanced Skills or Concepts    On Your Own   CH 12  Retrieving Information from Your Database    Lesson 1    Finding Records   Lesson 2    Sorting Records   Lesson 3    Filtering Records    Lesson 4    Creating Select Queries   Lesson 5    Creating Compound Queries and Using Comparison Operators Lesson 6    Creating a Query Based on more than One ­Table Lesson 7    Using a Wildcard to Locate Data   Check Your Work    Key Terms   Assessing Learning Outcomes    Skill Drill    On the Job    Discussion of Advanced Skills or Concepts    On Your Own