ICDL 201 – Project Management & office Proficiency

ICDL Advanced modules will enable you to become a ‘power user’/perform advanced actions in four of the most commonly used applications. These modules are aimed at the work user who needs to demonstrate an in depth knowledge of these applications in the course of their job role. Prior to taking an ICDL Advanced module, it is recommended that you will already have successfully completed the respective ICDL module, however this is not mandatory.
Name: Project Management & office Proficiency
Course Code: ICDL 201
Course Time: 08:00am - 05:00pm
Prerequisite(s): ICDL Standard modules complement our range of Base modules. They will enable you to develop your skills in knowledge areas that are appropriate for your everyday life, or for your job role.
Credit(s): 4.0
Course ID: 00004
Room Number: GHR 005
Course Days: Mon - Fri
Component(s): Access: 12 Months
Location: Map
Notes: For credit, all modules are to be successfully completed.

Get ICDL ADVANCE

Study at KIT to earn your International Driving License Advance Certificate

Enroll For this course!

Go to top

ADVANCED WORD PROCESSING

Advanced Word Processing Banner Image

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. Convert text to a table and vice versa.
  • Work with referencing features like footnotes, endnotes and captions. 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. Work with master documents and subdocuments. Apply document security features.
  • Work with watermarks, sections, and headers and footers in a document.

WHAT ARE THE BENEFITS OF THIS MODULE?

  • Allows users to become more confident, efficient and effective in using a word processing application.
  • Proves mastery of the application.
  • Enables users to produce and manage large, complex word processing outputs.
  • Improves user’s productivity and saves time.
  • Developed with input from computer users, subject matter experts and practising computer professionals from all over the world. This process ensures the relevance and range of module content.

SYLLABUS

The Syllabus sets out the specific knowledge and skills that make up this module, as informed by input from subject matter experts from a wide range of computer societies and organisations.

Download the Advanced Word Processing Module Syllabus [EN](PDF)

Download the Advanced All Module Syllabi [FR] (PDF)

ADVANCED WORD PROCESSING SYLLABUS OVERVIEW:

CATEGORY SKILL SET
Formatting
  • Text
Referencing
  • Captions, Footnotes and Endnotes
  • Reference Tables and Indexes
  • Bookmarks and Cross-References
Enhancing Productivity
  • Using Fields
  • Forms, Templates
  • Mail Merge
  • Linking, Embedding
  • Automation
Collaborative Editing
  • Tracking and Reviewing
  • Master Documents
  • Security
Prepare Outputs
  • Sections
  • Documents Setup

SAMPLE TESTS

ICDL Africa provides sample tests to enable potential candidates and employers to understand Advanced Word Processing in more depth and prepare for testing.

Download the Advanced Word Processing Sample Test – Office 2013 (.zip)

Download the Advanced Word Processing Sample Test – Office 2010 (.zip)

Please note: Answers are provided for the multiple choice questions of the sample papers, please refer to ICDL training materials for information on practical tasks.

ADVANCED SPREADSHEETS

Advanced Spreadsheets Banner Image

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 features.
  • 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, macros and templates.
  • Use linking, embedding and importing features to integrate data.
  • Collaborate on and review spreadsheets. Apply spreadsheet security features.

WHAT ARE THE BENEFITS OF THIS MODULE?

  • Allows users to become more confident, efficient and effective in using a spreadsheet application.
  • Proves mastery of the application.
  • Enables users to produce better reports with deeper data analysis.
  • Improves user’s productivity.
  • Developed with input from computer users, subject matter experts and practising computer professionals from all over the world. This process ensures the relevance and range of module content.

SYLLABUS

The Syllabus sets out the specific knowledge and skills that make up this module, as informed by input from subject matter experts from a wide range of computer societies and organisations.

Download the Advanced Spreadsheets Module Syllabus [EN] (PDF)

Download the Advanced All Module Syllabi [FR] (PDF)

ADVANCED SPREADSHEETS SYLLABUS OVERVIEW:

CATEGORY SKILL SET
Formatting
  • Worksheets
Functions and Formulas
  • Using Functions and Formulas
Charts
  • Creating Charts
  • Formatting Charts
Analysis
  • Using Tables
  • Sorting and Filtering
  • Scenarios
Validating and Auditing
  • Validating
  • Auditing
Enhancing Productivity
  • Naming Cells
  • Paste Special
  • Templates
  • Linking, Embedding and Importing
  • Automation
Collaborative Editing
  • Tracking and Reviewing
  • Security

SAMPLE TESTS

ICDL Africa provides sample tests to enable potential candidates and employers to understand Advanced Spreadsheets in more depth and prepare for testing.

Download the Advanced Spreadsheets Sample Test –  Office 2013 (.zip)

Download the Advanced Spreadsheets Sample Test –  Office 2010 (.zip)

