Spreadsheets

Overview

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

Qualification Grading Type

Ungraded

For the full unit details, please download the latest version of the qualification specification. This is available for download on the relevant qualifications page.

Unit Learning Outcomes

To view the assessment criteria and any additional content, please expand the relevant learning outcome below.

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.