NTISthis.com

Evidence Guide: CPPSIS5060 - Develop spreadsheets for spatial data

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

CPPSIS5060 - Develop spreadsheets for spatial data

What evidence can you provide to prove your understanding of each of the following citeria?

Prepare for spreadsheet tasks.

  1. Spreadsheet requirements for spatial data entry, storage, output, reporting and presentation are identified to determine task requirements in consultation with appropriate persons.
  2. Tasks are evaluated to identify design parameters, required mathematical formulas and areas where automation would increase efficiency according to task requirements.
  3. Software is set up and checked to ensure functionality and capacity to meet task and organisational requirements.
Spreadsheet requirements for spatial data entry, storage, output, reporting and presentation are identified to determine task requirements in consultation with appropriate persons.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Tasks are evaluated to identify design parameters, required mathematical formulas and areas where automation would increase efficiency according to task requirements.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Software is set up and checked to ensure functionality and capacity to meet task and organisational requirements.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Set up spreadsheets.

  1. Spreadsheet templates are developed and edited to standardise spreadsheet operation and ensure quality and consistency in format and design.
  2. Linked worksheet solution is developed using software functions and formulas to meet task requirements.
  3. Worksheets are formatted to incorporate cell and data attributes, formulas and graphs with labels and titles.
  4. Formulas are tested to confirm that output meets task requirements and errors are identified and resolved or contingencies managed.
Spreadsheet templates are developed and edited to standardise spreadsheet operation and ensure quality and consistency in format and design.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Linked worksheet solution is developed using software functions and formulas to meet task requirements.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Worksheets are formatted to incorporate cell and data attributes, formulas and graphs with labels and titles.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Formulas are tested to confirm that output meets task requirements and errors are identified and resolved or contingencies managed.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use functions and features of spreadsheet software.

  1. Spatial data is entered, checked and edited according to task and organisational requirements.
  2. Spatial data is imported and exported between compatible spreadsheets, and host documents are adjusted according to task requirements.
  3. Software documentation and online help are used to overcome problems with spreadsheet design and production.
  4. Spreadsheets, including graphs, are produced and stored according to organisational requirements.
Spatial data is entered, checked and edited according to task and organisational requirements.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Spatial data is imported and exported between compatible spreadsheets, and host documents are adjusted according to task requirements.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Software documentation and online help are used to overcome problems with spreadsheet design and production.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Spreadsheets, including graphs, are produced and stored according to organisational requirements.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Finalise spreadsheets.

  1. Completed spreadsheets are protected to prevent accidental corruption and are archived according to organisational requirements.
  2. Documentation is completed and appropriate persons are informed of results according to organisational requirements.
Completed spreadsheets are protected to prevent accidental corruption and are archived according to organisational requirements.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Documentation is completed and appropriate persons are informed of results according to organisational requirements.

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

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.

Required Skills and Knowledge

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.

Range Statement

This section specifies work environments and conditions that may affect performance. Essential operating conditions that may be present (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) are included. Bold italicised wording, if used in the performance criteria, is detailed below.

Appropriate persons must include at least one of the following:

client

end user

manager.