Advanced Level 2 Digital Skills

What is the course about?

This course will provide you with the necessary background to be able to do apply these skills in a working environment. It will consolidate skills learned at level 2 and also prepare you for the challenging work of a higher level 2. Areas we will focus on include: WORD: using mail merge tools, creating, manipulating and formatting tables,
EXCEL: creating, formatting and adjusting charts, using formulae, functions and filtering
POWERPOINT: using different slide layouts and applying slide designs Advanced Transitions and Custom Animation. Custom Slide Show.
ACCESS: A brief introduction to Access including understanding key concepts in database development and usage. Creating a database, creating/editing queries

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?

WORD: using mail merge tools, creating, manipulating and formatting tables,
EXCEL: creating, formatting and adjusting charts, using formulae, functions and filtering
POWERPOINT: using different slide layouts and applying slide designs Advanced Transitions and Custom Animation. Custom Slide Show.
ACCESS: A brief introduction to Access including understanding key concepts in database development and usage. Creating a database, creating/editing queries

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

• feel sufficiently confident and competent to go onto a higher level course
• 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 pre-set 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?

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 an 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?

There are many courses you can do either before, during and after this course. These include:
• Business administration: ICT skills for business (advanced)
• Business Administration with digital skills: how to be organised, efficient and customer-focused using Outlook and OneNote (intermediate)
• Business administration: how to organise and manage with OneNote, MS Outlook and OneDrive (intermediate)
• Business administration: using Word, Excel, PowerPoint and Access in the office (intermediate)
• Award in Digital and IT Skills: word-processing, spreadsheets, presentations and databases (level 2)
• Digital skills for business: analysing, handling and presenting data with Excel (intermediate)
• Digital skills for business: visualising data with Excel - from column charts to scatter plots (intermediate)
• Digital skills for business: how use Teams and SharePoint for collaboration (intermediate)
• Digital skills for business: how to present and communicate data integrating Word, PowerPoint and Excel - a project-based approach (advanced)
• Digital skills for business: presenting and managing professional-looking documents with Word and Excel - from reports to newsletters (intermediate)

You can also do classes in the maths and English areas. These include:
• Maths for business with Excel: the essential skills to run a company and make a profit (level 1-2)
• Communication skills for business: how to tell a story with data in your writing and presentations (level 2)
• Communication skills for business: how to be clear, concise and organised in your writing (level 2)
• Core management skills: leading and building teams (introduction)
• Business administration with digital skills: communication skills in a business environment (advanced level 2)

For more information, talk with your tutor or contact universal.skills@citylit.ac.uk / 020 4582 0423.