Spreadsheet Software

Overview

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

Unit Learning Outcomes

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