ICDL (International Computing Driving License)

This course is for anyone who wishes to achieve the ICDL (International Computing Driving License) qualification.

Aims

By the end of this online course, you will be confident in all 7 ICDL modules needed to pass the ICDL exams.


Download Course Outline

What you will learn

The course will cover the following topics:

  • Module 1 – Concepts of Information and Communication Technology
    Getting started: Computer terminology; Computer hardware; Computer software; Computer memory and storage; Computer accessories
    Using information and communication technology: Using networks; The internet and email; Alternative ways of sending a message; Subscribing to websites; Online communities and social networking
    Computers in everyday life: Computers for home, work and education; Making computers accessible; Working safely with computers; Protecting your work; Protecting your PC
    Legal issues: Copyright; Data protection.
  • Module 2 – Using the computer and managing files
    Understanding your pc: Using power switches; Viewing system information; Changing the date, time and volume settings; Using help
    Using the desktop: Desktop icons; Desktop settings
    Using windows: Parts of a window; Working with Windows; Using applications; Printing
    Working with files: Drives, files and folders; Using my computer; File management; Recycle bin; Finding files; Memory and storage; File compression
    Safety and security: Protecting your work; Virus scanning.
  • Module 3 – Word Processing
    Starting with Word: Opening, Closing, Creating documents, Moving around
    Text basics: Entering text, Selection, Symbols
    Changing the document display: The Ribbon, Views, Zoom
    Editing: Copying and moving, Find and replace, Undo and redo
    Working with text: Bold, italic and underline, Fonts, Text case, Superscript and subscript
    Changing the layout: Bullets and numbers, Indents, Tabs, Spacing, Page breaks
    Adding extras to your page: Headers and footers, Page numbers, Borders and shading
    Saving shortcuts: Default file location, Saving into other file formats
    Styles and themes: Applying and creating styles
    Pictures and drawing: Adding, moving, resizing and deleting pictures
    Charts: Creating and editing charts
    Preparing for printing: Spelling and grammar, Margins, Orientation, Paper size
    Printing: Print preview, printing multiple copies, printing selected pages
    Tables: Creating, editing and formatting tables
    Mail merge: Creating a mail merge letter, merging with recipients.
  • Module 4 – Spreadsheets
    Starting Excel: Starting, Closing and opening spreadsheets, Using help
    Creating worksheets: Selecting, Editing, Undo and redo, Using sheets
    Saving: Saving spreadsheets, Saving in other formats
    Editing a spreadsheet: Inserting and deleting cells, Resizing, Freezing rows and columns
    Viewing worksheets: Changing view and zoom
    Formatting cells: Changing colours and borders
    Formatting data; Bold, italic and underline, Fonts, Colours, Changing number format
    Copying and moving: Copying and moving data and sheets
    Working with data: Using autofill, Find and replace, Sorting, Autosum
    Formulae: Entering calculations, Absolute and mixed cell references
    Functions: Sum, Average, Minimum, Maximum, Count and CountA, If functions, Round
    Charts: Creating and editing charts
    Printing: Print preview, Headers and footers, Page Setup, Print options.
  • Module 5 – Databases
    Understanding Databases: Key Concepts; Database Organisations; Relationships; Operation
    Using Access: Common tasks
    Tables: Records; Design
    Retrieving Information: Main Operations; Queries
    Objects: Forms
    Outputs: Reports, Data Exports; Printing.
  • Module 6 – Presentations
    Using PowerPoint: Working with Presentations; Enhancing Productivity
    Developing a Presentation: Views; Slides; Master Slide
    Text: Formatting; Lists; Tables
    Charts: Using Charts; Organisational Charts
    Graphical Objects: Insert, Manipulate; Drawing
    Prepare Outputs: Preparation; Check and Deliver.
  • Module 7 – Web Browsing and Communication/Using the Internet &
    Email
    The Internet: Concepts/Terms; Security Considerations
    Using the Browser: Basic Browsing; Settings; Navigations; Bookmarks
    Using the Web: Forms; Searching
    Web Outputs: Saving Files; Prepare and Print
    Electronic Communication: Concepts/Terms; Security Considerations; e-mail Theory
    Using e-mail: Sending Receiving; Enhancing Productivity
    e-mail Management: Organise; Address Book.

Requirements

Delegates must be confident in using a keyboard, Windows and a mouse.

How the online course works

The online modules are structured as follows:

How it works

Here you can find out about how our lessons are structured, the style of training we use, and guidance on some of the features you will find in our lessons.

Course materials

Here you will find the manual and the demo files you need to complete the lessons.

Complete the pre-course assessors

Here you can choose a pre-course assessor to assess which lessons you need to take. The pre-course assessors can be taken in any order you wish.

Start lessons

Here you will find the full list of lessons for that module.

Your learning plan

Here you will find lessons that have been added to a structured plan for you based on the results of the pre-course assessors. You can also manually add and remove lessons from this plan.

Next step

Once you have completed this course you will be ready to take your ICDL exams.


Download Course Outline