Gift Guide

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

Other Format (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Other Format)
  • All (10) from $1.99   
  • New (4) from $4.59   
  • Used (6) from $1.99   


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 and covers productivity software based on Microsoft Office including common program functions, word processing functions, spreadsheet functions, and presentation software functions. 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.

Starting with Office Applications; Creating a New Word Document and Inserting Graphics and Tables; Format and Organize Paragraphs and Documents; Formatting Informational Documents; Work with Collaborative Tools; Creating a Formatting a Worksheet; Managing Money Using Formulas and Functions; Giving Meaning to Data Using Charts; Creating a Presentation; Enhancing a Presentation; Creating a Customized Database; Retrieving Information from Your Database

Computer Literacy for IC3 prepares students from the IC3 certification, which ensures that students and professionals have all the core skills needed to work in today’s technological environment.

Read More Show Less

Product Details

  • ISBN-13: 9780135064979
  • Publisher: Prentice Hall
  • Publication date: 4/10/2009
  • Format: Spiral Bound
  • Edition description: Older Edition
  • Edition number: 2
  • Pages: 656
  • Product dimensions: 8.30 (w) x 10.80 (h) x 0.80 (d)

Meet the Author

Robert L. Ferrett recently retired as Director of the Center for Instructional Computing at Eastern Michigan University, where he provided computer training and support to faculty. He has authored or co-authored more than 80 books on Access, PowerPoint, Excel, Publisher, Windows Vista, WordPerfect, and Word. He has been designing, developing, and delivering computer workshops for nearly two decades. Bob has written for the GO! Series, and was a series editor for the Learn 97, Learn 2000, and Learn XP books. He has a BA in Psychology, an MS in Geography, and an MS in Interdisciplinary Technology from Eastern Michigan University. His doctoral studies are in Instructional Technology at Wayne State University. As a sidelight, Bob teaches a four-week Computers and Genealogy class, and has written genealogy and local history books.

Sally Preston teaches computing in a variety of settings, which provides her with ample opportunity to observe how people learn, what works best, and what challenges are present when learning a new software program. The diverse experience provides a complementary set of skills and knowledge that is blended into her writing. Sally has been writing computer textbooks for nearly ten years and has authored books for the GO! Series, the Learn Series, and for the Essential Series. Sally has an MBA from Eastern Michigan University. When she is away from her computer she is often found planting flowers in her garden.

John Preston is an Associate Professor at Eastern Michigan University in the College of Technology in the Technology Management program. He has been teaching, writing, and designing computer courses since the advent of PCs, and has authored and co-authored more than sixty books on computer applications and the relationship between technology and society. He teaches courses in global technologies, managing information systems, project management, and quantitative reasoning. He served as program coordinator of the Energy Management program and has trained commercial energy auditors for all of the major utilities in Michigan. Prior to his tenure at EMU, he was a partner in an energy management consulting firm.

Read More Show Less

Table of Contents

IC3-2009 Unit 2— Using Productivity Software Outline

Chapter 1—Starting with Office Applications

Lesson 1: Start an Application and Identify Common On-Screen Elements

Lesson 2: Open and Save a File, and Close Applications

Lesson 3: Navigate a Document and Insert, Select, and Edit Text

Lesson 4: Use Buttons and Dialog Boxes

Lesson 5: Check Spelling and Grammar

Lesson 6: Select and Format Text

Lesson 7: Copy, Paste, Cut and Move Text

Lesson 8: Use Galleries, Contextual Tabs, and the Quick Access Toolbar

Lesson 9: Print Documents

Lesson 10: Use Help

Chapter 2: Creating a New Word Document and Inserting Graphics and Tables

Lesson 1: Create a Document

Lesson 2: Create and Modify a Bulleted List

Lesson 3: Format, Align and Indent Text

Lesson 4: Create a Title with WordArt

Lesson 5: Insert and Modify Clip Art

Lesson 6: Insert and Modify Pictures

Lesson 7: Insert Tables

Lesson 8: Format Tables

Lesson 9 Insert a Header or Footer in a Document

Lesson 10: Create a Document from a Template

Chapter 3: Format and Organize Paragraphs and Documents

