Computer Literacy for IC3 Unit 2: Using Productivity Software

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 ...
See more details below
(Spiral Bound - New Edition)
$63.18
BN.com price
(Save 10%)$70.20 List Price
Other sellers (Other Format)
  • All (15) from $34.02   
  • New (11) from $34.02   
  • Used (4) from $35.10   
Sending request ...

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.

Read More Show Less

Product Details

  • ISBN-13: 9780133028614
  • Publisher: Prentice Hall
  • Publication date: 12/18/2012
  • Format: Spiral Bound
  • Edition description: New Edition
  • Edition number: 2
  • Pages: 608
  • Product dimensions: 8.30 (w) x 10.80 (h) x 0.90 (d)

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

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)