Pathway to ICDL level 3

What is the course about?

This course will provide you with the necessary background to be able to do ICDL Level 3. It will consolidate skills learned at level 2 and also prepare you for the challenging work of level 3. Areas we will focus on include: using mail merge tools, creating, manipulating and formatting tables, creating templates in Word; creating, formatting and adjusting charts, using formulae, functions and filtering in Excel; using different slide layouts and applying slide designs using presets and templates in PowerPoint. There will also be a brief introduction to Access including understanding key concepts in database development and usage.

You can choose to attend this course either live online or in person.
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
- Earphones/headphones/speakers.
We will contact you with joining instructions before your course starts.

What will we cover?

What will we cover?
Some of the areas covered will depend on the needs of the group but we will focus on:
• using mail merge tools, creating, manipulating and formatting tables and creating templates in Word
• creating, formatting and adjusting charts, using formulae, functions and filtering in Excel
• using different slide layouts and applying slide designs using presets and templates in PowerPoint
• understanding key concepts in database development and usage within Access.

What will I achieve?
By the end of this course you should be able to...

• feel sufficiently confident and competent to go ICDL level 3
• identify the areas you are most competent in and the areas you need to develop
• use mail merge tools, create, manipulate and format tables, and create templates in Word
• create, format and adjust charts, use formulae, functions and filtering in Excel
• use different slide layouts and apply slide designs using presets and templates in PowerPoint
• understand key concepts in database development and usage within Access.

What level is the course and do I need any particular skills?

This is a preparation course for ICDL Level 3. All students are expected to have a passed the ECDL level 2 course or the equivalent or have relevant experience. You are advised to come for interview and assessment if you are new to City Lit before enrolling on this course. If you need to develop your ESOL, English or Maths skills to enable you to get the most from this course, please contact the department.

How will I be taught, and will there be any work outside the class?

You will learn in a supportive and welcoming environment with an emphasis on your discovering how to do and complete tasks and functions, with guidance from the tutor. You will learn in a step by step manner so you can achieve challenging aims in an enjoyable and productive way. You will have lots of opportunities to practise as well as understand what you are doing and why. Everyone will be encouraged to participate and interact in a way that is best for them, including working in pairs and groups, as well as on your own. You will need to do work outside the classroom and use Google Classroom to help you.

Are there any other costs? Is there anything I need to bring?

You are advised to come for an advice and assessment session before doing this course. Otherwise,
please also bring a folder, pens and paper to class. There are no additional costs.

When I've finished, what course can I do next?

This course is a preparation for ICDL Level 3 both certificate and award but it can also be a stand alone course for those wanting to consolidate their skills. There are a variety of courses you can do either before, during and after this course. These include:
• Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)
• Workplace skills: how to be organised, focused and efficient using MS Outlook and OneDrive (intermediate)
• Digital skills for the workplace: how to present, organise and communicate with Word (intermediate)
• Digital skills for the workplace: creating newsletters, reports and tables with Word (intermediate)
• Digital skills for the workplace: how to integrate Word, Excel and PowerPoint to organise, present and communicate data (advanced)
• Business Administration: Word, Excel, PowerPoint and Access (intermediate-level 2)
• Business administration: ICT skills for business (advanced)
• Award in Digital and IT Skills: word-processing, spreadsheets, presentations and databases (intermediate-level 2)

There also many maths, English, employability and communication skills courses you can do. Ask your tutor or contact universal.skills@citylit.ac.uk / (telephone temporarily unavailable) for more detail. These include:
• Business Administration (with digital skills): English communication skills in a business environment (level 2)
• Professional communication skills: how to make your writing clear, concise and organised (level 2)
• Professional communication skills: reading, analysing, and comparing data and text (level 2)
• Professional communication skills: effective verbal communication in the workplace (level 2)
• Professional communication skills: effective written communication in the workplace (level 2)
• Becoming data literate: how to present data for work or study (L2+)
• Becoming data literate: understanding data and how it is presented from pie-charts to bell curves (level 2+).