Ic3: Internet and Computing Core Certification Global Standard 4 - Study Guid

Hands-on IC3 prep, with expert instruction and loads of toolsIC3: Internet and Computing Core Certification Global Standard 4 Study Guide is the ideal all-in-one resource for those preparing to take the exam for the internationally-recognized IT computing fundamentals credential. Designed to help candidates pinpoint weak areas while there's still time to brush up, this book provides one hundred percent coverage of the exam objectives for all three modules of the IC3-GS4 exam. Readers will find clear, concise information, hands-on examples, and self-paced exercises that demonstrate how to perform critical tasks. This useful guide includes access to a robust set of learning tools, including chapter review questions, a practice test environment, electronic flashcards, and author videos that explain complex topics.The certification consists of three separate exams: Computing Fundamentals, Key Applications, and Living Online. Candidates are given fifty minutes to answer forty-five questions, so rapid recall and deep understanding are critical to success. IC3: Internet and Computing Core Certification Global Standard 4 Study Guide provides expert instruction on everything candidates need to know, including hardware, software, networking, and more.* Review operating system basics and common application features* Understand troubleshooting and safe computing* Learn basic word processing, spreadsheet, presentation, and database activities* Study networking concepts, digital communication, and research fluencyThe exam includes both multiple choice and performance-based questions, and this guide provides plenty of both so candidates can get comfortable with both material and format. More than just a memorization tool, this book helps exam candidates understand the material on a fundamental level, giving them a greater chance of success than just going it alone. For the IC3 candidate who's serious about certification, IC3: Internet and Computing Core Certification Global Standard 4 Study Guide is the complete, hands-on exam prep guide.

List of contents

