IT in Business - Spreadsheets (SQA HN Unit F84V 34)

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

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 allow candidates to develop an understanding of spreadsheet design and how to use spreadsheet features and functions for practical and effective use. It is relevant to candidates wishing to develop their knowledge of spreadsheets as a tool to help provide solutions to common business problems.

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

1. Create a spreadsheet design to provide solutions for a business scenario.
2. Present spreadsheet data in graphical form and interpret the results.
3. Provide solutions to a business scenario using spreadsheet statistical functions.

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

For further information on this course, please visit the SQA website

The materials for this course 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 3 assessments undertaken using 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.

Assessments are booked through the BCD team.

ENTRY REQUIREMENTS

It would be beneficial if you have numeracy skills, previous experience in using a computer and spreadsheet software. A relevant qualification or recent relevant work experience would also be beneficial.

SPECIAL REQUIREMENTS

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

• Excel 2007

Please note: Microsoft Works cannot be used or this course