Computer Literacy for IC3 Unit 2
Using Productivity Software
Published on 6. August 2009
Book
Spiral bound
640 pages
978-0-13-506497-9 (ISBN)
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 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- Microsoft Office 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.
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- Microsoft Office 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.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 235 mm
Width: 285 mm
Thickness: 30 mm
Weight
1143 gr
ISBN-13
978-0-13-506497-9 (9780135064979)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
John Preston | Sally Preston | Robert Ferrett
Computer Literacy for IC3 Unit 2
Using Productivity Software
Book
02/2013
2nd Edition
Pearson
€56.94
Article exhausted; check for reprint
Persons
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 theEssential 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.
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 theEssential 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.
Content
IC3-2009 Unit 2-Using Productivity SoftwareOutline
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
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