Product Cover Image

Computer Literacy for IC3 Unit 2: Using Productivity Software, CourseSmart eTextbook

By John Preston, Sally Preston, Robert Ferrett

Published by Prentice Hall

Published Date: Mar 29, 2013

More Product Info

Description

 For introductory courses in computer literacy.


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 IC3text 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 1: Computing Fundamentals and covers basic computer concepts including computer hardware, computer software, and using an operating system.

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.

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

 

Purchase Info ?

With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.

Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.

Buy Access

Computer Literacy for IC3 Unit 2: Using Productivity Software, CourseSmart eTextbook
Format: Safari Book

$27.99 | ISBN-13: 978-0-13-303651-0