Spreadsheet Software

Overview

Framework:
RQF
Level:
Level 1
Unit No:
K/618/3665
Credits:
3
Guided learning hours:
24 hours

Aim

Learners will learn how to create spreadsheets to carry out calculations such as addition, subtraction, multiplication, division, averages and totals. They will also develop skills in presenting spreadsheet data in different ways, using numbers, text and graphs.

Unit Learning Outcomes

1

Know how spreadsheets can be used for different purposes.

  • A spreadsheet stores, sorts, manipulates and analyses data and presents it in tabular form, most common uses, to create budgets, to forecast future performance, calculate tax, completing basic payroll, producing charts and calculating revenues.
  • Uses: support decision making, presenting/analysing/manipulating data, perform calculations, cost modelling, stock control, repetitively and accurately performing calculations e.g. payroll, statistics, list management e.g. searching large datasets, interpreting data using sorting and filtering.

Assessment Criteria

  • 1.1

    Describe the different ways spreadsheets can be used.

2

Be able to create spreadsheets for different purposes.

AC 2.1:

  • Simple spreadsheet: workbook and worksheets, columns, rows, cells, active cell, cell reference, formula bar, labels, values, functional formulae, graphs and charts.
  • Basic calculations: formulae (addition, subtraction, multiplication and division), functions: SUM(), MIN(), MAX(),and AVERAGE(), data accuracy, e.g. numbers, formulae, results, apply and use filters, sort data using text and numbers, create graphs or charts.

AC 2.2:

  • Tools and techniques: insert and delete rows and columns, page layout, e.g. margins, orientation, header and footer, format numerical data, e.g. integer, real, decimal, currency, date, autofill, copy and paste, move, replicate formulae, formatting tools, e.g. height/width, wrap text, merge cells, styles, e.g. bold, underline, italics, borders/shading, colours.

AC 2.3:

  • Graphical format: types of charts and graphs (bar, pie, line etc), chart and graph formatting (titles, axis, labels, legend, resizing).

Assessment Criteria

  • 2.1

    Create a simple spreadsheet using basic calculations.

  • 2.2

    Use tools and techniques to edit and format spreadsheet data.

  • 2.3

    Display spreadsheet data in a graphical format.

3

Be able to review spreadsheets to ensure fitness for purpose.

  • Check for: accuracy of numbers, formulas and any text, suitability of charts and graphs, layout and formatting, validity and accuracy of analysis, sorting out errors, use of reveal formulae, checking that user requirements met.

Assessment Criteria

  • 3.1

    Check spreadsheet for accuracy, making corrections as necessary.