IC3: Internet and Computing Core Certification Global Standard 4 Study Guide

Introduction xxi

Assessment Test xliii

Part I Computing Fundamentals 1

Chapter 1 Understanding Operating Systems 3

Operating Systems and Their Roles When Using Computers and Devices 5

What Is Hardware? 5

What Is Software? 6

What Is an Operating System? 6

How Do They All Work Together? 7

Accessing and Locking the Operating System 9

Software and System Updates 12

Working with Files, Folders, and Libraries 17

Accessing Your Files and Folders 18

Understanding File Types 22

Managing Your Files and Folders 24

Customizing Your Computer 32

Customizing the Desktop 32

Understanding User Accounts 45

Summary 51

Exam Essentials 52

Key Terms 52

Review Questions 53

Chapter 2 Understanding Hardware 55

The Internal Hardware Components of a Computer 57

Peripheral Devices That Can Be Connected to a Computer 59

The Most Common Types of Computers and Devices 62

How Information Is Transmitted inside a Computer 65

How to Evaluate the Performance of a Computer or Device 66

Summary 71

Exam Essentials 72

Key Terms 72

Review Questions 74

Chapter 3 Understanding Software 77

The Dependencies between Hardware and Software 79

Installing, Removing, or Reinstalling Software 81

Software Licensing and Its Implications 91

The Most Common Types of Office Applications 96

Using Templates to Get Started with an Application 98

Personal Entertainment Applications 101

Compressing Files to Save Space 101

Optimizing Your Computer’s Hard Disk Performance 103

Protecting Yourself from Malware 108

Summary 109

Exam Essentials 110

Key Terms 111

Review Questions 112

Chapter 4 Troubleshooting Problems with Your Computer 115

Dealing with Problems Caused by Software 117

Dealing with Incompatibilities between the Operating System Version and Your Applications 118

Dealing with Unresponsive Applications 121

Dealing with Applications That Consume Too Many Resources 124

Dealing with Malware Infections 126

Using Safe Mode to Fix Problems with Windows 129

Finding Help Online 131

Dealing with Problems Caused by Hardware 132

Dealing with Problems Caused by Cables and Connectors 132

Upgrading the Firmware for Your Computer’s Components and Peripherals 133

Dealing with Drivers for Your Computer’s Hardware 135

Creating Your Own Backup System 140

Backing Up Your Data with Backup and Restore 140

Restoring Your Data with Backup and Restore 145

Backing Up Your Data to the Cloud with OneDrive 150

Summary 156

Exam Essentials 156

Key Terms 157

Review Questions 158

Part II Key Applications 161

Chapter 5 Exploring Common Application Features in Microsoft Office 163

Creating New Empty Documents with Microsoft Office 166

Starting and Closing Microsoft Office Applications 167

Opening and Closing Microsoft Office Files 168

Creating New Empty Files with Microsoft Office 169

Saving Your Microsoft Office Files 171

Working with Several Windows at the Same Time 175

The Basics of Using Microsoft Office Applications 180

Keyboard Shortcuts for Using the Ribbon Productively 180

Selecting, Copying, and Moving Data When Using Microsoft Office Applications 184

Dragging and Dropping Data When Using Microsoft Office Applications 193

Finding and Replacing Data in Your Microsoft Office Documents 194

Checking the Spelling of Your Microsoft Office Documents 197

Undoing Your Changes and Mistakes When Working with Microsoft Office Documents 200

Hiding Your Data from Tables and Charts 201

Selecting Non-adjacent Cells in Microsoft Excel Tables 203

Sorting Data When Working with Microsoft Excel Files 205

Adjusting the Way You View Microsoft Office Files 207

Adjusting the Size and the Orientation of Your

Microsoft Office Files 211

Printing Your Documents from Microsoft Office 213

Where to Get Help with Using Microsoft Office 214

The Basics of Formatting Your Microsoft Office Files 217

Formatting the Text in Your Documents 217

Using Styles to Format Your Documents 220

Working with Multimedia Files in Microsoft Office 224

Adding Multimedia Files to Your Presentations 224

Adjusting the Pictures Used in Your Presentations 228

Summary 231

Exam Essentials 232

Key Terms 233

Review Questions 234

Chapter 6 Using Microsoft Word 237

Configuring the Layout of Your Documents 238

Adjusting Line and Paragraph Spacing in Your Documents 238

Aligning the Text in Your Documents 241

Organizing Your Documents into Columns 245

Setting the Margins of Your Documents 246

Displaying the Ruler When Editing Documents 249

Indenting the Text in Your Documents 250

Using Tabs to Control Where the Text Is Placed in Your Documents 254

Organizing the Data in Your Documents 258

Creating Bulleted and Numbered Lists 259

Sorting Single?]Level Lists 260

Creating Tables 262

Adding or Removing Rows and Columns in Your Tables 265

Merging and Splitting Cells in Your Tables 266

Adding Page Numbers to Your Documents 269

Summary 273

Exam Essentials 273

Key Terms 273

Review Questions 274

Chapter 7 Using Microsoft Excel 277

Navigating among Worksheets, Workbooks, and Cells 278

Navigating between Worksheets 279

Navigating between Cells 280

Changing the Alignment and the Positioning of Cells 284

Changing the Size of Cells 287

Formatting How Cells Are Displayed 290

Adding and Removing Rows and Columns 292

Merging or Unmerging Cells 295

Using Number Formats in Microsoft Excel Workbooks 297

Sorting and Filtering Data 299

Sorting Data 300

Filtering Data 302

Using Common Formulas and Functions 304

Using Mathematical Operators 305

Using Relative and Absolute References 307

Using Functions 310

Adding Charts and Graphs 313

Inserting a Line Chart 315

Inserting a Pie Chart 317

Inserting a Bar Graph 319

Summary 321

Exam Essentials 321

Key Terms 322

Review Questions 323

Chapter 8 Using Microsoft PowerPoint 325

Adding and Removing Slides When Creating Presentations 327

Changing the Order of Your Slides 330

Changing the Design and the Background of Your Presentations 331

Adding and Formatting the Text in Your Presentations 334

Changing the Layout of Your Slides 337

Adding Shapes and Pictures to Your Slides 339

Adding Tables to Your Presentations 342

Formatting the Tables in Your Presentations 345

Adding Charts to Your Presentations 348

Adding Video and Other Multimedia Files to Your Presentations 350

Adding Animations to Your Presentation 352

Setting Transitions between Slides and Viewing Your Presentations 355

Summary 357

Exam Essentials 358

Key Terms 358

Review Questions 359

Chapter 9 Using Microsoft Access 361

Adding, Modifying, and Removing Data in a Microsoft Access Database 362

Using Search in a Microsoft Access Database 367

Using Stored Queries in a Microsoft Access Database 370

Running Predefined Reports in a Microsoft Access Database 372

Creating Simple Reports in a Microsoft Access Database 373

Summary 379

Exam Essentials 380

Key Terms 380

Review Questions 381

Chapter 10 Collaborating with Others When Working in Microsoft Office 383

Adding Comments to Your Microsoft Office Files 384

Reviewing the Comments That Were Added to a Document 387

Tracking Changes in a Microsoft Word Document 388

Reviewing Changes in a Microsoft Word Document 390

Sharing Your Work Files Using Email 393

Storing Documents Using Network Attached Storage Solutions 396

Storing Documents Using Cloud Storage Solutions 398

Summary 400

Exam Essentials 400

Key Terms 401

Review Questions 402

Part III Living Online 405

Chapter 11 Using the Internet 407

Understanding the Terminology about the Internet and the WWW 408

Understanding the World Wide Web 410

Standard Domain Names 410

Special Domain Names 411

Understanding Hyperlinks 411

Browsing the Web with a Web Browser 412

Using Multiple Tabs While Browsing the Web 417

Downloading and Uploading Files on the Web 419

Setting a Homepage in Your Web Browser 420

Using and Clearing Your Browsing History 423

Using Favorites or Bookmarks in Your Web Browser 428

Searching for Text in a Web Page from Your Web Browser 433

Using Plug?]ins, Add?]ons, and Extensions in Your Web Browser 435

Summary 436

Exam Essentials 436

Key Terms 437

Review Questions 438

Chapter 12 Understanding Networking and Its Most Important Concepts 441

Understanding Networks: LAN vs. WAN 442

Understanding Network Addressing 445

IP Addresses 445

The Domain Name Service 446

Private IPv4 Address Ranges 448

Using and Securing Wireless Networks 449

Changing How You Authenticate to Wireless Access Points 450

Setting the Encryption for Your Wireless Network 451

Security Networks with Firewalls and Gateways 452

Using a Firewall 453

Understanding the Gateway Concept 455

Measuring the Speed of Your Internet Connection 455

Factors Limiting the Speed of Your Internet Connection 457

Wireless Networking Standards and Speeds 458

Understanding the Different Types of Internet Connections 459

Dial?]up Internet Access 460

Broadband Internet Access 461

Virtual Private Networks 462

Principles for Troubleshooting Networking Problems 464

Troubleshooting Network Problems with the Help of Windows Troubleshooting Tools 465

Troubleshooting Network Problems from the Command Prompt 471

Ping 471

Tracert 473

Ipconfig 473

Summary 475

Exam Essentials 475

Key Terms 476

Review Questions 477

Chapter 13 Communicating Online with Others 479

Creating and Securing Email Accounts 480

Sending Email Messages 482

Attaching Files to Email Massages 484

Building a Contacts List 485

Replying to and Forwarding Email Messages 488

Automating Your Email Account 490

Organizing and Archiving Your Inbox 491

Communicating through Text Messages 493

Communicating through Multimedia 496

Using Social Media and Social Networks 498

Social Networks 498

Blogs 502

Increasing the Privacy of Your Social Networking Activity 502

Summary 505

Exam Essentials 505

Key Terms 506

Review Questions 507

Chapter 14 Being a Responsible Digital Citizen 509

Personal vs. Professional Communication 510

Verbal vs. Written Communication 512

Inappropriate Ways of Communicating Online 512

Censorship and Filters in the Digital World 514

Intellectual Property, Copyright, Licensing, and Piracy 516

Avoiding Piracy 517

Creative Commons: A Less Restrictive Form of Licensing 518

Summary 519

Exam Essentials 519

Key Terms 520

Review Questions 521

Chapter 15 Maintaining Your Health and Safety While Using Computers 523

Protecting Your Identity and Your Data 524

Removing Data from Your Computer 526

Keeping Your Computer Safe from Threats and Malware 530

The Ergonomics of Using the Computer in a Healthy Way 531

Common Problems That Are Generated by Incorrect Computer Use and Posture 533

Summary 534

Exam Essentials 534

Key Terms 534

Review Questions 535

Chapter 16 Searching the World Wide Web 537

Using Search Engines to Find Information Online 538

Performing Advanced Searches Using Symbols and Search Operators 542

Searching for Files Online 543

Dealing with Online Advertisements 546

Finding Valuable Information on Internet Forums and Knowledge Bases 547

Evaluating the Information That You Find on the Web 549

Summary 550

Exam Essentials 550

Key Terms 551

Review Questions 552

Appendixes 555

Appendix A Answers to Review Questions 557

Appendix B Using the Practice Files 571

Index 575