Computer Literacy for IC3 Unit 2: Using Productivity Software / Edition 2

Computer Literacy for IC3 Unit 2: Using Productivity Software / Edition 2

by John Preston, Sally Preston, Robert Ferrett
     
 

View All Available Formats & Editions

ISBN-10: 0133028615

ISBN-13: 9780133028614

Pub. Date: 12/18/2012

Publisher: Prentice Hall

Written to provide all students with an opportunity to learn and demonstrate computer and Internet literacy. Computer Literary for IC3 was written to align with a certification called “Internet and Computing Core Certification (IC3)”. This certification is for users who want to demonstrate critical computer and Internet skills valued in

Overview

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

This certification has 3 units:
• Unit 1: Computing Fundamentals (computer concepts)
• Unit 2: Using Productivity Software
• Unit 3: Living Online (the Internet)

Each of these units is available as a separate Computer Literacy for IC3 text. This text contains: Unit 2: Using Productivity Software covers productivity software based on Microsoft® Office 2010, including word processing, spreadsheets, presentation software, and (new for GS4) databases. The second edition of Computer Literacy for IC3 has been revised to keep up with the IC3 program’s evolution, which reflects the recent changes in computers and technology. Instead of publishing one large, comprehensive text, the three units are now available as separate, smaller texts.

Product Details

ISBN-13:
9780133028614
Publisher:
Prentice Hall
Publication date:
12/18/2012
Series:
Computers Are Your Future Series
Edition description:
New Edition
Pages:
608
Product dimensions:
8.30(w) x 10.80(h) x 0.90(d)

Related Subjects

Table of Contents

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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >