Computer Literacy for IC3 Unit 2:... | Buy

Written to provide all readers with an opportunity to learn and demonstrate computer and Internet literacy. This title is also appropriate for courses in computer literacy teaching non-Microsoft productivity software such as Google or Open Office.

Computer Literary for IC3 is written to align with a certification called Internet and Computing Core Certification (IC3). This certification is for users who want to demonstrate the critical computer and Internet skills valued in today’s academic and professional environments. The Computer Literacy for IC3 text provides students with a broad understanding of the key components of computer literacy in order to prepare for the IC3 exam.

This certification has 3 units. Each of these units is available as a separate Computer Literacy for IC3 text:

Unit 1: Computing Fundamentals (computer concepts)
Unit 2: Using Open-Source Productivity Software
Unit 3: Living Online (the Internet)

Unit 2: Using Open-Source Productivity Software covers productivity software based on open-source productivity software, including word processing, spreadsheets, presentation software, and databases.

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

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rent More, Save More! Use code: ECRENTAL

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

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

Summary

Table of Contents

Supplemental Materials

Rewards Program