ICCDL
Syllabus
Contents
Introduction....................................................................................................................................3
Unit 1 –
Use IT Systems (Basic Concepts of IT)
...........................................................................4
Unit 2 –
Using the Computer and Managing Files
........................................................................9
Unit 3 –
Word Processing.............................................................................................................
12
Unit 4 –
Spreadsheets
..................................................................................................................
16
Unit 5 –
Databases.......................................................................................................................
20
Unit 6 –
Presentations
..................................................................................................................
23
Unit 7 –
Information and Communication
...................................................................................
27
ICCDL Version 4.5 3
© ICCDL
Foundation Ltd
Introduction
This document sets
out the syllabus for ICCDL Version 4.5. Version 4.5 contains minor updates to
certain units of ICCDL Version 4.0 in order to align
it more closely with the National Occupational
Standards (NOS)
for IT Users. The updates affect ICCDL modules 1, 2
and 7 only and are specific
to the
All ICCDL units
now fully map to their NOS counterparts ensuring that candidates can progress
to an
ITQ more easily,
should they wish to. The ICCDL modules map to the following NOS units:
ICCDL
Unit NOS Unit
ICCDL Unit 1 Use
IT Systems (Basic Concepts of IT) Use IT Systems Level 1
ICCDL Unit 2 Using
the Computer and Managing Files Operate a Computer Level 1
ICCDL Unit 3 Word
Processing Word Processing Software Level 2
ICCDL Unit 4 Spreadsheets
Spreadsheet Software Level 2
ICCDL Unit 5
Databases Database Software Level 2
ICCDL Unit 6
Presentations Presentation Software Level 2
ICCDL Unit 7
Information and Communication
Internet and
Intranets Level 1
Email Level 1
ICCDL Version 4.5 4
© ICCDL
Foundation Ltd
Unit 1 –
Use IT Systems (Basic Concepts of IT)
Category
Knowledge
Area
Ref.
Knowledge Item
US1.1
General
Concepts
US1.1.1
Hardware,
Software,
Information
Technology
US1.1.1.1
Understand the terms hardware, software,
Information
Technology (IT).
US1.1.2
Types
of
Computer
US1.1.2.1
Understand and distinguish between mainframe
computer, network computer, personal computer,
laptop, personal digital assistant (
capacity, speed, cost, and typical users.
US1.1.3
Main
Parts of a
Personal
Computer
US1.1.3.1 Know the
main parts of a personal computer such
as: central processing unit (CPU), hard disk,
common input and output devices, types of memory.
Understand the
term peripheral device.
US1.1.4
Computer
Performance
US1.1.4.1 Know
some of the factors that impact on a
computer’s performance such as: CPU speed,
size, and the number of applications running.
US1.2
Hardware
US1.2.1
Central
Processing
Unit
US1.2.1.1
Understand some of the functions of the CPU in
terms of calculations, logic control, and immediate
access memory. Know that the speed of the CPU is
measured in megahertz (MHz) or gigahertz (GHz).
US1.2.2
Memory
US1.2.2.1
Understand different types of computer memory
such as:
(read-only memory) and distinguish between them.
US1.2.2.2 Know how
computer memory is measured: bit, byte,
KB,
MB, GB, TB. Relate computer memory
measurements to characters, files and
directories/folders.
US1.2.3
Input
Devices
US1.2.3.1 Identify
some of the main devices for inputting data
into a computer such as: mouse, keyboard,
trackball, scanner, touchpad, lightpen,
joystick,
digital camera, and microphone.
US1.2.4
Output
Devices
US1.2.4.1 Identify
common output devices for displaying the
results of processing carried out by a computer,
such as: monitors, screens, printers, plotters, and
speakers. Know where these devices are used.
US1.2.5
Input/Output
Devices
US1.2.5.1
Understand some devices are both input/output
devices such as: touchscreens.
US1.2.6
Storage
Devices
US1.2.6.1 Compare
the main types of memory storage devices
in terms of speed, cost and capacity such as:
diskette, Zip disk, data cartridges,CD-ROM,
internal,
external hard disk.
US1.2.6.2
Understand the purpose of formatting a disk.
ICCDL Version 4.5 5
© ICCDL
Foundation Ltd
Category
Knowledge
Area
Ref.
Knowledge Item
US1.3
Basic
System
Maintenance
US1.3.1
Typical
Components
US1.3.1.1
Understand a simple system set-up and list the
basic checks required for starting up a computer
such as: power, ensuring cables are connected,
monitors and printers are switched on.
US1.3.2
Operating
System
US1.3.2.1 Describe
the main functions of the operating system.
Understand the
basic difference of the BIOS to the
operating system.
US1.3.3
Error
Indicators
US1.3.3.1 List
some of the common error indicators such as:
flashing lights, bleeps, lack of display, lack of
printer
output, lack of mouse cursor and on screen
messages.
US1.3.4
Resolving
Problems
US1.3.4.1
Understand some basic steps to take in order to
resolve errors such as: checking power supplies,
ensuring printers have paper supplies and checking
external connections.
US1.3.4.2
Understand common procedures for report
problems/errors. Report problems/errors in an
effective way.
US1.3.4.3
Understand the importance of updating operating
systems, software and hardware. Be able to follow
verbal/written instructions to find and access update
files, service packs and drivers on a network or
storage media.
US1.3.4.4
Understand the importance of backing up and
securing data in the context of damage limitation to
stored data and the limitations of such systems.
US1.4
System
Interrogation
US1.4.1
System
Set-Up
US1.4.1.1
Understand where to find, interrogate and list some
of the most relevant areas of a computer setup
such
as: printers, networking, performance and
maintenance areas, basic settings (sound, date,
time).
US1.4.2
Managing
Active
Applications
US1.4.2.1 Know how
and when to activate and use basic
controls to manage active application software such
as checking for and closing non-responsive
programs.
US1.4.3
System
Properties
US1.4.3.1
Understand and know how to access the properties
of a system to find any error indicators
associated
with the hardware of a computer.
US1.4.3.2
Understand the icons indicating storage areas
available to the computer. Differentiate between
hard drive, network and removable media icons.
Understand why
access to some areas may not be
possible and the reasons for this such as: secure
drives, password-protected folders, network and
hardware errors.
ICCDL Version 4.5 6
© ICCDL
Foundation Ltd
Category
Knowledge
Area
Ref.
Knowledge Item
US1.5
The Use
of IT in
Everyday
Life
US1.5.1
Computers
at
Work
US1.5.1.1 Identify
some situations where a computer might be
more appropriate than a person for carrying out a
task and where not.
US1.5.1.2 Know
some of the uses of large-scale computer
applications in business such as: business
administration systems, airline booking systems,
insurance claims processing, online banking.
US1.5.1.3 Know
some of the uses of large-scale computer
applications in government such as: public records
systems (census, vehicle registration), revenue
collection, electronic voting.
US1.5.1.4 Know
some of the uses of large-scale computer
applications in hospitals/healthcare such as: patient
records systems, ambulance control systems,
diagnostic tools and instruments, specialist surgical
equipment.
US1.5.1.5 Know
some of the uses of computer applications in
education such as: student registration and
timetabling systems, computer-based training
(
Internet.
US1.5.1.6
Understand the term teleworking. List some of the
advantages of teleworking such
as: reduced or no
commuting time, greater ability to focus on one task,
flexible schedules, reduced company space
requirements. List some disadvantages of
teleworking such as: lack of human contact, less
emphasis on teamwork.
US1.5.2
Electronic
World
US1.5.2.1
Understand the term electronic mail (e-mail) and
know its main uses.
US1.5.2.2
Understand the term e-Commerce. Understand the
concept of purchasing goods and services online,
including giving personal details before a transaction
can be carried out, payment methods, consumer’s
basic right to return unsatisfactory goods.
US1.5.2.3 List
some of the advantages of purchasing goods
and services online, such as: services available
24
hours a day, opportunity to view a wide range of
products. List some of the disadvantages of
purchasing goods and services online such as:
choosing from a virtual store, no human contact, risk
of insecure payment methods.
ICCDL Version 4.5 7
© ICCDL
Foundation Ltd
Category
Knowledge
Area
Ref.
Knowledge Item
US1.6
Health
and
Safety,
Environment
US1.6.1
Ergonomics
US1.6.1.1
Understand what elements and practices can help
create a good working environment such as:
appropriate positioning of monitors, keyboards and
adjustable chairs, use of a mouse mat, use of a
monitor filter, provision of adequate lighting and
ventilation, frequent breaks away from the computer.
US1.6.1.2 Know
where to find information on health and safety
laws and guidelines that affect the use of IT.
US1.6.2
Health
Issues
US1.6.2.1 List
some common health problems which can be
associated with using a computer such as: injuries
to wrists caused by prolonged typing, eye strain
caused by screen glare, back problems associated
with poor seating or bad posture.
US1.6.3
Precautions
US1.6.3.1 List
some safety precautions when using a computer
such as: ensuring power cables are safely secured,
power points are not overloaded.
US1.6.4
The
Environment
US1.6.4.1 Be aware that recycling printed outputs, recycling
printer toner cartridges, using a monitor that
consumes less power while the computer is inactive
can help the environment.
US1.6.4.2
Understand that using electronic documents can
help reduce the need for printed materials.
US1.7
Security
US1.7.I
Information
Security
US1.7.1.1
Understand the term information security and the
benefits to an organisation
of being proactive in
dealing with security risks such as: adopting an
information security policy with respect to handling
sensitive data, having procedures for reporting
security incidents, making staff members aware of
their responsibilities with respect to information
security.
US1.7.1.2 Know
about privacy issues associated with
computers, such as adopting good password
policies. Understand what is meant by user ID and
differentiate between user ID and password.
Understand the
term access rights and know why
access rights are important.
US1.7.1.3 Know
about the purpose and value of backing up
data, software to a removable storage device.
US1.7.1.4 Be aware of possible implications of theft of a laptop
computer,
misuse of confidential files, loss of files, loss of
important contact details if not available on a
separate source, possible misuse of telephone
numbers.
ICCDL Version 4.5 8
© ICCDL
Foundation Ltd
Category
Knowledge
Area
Ref.
Knowledge Item
US1.7.2
Computer
Viruses
US1.7.2.1
Understand the term virus when used in computing
and understand that there are different types of
virus. Be aware when and how viruses can enter a
computer system.
US1.7.2.2 Know
about anti-virus measures and what to do
when a virus infects a computer. Be aware of the
limitations of anti-virus software. Understand what
‘disinfecting’ files means.
US1.7.2.3
Understand good practice when downloading files,
accessing file attachments, such as: use of virus
scanning software, not opening unrecognised
e-mail
messages, not opening attachments contained
within unrecognised e-mail
messages.
US1.8
Copyright
and
the Law
US1.8.1
Copyright
US1.8.1.1
Understand the concept of copyright when applied
to software, and also to files such as: graphics,
text,
audio, video. Understand copyright issues involved
in downloading information from the Internet.
US1.8.1.2
Understand copyright issues associated with using
and distributing materials stored on removable
media such as CD’s, Zip disks, diskettes.
US1.8.1.3 Know how
to check the Product ID number for a
software product. Understand the terms shareware,
freeware, end-user license agreement.
US1.8.2
Data
Protection
Legislation
US1.8.2.1 Know
about data protection legislation or
conventions in your country. Understand the
implications of data protection legislation for data
subjects and data holders. Describe some of the
uses of personal data.
ICCDL Version 4.5 9
© ICCDL
Foundation Ltd
Unit 2 –
Using the Computer and Managing Files
Category
Skill Set Ref. Task Item
UC1.1
Computer
Environment
UC1.1.1
First
Steps with
the Computer
UC1.1.1.1
Understand how to set up and use a work station
safely including: equipment, layout, health and
safety issues to self and others, and laws and
guidelines that affect the use of IT.
UC1.1.1.2 Start
the computer. Shut down the computer using
an appropriate routine.
UC1.1.1.3 Restart
the computer using an appropriate routine
UC1.1.1.4 Shut down a non-responding application.
UC1.1.2
Basic
Information
and Operations
UC1.1.2.1 View the
computer’s basic system information:
operating system and version number, installed
UC1.1.2.2 Change
the computer’s desktop configuration: date
& time, volume
settings, desktop display options
(colour settings, screen pixel
resolution, screen
saver options).
UC1.1.2.3 Set,
change keyboard language.
UC1.1.2.4 Format
removable disk media: diskette, Zip disk.
UC1.1.2.5 Install,
uninstall a software application.
UC1.1.2.6 Use
keyboard print screen facility and paste
contents into a document.
UC1.1.2.7 Use
available Help functions.
UC1.1.3
Text
Editing
UC1.1.3.1 Launch a
text editing application. Open, create a
file.
UC1.1.3.2 Save the
file to a location on a drive.
UC1.1.3.3 Close
the text editing application.
UC1.2
Desktop
UC1.2.1
Work
with Icons
UC1.2.1.1
Recognize common desktop icons such as those
representing: files, directories/folders, applications,
printers, recycle bin/wastebasket.
UC1.2.1.2 Select
and move desktop icons.
UC1.2.1.3 Open a
file, directory/folder, application from the
desktop.
UC1.2.1.4 Create a
desktop shortcut icon, desktop menu alias.
UC1.2.2
Work
with
Windows
UC1.2.2.1 Identify
the different parts of a window: title bar,
menu bar, toolbar, status bar, scroll bar.
UC1.2.2.2
Collapse, expand, resize, move, close a window.
UC1.2.2.3 Switch
between open windows.
ICCDL Version 4.5 10
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
UC1.3
Managing
Files
UC1.3.1
Concepts
UC1.3.1.1
Understand how an operating system shows drives,
folders, files in a hierarchical structure.
UC1.3.1.2 Know
that the devices used by an operating system
to store files and folders are the hard disk,
diskette,
CD-ROM, network
drives.
UC1.3.2
Directories/Folders
UC1.3.2.1 Navigate
to a file, folder on a drive.
UC1.3.2.2 Create a
directory/folder and a further subdirectory/
sub-folder.
UC1.3.2.3 Open a
window to display directory/folder name,
size, location on drive.
UC1.3.3
Working
with Files
UC1.3.3.1
Recognize common file types: word-processing
files, spreadsheet files, database files,
presentation
files, image files, audio files, video files,
compressed files, temporary files.
UC1.3.3.2 Count
the number of files, files of a particular type,
in a folder (including any files in sub-folders).
UC1.3.3.3 Change file status: read-only/locked, read-write.
UC1.3.3.4 Sort
files by name, size, type, date modified.
UC1.3.3.5
Understand the importance of maintaining correct
file extensions when re-naming files.
UC1.3.3.6 Re-name
files, directories/folders.
UC1.3.4
Duplicate,
Move
UC1.3.4.1 Select a
file, directory/folder individually or as a
group of adjacent, non-adjacent files,
directories/folders.
UC1.3.4.2
Duplicate files, directories/folders between
directories/folders and between drives.
UC1.3.4.3 Move
files, directories/folders between
directories/folders and drives.
UC1.3.4.4
Understand why making a ‘backup’ copy of files to a
removable storage device is important.
UC1.3.5
Delete,
Restore
UC1.3.5.1 Delete
files, directories/folders to the recycle
bin/wastebasket.
UC1.3.5.2 Restore
files, directories/folders from the recycle
bin/wastebasket.
UC1.3.5.3 Empty
the recycle bin/wastebasket.
UC1.3.6
Searching
UC1.3.6.1 Use the
Find tool to locate a file, directory/ folder.
UC1.3.6.2 Search
for files by content, date modified, date
created, size, wildcards.
UC1.3.6.3 View
list of recently used files.
ICCDL Version 4.5 11
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
UC1.3.7
Compressing
Files
UC1.3.7.1
Understand what file compression means.
UC1.3.7.2 Compress
files in a folder on a drive.
UC1.3.7.3 Extract
compressed files from a location on a drive.
UC1.4
Viruses
UC1.4.1
Concepts
UC1.4.1.1 Know
what a virus is and what the effects of a virus
might be.
UC1.4.1.2
Understand some of the ways a virus can be
transmitted onto a computer.
UC1.4.1.3
Understand the advantages of a virus-scanning
application.
UC1.4.1.4
Understand what ‘disinfecting’ files means.
UC1.4.2
Handling
Viruses
UC1.4.2.1 Use a
virus scanning application to scan specific
drives, folders, files.
UC1.4.2.2
Understand why virus-scanning software needs to
be updated regularly.
UC1.5
Print
Management
UC1.5.1
Setup UC1.5.1.1 Change the
default printer from an installed printer
list.
UC1.5.1.2 Install
a new printer on the computer.
UC1.5.2
Print
Outputs
UC1.5.2.1 Print a
document from a text editing application.
UC1.5.2.2 View a
print job’s progress using a desktop print
manager.
UC1.5.2.3 Pause,
re-start, delete a print job using a desktop
print manager.
ICCDL Version 4.5 12
© ICCDL
Foundation Ltd
Unit 3 –
Word Processing
Category
Skill Set Ref. Task Item
WP2.1
Using
the
Application
WP2.1.1
First
Steps with
Word
Processing
WP2.1.1.1 Open
(and close) a word processing application.
WP2.1.1.2 Open
one, several documents.
WP2.1.1.3 Create a
new document (based on default, other
available template).
WP2.1.1.4 Save a
document to a location on a drive.
WP2.1.1.5 Save a
document under another name.
WP2.1.1.6 Save a
document in another file type such as: text
file, Rich Text Format, HTML, template, software
specific file extension, version number.
WP2.1.1.7 Switch
between open documents.
WP2.1.1.8 Use
available Help functions.
WP2.1.1.9 Close a
document.
WP2.1.2
Adjust
Settings
WP2.1.2.1 Change
between page view modes.
WP2.1.2.2 Use
magnification/zoom tools.
WP2.1.2.3
Display, hide built-in toolbars.
WP2.1.2.4
Display, hide non-printing characters.
WP2.1.2.5 Modify
basic options/preferences in the application:
user name, default directory/ folder to open, save
documents.
WP2.2
Operations
WP2.2.1
Insert
Data
WP2.2.1.1
Insert text.
WP2.2.1.2 Insert
special characters, symbols.
WP2.2.2
Select
Data
WP2.2.2.1 Select
character, word, line, sentence, paragraph,
entire body text.
WP2.2.3
Edit
Data
WP2.2.3.1 Edit
content by inserting new characters, words
within existing text, over-typing to replace existing
text.
WP2.2.3.2 Use the
undo, redo command.
ICCDL Version 4.5 13
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
WP2.2.4
Duplicate,
Move,
Delete
WP2.2.4.1
Duplicate text within a document, between open
documents.
WP2.2.4.2 Move
text within a document, between open
documents.
WP2.2.4.3
Delete text.
WP2.2.5
Search
and
Replace
WP2.2.5.1 Use the
search command for a specific word,
phrase.
WP2.2.5.2 Use a
simple replace command for a specific word,
phrase.
WP2.3
Formatting
WP2.3.1
Text
Formatting
WP2.3.1.1 Change
text appearance: font sizes, font types.
WP2.3.1.2 Apply
text formatting such as: bold, italic, underline.
WP2.3.1.3 Apply
subscript, superscript to text.
WP2.3.1.4 Apply
case changes to text.
WP2.3.1.5 Apply
different colours to text.
WP2.3.1.6 Copy
formatting from a piece of text to another
piece of text.
WP2.3.1.7 Apply an
existing style to a word, a line, a
paragraph.
WP2.3.1.8 Use
automatic hyphenation.
WP2.3.2
Paragraph
Formatting
WP2.3.2.1 Insert,
remove paragraph marks.
WP2.3.2.2 Insert,
remove soft carriage return (line break)
marks.
WP2.3.2.3 Align
text left, centre, right, justified.
WP2.3.2.4 Indent
paragraphs: left, right, first line, hanging.
WP2.3.2.5 Apply single, double line spacing within paragraphs.
WP2.3.2.6
Apply spacing above, below paragraphs.
WP2.3.2.7 Set,
remove and use tabs: left, centre, right,
decimal.
WP2.3.2.8
Apply bullets, numbers to a single level list.
Remove bullets,
numbers from a single level list.
WP2.3.2.9 Change
between the style of bullets, numbers in a
single level list from built-in standard options.
WP2.3.2.10 Add a
top and bottom border, box border and
shading to a paragraph.
ICCDL Version 4.5 14
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
WP2.3.3
Document
Formatting
WP2.3.3.1 Change
document orientation, portrait, landscape.
Change paper size.
WP2.3.3.2 Change
margins of entire document, top, bottom,
left, right.
WP2.3.3.3 Insert,
delete a page break in a document.
WP2.3.3.4
Add, modify text in Headers, Footers.
WP2.3.3.5 Add
fields in Headers, Footers: date, page number
information, file location.
WP2.3.3.6 Apply
automatic page numbering to a document.
WP2.4
Objects
WP2.4.1
Tables
WP2.4.1.1 Create a
table ready for text insertion.
WP2.4.1.2 Insert,
edit data in a table.
WP2.4.1.3
Select rows, columns, cells, entire table.
WP2.4.1.4 Insert,
delete, rows and columns.
WP2.4.1.5
Modify column width, row height.
WP2.4.1.6 Modify
cell border width, style, colour.
WP2.4.1.7
Add shading to cells.
WP2.4.2
Pictures,
Images,
Charts
WP2.4.2.1 Insert a
picture, an image, a chart into a document.
WP2.4.2.2 Select a
picture, image, chart in a document.
WP2.4.2.3
Duplicate a picture, image, chart within a document,
between open documents.
WP2.4.2.4 Move a
picture, image, chart within a document, to
another document.
WP2.4.2.5 Resize a
picture, image, chart.
WP2.4.2.6 Delete a
picture, image, chart.
WP2.5
Mail
Merge
WP2.5.1
Concept
and
Practice
WP2.5.1.1
Understand the term mail merge and the concept of
merging a data source with a main document such
as a letter or a label document.
WP2.5.1.2 Open,
prepare a main document for a mail merge
by inserting data fields.
WP2.5.1.3 Open,
prepare a mailing list, other data file, for use
in a mail merge.
WP2.5.1.4 Merge a
mailing list with a letter, label document.
ICCDL Version 4.5 15
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
WP2.6
Prepare
Outputs
WP2.6.1
Preparation
WP2.6.1.1
Understand the importance of proofing your
document such as: checking the layout,
presentation (margins, appropriate font sizes and
formats) and spelling.
WP2.6.1.2
Spell-check a document and make changes such
as correcting spelling errors, deleting repeated
words.
WP2.6.1.3 Add
words to a built-in custom dictionary.
WP2.6.1.4 Preview
a document.
WP2.6.2
Printing
WP2.6.2.1 Choose
print output options such as: entire
document, specific pages, number of copies.
WP2.6.2.2 Print a
document from an installed printer using
defined options, default settings.
ICCDL Version 4.5 16
© ICCDL
Foundation Ltd
Unit 4 –
Spreadsheets
Category
Skill Set Ref. Task Item
SS2.1
Using
the
Application
SS2.1.1
First
Steps with
Spreadsheets
SS2.1.1.1 Open
(and close) a spreadsheet application.
SS2.1.1.2 Open
one, several spreadsheets.
SS2.1.1.3 Create a
new spreadsheet (default template).
SS2.1.1.4 Save a
spreadsheet to a location on a drive.
SS2.1.1.5 Save a
spreadsheet under another name.
SS2.1.1.6 Save a
spreadsheet in another file type such as: text
file, HTML, template, software specific file
extension,
version number.
SS2.1.1.7 Switch
between worksheets, open spreadsheets.
SS2.1.1.8 Use
available Help functions.
SS2.1.1.9 Close a
spreadsheet.
SS2.1.2
Adjust
Settings
SS2.1.2.1 Use
magnification/zoom tools.
SS2.1.2.2
Display, hide built-in toolbars.
SS2.1.2.3 Freeze,
unfreeze row and/or column titles.
SS2.1.2.4 Modify
basic options/preferences in the application:
user name, default directory/ folder to open, save
spreadsheets.
SS2.2
Cells
SS2.2.1
Insert
Data
SS2.2.1.1 Enter a
number, date, text in a cell.
SS2.2.2
Select
Cells
SS2.2.2.1 Select a
cell, range of adjacent cells, range of nonadjacent
cells, entire worksheet.
SS2.2.2.2 Select a
row, range of adjacent rows, range of nonadjacent
rows.
SS2.2.2.3 Select a
column, range of adjacent columns, range
of non-adjacent columns.
SS2.2.3
Rows
and
Columns
SS2.2.3.1 Insert
rows, columns in a worksheet.
SS2.2.3.2 Delete
rows, columns in a worksheet.
SS2.2.3.3
Modify column widths, row heights.
SS2.2.4
Edit
Data
SS2.2.4.1 Insert
additional cell content, replace existing cell
content.
SS2.2.4.2 Use the
undo, redo command.
ICCDL Version 4.5 17
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
SS2.2.5
Duplicate,
Move,
Delete
SS2.2.5.1
Duplicate the content of a cell, cell range within a
worksheet, between worksheets, between open
spreadsheets.
SS2.2.5.2 Use the autofill tool/copy handle tool to copy,
increment data entries.
SS2.2.5.3 Move the
contents of a cell, cell range within a
worksheet, between worksheets, between open
spreadsheets.
SS2.2.5.4
Delete cell contents.
SS2.2.6
Search
and
Replace
SS2.2.6.1 Use the
search command for specific content in a
worksheet.
SS2.2.6.2 Use the
replace command for specific content in a
worksheet.
SS2.2.7
Sort
Data
SS2.2.7.1 Sort a
cell range by one criterion in ascending,
descending numeric order, ascending, descending
alphabetic order.
SS2.3
Worksheets
SS2.3.1
Handling
Worksheets
SS2.3.1.1 Insert a
new worksheet.
SS2.3.1.2 Rename a
worksheet.
SS2.3.1.3 Delete a
worksheet.
SS2.3.1.4
Duplicate a worksheet within a spreadsheet,
between open spreadsheets.
SS2.3.1.5 Move a
worksheet within a spreadsheet, between
open spreadsheets.
SS2.4
Formulas
and
Functions
SS2.4.1
Arithmetic
Formulas
SS2.4.1.1 Generate
formulas using cell references and
arithmetic operators (addition, subtraction,
multiplication, division).
SS2.4.1.2
Recognize and understand standard error values
associated with using formulas.
SS2.4.2
Cell
Referencing
SS2.4.2.1
Understand and use relative, mixed, absolute cell
referencing in formulas.
SS2.4.3
Working
with
Functions
SS2.4.3.1 Generate
formulas using sum, average, minimum,
maximum, count, functions.
SS2.4.3.2 Generate
formulas using the logical function if
(yielding one of two specific values).
ICCDL Version 4.5 18
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
SS2.5
Formatting
SS2.5.1
Numbers/Dates
SS2.5.1.1 Format
cells to display numbers to a specific
number of decimal places, to display numbers with,
without commas to indicate thousands.
SS2.5.1.2 Format
cells to display a date style.
SS2.5.1.3 Format
cells to display a currency symbol.
SS2.5.1.4 Format
cells to display numbers as percentages.
SS2.5.2
Contents
SS2.5.2.1 Change
cell content appearance: font sizes, font
types.
SS2.5.2.2 Apply
formatting to cell contents such as: bold, italic,
underline, double underline.
SS2.5.2.3 Apply
different colours to cell content, cell
background.
SS2.5.2.4 Copy the
formatting from a cell, cell range to another
cell, cell range.
SS2.5.2.5 Apply
text wrapping to contents within a cell.
SS2.5.3
Alignment,
Border
Effects
SS2.5.3.1 Align
contents in a cell, cell range: left, centre, right,
top, bottom.
SS2.5.3.2 Centre a
title over a cell range.
SS2.5.3.3 Adjust
cell content orientation.
SS2.5.3.4 Add
border effects to a cell, cell range.
SS2.6
Charts/Graphs
SS2.6.1
Using
Charts/Graphs
SS2.6.1.1 Create
different types of charts/graphs from
spreadsheet data: column chart, bar chart, line
chart, pie chart.
SS2.6.1.2 Add a
title, label to the chart/graph. Remove a title,
label from the chart/graph.
SS2.6.1.3 Change
the background colour in a chart/ graph.
SS2.6.1.4 Change
the column, bar, line, pie slice colours in the
chart/graph.
SS2.6.1.5 Change
the chart/graph type.
SS2.6.1.6
Duplicate, move charts/graphs within a worksheet,
between open spreadsheets.
SS2.6.1.7 Resize,
delete charts/graphs.
ICCDL Version 4.5 19
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
SS2.7
Prepare
Outputs
SS2.7.1
Worksheet
Setup
SS2.7.1.1 Change
worksheet margins: top, bottom, left, right.
SS2.7.1.2 Change
worksheet orientation: portrait, landscape.
Change paper size.
SS2.7.1.3 Adjust
page setup to fit worksheet contents on one
page, on a specific number of pages.
SS2.7.1.4
Add, modify text in Headers, Footers in a worksheet.
SS2.7.1.5 Insert
fields: page numbering information, date,
time, file name, worksheet name into Headers,
Footers.
SS2.7.2
Preparation
SS2.7.2.1
Understand the importance of checking spreadsheet
calculations and text before distribution.
SS2.7.2.2 Preview
a worksheet.
SS2.7.2.3 Turn on,
off display of gridlines, display of row and
column headings for printing purposes.
SS2.7.2.4 Apply
automatic title row(s) printing on every page of
a printed worksheet.
SS2.7.3
Printing
SS2.7.3.1 Print a
cell range from a worksheet, an entire
worksheet, number of copies of a worksheet, the
entire spreadsheet, a selected chart.
ICCDL Version 4.5 20
© ICCDL
Foundation Ltd
Unit 5 –
Databases
Category
Skill Set Ref. Task Item
DB2.1
Using
the
Application
DB2.1.1
Database
Concepts
DB2.1.1.1
Understand what a database is.
DB2.1.1.2
Understand how a database is organised in terms of
tables, records, fields, and with field data types,
field
properties.
DB2.1.1.3
Understand what a primary key is.
DB2.1.1.4
Understand what an index is.
DB2.1.1.5
Understand the purpose of relating tables in a
database.
DB2.1.1.6
Understand the importance of setting rules to ensure
relationships between tables are valid.
DB2.1.2
First
Steps with
Databases
DB2.1.2.1 Open
(and close) a database application.
DB2.1.2.2
Open, log onto an existing database.
DB2.1.2.3 Create a
new database.
DB2.1.2.4 Save a
database to a location on a drive.
DB2.1.2.5 Use
available Help functions.
DB2.1.2.6 Close a
database.
DB2.1.3
Adjust
Settings
DB2.1.3.1 Change
between view modes in a table, form,
report.
DB2.1.3.2
Display, hide built-in toolbars.
DB2.2
Tables
DB2.2.1
Main
Operations
DB2.2.1.1 Create
and save a table and specify fields with their
data types.
DB2.2.1.2
Add, delete records in a table.
DB2.2.1.3 Add a
field to an existing table.
DB2.2.1.4
Add, modify data in a record.
DB2.2.1.5
Delete data in a record.
DB2.2.1.6 Use the
undo command.
DB2.2.1.7 Navigate
within a table to next record, previous
record, first record, last record, specific record.
DB2.2.1.8 Delete a
table
DB2.2.1.9 Save and
close a table.
ICCDL Version 4.5 21
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
DB2.2.2
Define
Keys
DB2.2.2.1 Define a
primary key.
DB2.2.2.2 Index a
field with, without duplicates allowed.
DB2.2.3
Table
Design/Layout
DB2.2.3.1 Change
field format attributes such as: field size,
number format, date format.
DB2.2.3.2
Understand consequences of changing field size
attributes in a table.
DB2.2.3.3 Create a
simple validation rule for number, text,
date/time, currency.
DB2.2.3.4
Change width of columns in a table.
DB2.2.3.5 Move a
column within a table.
DB2.2.4
Table
Relationships
DB2.2.4.1 Create a
one-to-one, one-to-many relationship
between tables.
DB2.2.4.2
Delete relationships between tables.
DB2.2.4.3 Apply
rule(s) to relationships such that fields that
join tables are not deleted as long as links to
another table exist.
DB2.3
Forms
DB2.3.1
Working
with
Forms
DB2.3.1.1 Open a
form.
DB2.3.1.2 Create
and save a form.
DB2.3.1.3 Use a
form to enter, modify, delete records.
DB2.3.1.4 Go to
next record, previous record, first record, last
record, specific record using form display.
DB2.3.1.5
Add, modify text in Headers, Footers in a form.
DB2.3.1.6 Delete a
form.
DB2.3.1.7 Save and
close a form.
DB2.4
Retrieving
Information
DB2.4.1
Main
Operations
DB2.4.1.1 Use the
search command for a specific word,
number, date in a field.
DB2.4.1.2 Apply a
filter to a table, form.
DB2.4.1.3 Remove a
filter from a table, form.
ICCDL Version 4.5 22
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
DB2.4.2
Queries
DB2.4.2.1 Create
and save a single table query, two-table
query using specific search criteria.
DB2.4.2.2 Add
criteria to a query using any of the following
operators: < (Less than), <= (Less than or
equals), >
(Greater than),
>= (Greater than or equals), =
(Equals), <>
(Not equal to), And, Or.
DB2.4.2.3 Edit a
query by adding, removing criteria.
DB2.4.2.4 Edit a
query: add, remove, move, hide, unhide
fields.
DB2.4.2.5 Run a
query.
DB2.4.2.6 Delete a
query.
DB2.4.2.7 Save and
close a query.
DB2.4.3
Sort
Records
DB2.4.3.1 Sort
data in a table, form, query output, in
ascending, descending numeric, alphabetic order.
DB2.5
Reports
DB2.5.1
Working
with
Reports
DB2.5.1.1 Create
and save a report based on a table, query.
DB2.5.1.2 Change
arrangement of data fields and headings
within a report layout.
DB2.5.1.3 Group
data under a specific heading (field) in a
report in ascending, descending order.
DB2.5.1.4 Present
specific fields in a grouped report by sum,
minimum, maximum, average, count, at appropriate
break points.
DB2.5.1.5
Add, modify text in Headers, Footers in a report.
DB2.5.1.6 Delete a
report.
DB2.5.1.7 Save and
close a report.
DB2.6
Prepare
Outputs
DB2.6.1
Prepare
to Print
DB2.6.1.1 Preview
a table, form, report.
DB2.6.1.2 Change
report orientation: portrait, landscape.
Change paper size.
DB2.6.2
Print
Options
DB2.6.2.1 Print a
page, selected record(s), complete table.
DB2.6.2.2 Print
all records using form layout, specific pages
using form layout.
DB2.6.2.3 Print the
result of a query.
DB2.6.2.4
Print specific page(s) in a report, complete report.
ICCDL Version 4.5 23
© ICCDL
Foundation Ltd
Unit 6 –
Presentations
Category
Skill Set Ref. Task Item
PR2.1
Using
the
Application
PR2.1.1
First
Steps with
Presentations
PR2.1.1.1 Open
(and close) a presentation application.
PR2.1.1.2 Open
one, several presentations.
PR2.1.1.3 Create a
new presentation (default template).
PR2.1.1.4 Save a
presentation to a location on a drive.
PR2.1.1.5 Save a
presentation under another name.
PR2.1.1.6 Save a
presentation in another file type such as:
Rich Text Format,
template, image file format,
software specific file extension, version number.
PR2.1.1.7 Switch
between open presentations.
PR2.1.1.8 Use
available Help functions.
PR2.1.1.9 Close a
presentation.
PR2.1.2
Adjust
Settings
PR2.1.2.1 Use
magnification/zoom tools.
PR2.1.2.2
Display, hide built-in toolbars.
PR2.1.2.3 Modify
basic options/preferences in the application:
user name, default directory/ folder to open, save
presentations.
PR2.2
Developing
a
Presentation
PR2.2.1
Presentation
Views
PR.2.1.1
Understand the uses of different presentation view
modes.
PR.2.1.2 Change
between presentation view modes.
PR2.2.2
Slides
PR2.2.2.1 Add a
new slide with a specific slide layout such as:
title slide, chart and text, bulleted list, table.
PR2.2.2.2 Change
between built-in slide layouts.
PR2.2.2.3 Change
background colour on specific slide(s), all
slides.
PR2.2.3
Using
Design
Templates
PR2.2.3.1 Apply an
available design template to a
presentation.
PR2.2.3.2 Change
between available design templates.
ICCDL Version 4.5 24
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
PR2.2.4
Master
Slide
PR2.2.4.1 Insert a
picture, image, drawn object into a master
slide. Remove a picture, image, drawn object from a
master slide.
PR2.2.4.2 Add text
into Footer of specific slides, all slides in a
presentation.
PR2.2.4.3 Apply
automatic slide numbering, automatically
updated date, non-updating date into Footer of
specific slides, all slides in a presentation.
PR2.3
Text and
Images
PR2.3.1
Text
Input,
Formatting
PR2.3.1.1 Add text
into a presentation in standard, outline
view.
PR2.3.1.2 Edit
slide content, notes pages content by inserting
new characters, words.
PR2.3.1.3 Change
text appearance: font sizes, font types.
PR2.3.1.4 Apply
text formatting such as: bold, italic, underline.
PR2.3.1.5 Apply
case changes to text.
PR2.3.1.6 Apply
different colours to text.
PR2.3.1.7 Apply
shadow to text.
PR2.3.1.8 Align
text: left, centre, right in a slide.
PR2.3.1.9 Adjust
line spacing before and after bulleted,
numbered points.
PR2.3.1.10 Change
between the style of bullets, numbers in a
list from built-in standard options.
PR2.3.1.11 Use the
undo, redo command.
PR2.3.2
Pictures,
Images
PR2.3.2.1 Insert a
picture into a slide.
PR2.3.2.2 Insert
an image into a slide.
PR2.3.3
Duplicate,
Move,
Delete
PR2.3.3.1
Duplicate text, pictures, images within the
presentation, between open presentations.
PR2.3.3.2 Move
text, pictures, images within the presentation,
between open presentations.
PR2.3.3.3 Resize
pictures, images in a presentation.
PR2.3.3.4
Delete text, pictures, images in a slide.
ICCDL Version 4.5 25
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
PR2.4
Charts/Graphs,
Drawn
Objects
PR2.4.1
Using
Charts/
Graphs
PR2.4.1.1 Input
data to create, modify different kinds of built-in
charts/graphs in a slide: column, bar, line, pie.
PR2.4.1.2 Change
the background colour in the chart/ graph.
PR2.4.1.3 Change
the column, bar, line, pie slice colours in the
chart/graph.
PR2.4.1.4 Change
the chart/graph type.
PR2.4.2
Organisation
Charts
PR2.4.2.1 Create
an organisation chart with a labelled
hierarchy. (Use a built-in organisation
chart feature).
PR2.4.2.2 Change
the hierarchical structure of an organisation
chart.
PR2.4.2.3 Add,
remove managers, co-workers, sub-ordinates
in an organisation
chart.
PR2.4.3
Drawn
Objects
PR2.4.3.1 Add
different types of drawn object to a slide: line,
free drawn line, arrow, rectangle, square, circle,
text
box, other available shapes.
PR2.4.3.2 Change
drawn object background colour, line
colour, line weight, line style.
PR2.4.3.3
Change arrow start style, arrow finish style.
PR2.4.3.4 Apply a
shadow to a drawn object.
PR2.4.3.5 Rotate,
flip a drawn object.
PR2.4.3.6 Align a
drawn object: left, centre, right, top, bottom
of a slide.
PR2.4.3.7 Resize
drawn object, chart within the presentation.
PR2.4.3.8 Bring an
object to the front, back.
PR2.4.4
Duplicate,
Move,
Delete
PR2.4.4.1
Duplicate a chart/graph, drawn object within the
presentation, between open presentations.
PR2.4.4.2 Move a
chart/graph, drawn object within the
presentation, between open presentations.
PR2.4.4.3 Delete a
chart/graph, drawn object.
PR2.5
Slide Show
Effects
PR2.5.1
Preset
Animation
PR2.5.1.1 Add
preset text, image animation effects to slides.
Change preset
animation effects on text, images.
PR2.5.2
Transitions
PR2.5.2.1 Add
transition effects between slides. Change slide
transition effects between slides.
ICCDL Version 4.5 26
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
PR2.6
Prepare
Outputs
PR2.6.1
Preparation
PR2.6.1.1 Select
appropriate output format for slide
presentation such as: overhead, handout, 35 mm
slides, on-screen show.
PR2.6.1.2
Spell-check a presentation and make changes such
as: correcting spelling errors, deleting repeated
words.
PR2.6.1.3 Add
notes for the presenter to slides.
PR2.6.1.4 Change
slide setup, slide orientation to portrait,
landscape. Change paper size.
PR2.6.1.5
Duplicate, move slides within the presentation,
between open presentations.
PR2.6.1.6 Delete a
slide, slides.
PR2.6.2
Printing
PR2.6.2.1 Print
entire presentation, specific slides, handouts,
notes pages, outline view of slides, number of
copies of a presentation.
PR2.6.3
Deliver
a
Presentation
PR2.6.3.1 Hide,
show slides.
PR2.6.3.2 Start a
slide show, start a slide show on any slide.
ICCDL Version 4.5 27
© ICCDL
Foundation Ltd
Unit 7 –
Information and Communication
Category
Skill Set Ref. Task Item
IC1.1
The
Internet
IC1.1.1
Concepts/Terms
IC1.1.1.1
Understand and distinguish between the Internet
and the World Wide Web (
IC1.1.1.2 Define
and understand the terms: HTTP, URL,
hyperlink, ISP, FTP.
IC1.1.1.3
Understand the make-up and structure of a Web
address.
IC1.1.1.4 Know
what a Web Browser is and what it is used for.
IC1.1.1.5 Know
what a Search Engine is and what it is used
for.
IC1.1.1.6
Understand the terms cookie, cache.
IC1.1.2
Security
Considerations
IC1.1.2.1 Know
what a protected Web site is, (use of
username and password).
IC1.1.2.2 Know
what a digital certificate is.
IC1.1.2.3 Know
what encryption is and why it is used.
IC1.1.2.4 Be aware of the danger of infecting the computer
with a virus from a downloaded file.
IC1.1.2.5 Be aware of the possibility of being subject to fraud
when using a credit card on the Internet.
IC1.1.2.6
Understand the term firewall.
IC1.1.3
First
Steps with
the Web
Browser
IC1.1.3.1 Open
(and close) a Web browsing application.
IC1.1.3.2 Change
the Web browser Home Page/ Startpage.
IC1.1.3.3 Display
a Web page in a new window.
IC1.1.3.4 Stop a
Web page from downloading.
IC1.1.3.5 Refresh
a Web page.
IC1.1.3.6 Use
available Help functions.
IC1.1.4
Adjust
Settings
IC1.1.4.1
Display, hide built-in toolbars.
IC1.1.4.2
Display, hide images on a Web page.
IC1.1.4.3 Display
previously visited URLs using the browser
address bar.
IC1.1.4.4 Delete
browsing history.
ICCDL Version 4.5 28
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
IC1.2
Web
Navigation
IC1.2.1
Accessing
Web
Pages
IC1.2.1.1 Go to a
URL.
IC1.2.1.2 Activate
a hyperlink/image link.
IC1.2.1.3 Navigate
backwards and forwards between
previously visited Web pages.
IC1.2.1.4 Complete
a Web-based form and enter information
in order to carry out a transaction.
IC1.2.2
Using
Bookmarks
IC1.2.2.1 Bookmark
a Web page.
IC1.2.2.2 Display
a bookmarked Web page.
IC1.2.3
Organizing
Bookmarks
IC1.2.3.1 Create a
bookmark folder.
IC1.2.3.2 Add Web
pages to a bookmark folder.
IC1.2.3.3 Delete a
bookmark.
IC1.3
Web
Searching
IC1.3.1
Using
a Search
Engine
IC1.3.1.1 Select a
specific search engine.
IC1.3.1.2 Carry
out a search for specific information using a
keyword, phrase.
IC1.3.1.3
Combine selection criteria in a search.
IC1.3.1.4
Duplicate text, image, URL from a Web page to a
document.
IC1.3.1.5 Save a
Web page to a location on a drive as a txt
file, html file.
IC1.3.1.6 Download
text file, image file, sound file, video file,
software, from a Web page to a location on a drive.
IC1.3.2
Preparation
IC1.3.2.1 Preview
a Web page.
IC1.3.2.2 Change
Web page orientation: portrait, landscape.
Change paper size.
IC1.3.2.3 Change
Web page margins top, bottom, left, right.
IC1.3.3
Printing
IC1.3.3.1 Choose
Web page print output options such as:
entire Web page, specific page(s), specific frame,
selected text, number of copies and print.
ICCDL Version 4.5 29
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
IC1.4
Electronic
Mail
IC1.4.1
Concepts/Terms
IC1.4.1.1
Understand the make-up and structure of an e-mail
address.
IC1.4.1.2
Understand the advantages and disadvantages of
different e-mail systems such as: speed of delivery,
low cost, additional functions such as formatting
options, attachment restrictions, memory space and
the flexibility of using a Web-based e-mail
account in
different locations.
IC1.4.1.3
Understand the importance of network etiquette
(netiquette) such as: using accurate descriptions in
e-mail message subject fields, brevity in e-mail
responses, spell checking outgoing e-mail and text
formatting techniques.
IC1.4.2
Security
Considerations
IC1.4.2.1
Understand guidelines and regulations on using
email such as sensitive content, phishing,
identity
theft, and common business rules and regulations.
IC1.4.2.2 Be aware of the possibility of receiving unsolicited email
and the associated dangers of infecting the
computer with a virus by opening an unrecognized
mail message, an attachment contained within an
unrecognized mail message.
IC1.4.2.3 Know
what a digital signature is.
IC1.4.3
First
Steps with
E-mail
IC1.4.3.1 Open
(and close) an e-mail application.
IC1.4.3.2 Open a
mail inbox for a specified user.
IC1.4.3.3 Open
one, several mail messages.
IC1.4.3.4 Switch
between open messages.
IC1.4.3.5 Close a
mail message.
IC1.4.3.6 Use
available Help functions.
IC1.4.4
Adjust
Settings
IC1.4.4.1 Add,
remove message inbox headings such as:
sender, subject, date received.
IC1.4.4.2
Display, hide built-in toolbars.
IC1.5
Messaging
IC1.5.1
Read
a
Message
IC1.5.1.1 Flag a
mail message. Remove a flag mark from a
mail message.
IC1.5.1.2 Mark a
message as unread, read.
IC1.5.1.3 Open and
save a file attachment to a location on a
drive and consider potential problems when trying to
receive an attachment such as: file types, automatic
anti-virus settings, network settings.
ICCDL Version 4.5 30
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
IC1.5.2
Reply
to a
Message
IC1.5.2.1 Use the
reply, reply to all function.
IC1.5.2.2 Reply
with, without original message insertion.
IC1.5.3
Send
a Message
IC1.5.3.1 Create a
new message using netiquette and
formatting tools such as font, style and colour
changes, layout, bullets and indents.
IC1.5.3.2 Insert a
mail address in the ‘To’ field.
IC1.5.3.3 Copy
(Cc), blind copy (Bcc) a message to another
address/addresses.
IC1.5.3.4 Insert a
title in the ‘Subject’ field.
IC1.5.3.5 Use a
spell-checking tool if available and make
changes such as: correcting spelling errors, deleting
repeated words.
IC1.5.3.6 Attach a file to a message and consider potential
problems when trying to send attachments such as
file sizes, file types, anti-virus restrictions,
network
restrictions.
IC1.5.3.7 Send a
message with high, low priority.
IC1.5.3.8 Send a
message using a distribution list.
IC1.5.3.9 Forward
a message.
IC1.5.4
Duplicate,
Move,
Delete
IC1.5.4.1
Duplicate, move text within a message, or between
other active messages.
IC1.5.4.2
Duplicate text from another source into a message.
IC1.5.4.3
Delete text in a message.
IC1.5.4.4 Delete a
file attachment from an outgoing message.
IC1.6
Mail
Management
IC1.6.1
Techniques
IC1.6.1.1 Recognise some techniques to manage e-mail
effectively such as creating and naming folders,
moving messages to appropriate folders, deleting
unrequired e-mail, using address lists.
IC1.6.2
Using
Address
Books
IC1.6.2.1 Create a
new address list/distribution list.
IC1.6.2.2 Add a
mail address to an address list.
IC1.6.2.3 Delete a
mail address from an address list.
IC1.6.2.4 Update
an address book from incoming mail.
ICCDL Version 4.5 31
© ICCDL
Foundation Ltd
Category
Skill Set Ref. Task Item
IC1.6.3
Organising
Messages
IC1.6.3.1 Search
for a message by sender, subject, mail
content.
IC1.6.3.2 Create a
new folder for mail.
IC1.6.3.3 Move
messages to a new folder for mail.
IC1.6.3.4 Sort
messages by name, by date.
IC1.6.3.5 Delete a
message.
IC1.6.3.6 Restore
a message from the mail bin/deleted items
folder.
IC1.6.3.7 Empty
the mail bin/deleted items folder.
IC1.6.4
Prepare
to Print
IC1.6.4.1 Preview
a message.
IC1.6.4.2 Choose
print output options such as: entire
message, selected contents of a message, number
of
copies and print.