Employability and Enterprise

Agriculture, Environment & Animal Care

Vocational Qualifications

Catering, Hospitality & Leisure

Vocational Qualifications

Childcare & Education

Access to HE
Apprenticeships
Pre-Access to HE
Vocational Qualifications

Construction, Engineering & Manufacturing

Access to HE
Vocational Qualifications

Creative, Design & Digital

Access to HE
Vocational Qualifications

Education & Training

Professional Development

Hair & Beauty

Vocational Qualifications

Health, Science & Social Care

Access to HE
Apprenticeships
Pre-Access to HE
Vocational Qualifications

Life Skills & Progression

Personal & Social Development

Personal and Professional Development

Personal & Social Development
Professional Development
Vocational Qualifications

Public & Protective Services

Access to HE
Vocational Qualifications

Safeguarding & Wellbeing

Supporting SEND

Personal & Social Development
Professional Development

Transport & Logistics

Access to HE
Vocational Qualifications

Overview

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

Qualification Grading Type

Graded

Grade Descriptors

  • GD3-Application of skills
  • GD7-Quality

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.


Offer this Unit

If you would like to offer this unit, you can book a meeting with us to discuss the best options.