Advanced Spreadsheets

This module sets out advanced skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.
Module Goals

Successful candidates 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.

Advanced Presentation

This module sets out advanced knowledge relating to planning and designing presentations, as well as the skills needed to produce advanced presentation outputs using a presentation application.

Module Goals

Successful candidates 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.

Advanced Word Processing

This module sets out advanced skills that can be used to produce complex documents, enhance outputs, and improve productivity, when using a word processing application.

Module Goals

Successful candidates 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.

Digital Marketing Module

This module sets out essential concepts and skills relating to the fundamentals of digital marketing.

Module Goals

Successful candidates will be able to:

Understand key concepts of digital marketing, including advantages, limitations and planning.
Understand various web presence options and how to select appropriate keywords for search engine optimisation.
Recognise different social media platforms, and set up and use common platforms.
Understand how effective social media management assists in promotion and lead generation.
Use a social media management service to schedule posts and set up notifications.
Understand various options for online marketing and advertising, including search engine, e-mail and mobile marketing.
Understand and use analytics services to monitor and improve campaigns.

ICT in Education Module

This module sets out knowledge and skills relating to the pedagogically effective use of ICT to support and enhance teaching, learning and assessment in the classroom.

Module Goals

Successful candidates will be able to:

Understand the key concepts and benefits of using ICT to support and enhance teaching, learning and assessment in the classroom.
Outline considerations for planning an ICT-enhanced lesson.
Understand safety, security and well-being considerations when using ICT in education.
Outline ICT resources that can be used to support and enhance teaching, learning and assessment.
Understand how to source and evaluate ICT resources to support and enhance teaching, learning and assessment.
Outline key features of classroom technologies.
Use key features of a learning platform.

ICDL Project Planning

This module sets out essential concepts and skills relating to the ability to use project management software to prepare project plans and monitor projects including planning and managing time, costs, tasks, and resources.

Module Goals

Successful candidates will be able to:

Understand the key concepts relating to managing projects.
Use a project management application to create a new project and maintain an existing project.
Create and schedule tasks and add project constraints and deadlines.
Assign costs and create and assign resources to tasks.
View the critical path, monitor progress and reschedule work.
Prepare and print outputs, including charts and reports.