Lesson 1: Import and Modify Text

Lesson 2: Create, Apply, and Modify Styles

Lesson 3: Use Language Tools

Lesson 4: Create Footnotes

Lesson 5: Manage Citations

Lesson 6: Prepare Document for Printing

Chapter 4: Formatting Informational Documents

Lesson 1: Insert Data from Another Document

Lesson 2: Format a Multi-Column Document

Lesson 3: Save a Document as a Template

Lesson 4: Insert Data from Excel

Lesson 5: Create a Tabbed List

Lesson 6: Use the Format Painter

Lesson 7: Save a Document as a PDF Fil

Lesson 8: Save a File as a Web Page

Chapter 5: Work with Collaborative Tools

Lesson 1: Insert Comments into a Document

Lesson 2: Track Changes in a Document

Lesson 3: Review and Consolidate Changes

Lesson 4: Create a Document Template for Merging

Lesson 5: Insert Merge Fields into a Document

Lesson 6: Merge Document with a Data Source

Lesson 7: Transmit Files Electronically

Chapter 6: Creating a Formatting a Worksheet

Lesson 1: Navigate a Workbook, Select Cells, and Enter Text and Data

Lesson 2: Adjust Column Widths

Lesson 3: Insert or Delete Rows or Columns

Lesson 4: Sum a Column of Numbers

Lesson 5: Format Numbers and Dates

Lesson 6: Align Text

Lesson 7: Add Emphasis, Colors, Shading and Borders

Lesson 8: Open, Copy, Insert, and Delete Worksheets

Lesson 9: Format, Sort, and Filter Tables

Lesson 10: Document and Print Worksheets

Chapter 7: Managing Money Using Formulas and Functions

Lesson 1: Fill Labels and Use Worksheet Functions

Lesson 2: Use the Payment Function

Lesson 3: Fill a Sequence of Numbers as Labels and Format Them as Text

Lesson 4: Use References to Cells in Other Worksheets and Relative Cell References

Lesson 5: Calculate a Percentage Increase and Decrease Using Absolute Cell References

Lesson 6: Use a Cash Flow Analysis

Lesson 7: Calculate a Simple Payment Using a Hidden Row, the IF Function and Conditional Formatting

Lesson 8: Use the Internal Rate of Return Function

Lesson 9: Print Large Worksheets

Chapter 8: Giving Meaning to Data Using Charts

Lesson 1: Create a Column Chart

Lesson 2: Edit Chart Elements

Lesson 3: Use a Pie Chart

Lesson 4: Chart a Trend with a Line Chart

Lesson 5: Format Axis Labels and Add a Trendline

Lesson 6: Document the Chart and Worksheets

Chapter 9: Creating a Presentation

Lesson 1: Create a Presentation and Work in Different Views

Lesson 2: Add Slides to a Presentation

Lesson 3: Add Graphic Elements

Lesson 4: Add a Design

Lesson 5: Animate a Presentation

Lesson 6: Create Handouts

Chapter 10: Enhancing a Presentation

Lesson 1: Import Slides into a Presentation

Lesson 2: Add Data Elements to a Presentation

Lesson 3: Control Design Elements

Lesson 4: Add Headers and Footers

Lesson 5: Add Timings to a Presentation

Lesson 6: Create and Print Speaker Notes

Lesson 7: Preview and Navigate a Slide Show

Chapter 11: Creating a Customized Database

Lesson 1: Open and Navigate a Database

Lesson 2: Create a Database and Add Tables

Lesson 3: Change Table Field Properties

Lesson 4: Create Table Relationships

Lesson 5: Add and Delete Records

Lesson 6: Create a Form Using the Form Wizard

Lesson 7: Create a Report Using the Report Wizard

Chapter 12: Retrieving Information from Your Database

Lesson 1: Find Records

Lesson 2: Sort Records

Lesson 3: Filter Records

Lesson 4: Create Select Queries

Lesson 5: Create Compound Queries and Use Comparison Operators

Lesson 6: Create a Query Based on Two Tables

Lesson 7: Use a Wildcard to Locate Data

Read More Show Less

Customer Reviews

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

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & 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 & 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 & 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 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


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & 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 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)