ABC IT-1: Basic Concepts

Module One: IT Today

Lesson 1: Introduction to IT

Overview of Information Technology
Computer Types
Parts of a Computer
Understanding Computer Performance

Lesson 2: Working with IT

Home Computing
Computing at Work
Computers in Society

Lesson 3: The Digital World

The Digital World
E-commerce
E-mail

Lesson 4: Using IT Safely and Protecting the Environment

Creating a Good Workspace
Health and Safety
Protecting the Environment

Lesson 5: Legal Matters in IT

Understanding Copyright
Data Protection

Module Two: The Computer

Lesson 1: Computer Hardware

The CPU
Types of Memory
Measuring Memory
Device Types - Input
Device Types - Output
Input and Output Devices
Storage

Lesson 2: Computer Software

Different Types of Software
Operating Systems
Applications
Designing Systems

Lesson 3: Computer Networks

Local and Wide Area Networks
Intranets and Extranets
Internet
Data Transfer
High-Speed Connections

Lesson 4: Maintenance

Hardware Setup
System Software
Resolving Problems

Lesson 5: System Analysis

Device and Task Managers
Drive Icons and Available Storage

Lesson 6: Working Securely

Understanding Security
Viruses

Lesson 7: Starting Up and Using Your Computer

Getting Started
Covering the Basics

Lesson 8: Desktop Management

Icons
Windows
Identifying Your Computer's Properties
Personalising Your Desktop

Lesson 9: File Management

Overview of Files and Folders
Copying, Moving and Deleting Files and Folders
Backing Up Files and Folders
Using the Search Tool
File Compression

Lesson 10: Virus Management

Reviewing Computer Viruses
Identifying Computer Viruses
Scanning for Computer Viruses
Quarantining a Computer Virus

Module Three: The Online World

Lesson 1: Getting Started on the Web

Terminology and Concepts
Security
Web Browsers
Adjusting Basic Settings
Cookies and Cache

Lesson 2: Surfing the Web

Surfing the Web
Accessing a Web Address
Web-based Forms

Lesson 3: Searching the Web

Searching the Web
Search Engines
Saving and Downloading a Web Page
Printing a Web Page

Lesson 4: Web Bookmarks

Web Bookmarks
Bookmarking a Web Page
Organizing Your Bookmarks

Lesson 5: E-mail

E-mail
Understanding E-mail
Security
Netiquette
E-mail Basics
Adjusting Basic Settings

Lesson 6: Basic Messaging

Basic Messaging
Message Sending
Copying, Moving and Deleting Text
Message Viewing
Message Replying
Using Netiquette and Formatting

Lesson 7: Managing Mail

Managing Mail
Message Management

Lesson 8: Address Books

Address Books
Address Books
Sending Messages to Several Addresses
Print Preparation

ABC IT-2: Applications

Module One: Microsoft Word

Lesson 1: First Steps with Word

First Steps with Word
Getting Started
Saving as Another File Format
Adjusting Basic Settings

Lesson 2: Key Operations

Key Operations
Data Input
Data Selection
Copying, Moving and Deleting Text
Find and Replace

Lesson 3: Applying Formatting

Applying Formatting
Adjusting Text Type, Size, and Colour
Adjusting Text Layout
Formatting Paragraphs

Lesson 4: Finishing a Document

Finishing a Document
Styles and Pagination
Headers and Footers

Lesson 5: Advanced Features

Advanced Features
Using Tables
Working with Images
Adding Shapes
Importing Objects

Lesson 6: Using Mail Merge

Using Mail Merge
Creating a Mail Merge

Lesson 7: Outputs

Overview
Output Preparation
Spelling and Grammar

Lesson 8: Printed Output

Printed Output
Preparing to Print

Module Two: Microsoft Excel

Lesson 1: First Steps with Excel

First Steps with Excel
Getting Started
Adjusting Basic Settings
Document Exchange

Lesson 2: Key Operations

Key Operations
Data Input
Data Selection
Using the Find Tool
Columns and Rows
Data Sorting

Lesson 3: Introduction to Worksheets

Introduction to Worksheets
Managing Worksheets
Copying, Moving, and Deleting Cells
Freezing and Unfreezing Rows and Columns

Lesson 4: Working with Functions and Formulas

Working with Functions and Formulas
Arithmetic and Logical Formulas
Functions

Lesson 5: Formatting Cells

Formatting Cells
Formatting Cells - Numbers
Formatting Cells - Text
Formatting Cells - Cell Ranges
Spelling

Lesson 6: Using the Print Function

Using the Print Function
Output Preparation
Spreadsheet Printing

Lesson 7: Graphs and Charts

Graphs and Charts
Creating Charts and Graphs
Modifying Charts and Graphs

Module Three: Microsoft Access

Lesson 1: First Steps with Access

First Steps with Access
Concepts
Getting Started
Adjusting Basic Settings

Lesson 2: Creating a Database

Creating a Database
Designing and Planning a Database
Creating a Table
Setting Table Properties
Entering Data

Lesson 3: Making Changes to a Database

Making Changes to a Database
Designing a Table
Validation Rules
Updating a Database
Defining Relationships Between Tables

Lesson 4: Database Forms

Database Forms
Creating a Form
Modifying Form Layout

Lesson 5: Information Retrieval

Information Retrieval
Key Operations
Refining a Query
Selecting and Sorting Data

Lesson 6: Using Database Reports

Using Database Reports
Creating Reports
Modifying Reports

Lesson 7: Printing

Printing
Print Preparation
Printing a Table, Query, or Report

Module Four: Microsoft PowerPoint

Lesson 1: First Steps with PowerPoint

First Steps with PowerPoint
Getting Started
Adjusting Basic Settings
Saving as Another File Format

Lesson 2: Creating a Presentation

Creating a Presentation
Views
Inserting Master Slides
Slides and Design Templates
Copying, Moving, and Deleting Text
Copying, Moving, and Deleting Images
Copying, Moving, and Deleting Slides

Lesson 3: Formatting

Formatting
Formatting Text
Modifying Text Boxes
Adding Headers and Footers

Lesson 4: Graphics and Charts

Graphics and Charts
Creating Drawn Objects
Charts
Images

Lesson 5: Printing and Distribution

Printing and Distribution
Slide Setup
Preparing for Distribution
Print Setup

Lesson 6: Slide Show Animations and Transitions

Slide Show Animations and Transitions
Animation Effects
Using Transitions
Slide Show Options

ABC IT-3: Practical Skills

Module One: Gmail

Topic 0: Understanding E-mail (Introduction)
Topic 1: Signing Up For Gmail
Topic 2: Getting Started With Gmail
Topic 3: Messaging Part One
Topic 4: Messaging Part Two
Topic 5: Quiz

Module Two: Touch Typing

Basic Technique
Left Index Finger
Right Index Finger
Left Middle Finger
Right Middle Finger
Easy to type Words
Left Ring Finger
Right Ring Finger
Left Little Finger
Right Little Finger
Hard to type Words
Common Words
Capital Letters
Capitalized Words
Numbers