63 Hours – Instructor Led Course

Center Benefits – ICDL Course
Corporate Venue: Onsite or at NLP Tech for MA
ICDL Accredited Training Provider
ICDL Official Curriculum
ICDL Certified Trainers
Computer Labs: 1 PC for each student
UAE Ministry of Education Accredited Institute
Certificate of Achievement (Ministry Attestation fees apply)
Exams: ICDL Authorized Testing Center (fees included)

Course Outline
ICDL Module 1: Concepts of Information Technology
1 General IT Concepts
Hardware/Software and Information Technology
Types of Computer
Main Parts of a Personal Computer
Computer Performance
Summary
2 Hardware
Central Processing Unit
Memory
Input Devices
Output Devices
Input/Output Devices
Storage Devices
Summary
3 Software
Operating System Software
Application Software
Systems Development
Summary
4 Information Networks
LANs and WANs
The Internet
Intranet and Extranet
The Telephone Network in Computing
Summary
5 Use of IT in Everyday Life
Computers at Work
The Electronic World
Summary

6 Safety and Security: Protecting Your Health, Data,
and Rights
Health and Safety Issues
The Environment
Information Security
Protecting Copyright
Data Protection Act
Summary
Module Review Questions
Answers to Module Review Questions

ICDL Module 2: Using the Computer and Managing Files
7 First Steps with the Computer
First Steps with the Computer
The Basics of the Windows Operating System Interface
Basic Information and Operations
Summary

8 Working with Icons
Selecting, Moving, and Arranging Icons
Basic Types of Icons
Shortcut Icons
Summary

9 Working with Windows
The Parts of a Desktop Window

Applications Windows
Shutting Down a Non-Responsive Application

Capturing the Screen Image and Pasting It into a Document

Installing and Uninstalling Software Applications
Summary

10 Working with Files and Folders
File and Folder Structures
Common Types of Files
Creating Folders and Subfolders
Selecting, Copying, Moving, and Deleting Files and Folders
Compressing Files
Searching for Files and Folders
Recently Used Files
Summary

11 Viruses
What Effect Can Viruses Have?
How Do Viruses Arrive on Your System?
Anti-Virus Software
Summary

12 Editing Text Files
Opening a File in Notepad and WordPad
Using Notepad to Edit and Create Files
Using WordPad to Edit and Create Files
Closing Notepad or WordPad
Summary

13 Printing
Basic Printing
Using the Desktop Print Manager
Printer Setup
Summary
Module Review Questions
Answers to Module Review Questions

ICDL Module 3: Word Processing
14 First Steps With Word Processing
Getting Started in Word
Opening and Creating Word Documents
Saving and Closing Documents
Adjusting Basic Settings
Using Help
Summary

15 Basic Text Operations
Inserting, Editing, and Deleting Text
Selecting, Copying, Moving, and Deleting Data
Searching and Replacing
Checking Spelling and Grammar
Summary

16 Formatting
Formatting Fonts
Formatting Paragraphs
Copying Formats
Tabs, Lists, and Borders
Using Styles

Using Templates
Document Formatting
Page Setup
Summary

17 Tables, Graphics, and Other Objects
Using Tables in Word
Adding Pictures in Word
Adding Other Elements in Word
Summary

18 Word Processing Output
Printing Documents
Mail Merge
Summary
Module Review Questions
Answers to Module Review Questions

ICDL Module 4: Spreadsheets

19 Using the Spreadsheet Application
First Steps with Spreadsheets
Getting Started with Excel
Adjusting Basic Settings
Saving Documents in Different Formats
Summary

20 Cells
Spreadsheet Navigation
Inserting Data
Selecting Data
Editing Data
Duplicating, Moving, and Deleting Cell Contents
Search and Replace
Rows and Columns
Sorting Data
Summary
21 Worksheets
Inserting a New Worksheet
Renaming a Worksheet
Deleting and Copying a Worksheet
Moving Worksheets
Summary

22 Formulas and Functions
Arithmetic Formulas
Cell Referencing
Working with Functions
Summary

23 Formatting Cells and Worksheets
Setting Up a Sample Worksheet
Formatting Numbers and Dates
Formatting Cell Contents
Alignment and Border Effects
Summary
24 Charts and Graphs
Using Charts and Graphs
Summary
25 Preparing Outputs
Worksheet Setup
Preparing the Worksheet for Printing
Printing a Worksheet
Module Review Questions
Answers to Module Review Questions

ICDL Module 5: Databases

26 An Introduction to Databases
Introduction to Databases
Getting Started with Access
Summary

27 Creating a Database
Designing Tables
Creating a New Database
Setting Up Relationships
Data Entry
Organising Data
Summary

28 Retrieving Information Using Queries
Creating Queries
Using Queries
Summary

29 Using Forms
Form Basics
Creating a Form
Working with Forms
Summary

30 Producing Reports
Using Reports
Creating a Report Using Design View
Saving and Deleting Reports
Summary
Module Review Questions
Answers to Module Review Questions
ICDL Module 6: Presentation
31 Getting Started with Presentation Tools
First Steps with PowerPoint
Adjusting Settings in PowerPoint
Developing a Presentation
Summary

32 Using Text and Images in PowerPoint
Text Input and Formatting
Using Images in PowerPoint
Duplicating, Moving, and Deleting Content
Summary
33 Charts, Graphs, and Drawn Objects
Using Charts and Graphs
Drawn Objects
Duplicating, Moving, and Deleting Objects
Summary

34 Slide Show Effects
Pre-Set Animation
Slide Transitions
Summary

35 Preparing PowerPoint Outputs
Preparing a Slide Show for Printing
Printing Your Slide Show
Delivering a Presentation
Summary
Module Review Questions
Answers to Module Review Questions

ICDL Module 7: Information and Communication

36 The Internet
Connecting to the Internet
Internet Basics
Security Considerations
First Steps with the Web Browser
Adjusting Basic Settings in Explorer
Summary
37 Web Navigation
Accessing Web Pages
Using Bookmarks
Summary
38 Web Searching and Printing
Using a Search Engine
Using and Saving Search Results
Printing Web Pages
Summary

39 Electronic Mail
Setting Up Outlook Express
E-mail Basics
E-mail Security Considerations
First Steps with E-mail
Summary
40 E-mail Messaging
Reading and Replying to Messages
Sending Messages
Editing Messages
Summary