Preston, J: Computer Literacy for IC3 Unit 2

For introductory courses in computer literacy.

CH 1 Starting with Microsoft(R) 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