Demonstrate the following task:

Task 1

Prepare and plan to develop two complex spreadsheets.

BENCHMARKS
Organise the work environment, so it meets ergonomic requirements and follows safe work practices, eg:

• seat

• monitor

• keyboard and mouse

Analyse the task and determine the spreadsheet specifications, eg:

• formulae

• formatting and reformatting

• functions

• headers and footers

• headings

Identify the data entry, storage, output, reporting, and presentation requirements, eg:

• input

• processing

• output

Apply strategies and techniques for energy and resource conservation, eg:

• reduce

• reuse

• recycle

Task 2

Follow procedures and guidelines to develop two linked spreadsheet solutions.

BENCHMARKS
Use the spreadsheet application’s functions and formulae to meet its requirements, eg:

• cell references:

  • absolute

  • relative

• ranges

Use the application’s functionality to link spreadsheets.

Format spreadsheet cells and use data attributes, eg:

• borders

• shading

• number formatting

Test formulae to confirm output meets task requirements.

Task 3

Follow procedures and guidelines to automate and standardise operations on two complex spreadsheets.

BENCHMARKS
Identify tasks from the spreadsheet that can be automated, eg:

• editing and formatting

• combining multiple commands or actions

• automate complex tasks

Create, use, and edit macros to fulfil the requirements of tasks and automate spreadsheet operation.

Develop, edit, and use templates to ensure consistent design and layout.

Task 4

Follow procedures and guidelines to prepare, develop, and use two complex spreadsheets that meet the identified task requirements.

BENCHMARKS
Enter, check, and amend data, eg:

• data entry forms

• data validation rules

Import and export data between spreadsheets or other documents, eg:

• import data

• format data

• adjust documents

• export data in an appropriate format for use by another application

Use help functions to overcome problems with spreadsheet design or production.

Prepare, preview, and adjust the spreadsheets, so they meet task requirements, eg:

• content fits page

• content is readable

• Task 5

  Represent numerical data in graphic form in two complex spreadsheets and follow organisational requirements to store the spreadsheets.

  BENCHMARKS
  Determine the type of chart that meets the specified requirements, eg:

  • bar

  • pie

  • line

• Manipulate spreadsheet data to produce the desired outcome.

  Create a chart with labels and titles from numerical data contained in the spreadsheet.

  Follow procedures to name and store the spreadsheet.