ECDL (European Computer Driving Licence)

This course is for anyone who wishes to achieve the ECDL qualification.

Aims

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

What you will learn

In particular you will be able to:

Module 1 – BCS IT Security Level 1: General security: Organisational security; Passwords and security; Secure networks; Losing files
Security when using portable devices: Using portable devices; Using Bluetooth
Email and internet security: Virus scanning; Hoax emails; Dealing with spam.
Module 2 – IT User Fundamentals: 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
Fixing your computer: Maintaining your IT systems; When things go wrong; Fixing a printer; Installing software
Safety and security: Working safely with computers; Protecting your work; Passwords and security; Virus scanning; Dealing with spam
Legalities: Copyright; Data protection.
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 and 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 ECDL exams. If you wish to go to the next level, there is the ECDL Advanced qualification, or the Microsoft Business Certifications.