Preston, J: Computer Literacy for IC3 Unit 2

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