Spreadsheet Software

Overview

Framework:
RQF
Level:
Level 1
Unit No:
A/502/4624
Credits:
3
Guided learning hours:
20 hours

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 — Use a spreadsheet to enter, edit and organise numerical and other data

Assessment Criteria

  • 1.1
    Identify what numerical and other information is needed and how the spreadsheet should be structured to meet needs
  • 1.2
    Enter and edit numerical and other data accurately
  • 1.3
    Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available
2 — Use appropriate formulas and tools to summarise and display spreadsheet information

Assessment Criteria

  • 2.1
    Identify how to summarise and display the required information
  • 2.2
    Use functions and formulas to meet calculation requirements
  • 2.3
    Use spreadsheet tools and techniques to summarise and display information
3 — Select and use appropriate tools and techniques to present spreadsheet information effectively

Assessment Criteria

  • 3.1
    Select and use appropriate tools and techniques to format spreadsheet cells, rows and columns
  • 3.2
    Identify which chart or graph type to use to display information
  • 3.3
    Select and use appropriate tools and techniques to generate, develop and format charts and graphs
  • 3.4
    Select and use appropriate page layout to present and print spreadsheet information
  • 3.5
    Check information meets needs, using spreadsheet tools and making corrections as necessary