ICDL Essentials Level 1 Award

In order to achieve the ICDL Essentials Level 1 Award you will need to pass the below modules:

IT User Fundamentals

• - Use the right IT systems to meet your needs;
• - Organise, store and access information on the desktop or in folders and files;
• - Follow and understand the need for online safety; and
• - Carry out routine maintenance of IT systems, like updating your software and maintaining your drives and discs.

Electronic Communication

• - Send, receive and organise emails using Microsoft Outlook Express;
• - Use attachments;
• - Manage an address book of contacts or distribution lists;
• - Use instant messaging and internet conferencing;
• - Plan your social life by using the internet and social media to find information, organise events and buy tickets;
• - Use a search engine to find, bookmark, save and print information from websites;
• - Buy and pay for goods safely on the web;
• - Use the calendar and task manager in Outlook to plan events and manage your time and tasks;
• - Download useful software and use the internet to transfer files legally and safely; and
• - Publish information on your own website, web space or blog.

IT Security for Users

• - Create user accounts and passwords to protect your personal data on the web;
• - Understand the risks of online communities and social networking;
• - Understand different types of malware and what they can do to your computer;
• - Prevent viruses getting onto your computer through spam email;
• - Avoid online fraud, like phishing scams;
• - Keep your network secure, especially when using wi-fi;
• - Back up data and recognise different portable storage devices like USB sticks and recordable DVDs; and
• - Understand how data protection laws work.

ICDL Core

In order to achieve the ICDL Level 2 Certificate you will need to pass the below modules :

Security for IT Users

• - Create user accounts and passwords to protect your personal data on the web
• - Understand the risks of online communities and social networking;
• - Understand different types of malware and what they can do to your computer;
• - Prevent viruses getting onto your computer through spam email;
• - Avoid online fraud, like phishing scams;
• - Keep your network secure, especially when using wi-fi;
• - Back up data and recognise different portable storage devices like USB sticks and recordable DVDs; and
• - Understand how data protection laws work.

IT User Fundamentals

• - Using a variety of software’s and applications
• - Organise, store and access information on the desktop or in folders and files
• - Follow and understand the need for online safety
• - Carry out routine maintenance of IT systems, like updating your software and maintaining your drives and discs

Microsoft Word

• - Work with documents and save them in different file formats, locally or in the cloud.
• - Use available help resources, shortcuts and the go to tool to enhance productivity.
• - Create and edit word processing documents that will be ready to share and distribute.
• - Apply different formats and styles to enhance documents and recognise good practice in choosing the appropriate formatting options.
• - Insert tables, pictures and drawn objects into documents.
• - Prepare documents for mail merge operations.
• - Adjust document page settings and check and correct spelling before printing.

Microsoft Excel

• - Work with spreadsheets and save them in different file formats, locally or in the cloud.
• - Use available help resources, shortcuts and the go to tool to enhance productivity.
• - Enter data into cells and use good practice in creating lists. Select, sort and copy, move and delete data.
• - Edit rows and columns in a worksheet. Copy, move, delete and appropriately rename worksheets.
• - Create mathematical and logical formulas using standard spreadsheet functions. Use good practice in formula creation and recognizing error.
• - Format numbers and text content in a spreadsheet and use available autoformat/table styles.
• - Choose suitable charts, and create and format charts to communicate information meaningfully.
• - Adjust spreadsheet page settings and check and correct spreadsheet content before printing.

Microsoft Access

• - Understand what a database is and how it is organised and operated
• - Create a simple database and view the database content in various modes
• - Create a table, define and modify fields and their properties; enter and edit data in a table
• - Sort and filter a table or form; create, modify and run queries to retrieve specific information from a database
• - Understand what a form is and create a form to enter, modify and delete records and data in records
• - Create routine reports and prepare outputs ready for distribution

Microsoft PowerPoint

• - Work with presentations and save them in different file formats, locally or in the cloud.
• - Use available help resources to enhance productivity.
• - Understand different presentation views and when to use them, choose different built-in slide layouts, designs and themes.
• - Enter, edit and format text and tables in presentations. Recognise good practise in applying unique titles to slides and creating consistent slide content.
• - Choose, create and format charts to communicate information meaningfully.
• - Insert, edit and align pictures and drawn objects.
• - Apply animation and transition effects to presentations, and check and correct presentation content before printing and presenting.

Using the Internet and Email

• - Send, receive and organise emails using Microsoft Outlook Express;
• - Use attachments;
• - Manage an address book of contacts or distribution lists;
• - Use instant messaging and internet conferencing;
• - Plan your social life by using the internet and social media to find information, organise events and buy tickets;
• - Use a search engine to find, bookmark, save and print information from websites;
• - Buy and pay for goods safely on the web;
• - Use the calendar and task manager in Outlook to plan events and manage your time and tasks;
• - Download useful software and use the internet to transfer files legally and safely; and
• - How to be safe online

ICDL Advanced

In order to achieve the ICDL Advanced Level 3 Certificate you will need to pass the below modules :

ICDL ADVANCED – WORD PROCESSING

• - Apply advanced text, paragraph, column and table formatting.
• - Maintain a consistent design through the use of character and paragraph styles.
• - Work with referencing features like footnotes, endnotes and captions. Manage citations and bibliography using a chosen citation style.
• - Create tables of contents, indexes and cross-references.
• - Enhance productivity by using fields, forms and templates.
• - Apply advanced mail merge techniques and work with automation features like macros.
• - Use linking and embedding features to integrate data.
• - Collaborate on and review documents locally or online. Apply document security features.
• - Work with watermarks, sections, and headers and footers in a document. Use a thesaurus and manage spell check settings.

ICDL ADVANCED – SPREADSHEETS

• - Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets.
• - Use functions such as those associated with logical, statistical, financial and mathematical operations.
• - Create charts and apply advanced chart formatting.
• - Work with tables and lists to analyse, filter and sort data. Create and use scenarios.
• - Validate and audit spreadsheet data.
• - Enhance productivity by working with named cell ranges and macros.
• - Use linking, embedding and importing features to integrate data.
• - Compare and merge spreadsheets. Apply spreadsheet security features.

ICDL ADVANCED – DATABASE

• - Understand key concepts of database development and usage.
• - Create a relational database using advanced table creation features and complex relationships between tables.
• - Design and use queries to create a table, update, delete and append data. Refine queries using wildcards, parameters and calculations.
• - Use controls and subforms to enhance forms and improve functionality.
• - Create report controls to perform calculations. Create subreports and enhance report presentation.
• - Enhance productivity by working with macros and use linking and importing features to integrate data.

ECDL ADVANCED PRESENTATION

• - Understand target audience, venue and technical considerations in presentation planning.
• - Create and modify templates and themes, and work with slide master layouts.
• - Enhance a presentation using built-in drawing and image tools. Use alternative text for accessibility.
• - Apply advanced chart formatting features and create and edit diagrams.
• - Insert audio and video, create audio and screen recordings, and apply built-in animation features.
• - Use linking, embedding, importing and exporting features to integrate data. Use password protection to secure a presentation.
• - Work with custom slide shows and apply slide show settings. Use presenter view and control a slide show.

ECDL ADVANCED – Improving Productivity Using IT