Advanced ECDL: Spreadsheets 2013

This is a self study course which means you can study at home, workplace or wherever you choose at times that are convenient for you. You do not have any classes to attend.

The Advanced ECDL is a Level 3 qaulification (QCF). This is roughly equivalent to Level 6 in Scotland (SCQF). It is accredited by the British Computer Society (BCS).

Advanced ECDL Spreadsheets (Module AM4) is a high-level certification programme which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. Completion of this module will enable candidates to master the more advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations, thus saving time and improving productivity in the completion of tasks.

Please note that although there are four Advanced ECDL Modules and these can enrolled on, completed and certified independently of each other. You only need to complete all four modules if you choose too.

Individuals with Advanced ECDL Spreadsheets will be able to:

• Apply advanced formatting options such as conditional formatting and customised number formatting and handle worksheets
• 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
• Validate and audit spreadsheet data
• Enhance productivity by working with named cell ranges, macros and templates
• Use linking, embedding and importing features to integrate data
• Collaborate on and review spreadsheets. Apply spreadsheet security features

The materials are provided as web-pages for you to work through online. As you progress through the course materials you will find written explanations of each feature, followed by practical exercises.

You will be supported throughout the course by a specialist Distance Learning Tutor. Your tutor will contact you (via your College email account) within 7-10 working days of receiving your welcome letter and materials. As you progress they will continue to make regular contact to offer support and guidance, usually by e-mail but sometimes by phone, to ensure you are making good progress and to support your learning throughout. Please note that you must be able to study independently through the course materials.

HOW WILL I BE ASSESSED?

An assessment will be carried out in the college assessment centre, when you have completed the course work. The cost of the Advanced Test is £60 payable at the time of booking. Payment can be made in cash at the Assessment Centre Reception in LG10, by cheque made payable to North East Scotland College or by Credit or Debit Card by telephoning the Assessment Centre on 01224 612237.

ENTRY REQUIREMENTS

Prospective students should ideally have the ECDL certification and/or previous experience using computers and common software applications. It is essential that you have previous experience in using a computer, the Windows interface and Windows terminology.

SPECIAL REQUIREMENTS

Please click here for a list of the technical requirements for this course. You must also have the following Microsoft Office 2013 software installed:

• Excel 2013

Please note: Microsoft Works cannot be used or this course