Gain hands-on experience to pass the IC3 certification exam with the Key Applications (IC3 GS5 Exam 2) course and lab. The lab provides a hands-on learning experience in a safe and online environment. This IC3 exam guide completely covers IC3 GS5 Key Applications exam objectives and includes topics such as exploring common application features in Microsoft Access, using Microsoft Word, Excel, PowerPoint, and Access, collaborating with others when working in Microsoft Office, and so on.

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

IC3 Global Standard 5 (GS5) is the newest addition to the IC3 Digital Literacy program. Like its predecessors, the GS5 certification is comprised of three exams: Computing Fundamentals, Living Online, and Key Applications. The Key Applications exam covers the most common features of the world's best spreadsheet, word processing, and presentation applications. IC3 GS5 now includes app culture elements that will help the examinees understand how to obtain and maximize the use of some of today's most popular applications.

1
  • Exploring Common Application Features in Microsoft Office

  • Creating New Empty Documents with Microsoft Office
    The Basics of Using Microsoft Office Applications
    The Basics of Formatting Your Microsoft Office Files
    Working with Multimedia Files in Microsoft Office
    Summary

2
  • Using Microsoft Word

  • Configuring the Layout of Your Documents
    Organizing the Data in Your Documents
    Summary

3
  • Using Microsoft Excel

  • Navigating among Worksheets, Workbooks, and Cells
    Changing the Alignment and the Positioning of Cells
    Changing the Size of Cells
    Formatting How Cells Are Displayed
    Adding and Removing Rows and Columns
    Merging or Unmerging Cells
    Using Number Formats in Microsoft Excel Workbooks
    Sorting and Filtering Data
    Using Common Formulas and Functions
    Adding Charts and Graphs
    Summary

4
  • Using Microsoft PowerPoint

  • Adding and Removing Slides When Creating Presentations
    Changing the Order of Your Slides
    Changing the Design and the Background of Your Presentations
    Adding and Formatting the Text in Your Presentations
    Changing the Layout of Your Slides
    Adding Shapes and Pictures to Your Slides
    Adding Tables to Your Presentations
    Formatting the Tables in Your Presentations
    Adding Charts to Your Presentations
    Adding Video and Other Multimedia Files to Your Presentations
    Adding Animations to Your Presentation
    Setting Transitions between Slides and Viewing Your Presentations
    Summary

5
  • Using Microsoft Access

  • Adding, Modifying, and Removing Data in a Microsoft Access Database
    Using Search in a Microsoft Access Database
    Using Stored Queries in a Microsoft Access Database
    Running Predefined Reports in a Microsoft Access Database
    Creating Simple Reports in a Microsoft Access Database
    Creating Simple Forms in a Microsoft Access Database
    Summary

6
  • Collaborating with Others When Working in Microsoft Office

  • Adding Comments to Your Microsoft Office Files
    Reviewing the Comments That Were Added to a Document
    Tracking Changes in a Microsoft Word Document
    Reviewing Changes in a Microsoft Word Document
    Sharing Your Work Files Using Email
    Storing Documents Using Network Attached Storage Solutions
    Storing Documents Using Cloud Storage Solutions
    Summary

7
  • Appendix A:

  • Objective Mappings

Audience

Those looking to pass the IC3 examinationwill benefit from this course.

Language

English

Prerequisites

While there are no prerequisites for this course, please ensure you have the right level of experience to be successful in this training.

Length: 365.0 days ( hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...