IT in Business - Advanced Spreadsheets (SQA HN Unit F849 35)

Credit points and level: 1 HN credit at SCQF level 8: (8 SCQF credit points at SCQF level 8)

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.

This Unit is designed to develop in-depth technical skills to facilitate a high level of competence in the component functions of a spreadsheet programme. Candidates should develop spreadsheet skills to support the management, analysis and forecasting of data. This Unit should also develop critical and evaluative thinking skills.

On completion of the Unit the candidate should be able to:

1. Apply data management features using spreadsheet software.
2. Use spreadsheet analysis tools to forecast statistical data.
3. Use a range of spreadsheet functions to propose solutions to a business problem.

Credit points and level: 1 HN credit at SCQF level 8: (8 SCQF credit points at SCQF level 8*)

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?

Evidence for this Unit is generated through assessment undertaken in open book controlled conditions.

Your Tutor will mark your all your certified assessments. Any re-submissions, known as remediation, will also be directed and remarked by your tutor. Your work will then be cross-marked by an in college subject expert, a process called moderation. It is only then that a result can be sent to the Awarding Body for certification.

A Pass is not final until all crosschecking procedures have been successfully completed. Your pass will be notified to the SQA for certification.

This course has a credit value of 1 HN Credit at SCQF level 8.

Assessments are booked through the BCD team.

ENTRY REQUIREMENTS

Candidates will have met the knowledge and/or skills contained in HN Unit IT in Business - Spreadsheets (F84V 34).

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