Overview

Computer skills are more crucial than ever, and the skills most people need have radically changed. Unfortunately, most typical introductory computer skills books haven't changed. Now, best-selling author and expert teacher Jean Andrews has completely reinvented the basic computer tutorial for today's students and workplaces. Andrews focuses on how computers are really used now in personal life, in academics, and in technical careers. She clears away distractions found in most introductory books, provides plenty of useful help, and teaches the #1 competency students need most: the ability to keep learning new skills on their own. She also prepares students for a key career milestone: passing CompTIA's entry-level Strata certification exam. Coverage includes: Using and managing Windows 7 computers Using the Internet to access and share information, and to do business Using the Web for academic research Capturing and organizing information with OneNote 2010 Using Word 2010 to communicate information and apply for a job Using PowerPoint 2010 to persuade an audience, present a compelling story, or deliver important information Using Excel 2010 to organize data, solve problems, make decisions, and transform data into knowledge Making informed computer buying decisions Keeping computers reliable, fast, and safe

Full Product Details

Author:   Jean Andrews
Publisher:   Pearson Education (US)
Imprint:   Pearson IT Certification
ISBN:  

9780789748225

ISBN 10:   0789748223
Pages:   700
Publication Date:   21 December 2011
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Mixed media product
Publisher's Status:   Out of Print
Availability:   Awaiting stock  

Table of Contents

