Level 3 Certificate in IT User Skills (ECDL Advanced)

Course Dates: 05/10/19 - 22/02/20
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.

The course fee is £1200. If you’re 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.

Description

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

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

This will be a practical hands-on course. You will be encouraged to practise as much as possible. An interactive whiteboard will help make demonstrations easy to understand. Each student has their own computer. You will receive regular handouts and information via Google classroom so you can practise at home.This is an intense course. You will need to be able to dedicate time outside the classroom to your studies as well as attend every week. You will need to do homework on a regular basis.

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

The course fee is £1200. 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, plus a deposit of £200 to secure your place (refundable after you complete the course).

For more information, please call English, Maths and Essential Computing on 0207 492 2511.
Please also bring a folder, pens and paper. There are no 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 a variety of courses you can do either after this course or at the same time. These include our advanced Microsoft Office courses designed for the workplace. There are also a number of specialist Excel courses. Your tutor will advise you on the best course. Our How to be an Administrator series might also interest you. You can also call our administrator on 0207 492 2511 to arrange an assessment with one of our course advisors.

General information and advice on courses at City Lit is available from the Student Centre and Library on Monday to Friday from 12:00 – 19:00.
See the course guide for term dates and further details

Reviews
Tutor Biographies
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.

Check your level

Course Code: CEA03

Please choose a course date 

Sat, day, 05 Oct - 22 Feb '20

Duration: 18 sessions (over 21 weeks)

Full fee: £1,200.00
Senior fee: £1,200.00
Concession: £1,200.00

Before booking on this course, we'll need you to log in or register with us if you're new. Please then contact us for a chat with our team to check that this course is the right level for you.
Why do I need an advice session?

Any questions? skills@citylit.ac.uk
or call 020 7492 2511

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.