Table Of ContentA ll In O n e
Com puter C o n ce p ts & A p p lication s
Student R eso u rces (available online or in MylTLab)
Companion Web Site [pearsonhighered.com/go) includes supporting videos and simulations, as well as
all student data files referenced in the book, glossary, and an interactive study guide.
Student Videos - 3 Types!
• Instructor-Led Videos—Authors, who are instructors, guide students through the Objectives of each
project, just as they do in their own classrooms, providing a visual and audio walk-through of project
Objectives in the Office application chapters.
• Job-Focused Videos —Each unit begins with a video of a person in a real job talking about how they
use Office applications in their occupation.
• Video Simulations—Short animations illustrate and clarify interesting or difficult topics for the
concepts chapters.
Interactive Simulations—Concepts chapters are supported by an interactive simulation of a key computer
concept, allowing you to learn by doing.
Online Study Guide—Interactive quizzes let you practice and get immediate answers and feedback.
A ll In One
C o m p u te r C o n c e p ts a n d
A p p lic a t io n s
,
Shelley Gaskin Nancy Graviett,
and Cathy La Berta
PEARSON
Boston Columbus Indianapolis New York San Francisco Upper Saddle River
Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto
Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo
Editor in Chief: Michael Payne Marketing Assistant: Darshika Vyas
Executive Editor: Jenifer Niles Associate Managing Editor: Camille Trcntaeostc
Product Development Manager: Laura Burgess Operations Director: Nick Sklitsis
Development Editor: Nancy Lamm Operations Specialist: Maura Zaldivar-Garcia
Editorial Assistant: Carly Prakapas Senior Art Director: Jonathan Boylan
Director of Digital Development: Zara Wanlass Cover Photo: © Ben Durrani
VP, Director of Digital Strategy & Assessment: Text and Cover Designer: Blair Brown
Paul Gentile Manager, Cover Visual Research & Permissions: Karen
Director, Media Development: Cathi Profit ko Sanatar
Senior Editorial Media Project Manager: Alana Coles Full-Service Project Management: lYcMcdiaGlobal
Production Media Project Manager: John Cassar Composition: PreMediaGlobal
Director of Marketing for Business & Technology: Printer/Binder: Quad Graphics
Patrice Lumumba Jones Cover Printer: Lehigh-Phoenix Color
Marketing Coordinator: Susan Osterlitz Text Font: MinionlYo
Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on
appropriate page within text.
Microsoft and/or its respective suppliers make no representations about the suitability of the information contained in the
documents and related graphics published as part of the services for any purpose. All such documents and related graphics
arc provided "as is” without warranty of any kind. Microsoft and/or its respective suppliers hereby disclaim till warranties
and conditions with regard to this information, including all warranties and conditions of merchantability, whether express,
implied or statutory, fitness for a particular purpose, title and non infringement. In no event shall Microsoft and/or its
respective suppliers be liable for any special, indirect or consequential damages or any damages whatsoever resulting
from loss of use. data or profits, whether in an action of contract, negligence or other tortious action, arising out of or
in connection with the use or performance of Information available from the services.
The documents and related graphics contained herein could include technical inaccuracies or typographical errors. Changes
are periodically added to the information herein. Microsoft and/or its respecUve suppliers may make improvements and/or
changes in the product(s) and/or the program(s) described herein at any time.
Microsoft and Windows are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. This book
is not sponsored or endorsed by or affiliated with the Microsoft Corporation.
Copyright © 2013 Pearson Education, Inc., publishing as Prentice Hall, One Lake Street, Upper Saddle River,
New Jersey, 07458. All rights reserved. Manufactured in the United States of America. This publication is protected bv
Copyright, and permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval
system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. To
obtain permission(s) to use material from this work, please submit a written request to Pearson Education. Inc., Permissions
Department, One I^ake Street. Upper Saddle Kiver. New Jersey. 07458.
Many of the designations by manufacturers and seller to distinguish their products arc claimed as trademarks. Where those
designations appear in this book, and the publisher was aware of a trademark claim, the designations have been printed in
initial caps or all caps.
Library of Congress Cataloging-in-Publication Data
Gaskin, Shelley.
GO! All in one : computer concepts and applications / Shelley Gaskin. Nancy Gravtett, and Cathv Laberta.
p. cm.
Includes Index.
ISBN 978-0-13-284412-3 (alk. paper)
1. Computers—Textbooks. 2. Application software—Textbooks. I. Graviett. Nancy. II. I>aBerta. Catherine. III. Title.
QA76.27.G37 2012
004—dc23
2011045721
10 9 8 7 6 5 4 3 2 1
PEARSON ISBN-10: 0-13-284412-5
ISBN-13: 978-0-13-284412-3
Brief Contents
GO! Walkthrough.................................................xxvi
Unit 1 Computer History, Windows 7,
Internet, and Social Media 1
Chapter 1 Concepts: Computer History,
Fundamentals, and Operating Systems ....2
Chapter 2 Applications: Use Windows 7 to
Manage Files and Programs and to
Browse the Internet...................................37
Chapter 3 Applications: Communicating and
Networking with Outlook, Skype,
Linkedln, and Squarespace......................89
Unitl Case Project.............................................. 124
Unit 2 Computers, Privacy, Office
Common Features, and W ord 127
Chapter 4 Concepts: Computer Hardware,
Privacy, and Security.............................. 128
Chapter 5 Applications: Windows Explorer
File Management, Office Features,
and Word Documents.............................. 168
Chapter 6 Applications: Resumes, Cover Letters,
Research Papers, Newsletters, and
Merged Address Labels with W ord......232
Unit 2 Case Project.............................................. 298
Unit 3 Computer Hardware and
Microsoft Excel 301
Chapter 7 Concepts: System Components, Input/
Output Devices, and Storage Devices....302
Chapter 8 Applications: Excel Worksheets, Charts,
Formulas, Functions, and Tables..........339
Brief Contents
Chapter 9 Applications: Excel Pie Charts, Line
Charts, and What-lf Analysis Tools.......419
Unit 3 Case Project..............................................456
Unit 4 Application and Productivity
Software, Including Microsoft
PowerPoint.........................................459
Chapter 10 Concepts: Using Application
Software as Productivity Tools............460
Chapter 11 Applications: PowerPoint Presentation
Creation; Enhancing Presentations
with Pictures, Transitions, Objects,
Backgrounds, and SmartArt..................485
Unit 4 Case Project..............................................546
Unit 5 The Internet, Web Apps, and
Microsoft Access 549
Chapter 12 Concepts: The Internet and World
Wide Web..................................................550
Chapter 13 Applications: Create, Query, and Sort
an Access Database; Create Forms and
Reports......................................................586
Chapter 14 Applications: Explore Cloud Computing
Using Windows Live and Microsoft
Office Web Apps...................................... 656
Unit 5 Case Project..............................................702
Unit 6 Networks, Communication, and
Cloud Computing Applications....705
Chapter 15 Concepts: Computer Networks and
Communication.........................................706
Chapter 16 Applications: Cloud Computing with
Google Docs and Microsoft OneNote...748
Unit 6 Case Project..............................................786
Glossary .......................................................G-1
Index .........................................................1-1
iv Brief Contents
Contents
GO! Walkthrough.................................................xxvi
Unit 1 Computer History, Windows 7,
Internet, and Social Media 1
Chapter 1 Concepts: Computer History,
Fundamentals, and Operating
Systems.............................................2
Objective 1 Understand Computers: Yesterday, Today,
and Tomorrow 3
Concept 1.01 Taking a Brief Look Back 3
Concept 1.02 Looking at the Present 4
Concept 1.03 Gaining an Insight into the Future 4
Objective 2 Identify Computer Fundamentals 5
Concept 1.04 Understanding the Computer: Basic Definitions 5
Concept 1.05 Getting Data into the Computer: Input 8
Concept 1.06 Transforming Data into Information: Processing 8
Concept 1.07 Displaying Information: Output 9
Concept 1.08 Holding Programs and Data for Future Use: Storage 9
Concept 1.09 Moving Data: Communications 10
Concept 1.10 Examining the Information Processing Cycle in Action 10
Objective 3 Recognize Operating Systems and Their Functions 11
Concept 1.11 Starting the Computer 12
Concept 1.12 Managing Applications 16
Concept 1.13 Managing Memory 16
Concept 1.14 Coordinating Tasks 18
Concept 1.15 Providing the User Interface 18
Concept 1.16 Exploring Popular Operating Systems 20
Objective 4 Utilize Standalone Operating Systems 21
Concept 1.17 Using Microsoft Windows 21
Concept 1.18 Using MAC OS 23
Concept 1.19 Using Unix 23
Concept 1.20 Using Linux 23
Concept 1.21 Comparing Windows, MAC OS, and Linux 24
Concept 1.22 Understanding Server Operating Systems 25
Concept 1.23 Understanding Embedded Operating Systems 25
Objective 5 Use System Utilities 27
Concept 1.24 Using Backup Software 28
Concept 1.25 Using Antivirus Software 29
Concept 1.26 Searching for and Managing Files 29
Concept 1.27 Scanning and Defragmenting Disks 29
Concept 1.28 Using File Compression Utilities 30
Concept 1.29 Using Accessibility Utilities 30
Concept 1.30 Performing a System Update 31
Concept 1.31 Troubleshooting a Computer 31
Contents v
Chapter Summary, Key Terms and Concepts, Matching, and Multiple Choice 33-35
Teamwork 35
On the Web 36
Ethics and Social Media 36
Sources 36
Chapter 2 Applications: Use Windows 7 to
Manage Files and Programs
and to Browse the Internet..........37
PROJECT 2A Using Windows 7...................................................................38
Objective 1 Create a New Folder and Save a File on a Removable
Storage Device 39
Activity 2.01 Turning On Your Computer, Logging On to a Windows 7 User
Account, and Exploring the Windows 7 Environment 39
Activity 2.02 Creating a New Folder on a Removable Storage Device 42
Activity 2.03 Using Snipping Tool to Create a File 44
Objective 2 Download and Save Files from the Web 48
Activity 2.04 Downloading Data Files and Saving Them on Your USB Drive 48
Objective 3 Display Libraries, Folders, and Files in a Window 49
Activity 2.05 Displaying Libraries, Folders, and Files in a Folder Window 50
Activity 2.06 Changing Views, Sorting, Grouping, and Filtering in a Folder Window 52
Objective 4 Start Programs and Open Data Files 53
Activity 2.07 Starting Programs and Opening Data Files 54
Objective 5 Manage the Display of Individual and Multiple Windows 55
Activity 2.08 Moving, Sizing, Hiding, Closing, and Switching Between
Windows 55
Activity 2.09 Using Aero Peek and Displaying Multiple Windows in the Cascade,
Stack, and Side by Side Arrangements 56
Activity 2.10 Switching Windows by Using Aero Flip 3D 58
Activity 2.11 Using Snap to Display Windows 59
PROJECT 2B Managing Files and Folders..................................................60
Objective 6 Copy Files from a Removable Storage Device to the
Hard Disk Drive 61
Activity 2.12 Copying Files from a Removable Storage Device to the
Documents Library on the Hard Disk Drive 61
Objective 7 Navigate by Using Windows Explorer 62
Activity 2.13 Pinning a Location to a Jump List 62
Activity 2.14 Navigating by Using the Address Bar 63
Objective 8 Create, Name, and Save Files 64
Activity 2.15 Pinning a Program to the Taskbar 64
Activity 2.16 Naming and Saving Files in Word 64
Objective 9 Create Folders and Rename Folders and Files 66
Activity 2.17 Creating Folders and Renaming Folders and Files 66
Objective 10 Select, Copy, and Move Files and Folders 67
Activity 2.18 Selecting Groups of Files or Folders in the File List 67
Activity 2.19 Copying Files 68
Activity 2.20 Moving Files 68
Activity 2.21 Copying Files to a Compressed Folder 69
PROJECT 2C Browsing the Web with Internet Explorer 8..........................71
Objective 11 Search the Internet 72
Activity 2.22 Searching the Internet 72
Objective 12 Use Tabbed Browsing 72
Activity 2.23 Using Tabbed Browsing 73
Activity 2.24 Using the Tab List, Quick Tabs, and Shortcuts to Navigate
Among Open Tabs 75
Objective 13 Organize Favorites 77
Activity 2.25 Organizing Favorites 78
Activity 2.26 Using the Favorites Bar 79
Objective 14 Print Web Pages 79
Activity 2.27 Printing Web Pages 79
Summary, Key Terms 82
Skills Review 83
Chapter 3 Applications: Communicating
and Networking with Outlook,
Skype, Linkedln, and
Squarespace .................................. 89
PROJECT 3A Client Communication...........................................................90
Objective 1 Create an Outlook Account 91
Activity 3.01 Creating a User Account in Windows 7 91
Activity 3.02 Creating an Outlook Account and Exploring the Outlook Window 92
Activity 3.03 Importing an Outlook Data File 94
Objective 2 Enter and Edit Contacts and Calendar Entries 95
Activity 3.04 Creating and Editing Contacts 96
Activity 3.05 Navigating the Calendar and Creating Entries 98
Objective 3 Send and Receive E-Mail 102
Activity 3.06 Configuring Outlook for Sending and Receiving Messages 102
Activity 3.07 Creating and Sending a New E-mail Message 103
Activity 3.08 Opening and Responding to an E-mail Message 105
Activity 3.09 Printing and Deleting Messages 108
Objective 4 Make Calls Over the Internet Using Skype 110
Activity 3.10 Participating in a Skype Call 111
PROJECT 3B Online Presence....................................................................113
Objective5 Create a Linkedln Account 114
Activity 3.11 Creating a Linkedln Account and Profile 114
Activity 3.12 Inviting Linkedln Connections and Sharing
an Update 116
Objective 6 Create and Maintain a Web Site and Blog with
Squarespace 117
Activity 3.13 Creating a Squarespace Account and Blog Post 117
Summary, Key Terms 120
Mastering Outlook 121
UNIT 1 Case Project: Tasks Performed by a Freelance Interior
Designer Using Windows 7 and Outlook.............................124
Contents vii
Unit 2 Computers, Privacy, Office
Common Features, and Word ..127
Chapter 4 Concepts: Computer Hardware,
Privacy, and Security 128
Objective 1 Categorize Computers 129
Concept 4.01 Identifying Computers for Individuals 129
Concept 4.02 Identifying Enterprise Systems 130
Objective 2 Understand and Relate Computers, Society, and You 133
Concept 4.03 Recognizing the Digital Divide 133
Concept 4.04 Using Social Networks 133
Concept 4.05 Working Collaboratively 135
Concept 4.06 Recognizing Advantages and Disadvantages of Computer Use 135
Concept 4.07 Using Computer Hardware 136
Concept 4.08 Recognizing the Risks of Using Flawed Software 137
Concept 4.09 Identifying the Impact of Computer Use 137
Concept 4.10 Recognizing the Effects of Computers on Employment 138
Concept 4.11 Identifying Responsible and Ethical Computer Behavior 139
Objective 3 Protect Privacy in Cyberspace 140
Concept 4.12 Collecting Information without Consent 141
Concept 4.13 Exploring the Technology versus Anonymity Debate 141
Concept 4.14 Protecting Your Privacy 144
Objective 4 Recognize Computer Crime in Cyberspace 149
Concept 4.15 Categorizing Computer Crime 150
Concept 4.16 Identifying the Attackers 155
Objective5 Make Security a Priority 157
Concept 4.17 Recognizing Security Risks 157
Concept 4.18 Protecting Your Computer System 159
Concept 4.19 Safeguarding Yourself and Your Data 160
Objective 6 Encrypt Data 160
Concept 4.20 Understanding Encryption Basics 160
Concept 4.21 Using Public Key Encryption 161
Objective 7 Identify Technologies That Prosecute Computer Crime 162
Concept 4.22 Defining E-Discovery 162
Concept 4.23 Investigating Computer Forensics 162
Chapter Summary, Key Terms and Concepts, Matching, and Multiple Choice 163-165
Teamwork 166
On the Web 166
Ethics and Social Media 167
Sources 167
Chapter 5 Applications: Windows Explorer
File Management, Office Features,
and Word Documents..................168
PROJECT 5A PowerPoint File...................................................................169
Objective 1 Locate and Start a Microsoft Office 2010 Program 170
Activity 5.01 Locating and Starting a Microsoft Office 2010 Program 170
viii Contents
