CPPSSI5060 — Develop spreadsheets for spatial data

1 Prepare for spreadsheet tasks.

• 1.1Determine specifications for spreadsheets and identify the task requirements for spatial data entry, storage, output, reporting and presentation.
• 1.2Evaluate tasks to identify design parameters, required features and functions and areas where automation would increase efficiency.
• 1.3Set up and check software for functionality and capacity to meet task requirements.

2 Set up spreadsheets.

• 2.1Develop linked spreadsheet solution using software features and formulas to meet task requirements.
• 2.2Test formulas and functions and resolve errors to confirm that output meets task requirements.
• 2.3Format spreadsheets and use titles, colours, headings, labels and data to enhance meaning and presentation of data.

3 Use functions and features of spreadsheet software.

• 3.1Enter, check and edit spatial data according to task and organisational requirements.
• 3.2Import and export spatial data between compatible software applications and adjust host documents according to task requirements.
• 3.3Use software documentation and online help to overcome errors and problems with spreadsheet design and production as required.
• 3.4Develop and edit spreadsheet templates to standardise spreadsheet operation and ensure quality and consistency in format and design.

4 Finalise spreadsheets.

• 4.1Protect completed spreadsheets to prevent accidental corruption and archive according to organisational requirements.
• 4.2Complete documentation and inform appropriate persons of results according to organisational requirements.

What does an assessment tool for CPPSSI5060 need to cover?

To satisfy the Principles of Assessment and Rules of Evidence, an assessment for CPPSSI5060 needs to address all 39 unit components: 4 elements with 12 performance criteria, 16 performance evidence requirements, 11 knowledge evidence requirements, and the foundation skills. A coverage matrix mapping each question and task to these components is what an auditor looks for.

How does Auditori generate an assessment tool for CPPSSI5060?

Auditori pulls the current release of CPPSSI5060 from training.gov.au and generates a complete package: candidate assessment, assessor guide with model answers and observation criteria, and a coverage matrix mapping every component. A suitably qualified person then reviews and approves the draft in a built-in workflow — consistent with ASQA's guidance on AI use in VET — before export as branded PDF and editable Word.

Is the first assessment tool really free?

Yes. Every new account includes one free credit — enough to generate the complete assessment tool for CPPSSI5060 — with no card and no subscription required. After that it's pay-as-you-go per unit.

Can I check my existing CPPSSI5060 assessment instead of generating a new one?

Yes — upload your existing assessment or learner guide and Auditori maps it against every element, performance criterion, PE and KE of CPPSSI5060, showing exactly what's covered and what's missing. Mapping costs a quarter of a credit.