Spreadsheets

This unit is expiring
The expiry date of this unit is 31/07/2029.

Overview

Framework:
Access to HE 2024
Level:
Level 3
Unit No:
Not available
Credits:
3
Guided learning hours:
Not available

Qualification Grading Type

Ungraded

Unit Learning Outcomes

1.

Know how to design and store a spreadsheet.

Assessment Criteria

  • 1.1.

    Design a spreadsheet appropriate to a user's requirements.

  • 1.2.

    Create and store the spreadsheet.

  • 1.3.

    Evaluate the spreadsheet in terms of meeting the user's needs.

2.

Be able to retrieve and modify an existing spreadsheet.

Assessment Criteria

  • 2.1.

    Modify the spreadsheet design/content in response to user feedback.

3.

Be able to print a spreadsheet.

Assessment Criteria

  • 3.1.

    Print or display whole or part spreadsheets/formulae with a variety of print layout options.

4.

Be able to enhance user readability

Assessment Criteria

  • 4.1.

    Use suitable formatting options for displaying text and numeric values.

  • 4.2.

    Define and use conditional formatting to limit input error and give suitable messages to users.

5.

Be able to use spreadsheet functions.

Assessment Criteria

  • 5.1.

    Develop a spreadsheet solution using a range of mathematical functions.

6.

Be able to use graphical facilities.

Assessment Criteria

  • 6.1.

    Use an appropriate graph type.

  • 6.2.

    Draw pie, bar, line graphs with appropriate labels attached.

7.

Know how to use additional features within the spreadsheet environment

Assessment Criteria

  • 7.1.

    Use advanced sorting, protecting and filtering facilities on a spreadsheet.

  • 7.2.

    Analyse data using pivot tables.