Spreadsheet Software Skills

Overview

Framework:
RQF
Level:
Entry Level 3
Unit No:
Y/505/1698
Credits:
2
Guided learning hours:
20 hours

Assessment Guidance

N/A

Unit Learning Outcomes

1

Be able to enter and edit information in a spreadsheet.

Assessment Criteria

  • 1.1
    Enter and edit information into a spreadsheet.
  • 1.2
    Store spreadsheet files effectively.
  • 1.3
    Retrieve spreadsheet files effectively.
2

Be able to use formulae and tools.

Assessment Criteria

  • 2.1
    Identify how to summarise and display information in a spreadsheet.
  • 2.2
    Use spreadsheet formulae and tools to summarise data and process information.
3

Be able to use tools and techniques to present spreadsheet information.

Assessment Criteria

  • 3.1
    Use appropriate tools and techniques to format spreadsheet:
    (a) cells
    (b) rows
    (c) columns.
  • 3.2
    Identify the chart or graph type that they will use to display information.
  • 3.3
    Use appropriate tools to generate a chart or graph.
  • 3.4
    Select a page layout to present and print spreadsheet information.
  • 3.5
    Check spreadsheet information using IT tools making corrections as appropriate.