ECDL: advanced

This unique qualification for power users covers word processing software, spreadsheet software, presentation software and database software, as well as a unit on improving productivity using IT. You will gain the BCS level 3 ITQ certificate in IT user skills (ECDL advanced), an ECDL expert certificate and entitlement to Associate Membership of the British Computer Society at a reduced rate. All registration and exam fees included.

(average based on 1 review) » Write a review of this course

» View full course outline

Key course information

Dates
21/02/12 - 10/07/12

Day(s)
Tue+Wed

Duration
19 weeks

Time
18:00 - 21:00

Fees
Full fee: £632
Senior fee: £632
Concession: £301

Venue
KS - Keeley Street

» View location

Course code
CEA02*

Availability
Contact department

This course is full

» Find another course in Computing
» Search all courses

Still got questions?
computing@citylit.ac.uk or call 020 7492 2515

Course outline

What is the course about?

ECDL advanced brings together four ECDL advanced units and a new mandatory unit entitled Improving Productivity using IT to create a unique qualification for power users.

ECDL advanced is a full level 3 ITQ certificate.

What topics will we cover?

Word processing software
Spreadsheet software
Presentation software
Database software
Improving productivity using IT.

By the end of this course you should be able to:

WORD:

Apply advanced text, paragraph, column and table formatting.
Work with referencing features and create tables of contents etc.
Enhance productivity by using fields, forms and templates.
Apply advanced mail merge techniques and macros.
Work with master documents and subdocuments.
Work with watermarks, sections and headers and footers.

MICROSOFT EXCEL:

Use functions such as those associated with logical, statistical, financial and mathematical operations.
Create charts and apply advanced chart formatting features.
Work with tables and lists to analyse, filter and sort data.
Create and use scenarios and pivot tables.
Validate and audit spreadsheet data.
Enhance productivity by working with named cell ranges, macros and templates.
Apply spreadsheet security features.

MICROSOFT ACCESS:

Understand key concepts in database development and usage.
Create a relational database using advanced table creation features and complex relationships between tables.
Design and refine queries using wildcards, parameters and calculations.
Use controls and sub forms to enhance forms and improve functionality.
Create report controls to perform calculations.
Enhance productivity by working with macros.

MICROSOFT POWERPOINT:

Understand target audience and venue considerations in presentation planning.
Create and modify templates and format slide backgrounds.
Enhance a presentation using 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.
Work with custom slide shows, apply slide show setting, and control a slide show.

IMPROVING PRODUCTIVITY USING IT

This module will give you the ability 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 level is the course and do I need any particular skills?

This is an advanced course at Level 3. All students are expected to have a passed the ECDL level 2 course or have relevant experience.

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

Each student has their own computer.
Presentations will be made using computers, interactive whiteboard, overhead screen and printed notes.
Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.

Do I need to have an interview before I can enrol?

Yes. Before you can enrol on this course, you need to have an advisory interview with the relevant department. Without this the enrolment team will be unable to process your enrolment. Please contact the department to arrange your interview, or to find out about drop-in sessions.

What feedback will I get?

You will receive regular feedback from your tutor throughout the course, as and when appropriate. At the end of the course you and your tutor are asked to assess the progress you have made.

How will I be able to give my views on the course?

Please complete the evaluation form at the end of your course. These are monitored and help us to continually improve our courses.

How do I find out if I can get some support for my learning?

You may be interested in: education and careers advice; financial and childcare support; disability support; support for Deaf and hearing-impaired students; dyslexia support; English and maths support; counselling, and library services (supported learning centre). To find out what may be available to you, and how to apply, see page 213 of the 11/12 course guide, or visit www.citylit.ac.uk/students

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

General information and advice on courses at City Lit is available from the Information and Advice Shop, open Monday to Friday 12:00 – 19:00 during term time, and Monday to Friday 12:00 – 17:00 out of term time. See the course guide for term dates and further details.

Who can I contact for further information?

Tel: 020 7492 2515

computing@citylit.ac.uk

Advice times:

Tuesday 17.30 - 18.30; Wednesday 12.30 - 13.30

You do not need to book an appointment, just come along on the days and at the times listed.

To enrol on a course, call 020 7831 7831.

Select another date / day / time

Dates	Day(s)	Time	Duration	Fees	Snr	Conc	Code	Availability
21/02/12 to 10/07/12	Tue+Wed	18:00 - 21:00	19 weeks	£632	£632	£301	CEA02	Full	» Select
13/09/11 to 15/02/12	Tue+Wed	18:00 - 21:00	18 weeks	£632	£632	£301	CEA01	Contact department	» Select

Contact us

Computing