ICDL Advanced Exam

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

ICDL ADVANCED – WORD PROCESSING

This module is a high-level certification programme through which candidates can demonstrate their ability to use the advanced features of word processing applications to enhance their work, improve productivity and save time. Completion of this module will enable candidates to demonstrate professionalism and save time in the creation, production, review, and distribution of documents.
On completion of this module the candidate will be able to:

• 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.

ECDL ADVANCED SPREADSHEETS

This module is a high-level certification programme which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. Completion of this module will enable candidates to master the more advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations, thus saving time and improving productivity in the completion of tasks.

On completion of this module the candidate will be able to:

• 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

This module is a high-level certification programme that enables candidates to use the many advanced tools available in database applications to better manage and organise structured information. Successful completion of this module will enable candidates to maximise database functions, in order to manage and analyse high volumes of data, thus enabling the production of the quantity and quality of information that business today demands.

On completion of this module the candidate will be able to:

• 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
This module is a high-level certification programme for candidates who wish to create effective, high-impact presentations using advanced features and who need to be able to prove their skills in this area. The programme covers advanced presentation features that will allow candidates to use the presentation application to its full potential, and to plan and design more effective presentations that have greater impact and that will better engage and involve an audience.

On completion of this module the candidate will be able to:

• 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

The ‘Improving Productivity Using IT’ unit is a mandatory unit for this qualification. This qualification provides learners with a full Level 3 qualification; therefore the completion of ECDL Advanced meets the requirements of the national funding objectives at Level 3
Improving Productivity Using IT is the ability to plan, evaluate and improve procedures involving the use of IT tools and systems in order to improve the productivity and efficiency of work activities.

Level 3 Summary
An advanced user can plan and review their use of predefined or commonly used IT tools for activities most of which are complex and non-routine. As a result of reviewing their work, they will be able to devise solutions in the use of IT tools in order to improve productivity. They will take considerable responsibility and autonomy, and be prepared to offer support and advice to others.

An activity will typically be ‘complex and non-routine’ because:

• the task or context is likely to require research, analysis and interpretation;
• the work may be undertaken by others; and
• the techniques required will be complex, and the selection process may involve analysis, research, identification and application.

Examples of context: An improvement may be adapting an off-the-shelf solution to create a bespoke database to manage customer relationships in a marketing context