Introduction xxi Part I: Getting Started CHAPTER 1: Using Windows 7 to Manage Applications and Data 2 Getting Started with Hardware and Software 4 Hardware to Get You Started 5 Software to Get You Started 11 Start a Windows 7 Session 15 On Your Own 1-1: Turn on Your Computer 15 Managing Programs and Their Windows 17 Manage an Application Window 18 On Your Own 1-2: Start a Program 19 On Your Own 1-3: Manage a Window 20 On Your Own 1-4: Resize and Close a Window 21 Manage Multiple Windows 22 On Your Own 1-5: Manage Multiple Windows 22 Managing Folders and Files on Storage Devices 22 On Your Own 1-6: Explore Files, Folders, and Libraries on the Hard Drive 27 On Your Own 1-7: Explore Files and Folders on the DVD 29 Tips for Working with Folders and Files 30 Manage Folders 31 On Your Own 1-8: Manage Folders on a USB Flash Drive 32 Manage Files 32 On Your Own 1-9: Open, Copy, Move, and Delete a File 32 Safely Remove Hardware and Eject Media 33 The Windows Snipping Tool 33 On Your Own 1-10: Use the Windows Snipping Tool 34 Installing Applications from CD or DVD 34 On Your Own 1-11: Install Software from DVD 36 Ending a Windows Session 36 On Your Own 1-12: End a Windows Session 37 Summary 38 Review Questions 39 Chapter Mastery Project 40 Mastery Project Part 1: Getting Started with Hardware and Software 40 Mastery Project Part 2: Managing Programs and Their Windows 41 Mastery Project Part 3: Managing Folders and Files on Storage Devices 41 Mastery Project Part 4: Installing Applications from CD or DVD 42 Mastery Project Part 5: Ending a Windows Session 43 Becoming an Independent Learner 43 Projects to Help You 43 Project 1: Windows in Your Personal Life 43 Project 2: Windows in Your Academic Career 44 Project 3: Windows in Your Technical Career 45 Project to Help Others 46 CHAPTER 2: Finding and Using Information on the Web 48 Getting News on the Web 50 Introduction to Internet Explorer 50 On Your Own 2-1: Use Internet Explorer 51 News and More News 53 On Your Own 2-2: Manage Multiple Web Pages 53 Save a Favorite Site 54 On Your Own 2-3: Save a Web Page to Your Favorites 54 Searching for Other Information on the Web 54 On Your Own 2-4: Use a Search Engine 55 Popular Websites 55 More Advanced Google Searches 57 On Your Own 2-5: Perform Google Advanced Searches 59 On Your Own 2-6: Find Images, Videos, Directions, and Translations 59 Customize Your Browser 59 On Your Own 2-7: Change Your Home Page 59 Using Applications and Storing Data in the Cloud 60 Websites That Provide Free Cloud Computing 60 Use a SkyDrive 61 On Your Own 2-8: Set Up and Use a SkyDrive 61 Doing Business Safely on the Web 61 Stay Safe on the Web 61 On Your Own 2-9: Print and Save a Web Page 65 Buy Software Online 66 On Your Own 2-10: Download, Install, and Run Microsoft Security Essentials 67 Summary 68 Review Questions 69 Chapter Mastery Project 70 Mastery Project Part 1: Getting the News on the Web 70 Mastery Project Part 2: Searching for Other Information on the Web 70 Mastery Project Part 3: Using Applications and Storing Data in the Cloud 71 Mastery Project Part 4: Doing Business Safely on the Web 72 Becoming an Independent Learner 73 Projects to Help You 74 Project 1: Using the Web in Your Personal Life 74 Project 2: Using the Web in Your Academic Career 75 Project 3: Using the Web in Your Technical Career 76 Project to Help Others 77 CHAPTER 3: Creating Documents with Microsoft Word 78 Entering Text and Saving the Document 80 On Your Own 3-1: Use the Word Window 80 Enter Text 81 On Your Own 3-2: Enter and Edit Text 82 Save the Document File 83 On Your Own 3-3: Save, Close, and Open a Document 83 Formatting Text 85 Format Text with the Font Tools 87 On Your Own 3-4: Format Text Using the Font Tools 87 Format with the Paragraph Tools and Format Painter 88 On Your Own 3-5: Format Text and Create a Bulleted List 89 Adding Graphics to a Document 90 On Your Own 3-6: Insert Clip Art into a Document 91 Finishing Up and Printing Your Document 92 Set Document Properties 92 On Your Own 3-7: Change Document Properties 93 Print the Document 93 On Your Own 3-8: Print a Document 93 Using Page Color, Text Boxes, Shapes, and WordArt 95 Create Text Boxes 95 On Your Own 3-9: Add Page Color and Text Boxes 96 On Your Own 3-10: Add Clip Art to a Document 97 Add a Shape to a Document 97 On Your Own 3-11: Add a Shape to a Document 98 Use WordArt 98 On Your Own 3-12: Add WordArt to a Document 99 Save a Document as a PDF File 99 On Your Own 3-13: Save a Document as a PDF File 99 Templates as Shortcuts to Great Documents 100 On Your Own 3-14: Use a Party Invitation Template 101 Summary 103 Review Questions 104 Chapter Mastery Project 104 Mastery Project Part 1: Entering Text and Saving the Document 105 Mastery Project Part 2: Formatting Text 106 Mastery Project Part 3: Adding Graphics to a Document 106 Mastery Project Part 4: Using Page Color, Text Boxes, Shapes, and WordArt 106 Mastery Project Part 5: Finishing Up and Printing Your Document 107 Mastery Project Part 6: Templates as Shortcuts to Great Documents 107 Becoming an Independent Learner 108 Projects to Help You 108 Project 1: Using Word in Your Personal Life 108 Project 2: Word in Your Academic Career 109 Project 3: Word in Your Technical Career 109 Project to Help Others 109 Part II: Fundamental Computer Competency CHAPTER 4: Using the Web for Research 110 Preparing to Take Research Notes and Selecting Your Research Topic 112 Use OneNote for Taking Research Notes 112 On Your Own 4-1: Create and Set Up a New Notebook in OneNote 113 Find a Research Topic for an Assigned Research Paper 116 Phase 1: Finding General Information and Subtopics About the Topic 118 On Your Own 4-2: Use Google.com and Wikipedia.org for Preliminary Research 119 On Your Own 4-3: Find Subtopics Using a Clustering Search Engine 120 On Your Own 4-4: Use a Google Timeline 121 Phase 2: Finding Authoritative and Scholarly Research 122 Decide Whether Content Is Credible 124 Wikipedia.org Can Lead You to the Experts 126 On Your Own 4-5: Use Wikipedia.org to Locate Authoritative Content 126 Find Online Newspapers, Blogs, and Other Primary Sources 127 On Your Own 4-6: Find Newspaper Articles and Blogs 128 Find Books Online 129 On Your Own 4-7: Find Books Using Wikipedia.org, Google Books, and Worldcat.org 129 Find Scholarly Journal Articles 130 On Your Own 4-8: Use Google Scholar to Find a Journal Article 131 Use Your School Library's Website 132 On Your Own 4-9: Explore Your School Library's Website 132 Phases 3 and 4: Evaluating Your Research and Organizing Your Research Notes 134 Evaluate Your Research by Asking Important Questions 134 Use OneNote to Organize Your Notes 134 On Your Own 4-10: Organize, Print, and Export Your Research in OneNote 135 Summary 136 Review Questions 137 Chapter Mastery Project 137 Mastery Project Part 1: Preparing to Take Research Notes and Selecting Your Research Topic 138 Mastery Project Part 2: Phase 1: Finding General Information and Subtopics About the Topic 138 Mastery Project Part 3: Phase 2: Finding Authoritative and Scholarly Research 139 Mastery Project Part 4: Phases 3 and 4: Evaluating Your Research and Organizing Your Research Notes 140 Becoming an Independent Learner 140 Projects to Help You 141 Project 1: Research in Your Personal Life 141 Project 2: Research in Your Academic Career 142 Project 3: Research in Your Technical Career 142 Project to Help Others 143 CHAPTER 5: Writing Papers Using Microsoft Word Templates and Tools 144 Preparing to Write Your Paper 146 The Formatting Guidelines for Research Papers 148 Give Credit Where Credit Is Due 148 Use Research Notes Taken in OneNote 151 On Your Own 5-1: Open the OneNote Notebook to View Research Notes 153 Set Up the Paper Format 154 On Your Own 5-2: Create a Document Using an MLA Template 154 Typing and Formatting the Paper 156 On Your Own 5-3: Enter Header, Student and Course Information, and Paper Title 156 On Your Own 5-4: Enter the First Paragraph and Create a Citation 157 On Your Own 5-5: Enter the Second Paragraph and a Citation 158 On Your Own 5-6: Enter More Text, a Long Quotation, and a Book Citation 159 On Your Own 5-7: Enter More Text, a Blog Citation, and a Footnote 160 On Your Own 5-8: Enter the Conclusion Paragraph and Two More Citations 162 Creating the Works Cited Page 164 On Your Own 5-9: Create a Works Cited Page 166 Proofing and Revising the Paper 167 Correct Grammar Errors 167 Correct Spelling Errors 168 Check the Word Count 169 Use Synonyms 169 Find Text 170 Find Unwanted Hard Returns 171 Change the Font and Font Size 171 Summary 172 Review Questions 173 Chapter Mastery Project 173 Mastery Project Part 1: Preparing to Write Your Paper 175 Mastery Project Part 2: Typing and Formatting the Paper 175 Mastery Project Part 3: Creating the Works Cited Page 177 Mastery Project Part 4: Proofing and Revising the Paper 177 Becoming an Independent Learner 178 Projects to Help You 178 Project 1: Writing Papers in Your Personal Life 178 Project 2: Writing Papers in Your Academic Career 179 Project 3: Writing Papers in Your Technical Career 179 Project to Help Others 179 CHAPTER 6: Communicating with Others Using the Internet 180 Communicating Through Email 182 Email Using a Website 183 On Your Own 6-1: Manage Email Using a Website 184 Use Outlook as an Email Client 186 On Your Own 6-2: Set Up Outlook to Manage an Email Account 187 On Your Own 6-3: Use Outlook to Manage Email 187 Best Practices for Email Safety and Etiquette 188 Social Networking with Facebook, Twitter, and LinkedIn 191 Build a Social Network Using Facebook 191 On Your Own 6-4: Sign Up for Facebook and Build Your Profile 195 On Your Own 6-5: Find Friends on Facebook 197 On Your Own 6-6: Build Online Relationships with Facebook Friends 198 On Your Own 6-7: Find and Like Facebook Pages 200 Use Twitter to Know What's Happening Now 201 On Your Own 6-8: Set Up and Use a Twitter Account 202 Stay LinkedIn with Other Professionals 202 Best Practices for Social Networking 204 Present Yourself with Blogging 204 On Your Own 6-9: Create a Blog and Post to It 205 Communicating in Real Time with Text, Voice, and Video 206 Instant Messaging 206 Internet Voice using VoIP 207 Streaming Video 208 Summary 209 Review Questions 210 Chapter Mastery Project 210 Mastery Project Part 1: Communicating Through Email 211 Mastery Project Part 2: Social Networking with Facebook, Twitter, and LinkedIn 212 Mastery Project Part 3: Present Yourself with Blogging 212 Mastery Project Part 4: Communicating in Real Time with Voice, Text, and Video 213 Becoming an Independent Learner 213 Projects to Help You 213 Project 1: Communicating on the Web in Your Personal Life 213 Project 2: Communicating on the Web in Your Academic Career 214 Project 3: Communicating on the Web in Your Technical Career 214 Project to Help Others 215 Part III: Enhancing Your Productivity CHAPTER 7: Finding a Job Using the Web, a Resume, and a Business Letter 216 Job-Hunting Strategies 218 Finding Jobs That Suit Your Skills 219 Create a Document with Tables to Track Contacts 220 On Your Own 7-1: Create a Contacts Document Including Tables 221 Creating and Sending a Resume 222 Use a Resume Template 222 On Your Own 7-2: Create a Resume Using a Resume Template 224 Post the Resume Online 224 Email the Resume 226 On Your Own 7-3: Email a Resume PDF 227 Creating and Sending an Interview Follow-up Letter 227 Use Letterhead and Letter Templates 228 On Your Own 7-4: Create a Personal Letterhead for Business Letters 229 On Your Own 7-5: Create an Interview Follow-up Letter 230 Print an Envelope 231 On Your Own 7-6: Add an Envelope to a Letter 232 Email Your Follow-up Letter 232 On Your Own 7-7: Email the Follow-up Letter 233 Summary 234 Review Questions 234 Chapter Mastery Project 235 Mastery Project Part 1: Job Hunt Strategies 235 Mastery Project Part 2: Creating and Sending a Resume 236 Mastery Project Part 3: Creating and Sending an Interview Follow-up Letter 237 Becoming an Independent Learner 237 Projects to Help You 238 Project 1: Creating a Resume Cover Letter and Personal Business Cards 238 Project 2: Using Academic Resources to Find the Right Job for You 238 Project 3: Finding a Job in Your Technical Career 239 Project to Help Others 239 CHAPTER 8: Using PowerPoint to Give a Presentation 240 Using PowerPoint to Tell a Story 242 First Look at PowerPoint 243 On Your Own 8-1: Explore the PowerPoint Window 245 Tips for Creating Great Presentations 246 Creating a PowerPoint Presentation 247 Select a Theme 248 On Your Own 8-2: Choose a Theme 249 Create the Title Slide 250 On Your Own 8-3: Create a Title Slide 250 Add a Slide with a Bulleted List and Graphics 251 On Your Own 8-4: Add a Slide with a Bulleted List and Graphics 252 Add a Slide with SmartArt 253 On Your Own 8-5: A dd a Slide with SmartArt 254 Add the Final Slide 256 On Your Own 8-6: Add the Final Slide with Artistic Effects 258 Revising and Giving the Presentation 259 On Your Own 8-7: Review and Revise the Presentation 261 On Your Own 8-8: Print the Presentation and Save as a PowerPoint Show 262 Summary 264 Review Questions 264 Chapter Mastery Project 265 Mastery Project Part 1: Using PowerPoint to Tell Your Story 265 Mastery Project Part 2: Creating a PowerPoint Presentation 266 Mastery Project Part 3: Revising and Giving the Presentation 267 Becoming an Independent Learner 268 Projects to Help You 268 Project 1: Creating a Presentation About You 268 Project 2: Making a Presentation Using Award-Winning Designs 269 Project 3: Broadcasting a Presentation 269 Project to Help Others 270 CHAPTER 9: Adding Action and Sound to a PowerPoint Presentation 272 Adding Video, Audio, and Animation to a Presentation 274 Use a Slide Master 275 On Your Own 9-1: Edit the Slide Master 277 Add Video to a Slide 278 On Your Own 9-2: Add Video to the Title Slide 279 Add Audio and Animation 280 On Your Own 9-3: Create the Second Slide with Audio and Animation 280 Add WordArt to a Slide 282 On Your Own 9-4: Create the Third Slide with WordArt 282 Add Animated Graphics to a Slide 284 On Your Own 9-5: Add Animated Graphics and a Screen Clipping to a Slide 284 Adding Web Content to a Presentation 285 Browse the Web During a Presentation 285 On Your Own 9-6: Embed a Link in a Slide 286 Add a Video on the Web to a Slide 286 Adding Transitions to a Presentation 289 On Your Own 9-7: Add Transitions to the Presentation 289 Summary 290 Review Questions 290 Chapter Mastery Project 291 Mastery Project Part 1: Adding Video, Audio, and Animation to a Presentation 291 Mastery Project Part 2: Adding Web Content to a Presentation 295 Mastery Project Part 3: Adding Transitions to a Presentation 296 Becoming an Independent Learner 296 Projects to Help You 296 Project 1: Using PowerPoint in Your Personal Life 296 Project 2: Using PowerPoint in Your Academic Career 297 Project 3: Using PowerPoint in Your Technical Career 298 Project to Help Others 298 CHAPTER 10: Managing Numbers and Text Using Excel 300 What Is Excel and How Is It Used? 302 On Your Own 10-1: Examine the Excel Window and Tools 303 Building a Worksheet with Titles, Headings, and Data 304 Enter and Format Titles and Column Headings 305 On Your Own 10-2: Enter Worksheet Titles and Headings 306 On Your Own 10-3: Format Using Styles and Themes 307 Enter Data for Team Members 308 On Your Own 10-4: Format Rows for Team Data and Add One Team Member 308 On Your Own 10-5: Copy Team Data from a Word Table and Edit the Data 311 On Your Own 10-6: Sort Data and Add Row Numbers 312 Adding Calculations to a Worksheet 312 On Your Own 10-7: Enter Labels and Values for the Calculations 313 Use Formulas and Functions 314 On Your Own 10-8: Enter Two Sums in the Worksheet 315 Copy a Formula Using Relative and Absolute References 316 On Your Own 10-9: Calculate Fees Due 318 Calculate a Percentage 319 On Your Own 10-10: Calculate the Percentage Paid 319 Printing a Worksheet 320 On Your Own 10-11: Print the Worksheet 320 Summary 321 Review Questions 322 Chapter Mastery Project 322 Mastery Project Part 1: What Is Excel and How Is It Used? 322 Mastery Project Part 2: Building a Worksheet with Titles, Headings, and Data 323 Mastery Project Part 3: Adding Calculations to a Worksheet 326 Mastery Project Part 4: Printing a Worksheet 327 Becoming an Independent Learner 327 Projects to Help You 327 Project 1: Excel in Your Personal Life 327 Project 2: Using Excel in Your Academic Career 328 Project 3: Using Excel in Your Technical Career 328 Project to Help Others 329 CHAPTER 11: Organizing Data Using Excel 330 Using a Table to Manage Data 332 Enter Titles, Headings, and Data in the Sales Worksheet 332 On Your Own 11-1: Enter Titles, Headings, and Data on the Sales Worksheet 333 Convert the Data to an Excel Table and Add a Total Row 335 On Your Own 11-2: Convert the Data to an Excel Table 335 On Your Own 11-3: Add a Total Row to the Table 339 On Your Own 11-4: Explore the SUBTOTAL Function in a Table 342 Use Cell Names and the IF Function 342 On Your Own 11-5: Name Cells and a Table 343 On Your Own 11-6: Use the IF Function to Calculate the Commission Column and the Due to Seller Column 344 Using Multiple Worksheets 347 On Your Own 11-7: Build the Sellers Worksheet 347 Use the SUMIF Function to Create a Monthly Summary 348 On Your Own 11-8: Calculate Sales Totals for One Month 349 Create a Seller Statement 351 On Your Own 11-9: Enter Titles and Seller Name and Address on the Seller Statement 352 On Your Own 11-10: Copy Table Values to the Seller Statement 353 Adding a Chart to a Worksheet 354 On Your Own 11-11: Insert a Chart in the Month Summary Worksheet 356 Introducing Excel Macros and Microsoft Access 356 Use Excel Macros to Do Repetitive Tasks 356 Use Microsoft Access to Manage Large Quantities of Data 357 Summary 361 Review Questions 362 Chapter Mastery Project 363 Mastery Project Part 1: Using a Table to Manage Data 364 Mastery Project Part 2: Using Multiple Worksheets 366 Mastery Project Part 3: Adding a Chart to a Worksheet 368 Mastery Project Part 4: Introducing Excel Macros and Microsoft Access 370 Becoming an Independent Learner 370 Projects to Help You 371 Project 1: Using Excel in Your Personal Life 371 Project 2: Using Excel in Your Academic Career 371 Project 3: Using Excel in Your Technical Career 372 Project to Help Others 373 Part IV: Buying and Caring for Your Own Computer CHAPTER 12: Connecting to the Internet and Securing a Computer 374 Connecting a Computer to the Internet 376 Wired and Wireless Used on a LAN 376 Wired and Wireless Used on a WAN 377 Manage Network Connections 379 On Your Own 12-1: Examine Network Connections and Settings 381 Make a New Wireless Connection 382 On Your Own 12-2: Connect to a Wireless Hotspot 383 Make a Wired Connection 384 On Your Own 12-3: Verify Your Wired Network Connection 385 Make a Mobile Broadband Connection 385 Securing a Computer and Its Data 387 Keep Windows Updated 388 On Your Own 12-4: Install Windows Updates 389 On Your Own 12-5: Verify or Change Windows Update Settings 390 Back Up Important Data 391 On Your Own 12-6: Use Windows Backup and Restore 391 Set Up a Standard User Account and Manage Passwords 393 On Your Own 12-7: Create a Standard Account 394 On Your Own 12-8: Manage Windows Passwords 395 Securing a Small Home Network 395 Secure a Wireless Network 395 On Your Own 12-9: Secure a Wireless Network 397 Use a Homegroup to Share Your Data and Printer 398 On Your Own 12-10: Use a Homegroup to Share Data 399 Summary 402 Review Questions 403 Chapter Mastery Project 403 Mastery Project Part 1: Connecting a Computer to the Internet 404 Mastery Project Part 2: Securing a Computer and Its Data 405 Mastery Project Part 3: Securing a Small Home Network 406 Becoming an Independent Learner 406 Projects to Help You 407 Project 1: Selecting a Router for a Home Network 407 Project 2: Sharing Files in a Homegroup 407 Project 3: Investigating Broadband Internet Services 408 Project to Help Others 408 CHAPTER 13: Maintaining a Computer and Fixing Computer Problems 410 Keeping a Computer Running Well 412 Clean Up the Hard Drive 412 On Your Own 13-1: Clean Up the Hard Drive 414 Uninstall Software You No Longer Need 416 On Your Own 13-2: Uninstall Software You No Longer Need 416 Disable a Program from Launching at Startup 417 On Your Own 13-3: Limit Startup Programs Using System Configuration 419 Taking Care of Hardware 419 On Your Own 13-4: Manage Power Settings 422 Solving the Most Common Computer Problems 423 A File Is Missing or Was Accidentally Deleted 423 The Monitor Screen Is Difficult to Read 424 On Your Own 13-5: Practice Changing Monitor Settings 426 Internet Explorer Cannot Find a Requested Web Page 426 An Application Is Frozen and Will Not Respond 428 On Your Own 13-6: Use Task Manager to Close an Application 429 A Device or Program Will Not Install 429 A Document Will Not Print 430 On Your Own 13-7: Use the Printer Queue 435 Windows Gives Strange Errors 435 On Your Own 13-8: Check Your Hard Drive and Memory for Errors 438 I Think My Computer Has a Virus 439 My Computer Is Too Slow 440 On Your Own 13-9: Decide Whether Your Computer Needs a Memory Upgrade 443 My Computer Won't Start 443 On Your Own 13-10: Use Safe Mode 447 Prepare to Talk with a Computer Repair Technician 447 Summary 449 Review Questions 450 Chapter Mastery Project 450 Mastery Project Part 1: Keeping a Computer Running Well 451 Mastery Project Part 2: Taking Care of Hardware 451 Mastery Project Part 3: Solving the Most Common Computer Problems 452 Becoming an Independent Learner 454 Projects to Help You 455 Project 1: Maintaining a Personal Computer 455 Project 2: Setting Up Windows Maintenance and the Windows Desktop 455 Project 3: Solving Computer Problems for Others 456 Project to Help Others 457 CHAPTER 14: Buying Your Own Personal Computer 458 Do I Need an Upgrade or a New Computer? 460 Is Your Computer Missing a Device? 461 Is My Computer Slow? 463 On Your Own 14-1: Determine What Upgrade Would Improve Your Computer's Performance 467 How Much Is My Computer Worth? 467 On Your Own 14-2: Determine the Value of Your Computer 468 What Type Computer Do I Need? 469 Computers That Offer Mobility 469 Computers That Offer the Best Performance 472 On Your Own 14-3: Investigate the Latest Intel Processor for Laptops 473 Balancing Performance, Mobility, and Price 478 On Your Own 14-4: Compare Prices for a Desktop and a Comparable Laptop 478 IBM-Compatible Computers or Apple Computers 478 Extra Features a Computer Might Have 479 Web Cam, Card Reader, Sound Ports, and Other Standard Features 479 The Edition of Windows 7 480 On Your Own 14-5: Compare Prices for Windows 7 Editions 481 Video Ports 481 Wireless Capabilities 482 Optical Drive 483 On Your Own 14-6: Compare Prices for a Computer with a Blu-ray Burner 484 TV Tuner 484 Shopping for a Computer and Peripherals 485 On Your Own 14-7: Investigate Computer Manufacturers 486 On Your Own 14-8: Find Laptops with Extra Features 487 Consider an Extended Warranty 487 Shop for a Monitor 488 Shop for a Printer 489 Setting Up a New Computer and Recycling Your Old Computer 490 Summary 492 Review Questions 493 Chapter Mastery Project 494 Mastery Project Part 1: Do You Need an Upgrade or a New Computer? 494 Mastery Project Part 2: What Type Computer Do You Need? 495 Mastery Project Part 3: Extra Features a Computer Might Have 495 Mastery Project Part 4: Shopping for a Computer and Peripherals 496 Mastery Project Part 5: Setting Up a New Computer and Recycling Your Old Computer 496 Becoming an Independent Learner 497 Projects to Help You 497 Project 1: Customizing a Gaming Computer 497 Project 2: Using Comparison Tables to Select a Computer 498 Project 3: Advancing Your Technical Knowledge by Selecting a Motherboard 499 Project to Help Others 500 Solutions Appendix Chapter 1 Solutions: Using Windows 7 to Manage Applications and Data 502 On Your Own Solution 1-1 502 On Your Own Solution 1-2 502 On Your Own Solution 1-3 503 On Your Own Solution 1-4 504 On Your Own Solution 1-5 504 On Your Own Solution 1-6 506 On Your Own Solution 1-7 507 On Your Own Solution 1-8 509 How to Create a Folder on a USB Flash Drive 509 How to Delete a Folder 510 How to Use a Shortcut Menu in Windows Explorer 510 How to Copy a Folder from One Storage Device to Another 511 On Your Own Solution 1-9 513 On Your Own Solution 1-10 514 On Your Own Solution 1-11 515 On Your Own Solution 1-12 517 How to Log Off a Computer 517 How to Put Your Computer in Sleep Mode 518 How to Shut Down a Computer 518 How to Put a Laptop or Netbook in Hibernation 518 Chapter 2 Solutions: Finding and Using Information on the Web 519 On Your Own Solution 2-1 519 How to Navigate to New Web Pages 519 How to Use the Address Box and Back and Forward Buttons 520 On Your Own Solution 2-2 520 On Your Own Solution 2-3 522 On Your Own Solution 2-4 523 On Your Own Solution 2-5 524 On Your Own Solution 2-6 525 On Your Own Solution 2-7 528 On Your Own Solution 2-8 529 How to Set Up a SkyDrive 529 How to Upload a File to a SkyDrive and Share a SkyDrive Folder 531 On Your Own Solution 2-9 533 How to Print a Web Page 533 How to Save a Web Page to a Data File 534 On Your Own Solution 2-10 535 Chapter 3 Solutions: Creating Documents with Microsoft Word 541 On Your Own Solution 3-1 541 On Your Own Solution 3-2 541 On Your Own Solution 3-3 542 How to Save a Document to Your Hard Drive 542 How to Save a Document to a USB Flash Drive 543 How to Save a Document to Your SkyDrive 544 How to Save, Close, and Reopen Your Document 545 On Your Own Solution 3-4 546 On Your Own Solution 3-5 547 On Your Own Solution 3-6 548 On Your Own Solution 3-7 548 On Your Own Solution 3-8 549 On Your Own Solution 3-9 549 On Your Own Solution 3-10 551 On Your Own Solution 3-11 552 On Your Own Solution 3-12 553 On Your Own Solution 3-13 553 On Your Own Solution 3-14 555 Chapter 4 Solutions: Using the Web for Research 557 On Your Own Solution 4-1 557 How to Create a New Notebook 557 How to Set Up OneNote for Research 560 On Your Own Solution 4-2 562 How to Use Google.com for Preliminary Research 562 How to Use Wikipedia.org for Preliminary Research 562 On Your Own Solution 4-3 564 On Your Own Solution 4-4 565 On Your Own Solution 4-5 566 On Your Own Solution 4-6 568 On Your Own Solution 4-7 570 On Your Own Solution 4-8 573 On Your Own Solution 4-9 576 On Your Own Solution 4-10 577 Chapter 5 Solutions: Writing Papers Using Microsoft Word Templates and Tools 581 On Your Own Solution 5-1 581 On Your Own Solution 5-2 581 On Your Own Solution 5-3 584 On Your Own Solution 5-4 585 On Your Own Solution 5-5 587 On Your Own Solution 5-6 588 On Your Own Solution 5-7 590 On Your Own Solution 5-8 592 On Your Own Solution 5-9 593 Chapter 6 Solutions: Communicating with Others Using the Internet 595 On Your Own Solution 6-1 595 On Your Own Solution 6-2 600 How to Set Up an Email Account in Outlook That Is Not a Hotmail.com or Live.com Account 600 How to Set Up a Hotmail.com or Live.com Email Account in Outlook 601 On Your Own Solution 6-3 601 On Your Own Solution 6-4 605 On Your Own Solution 6-5 605 On Your Own Solution 6-6 605 On Your Own Solution 6-7 605 On Your Own Solution 6-8 605 On Your Own Solution 6-9 608 Chapter 7 Solutions: Finding a Job Using the Web, a Resume, and a Business Letter 613 On Your Own Solution 7-1 613 On Your Own Solution 7-2 615 On Your Own Solution 7-3 618 On Your Own Solution 7-4 619 On Your Own Solution 7-5 620 On Your Own Solution 7-6 622 On Your Own Solution 7-7 623 Chapter 8 Solutions: Using PowerPoint to Give a Presentation 625 On Your Own Solution 8-1 625 On Your Own Solution 8-2 625 On Your Own Solution 8-3 626 On Your Own Solution 8-4 628 On Your Own Solution 8-5 632 On Your Own Solution 8-6 635 On Your Own Solution 8-7 638 On Your Own Solution 8-8 638 Chapter 9 Solutions: Adding Action and Sound to a PowerPoint Presentation 641 On Your Own Solution 9-1 641 On Your Own Solution 9-2 643 On Your Own Solution 9-3 644 On Your Own Solution 9-4 649 On Your Own Solution 9-5 651 On Your Own Solution 9-6 652 On Your Own Solution 9-7 652 Chapter 10 Solutions: Managing Numbers and Text Using Excel 653 On Your Own Solution 10-1 653 On Your Own Solution 10-2 654 On Your Own Solution 10-3 655 On Your Own Solution 10-4 656 On Your Own Solution 10-5 657 On Your Own Solution 10-6 658 On Your Own Solution 10-7 659 On Your Own Solution 10-8 660 On Your Own Solution 10-9 660 On Your Own Solution 10-10 661 On Your Own Solution 10-11 661 Chapter 11 Solutions: Organizing Data Using Excel 663 On Your Own Solution 11-1 663 On Your Own Solution 11-2 666 On Your Own Solution 11-3 666 On Your Own Solution 11-4 666 On Your Own Solution 11-5 667 On Your Own Solution 11-6 667 On Your Own Solution 11-7 668 On Your Own Solution 11-8 669 On Your Own Solution 11-9 671 On Your Own Solution 11-10 672 On Your Own Solution 11-11 673 Chapter 12 Solutions: Connecting to the Internet and Securing a Computer 675 On Your Own Solution 12-1 675 On Your Own Solution 12-2 675 On Your Own Solution 12-3 675 On Your Own Solution 12-4 676 On Your Own Solution 12-5 678 On Your Own Solution 12-6 679 On Your Own Solution 12-7 683 On Your Own Solution 12-8 685 On Your Own Solution 12-9 685 On Your Own Solution 12-10 687 Chapter 13 Solutions: Maintaining a Computer and Fixing Computer Problems 691 On Your Own Solution 13-1 691 On Your Own Solution 13-2 691 On Your Own Solution 13-3 691 On Your Own Solution 13-4 692 On Your Own Solution 13-5 692 On Your Own Solution 13-6 693 On Your Own Solution 13-7 693 On Your Own Solution 13-8 693 On Your Own Solution 13-9 693 On Your Own Solution 13-10 694 Chapter 14 Solutions: Buying Your Own Personal Computer 695 On Your Own Solution 14-1 695 On Your Own Solution 14-2 695 On Your Own Solution 14-3 698 On Your Own Solution 14-4 699 On Your Own Solution 14-5 701 On Your Own Solution 14-6 701 On Your Own Solution 14-7 703 On Your Own Solution 14-8 704 Contents of the DVD CHAPTER A: Creating and Using Databases with Microsoft Access Using Access to Explore a Simple Database On Your Own A-1: Explore the AnimalShelter Database and the Access Window On Your Own A-2: Use the Design View of the Animals Table On Your Own A-3: Create and Run a Query Designing and Creating a New Database Design the Database Use Access to Implement the Database Design On Your Own A-4: Create a Database Create the Relationship Between Tables On Your Own A-5: Relate Two Database Tables On Your Own A-6: Use a Lookup Field to Protect Data Integrity Creating and Using Forms On Your Own A-7: Create and Use Detailed and Split Forms Creating and Using Queries On Your Own A-8: Create a Query That Includes a Calculation On Your Own A-9: Create a Query That Uses Two Tables Creating and Using Reports On Your Own A-10: Create Mailing Labels from a Single Table On Your Own A-11: Create a Report from a Query Summary Review Questions Chapter Mastery Project Mastery Project Part 1: Using Access to Explore a Simple Database Mastery Project Part 2: Designing and Creating a New Database Mastery Project Part 3: Creating and Using Forms Mastery Project Part 4: Creating and Using Queries Mastery Project Part 5: Creating and Using Reports Projects to Help You Project 1: Comparing Access and Excel Project 2: Access in Your Academic Career Project 3: Access in Your Technical Career Project to Help Others Chapter A Solutions: Creating and Using Databases with Microsoft Access On Your Own Solution A-1 On Your Own Solution A-2 On Your Own Solution A-3 On Your Own Solution A-4 On Your Own Solution A-5 On Your Own Solution A-6 On Your Own Solution A-7 On Your Own Solution A-8 On Your Own Solution A-9 On Your Own Solution A-10 On Your Own Solution A-11 CHAPTER W: Authoring Your Own Website Creating a Website from Beginning to End Create a Website with Text On Your Own W-1: Create a Web Page Publish Your Website On Your Own W-2: Publish Your Website Add an HTML Tag to the Web Page On Your Own W-3: Add a Line Break Tag to the Page Understanding HTML Structure and Tools On Your Own W-4: Use HTML Structure and Formatting Tags On Your Own W-5: Add a Photo to the Web Page Organize Your Files in Subfolders On Your Own W-6: Use a Subfolder on Your Website Enhancing a Website with Hyperlinks On Your Own W-7: Add a Link to a Second Web Page on Your Site On Your Own W-8: Add a Link to Another Website Surveying Web Authoring Software Explore Web Authoring Applications Use Microsoft Word to Generate HTML Tags Summary Review Questions Chapter Mastery Project Becoming an Independent Learner Projects to Help You Project 1: Building Your Personal Website Project 2: Testing a Website Project 3: Using Web Authoring Software and an FTP Client Project to Help Others Chapter W Solutions: Authoring Your Own Website On Your Own Solution W-1 On Your Own Solution W-2 On Your Own Solution W-3 On Your Own Solution W-4 On Your Own Solution W-5 On Your Own Solution W-6 On Your Own Solution W-7 On Your Own Solution W-8 Glossary Sample Files About the CompTIA Strata Exam Videos Video 1-7: Explore Files and Folders on the DVD Video 1-8: Create Folders on a USB Flash Drive Video 1-9: Open, Copy, Move, and Delete a File on USB Flash Drive Video 1-10: Use the Windows Snipping Tool Video 1-11: Install Software from DVD Video 1-12: End a Windows Session Video 2-7: Change Your Home Page Video 2-10: Download, Install, and Run Microsoft Security Essentials Video 3-1: Use the Word Window Video 3-3: Save, Close, and Open the Document Video 3-6: Insert Clip Art into a Document Video 3-8: Print a Document Video 3-11: Add a Shape to a Document Video 3-13: Save a Document as a PDF File Video 4-1: Create and Set Up a New Notebook in OneNote Video 4-2: Copy Research into OneNote Video 4-4: Use the OneNote Screen Clipping Tool Video 4-10: Organize Your Research in OneNote Video 5-1: Open the OneNote Notebook to View Research Notes Video 5-4: Enter the First Paragraph and Create a Citation Video 5-9: Create a Works Cited Page Video 7-1: Create a Contacts Document Including Tables Video 8-5: Add a Slide with SmartArt Video 8-6: Add a Slide with Artistic Effects Video 9-1: Edit the Slide Master Video 9-5: Add Animated Graphics and a Screen Clipping to a Slide Bonus Video 1: Add a Video on the Web to a Slide Video 10-1: Examine the Excel Windows and Tools Video 10-4: Format Rows for Team Data and Add One Team Member Video 10-8: Enter Two Sums in the Worksheet Video 11-2: Convert Data to an Excel Table Video 11-6: Use the IF Function for Calculations Video 12-2: Connect to a Wireless Hotspot Video 12-4: Install Windows Updates Bonus Video 2: Restore a Corrupted or Lost File from a Previous Version Video 12-7: Create a Standard Account Video 12-8: Manage Windows Passwords Video 12-9: Secure a Wireless Network Video 12-10: Use a Homegroup to Share Data Video 13-3: Limit Startup Programs Using System Configuration VIDEO 13-4: Manage Power Settings BONUS VIDEO 3: Install a USB Printer VIDEO 13-7: Use the Printer Queue BONUS VIDEO 4: Burn a CD

Reviews

Author Information

Jean Andrews, PhD, has more than 30 years of experience in the computer industry, including more than 13 years in the college classroom and 3 years in public schools. She has worked in a wide variety of businesses and corporations designing, writing, and supporting applications software; managing a PC repair help desk; and troubleshooting wide area networks. She has written a variety of books on software, hardware, and the Internet. She lives in northeast Georgia.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions