Level 3 certificate in IT user skills (ECDL Advanced)

Course Dates: 26/02/22 - 09/07/22
Time: 10:00 - 17:00
Location: KS - Keeley Street
Do you want to know that you can work to an outstanding level in any work environment requiring an expertise in Word, Excel, PowerPoint and Access? Do you want a qualification to prove these skills? The Level 3 Certificate in IT User Skills (ECDL Advanced) will give you exceptional proficiency in word processing, spreadsheet, presentation and database software, and will improve your productivity in using IT. You will gain all the skills you need to work at the highest level in an office environment. This course may be free if it is your first L3 qualification. The Advanced Learner Loan is also available.
You must have completed an initial assessment before enrolling onto this course. Click on the Start Assessment button. Or call our administrator on 0207 492 2511 or email universal.skills@citylit.ac.uk to arrange an assessment with one of our course advisors.
If you are eligible for government funding and you are 19 or over and do not already have a full level 3 qualification (equivalent to an advanced technical certificate or diploma, or 2 full A levels) you may be able to study this course for free. For more information click here
The course fee is £1200. If you are unable to pay this upfront, you can choose to apply for an Advanced Learner Loan from Student Finance England (SFE) to help cover the course fee, repayable after the course ends. A deposit of £200 is also payable to secure your place (refundable after you complete the course). You can find more information about the Advanced Learner Loan www.citylit.ac.uk/advanced-learner-loans
For more information, please call English, Maths and Essential Computing on 0207 492 2511.
This course takes place in the classroom, please follow this link to find out what we are doing to keep you safe: Staying COVID-19 secure at City Lit
Download
Book your place
In stock
SKU
176587
Full fee £1,200.00 Senior fee £1,200.00 Concession £1,200.00

Check your level

Course Code: CEA04

Please choose a course date 

Sat, day, 26 Feb - 09 Jul '22

Duration: 18 sessions (over 20 weeks)

Before booking on this course, please register or log in to your account to complete a short online assessment. We need you to do this to check that this course is the right level for you.
Why do I need an advice session?

Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Center for more information on a range of topics including fees, online learning and FAQs.

What is the course about?

The ECDL level 3 certificate will provide you with all you the skills you need to work in any office or administrative environment at a high level.
You will develop advanced word processing skills to format text and tables, work with referencing features and create tables of contents. You will improve your productivity by using fields, forms and templates. You will learn how to use advanced mail merge and macros, work with master documents and subdocuments, and work with watermarks, sections, headers and footers.
You will develop your skills with Excel to an advanced level so you can use sophisticated functions, create charts and apply advanced chart formatting features, work with tables and lists to analyse, filter and sort data. You will learn how to create and use scenarios and pivot tables, validate and audit spreadsheet data. You will enhance your productivity by working with named cell ranges, macros and templates. And you will learn about applying spreadsheet security.
You will develop your skills in using Microsoft Access including: understanding key concepts in database development and usage, creating a relational database, designing and refining queries using wildcards, parameters and calculations, using controls and sub forms to enhance forms and improve functionality. You will also learn how to create report controls to perform calculations and work with macros.
You will learn how to make advanced PowerPoint presentations including: how to understand your target audience, creating and modifying templates and formatting slide backgrounds. You will learn how to use 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. You will focus on how to work with custom slide shows, apply slide show setting, and control a slide show.
Finally, you will focus on how to improve your productivity in general through IT use.

What will we cover?

What will we cover?
• advanced word processing skills to enable you work at the highest level in any office environment. Including:
• formatting text and tables, working with referencing features and creating tables of contents
• improving productivity by using fields, forms and templates
• using advanced mail merge and macros
• working with master documents and subdocuments, watermarks, sections, headers and footers

• Advanced Excel functions including:
• using sophisticated functions
• creating charts and applying advanced chart formatting features, working with tables and lists to analyse, filter and sort data
• creating and using scenarios and pivot tables
• validating and auditing spreadsheet data
• working with named cell ranges, macros and templates
• applying spreadsheet security features.

• Developing advanced skills in using Microsoft Access including:
• understanding key concepts in database development and usage
• creating a relational database
• designing and refining queries using wildcards, parameters and calculations
• using controls and sub forms to enhance forms and improve functionality
• creating report controls to perform calculations and enhance productivity by working with macros

• Making advanced PowerPoint presentations including:
• how to understand your target audience
• creating and modifying templates and formatting slide backgrounds
• using built-in drawing and image tools
• applying advanced chart formatting features
• creating and editing diagrams, inserting movies and sound and applying built-in animation features
• working with custom slide shows, applying slide show settings, and controlling a slide show

• Improving your productivity in general through IT use:
• how to plan, evaluate and improve procedures involving the use of IT tools and systems in order to improve the productivity and efficiency of work activities.

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

• pass BCS ITQ Level 3 ECDL qualification
• use advanced word processing skills to enable you work at the highest level in any office environment. Including:
• formatting text and tables, working with referencing features and creating tables of contents
• improving productivity by using fields, forms and templates
• using advanced mail merge and macros
• working with master documents and subdocuments, watermarks, sections, headers and footers

• use Advanced Excel functions including:
• using sophisticated functions associated with logical, statistical, financial and mathematical operations
• creating charts and applying advanced chart formatting features, working with tables and lists to analyse, filter and sort data
• creating and using scenarios and pivot tables
• validating and auditing data
• working with named cell ranges, macros and templates
• applying spreadsheet security features.

• use advanced skills in Microsoft Access including:
• understanding key concepts in database development and usage
• creating a relational database using advanced table creation features and complex relationships between tables
• designing and refining queries using wildcards, parameters and calculations
• using controls and sub forms to enhance forms and improve functionality
• creating report controls to perform calculations and enhance productivity by working with macros

• Make advanced PowerPoint presentations including:
• understanding your target audience and consider your venue considerations when planning
• creating and modifying templates and formatting slide backgrounds
• enhancing a presentation using built-in drawing and image tools
• applying advanced chart formatting features
• creating and editing diagrams, inserting movies and sound and applying built-in animation features
• working with custom slide shows, applying slide show settings, and controlling a slide show

• Improve your productivity in general through IT use.

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

This is an advanced Level 3 course. All students need to have a passed the ECDL level 2 course or have relevant experience. You will need an interview and assessment if you are new to City Lit before enrolling on this course.

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, with guidance from the tutor. You will work on your own and with other students on different tasks so you are always practising important in-demand life and work skills such as problem-solving, decision-making, prioritising, negotiating, collaborating and independence. You will learn in a step by step manner so you can complete challenging tasks in enjoyable and relaxing ways. Your tutor will also work with you individually so you know how to improve and how to work in a way that improves your learning. 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?

This course will be free if you do not have a level 3 qualification.
If you’re unable to pay this upfront, you can choose to apply for an Advanced Learning Loan from the Student Loans Company to help cover the course fee, repayable after the course ends.

For more information, please call Universal Skills on 020 7492 2511.

There are no other additional costs.
.
For more information, please call English, Maths and Essential Computing on 0207 492 2511.

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

There are many courses you can do before, at the same time or after this course. These include:

• Workplace skills: how to be organised and self-managing using One Note and MS Outlook (intermediate)
• Workplace skills: how to be organised, focused and efficient using MS Outlook (intermediate)
• Workplace skills: how to collaborate, coordinate and build relationships through the Cloud using One Drive and SharePoint
• Workplace skills: how to collaborate, coordinate and build relationships through the Cloud using One Drive and SharePoint (intermediate)
• Workplace skills: how to collaborate, coordinate and build relationships with Microsoft Teams

There also many English maths and other employment skills courses you can do. Ask your tutor or contact universal.skills@citylit.ac.uk / 020 7492 2511 for more details.

We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.