Employability and Enterprise
Agriculture, Environment & Animal Care
Qualifications
Vocational Qualifications
Catering, Hospitality & Leisure
Qualifications
Vocational Qualifications
Childcare & Education
Qualifications
Access to HE
Apprenticeships
Vocational Qualifications
Construction, Engineering & Manufacturing
Education & Training
Qualifications
Professional Development
English & Maths
Essential Digital Skills
Hair & Beauty
Qualifications
Vocational Qualifications
Health, Science & Social Care
Qualifications
Access to HE
Apprenticeships
Vocational Qualifications
Life Skills & Progression
Qualifications
Digital Qualifications
Personal & Social Development
Personal and Professional Development
Public & Protective Services
Qualifications
Access to HE
Vocational Qualifications
Safeguarding & Wellbeing
Sales, Marketing & Retail
Supporting SEND
Qualifications
Personal & Social Development
Professional Development
Transport & Logistics
Qualifications
Access to HE
Vocational Qualifications

Overview

Framework:
Access to HE
Level:
Level 3
Unit No:
QU011467
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.


Offer our Qualifications

If you would like to teach our qualifications to your learners, submit an enquiry to discuss the best options.

Learners and students

Your questions answered

Learner Info