ICDL Exams

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

1 – 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.

2 – 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

3 – 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.

4 – 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 recognize error values in formulas.
• 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.

5 – 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

6 – 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 by using the master slide.
• 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.
•  

7 – 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