Introduction xxiAssessment Test xliiiPart I Computing Fundamentals 1Chapter 1 Understanding Operating Systems 3Operating Systems and Their Roles When Using Computers and Devices 5What Is Hardware? 5What Is Software? 6What Is an Operating System? 6How Do They All Work Together? 7Accessing and Locking the Operating System 9Software and System Updates 12Working with Files, Folders, and Libraries 17Accessing Your Files and Folders 18Understanding File Types 22Managing Your Files and Folders 24Customizing Your Computer 32Customizing the Desktop 32Understanding User Accounts 45Summary 51Exam Essentials 52Key Terms 52Review Questions 53Chapter 2 Understanding Hardware 55The Internal Hardware Components of a Computer 57Peripheral Devices That Can Be Connected to a Computer 59The Most Common Types of Computers and Devices 62How Information Is Transmitted inside a Computer 65How to Evaluate the Performance of a Computer or Device 66Summary 71Exam Essentials 72Key Terms 72Review Questions 74Chapter 3 Understanding Software 77The Dependencies between Hardware and Software 79Installing, Removing, or Reinstalling Software 81Software Licensing and Its Implications 91The Most Common Types of Office Applications 96Using Templates to Get Started with an Application 98Personal Entertainment Applications 101Compressing Files to Save Space 101Optimizing Your Computer's Hard Disk Performance 103Protecting Yourself from Malware 108Summary 109Exam Essentials 110Key Terms 111Review Questions 112Chapter 4 Troubleshooting Problems with Your Computer 115Dealing with Problems Caused by Software 117Dealing with Incompatibilities between the Operating System Version and Your Applications 118Dealing with Unresponsive Applications 121Dealing with Applications That Consume Too Many Resources 124Dealing with Malware Infections 126Using Safe Mode to Fix Problems with Windows 129Finding Help Online 131Dealing with Problems Caused by Hardware 132Dealing with Problems Caused by Cables and Connectors 132Upgrading the Firmware for Your Computer's Components and Peripherals 133Dealing with Drivers for Your Computer's Hardware 135Creating Your Own Backup System 140Backing Up Your Data with Backup and Restore 140Restoring Your Data with Backup and Restore 145Backing Up Your Data to the Cloud with OneDrive 150Summary 156Exam Essentials 156Key Terms 157Review Questions 158Part II Key Applications 161Chapter 5 Exploring Common Application Features in Microsoft Office 163Creating New Empty Documents with Microsoft Office 166Starting and Closing Microsoft Office Applications 167Opening and Closing Microsoft Office Files 168Creating New Empty Files with Microsoft Office 169Saving Your Microsoft Office Files 171Working with Several Windows at the Same Time 175The Basics of Using Microsoft Office Applications 180Keyboard Shortcuts for Using the Ribbon Productively 180Selecting, Copying, and Moving Data When Using Microsoft Office Applications 184Dragging and Dropping Data When Using Microsoft Office Applications 193Finding and Replacing Data in Your Microsoft Office Documents 194Checking the Spelling of Your Microsoft Office Documents 197Undoing Your Changes and Mistakes When Working with Microsoft Office Documents 200Hiding Your Data from Tables and Charts 201Selecting Non-adjacent Cells in Microsoft Excel Tables 203Sorting Data When Working with Microsoft Excel Files 205Adjusting the Way You View Microsoft Office Files 207Adjusting the Size and the Orientation of YourMicrosoft Office Files 211Printing Your Documents from Microsoft Office 213Where to Get Help with Using Microsoft Office 214The Basics of Formatting Your Microsoft Office Files 217Formatting the Text in Your Documents 217Using Styles to Format Your Documents 220Working with Multimedia Files in Microsoft Office 224Adding Multimedia Files to Your Presentations 224Adjusting the Pictures Used in Your Presentations 228Summary 231Exam Essentials 232Key Terms 233Review Questions 234Chapter 6 Using Microsoft Word 237Configuring the Layout of Your Documents 238Adjusting Line and Paragraph Spacing in Your Documents 238Aligning the Text in Your Documents 241Organizing Your Documents into Columns 245Setting the Margins of Your Documents 246Displaying the Ruler When Editing Documents 249Indenting the Text in Your Documents 250Using Tabs to Control Where the Text Is Placed in Your Documents 254Organizing the Data in Your Documents 258Creating Bulleted and Numbered Lists 259Sorting Single?]Level Lists 260Creating Tables 262Adding or Removing Rows and Columns in Your Tables 265Merging and Splitting Cells in Your Tables 266Adding Page Numbers to Your Documents 269Summary 273Exam Essentials 273Key Terms 273Review Questions 274Chapter 7 Using Microsoft Excel 277Navigating among Worksheets, Workbooks, and Cells 278Navigating between Worksheets 279Navigating between Cells 280Changing the Alignment and the Positioning of Cells 284Changing the Size of Cells 287Formatting How Cells Are Displayed 290Adding and Removing Rows and Columns 292Merging or Unmerging Cells 295Using Number Formats in Microsoft Excel Workbooks 297Sorting and Filtering Data 299Sorting Data 300Filtering Data 302Using Common Formulas and Functions 304Using Mathematical Operators 305Using Relative and Absolute References 307Using Functions 310Adding Charts and Graphs 313Inserting a Line Chart 315Inserting a Pie Chart 317Inserting a Bar Graph 319Summary 321Exam Essentials 321Key Terms 322Review Questions 323Chapter 8 Using Microsoft PowerPoint 325Adding and Removing Slides When Creating Presentations 327Changing the Order of Your Slides 330Changing the Design and the Background of Your Presentations 331Adding and Formatting the Text in Your Presentations 334Changing the Layout of Your Slides 337Adding Shapes and Pictures to Your Slides 339Adding Tables to Your Presentations 342Formatting the Tables in Your Presentations 345Adding Charts to Your Presentations 348Adding Video and Other Multimedia Files to Your Presentations 350Adding Animations to Your Presentation 352Setting Transitions between Slides and Viewing Your Presentations 355Summary 357Exam Essentials 358Key Terms 358Review Questions 359Chapter 9 Using Microsoft Access 361Adding, Modifying, and Removing Data in a Microsoft Access Database 362Using Search in a Microsoft Access Database 367Using Stored Queries in a Microsoft Access Database 370Running Predefined Reports in a Microsoft Access Database 372Creating Simple Reports in a Microsoft Access Database 373Summary 379Exam Essentials 380Key Terms 380Review Questions 381Chapter 10 Collaborating with Others When Working in Microsoft Office 383Adding Comments to Your Microsoft Office Files 384Reviewing the Comments That Were Added to a Document 387Tracking Changes in a Microsoft Word Document 388Reviewing Changes in a Microsoft Word Document 390Sharing Your Work Files Using Email 393Storing Documents Using Network Attached Storage Solutions 396Storing Documents Using Cloud Storage Solutions 398Summary 400Exam Essentials 400Key Terms 401Review Questions 402Part III Living Online 405Chapter 11 Using the Internet 407Understanding the Terminology about the Internet and the WWW 408Understanding the World Wide Web 410Standard Domain Names 410Special Domain Names 411Understanding Hyperlinks 411Browsing the Web with a Web Browser 412Using Multiple Tabs While Browsing the Web 417Downloading and Uploading Files on the Web 419Setting a Homepage in Your Web Browser 420Using and Clearing Your Browsing History 423Using Favorites or Bookmarks in Your Web Browser 428Searching for Text in a Web Page from Your Web Browser 433Using Plug?]ins, Add?]ons, and Extensions in Your Web Browser 435Summary 436Exam Essentials 436Key Terms 437Review Questions 438Chapter 12 Understanding Networking and Its Most Important Concepts 441Understanding Networks: LAN vs. WAN 442Understanding Network Addressing 445IP Addresses 445The Domain Name Service 446Private IPv4 Address Ranges 448Using and Securing Wireless Networks 449Changing How You Authenticate to Wireless Access Points 450Setting the Encryption for Your Wireless Network 451Security Networks with Firewalls and Gateways 452Using a Firewall 453Understanding the Gateway Concept 455Measuring the Speed of Your Internet Connection 455Factors Limiting the Speed of Your Internet Connection 457Wireless Networking Standards and Speeds 458Understanding the Different Types of Internet Connections 459Dial?]up Internet Access 460Broadband Internet Access 461Virtual Private Networks 462Principles for Troubleshooting Networking Problems 464Troubleshooting Network Problems with the Help of Windows Troubleshooting Tools 465Troubleshooting Network Problems from the Command Prompt 471Ping 471Tracert 473Ipconfig 473Summary 475Exam Essentials 475Key Terms 476Review Questions 477Chapter 13 Communicating Online with Others 479Creating and Securing Email Accounts 480Sending Email Messages 482Attaching Files to Email Massages 484Building a Contacts List 485Replying to and Forwarding Email Messages 488Automating Your Email Account 490Organizing and Archiving Your Inbox 491Communicating through Text Messages 493Communicating through Multimedia 496Using Social Media and Social Networks 498Social Networks 498Blogs 502Increasing the Privacy of Your Social Networking Activity 502Summary 505Exam Essentials 505Key Terms 506Review Questions 507Chapter 14 Being a Responsible Digital Citizen 509Personal vs. Professional Communication 510Verbal vs. Written Communication 512Inappropriate Ways of Communicating Online 512Censorship and Filters in the Digital World 514Intellectual Property, Copyright, Licensing, and Piracy 516Avoiding Piracy 517Creative Commons: A Less Restrictive Form of Licensing 518Summary 519Exam Essentials 519Key Terms 520Review Questions 521Chapter 15 Maintaining Your Health and Safety While Using Computers 523Protecting Your Identity and Your Data 524Removing Data from Your Computer 526Keeping Your Computer Safe from Threats and Malware 530The Ergonomics of Using the Computer in a Healthy Way 531Common Problems That Are Generated by Incorrect Computer Use and Posture 533Summary 534Exam Essentials 534Key Terms 534Review Questions 535Chapter 16 Searching the World Wide Web 537Using Search Engines to Find Information Online 538Performing Advanced Searches Using Symbols and Search Operators 542Searching for Files Online 543Dealing with Online Advertisements 546Finding Valuable Information on Internet Forums and Knowledge Bases 547Evaluating the Information That You Find on the Web 549Summary 550Exam Essentials 550Key Terms 551Review Questions 552Appendixes 555Appendix A Answers to Review Questions 557Appendix B Using the Practice Files 571Index 575

