Go! All in One: Computer Concepts and Applications PDF
Preview Go! All in One: Computer Concepts and Applications
A 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
The list of books you might like
