You are previewing IC3: Internet and Computing Core Certification Global Standard 4 Study Guide.
O'Reilly logo
IC3: Internet and Computing Core Certification Global Standard 4 Study Guide

Book Description

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.

    Table of Contents

    1. Introduction
      1. Assessment Test
      2. Answers to Assessment Test
    2. Part I Computing Fundamentals
      1. Chapter 1 Understanding Operating Systems
        1. Operating Systems and Their Roles When Using Computers and Devices
        2. Working with Files, Folders, and Libraries
        3. Customizing Your Computer
        4. Summary
        5. Exam Essentials
        6. Key Terms
        7. Review Questions
      2. Chapter 2 Understanding Hardware
        1. The Internal Hardware Components of a Computer
        2. Peripheral Devices That Can Be Connected to a Computer
        3. The Most Common Types of Computers and Devices
        4. How Information Is Transmitted inside a Computer
        5. How to Evaluate the Performance of a Computer or Device
        6. Summary
        7. Exam Essentials
        8. Key Terms
        9. Review Questions
      3. Chapter 3 Understanding Software
        1. The Dependencies between Hardware and Software
        2. Installing, Removing, or Reinstalling Software
        3. Software Licensing and Its Implications
        4. The Most Common Types of Office Applications
        5. Using Templates to Get Started with an Application
        6. Personal Entertainment Applications
        7. Compressing Files to Save Space
        8. Optimizing Your Computer’s Hard Disk Performance
        9. Protecting Yourself from Malware
        10. Summary
        11. Exam Essentials
        12. Key Terms
        13. Review Questions
      4. Chapter 4 Troubleshooting Problems with Your Computer
        1. Dealing with Problems Caused by Software
        2. Dealing with Problems Caused by Hardware
        3. Creating Your Own Backup System
        4. Summary
        5. Exam Essentials
        6. Key Terms
        7. Review Questions
    3. Part II Key Applications
      1. Chapter 5 Exploring Common Application Features in Microsoft Office
        1. Creating New Empty Documents with Microsoft Office
        2. The Basics of Using Microsoft Office Applications
        3. The Basics of Formatting Your Microsoft Office Files
        4. Working with Multimedia Files in Microsoft Office
        5. Summary
        6. Exam Essentials
        7. Key Terms
        8. Review Questions
      2. Chapter 6 Using Microsoft Word
        1. Configuring the Layout of Your Documents
        2. Organizing the Data in Your Documents
        3. Summary
        4. Exam Essentials
        5. Key Terms
        6. Review Questions
      3. Chapter 7 Using Microsoft Excel
        1. Navigating among Worksheets, Workbooks, and Cells
        2. Changing the Alignment and the Positioning of Cells
        3. Changing the Size of Cells
        4. Formatting How Cells Are Displayed
        5. Adding and Removing Rows and Columns
        6. Merging or Unmerging Cells
        7. Using Number Formats in Microsoft Excel Workbooks
        8. Sorting and Filtering Data
        9. Using Common Formulas and Functions
        10. Adding Charts and Graphs
        11. Summary
        12. Exam Essentials
        13. Key Terms
        14. Review Questions
      4. Chapter 8 Using Microsoft PowerPoint
        1. Adding and Removing Slides When Creating Presentations
        2. Changing the Order of Your Slides
        3. Changing the Design and the Background of Your Presentations
        4. Adding and Formatting the Text in Your Presentations
        5. Changing the Layout of Your Slides
        6. Adding Shapes and Pictures to Your Slides
        7. Adding Tables to Your Presentations
        8. Formatting the Tables in Your Presentations
        9. Adding Charts to Your Presentations
        10. Adding Video and Other Multimedia Files to Your Presentations
        11. Adding Animations to Your Presentation
        12. Setting Transitions between Slides and Viewing Your Presentations
        13. Summary
        14. Exam Essentials
        15. Key Terms
        16. Review Questions
      5. Chapter 9 Using Microsoft Access
        1. Adding, Modifying, and Removing Data in a Microsoft Access Database
        2. Using Search in a Microsoft Access Database
        3. Using Stored Queries in a Microsoft Access Database
        4. Running Predefined Reports in a Microsoft Access Database
        5. Creating Simple Reports in a Microsoft Access Database
        6. Summary
        7. Exam Essentials
        8. Key Terms
        9. Review Questions
      6. Chapter 10 Collaborating with Others When Working in Microsoft Office
        1. Adding Comments to Your Microsoft Office Files
        2. Reviewing the Comments That Were Added to a Document
        3. Tracking Changes in a Microsoft Word Document
        4. Reviewing Changes in a Microsoft Word Document
        5. Sharing Your Work Files Using Email
        6. Storing Documents Using Network Attached Storage Solutions
        7. Storing Documents Using Cloud Storage Solutions
        8. Summary
        9. Exam Essentials
        10. Key Terms
        11. Review Questions
    4. Part III Living Online
      1. Chapter 11 Using the Internet
        1. Understanding the Terminology about the Internet and the WWW
        2. Understanding the World Wide Web
        3. Browsing the Web with a Web Browser
        4. Using Multiple Tabs While Browsing the Web
        5. Downloading and Uploading Files on the Web
        6. Setting a Homepage in Your Web Browser
        7. Using and Clearing Your Browsing History
        8. Using Favorites or Bookmarks in Your Web Browser
        9. Searching for Text in a Web Page from Your Web Browser
        10. Using Plug-ins, Add-ons, and Extensions in Your Web Browser
        11. Summary
        12. Exam Essentials
        13. Key Terms
        14. Review Questions
      2. Chapter 12 Understanding Networking and Its Most Important Concepts
        1. Understanding Networks: LAN vs. WAN
        2. Understanding Network Addressing
        3. Using and Securing Wireless Networks
        4. Security Networks with Firewalls and Gateways
        5. Measuring the Speed of Your Internet Connection
        6. Understanding the Different Types of Internet Connections
        7. Virtual Private Networks
        8. Principles for Troubleshooting Networking Problems
        9. Troubleshooting Network Problems with the Help of Windows Troubleshooting Tools
        10. Troubleshooting Network Problems from the Command Prompt
        11. Summary
        12. Exam Essentials
        13. Key Terms
        14. Review Questions
      3. Chapter 13 Communicating Online with Others
        1. Creating and Securing Email Accounts
        2. Sending Email Messages
        3. Replying to and Forwarding Email Messages
        4. Automating Your Email Account
        5. Organizing and Archiving Your Inbox
        6. Communicating through Text Messages
        7. Communicating through Multimedia
        8. Using Social Media and Social Networks
        9. Increasing the Privacy of Your Social Networking Activity
        10. Summary
        11. Exam Essentials
        12. Key Terms
        13. Review Questions
      4. Chapter 14 Being a Responsible Digital Citizen
        1. Personal vs. Professional Communication
        2. Verbal vs. Written Communication
        3. Inappropriate Ways of Communicating Online
        4. Censorship and Filters in the Digital World
        5. Intellectual Property, Copyright, Licensing, and Piracy
        6. Summary
        7. Exam Essentials
        8. Key Terms
        9. Review Questions
      5. Chapter 15 Maintaining Your Health and Safety While Using Computers
        1. Protecting Your Identity and Your Data
        2. Removing Data from Your Computer
        3. Keeping Your Computer Safe from Threats and Malware
        4. The Ergonomics of Using the Computer in a Healthy Way
        5. Common Problems That Are Generated by Incorrect Computer Use and Posture
        6. Summary
        7. Exam Essentials
        8. Key Terms
        9. Review Questions
      6. Chapter 16 Searching the World Wide Web
        1. Using Search Engines to Find Information Online
        2. Performing Advanced Searches Using Symbols and Search Operators
        3. Searching for Files Online
        4. Dealing with Online Advertisements
        5. Finding Valuable Information on Internet Forums and Knowledge Bases
        6. Evaluating the Information That You Find on the Web
        7. Summary
        8. Exam Essentials
        9. Key Terms
        10. Review Questions
    5. Appendixes
      1. Appendix A Answers to Review Questions
        1. Chapter 1: Understanding Operating Systems
        2. Chapter 2: Understanding Hardware
        3. Chapter 3: Understanding Software
        4. Chapter 4: Troubleshooting Problems with Your Computer
        5. Chapter 5: Exploring Common Application Features in Microsoft Office
        6. Chapter 6: Using Microsoft Word
        7. Chapter 7: Using Microsoft Excel
        8. Chapter 8: Using Microsoft PowerPoint
        9. Chapter 9: Using Microsoft Access
        10. Chapter 10: Collaborating with Others When Working in Microsoft Office
        11. Chapter 11: Using the Internet
        12. Chapter 12: Understanding Networking and Its Most Important Concepts
        13. Chapter 13: Communicating Online with Others
        14. Chapter 14: Being a Responsible Digital Citizen
        15. Chapter 15: Maintaining Your Health and Safety While Using Computers
        16. Chapter 16: Searching the World Wide Web
      2. Appendix B Using the Practice Files
        1. IC3—Module 1: Computing Fundamentals
        2. IC3—Module 2: Key Applications
        3. IC3—Module 3: Living Online
    6. Index
    7. Advert
    8. EULA