Please note: Answers are provided for the multiple choice questions of the sample papers, please refer to ICDL training materials for information on practical tasks.

Video Example

https://www.youtube.com/watch?feature=player_embedded&v=tQBxzpsS16g

Required Readings

  • Nunc semper nisi et ultrices luctus.
  • Phasellus non eros quis erat sagittis pulvinar a non urna.
  • Curabitur fermentum nisi eu sem ultricies, id lobortis velit ultrices.
  • Sed sit amet nisl in sem interdum pretium.
  • Aenean ac neque commodo ante pharetra viverra sed dictum tortor.
  • Donec sagittis quam a auctor faucibus.

Lecture Notes

Nulla nisi ante, auctor a tellus in, varius molestie nisl. Donec ut accumsan sapien. Aliquam erat volutpat. Suspendisse et ligula non nulla gravida laoreet nec sed tortor. Donec ac neque malesuada, lobortis erat in, sollicitudin nulla. Sed vehicula imperdiet leo, euismod ultricies nisl dapibus in. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec ex ipsum, sollicitudin ac elit eu, pulvinar porttitor velit. In maximus consectetur risus.

ADVANCED DATABASE

Advanced Database Banner Image

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.

WHAT ARE THE BENEFITS OF THIS MODULE?

  • Allows users to become more confident, efficient and effective in using a database application.
  • Proves mastery of the application.
  • Enables users to retrieve and produce higher quality management information.
  • Improves user’s productivity.
  • Developed with input from computer users, subject matter experts and practising computer professionals from all over the world. This process ensures the relevance and range of module content.

SYLLABUS

The Syllabus sets out the specific knowledge and skills that make up this module, as informed by input from subject matter experts from a wide range of computer societies and organisations.

Download the Advanced Databases Module Syllabus [EN] (PDF)

Download the Advanced All Module Syllabi [FR] (PDF)

ADVANCED DATABASES SYLLABUS OVERVIEW:

CATEGORY SKILL SET
Database Concepts
  • Database Development and Use
Tables and Relationships
  • Fields/Columns Relationships and Joins
Queries
  • Query Types
  • Refining a Query
Forms
  • Controls
Reports
  • Controls
  • Presentation
Enhancing Productivity
  • Linking, Importing
  • Automation

SAMPLE TESTS

ICDL Africa provides sample tests to enable potential candidates and employers to understand Advanced Database in more depth and prepare for testing.

Download the Advanced Database Sample Test – Office 2013 (.zip)

Download the Advanced Database Sample Test – Office 2010 (.zip)

Please note: Answers are provided for the multiple choice questions of the sample papers, please refer to ICDL training materials for information on practical tasks.

ADVANCED PRESENTATION

Advanced Presentation Banner Image

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 and venue considerations in presentation planning.
  • Create and modify templates and format slide backgrounds.
  • Enhance a presentation using built-in drawing and image tools.
  • Apply advanced chart formatting features and create and edit diagrams.
  • Insert movies and sound and apply built-in animation features.
  • Use linking, embedding, importing and exporting features to integrate data.
  • Work with custom slide shows, apply slide show settings, and control a slide show.

WHAT ARE THE BENEFITS OF THIS MODULE?

  • Allows users to become more confident, efficient and effective in using a presentation application.
  • Proves mastery of the application.
  • Enables users to plan and design more effective presentations.
  • Improves user’s productivity.
  • Developed with input from computer users, subject matter experts, and practising computer professionals from all over the world. This process ensures the relevance and range of module content.

SYLLABUS

The Syllabus sets out the specific knowledge and skills that make up this module, as informed by input from subject matter experts from a wide range of computer societies and organisations.

Download the Advanced Presentation Module Syllabus [EN] (PDF)

Download the Advanced All Module Syllabi [FR] (PDF)

ADVANCED PRESENTATION SYLLABUS OVERVIEW:

 

CATEGORY SKILL SET
Presentation Planning
  • Audience and Environment
  • Design, Content and Layout
Slide Masters and Templates
  • Slide Masters
  • Templates
Graphical Objects
  • Formatting Drawn Objects
  • Formatting Pictures, Images
  • Handling Graphical Objects
Multimedia
  • Movies, Sounds
  • Animation
Enhancing Productivity
  • Linking, Embedding
  • Importing, Exporting
Managing Presentations
  • Custom Shows
  • Slide Show Settings
  • Slide Show Control

SAMPLE TESTS

ICDL Africa provides sample tests to enable potential candidates and employers to understand Advanced Presentation in more depth and prepare for testing.

Download the Advanced Presentation Sample Test – Office 2013 (.zip)

Download the Advanced Presentation Sample Test – Office 2010 (.zip)

Please note: Answers are provided for the multiple choice questions of the sample papers, please refer to ICDL training materials for information on practical tasks.