Computer Literacy for IC3 Unit 2: Using Open-Source Productivity Software

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

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

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

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

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

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

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

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

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

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

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

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