Agriculture, Environment & Animal Care
Vocational Qualifications
Catering, Hospitality & Leisure
Vocational Qualifications
Childcare & Education
Access to HE
Apprenticeships
Vocational Qualifications
Construction, Engineering & Manufacturing
Access to HE
Vocational Qualifications
Creative, Design & Digital
Access to HE
Digital Qualifications
Vocational Qualifications
Education & Training
Professional Development
English & Maths
English & Maths
Hair & Beauty
Vocational Qualifications
Health, Science & Social Care
Access to HE
Apprenticeships
Vocational Qualifications
Life Skills & Progression
Digital Qualifications
Personal & Social Development
Personal and Professional Development
Digital Qualifications
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 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