Spreadsheet Software

Overview

Framework:
RQF
Level:
Entry Level 3
Unit No:
F/502/0168
Credits:
2
Guided learning hours:
15 hours

Assessment Guidance

IT User Assessment Strategy available from www.e-skills.com
Assessment can be undertaken through:
• an assignment to cover practical ability and underpinning knowledge - that may include multiple choice questions as part of a single assessment activity or as a seperate acitivity
• work for a real purpose portfolio of evidence

Unit Learning Outcomes

1

SSE:1 Enter and edit numerical and other information using spreadsheets

Assessment Criteria

  • 1.1
    Enter and edit numerical and other information accurately
  • 1.2
    Store and retrieve spreadsheet files effectively, in line with local guidelines
2

SSE: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 formulas and tools as needed to summarise data and process information
    information
3

SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively

Assessment Criteria

  • 3.1
    Use appropriate tools and techniques to format spreadsheet cells, rows and columns
  • 3.2
    Identify the chart or graph type used 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