List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.
Elements describe the essential outcomes. | Performance criteria describe the performance needed to demonstrate achievement of the element. Where bold italicised text is used, further information is detailed in the range of conditions. |
1. | Prepare for spreadsheet tasks. | 1.1. | Spreadsheet requirements for spatial data entry, storage, output, reporting and presentation are identified to determine task requirements in consultation with appropriate persons. |
| 1.2. | Tasks are evaluated to identify design parameters, required mathematical formulas and areas where automation would increase efficiency according to task requirements. |
| 1.3. | Software is set up and checked to ensure functionality and capacity to meet task and organisational requirements. |
| | | |
2. | Set up spreadsheets. | 2.1. | Spreadsheet templates are developed and edited to standardise spreadsheet operation and ensure quality and consistency in format and design. |
| 2.2. | Linked worksheet solution is developed using software functions and formulas to meet task requirements. |
| 2.3. | Worksheets are formatted to incorporate cell and data attributes, formulas and graphs with labels and titles. |
| 2.4. | Formulas are tested to confirm that output meets task requirements and errors are identified and resolved or contingencies managed. |
| | | |
3. | Use functions and features of spreadsheet software. | 3.1. | Spatial data is entered, checked and edited according to task and organisational requirements. |
| 3.2. | Spatial data is imported and exported between compatible spreadsheets, and host documents are adjusted according to task requirements. |
| 3.3. | Software documentation and online help are used to overcome problems with spreadsheet design and production. |
| 3.4. | Spreadsheets, including graphs, are produced and stored according to organisational requirements. |
| | | |
4. | Finalise spreadsheets. | 4.1. | Completed spreadsheets are protected to prevent accidental corruption and are archived according to organisational requirements. |
| 4.2. | Documentation is completed and appropriate persons are informed of results according to organisational requirements. |
A person demonstrating competency in this unit must satisfy the requirements of the elements, performance criteria, foundation skills and range of conditions of this unit. The person must also develop three spreadsheets for different spatial data, in which the work must involve:
linking spreadsheets
multiple documents
advanced mathematical formulas based on trigonometrical functions.
While developing the above spreadsheets for spatial data, the person must:
analyse task requirements and evaluate work tasks as the basis for designing data layout, formulas and areas of automation
communicate clearly with others to clarify work tasks and notify task results
comply with organisational and legal requirements for:
accessing spatial data, including data privacy and information copyright
completing records and documentation
naming, storing and archiving spreadsheets
design and develop spreadsheet templates which ensure consistency in format, font type and size across multiple documents
develop spreadsheets using a range of complex software functions and formulas, including:
cell and data attributes
cell protection
embedding cell references in formulas
graphs
headers and footers
headings and labels
importing and exporting data
relative and absolute cell references
edit and proofread spreadsheets to check for accuracy and data consistency, including checks for correct formula function and output
identify errors and solve problems relating to data and spreadsheets
preserve the integrity and accuracy of spatial data during import and export process
use industry-accepted techniques to save and protect spreadsheets and data from corruption.
A person demonstrating competency in this unit must demonstrate knowledge of:
advanced functions of spreadsheet software applications, including linking spreadsheets and using formulas
display principles, including:
colour
composition
font type
legends
size
text and line style
methods for applying trigonometrical functions to formulas in spreadsheets
organisational requirements for:
completing records and documentation
preparing, naming, saving and archiving spreadsheet files.
The following must be present and available to learners during assessment activities:
equipment:
computer with access to appropriate spreadsheet software
printer
specifications:
organisational policies, procedures and documentation relating to data privacy and information copyright
physical conditions:
access to equipped work station
relationships with team members and supervisor:
working in a team.
Timeframe:
as specified by client and project requirements.
Assessor requirements
As a minimum, assessors must satisfy the assessor requirements in the Standards for Registered Training Organisations (RTOs) current at the time of assessment.