About the author

Ciprian Rusen ist IT-Projektmanager bei einem großen Handelsunternehmen. Er betreut ein Blog und koordiniert ein Autorenteam, das Windows-Anwendertutorials verfasst.

Summary

Hands-on IC3 prep, with expert instruction and loads of tools

IC3: Internet and Computing Core Certification Global Standard 4 Study Guide is the ideal all-in-one resource for those preparing to take the exam for the internationally-recognized IT computing fundamentals credential. Designed to help candidates pinpoint weak areas while there's still time to brush up, this book provides one hundred percent coverage of the exam objectives for all three modules of the IC3-GS4 exam. Readers will find clear, concise information, hands-on examples, and self-paced exercises that demonstrate how to perform critical tasks. This useful guide includes access to a robust set of learning tools, including chapter review questions, a practice test environment, electronic flashcards, and author videos that explain complex topics.

The certification consists of three separate exams: Computing Fundamentals, Key Applications, and Living Online. Candidates are given fifty minutes to answer forty-five questions, so rapid recall and deep understanding are critical to success. IC3: Internet and Computing Core Certification Global Standard 4 Study Guide provides expert instruction on everything candidates need to know, including hardware, software, networking, and more.
* Review operating system basics and common application features
* Understand troubleshooting and safe computing
* Learn basic word processing, spreadsheet, presentation, and database activities
* Study networking concepts, digital communication, and research fluency

The exam includes both multiple choice and performance-based questions, and this guide provides plenty of both so candidates can get comfortable with both material and format. More than just a memorization tool, this book helps exam candidates understand the material on a fundamental level, giving them a greater chance of success than just going it alone. For the IC3 candidate who's serious about certification, IC3: Internet and Computing Core Certification Global Standard 4 Study Guide is the complete, hands-on exam prep guide.

Product details

• Authors: Joli Ballew, Joli Harwood Ballew, Michael Harwood, Ciprian Rusen, Ciprian A. Rusen, Ciprian Adrian Rusen, Ciprian Adrian Ballew Rusen
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 17.04.2015
• EAN: 9781118952214
• ISBN: 978-1-118-95221-4
• No. of pages: 648
• Subjects: Children's and young people's books > Non-fiction books / Non-fiction picture books > Natural science, technology; Education and learning > Miscellaneous; Natural sciences, medicine, IT, technology > IT, data processing > Application software; Internet, Prüfungsvorbereitung, Computer, Zertifizierung, test prep, End-User Computing, Computer-Ratgeber, Misc (other) certifications, Sonstige Zertifizierungen, Allg. Computer-Ratgeber, IC3