Spreadsheets

Overview

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

Qualification Grading Type

Ungraded

Grade Descriptors

  • 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

Know how 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

Understand spreadsheet functions.

Assessment Criteria

  • 5.1

    Develop a spreadsheet solution using a range of mathematical functions.

6

Understand 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.