Computer Literacy for IC3 Unit 2
Using Productivity Software
2nd Edition
Published on 11. February 2013
Book
Paperback/Softback
608 pages
978-0-13-302861-4 (ISBN)
Description
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 (R) 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.
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 (R) 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.
More details
Other editions
New editions
Robert Ferrett | John Preston | Sally Preston
Computer Literacy for IC3, Unit 2
Using Productivity Software, Update to Office 2013 & Windows 8.1.1
Book
08/2014
2nd Edition
Pearson
€74.27
Article is exhausted; no reprint
Previous edition
John Preston | Sally Preston | Robert Ferrett
Computer Literacy for IC3 Unit 2
Using Productivity Software
Book
08/2009
Pearson
€54.46
Article exhausted; check for reprint
Content
CH 1 Starting with Microsoft (R) 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
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