ICT Fundamentals

ICT Fundamentals

Microsoft Office (Word, Excel, PowerPoint), Social Media Basics, Intro to Computer

The IC3 Digital Literacy Certification provides students and job-seekers with the foundation of knowledge they need to succeed in environments that require the use of computers and the Internet.

Register Now

Duration

  • Weekdays – 1 1/2 months
  • Weekends – 3 months

Course Description

In today’s high-tech world, digital literacy is a requirement. The best way to stand out of the crowd is to have the IC3 Digital Literacy Certification credential on your resume.

The Internet and Computing Core Certification (IC³) program covers a broad range of computing knowledge and skills that proves competency in digital literacy. Regardless of your career or education goals, computers and technology will most likely play an important role.

The study covers introduction to computer basic which comprises the hardware (e.g. this is everything physically present in a computer: the keyboard, the screen, and the case where the actual computer resides all constitute hardware) and software (e.g. operating system, which provides a user interface and some basic commands.).This course is designed for students who have no background knowledge in computer but interested in knowing about a computer and its features.

Certificate Earned

  • Internet And Computing Core (IC3)

Course Outline

Technical Introduction to the Internet
A basic introduction to how internet works, its origin, how to communicate on the internet with your computer, tools involves in the effective use of the internet, its applications and many more.

  • MS Word 2013:
    This course is designed for students who are interested in learning how to use Microsoft word to create, edit, format, lay out, and print standard business documents complete with tables and graphics. This course is intended for persons interested in pursuing Microsoft office specialist certification in Microsoft word.
  • MS Excel 2013:
    This course is designed for students who are interested in learning and familiar with data types (text and values),copying data, basic formulas and functions, and opening and saving files.
  • MS Powerpoint 2013
    This course is designed for students who are interested in learning the fundamentals needed to create and modify basic Microsoft PowerPoint presentations and those who which to pursue their Microsoft office certification in PowerPoint.

Microsoft Advance Excel

The IC3 Digital Literacy Certification provides students and job-seekers with the foundation of knowledge they need to succeed in environments that require the use of computers and the Internet.

Register Now

Overview

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering. In addition, students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analysing data, and using Excel data in other applications.

This course is designed for students who already have foundational knowledge, skills and experience working with Excel 2013. The student will now begin taking advantage of some of the higher-level functionality in Excel such as creating macros, working with shared documents, analyzing data, and auditing worksheets.

Duration

2 weeks

Course Outline

Course Outline – Level 2

Lesson 1: Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

 

Course Outline – Level 3

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

  • Use 3-D References
  • Use Links and External References
  • Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

  • Apply Data Validation
  • Work with Forms and Controls
  • Work with Macros

Lesson 4: Applying Conditional Logic

  • Use Lookup Functions
  • Combine Functions
  • Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets

  • Trace Cells
  • Search for Invalid Data and Formulas with Errors Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Activate and Use the Solver Tool
  • Analyze Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually

  • Use Advanced Chart Features
  • Create Spark lines