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
