Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners

PSPGEN063 Mapping and Delivery Guide
Process statistical data

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency PSPGEN063 - Process statistical data
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills required to record, store and manage data prior to analysis. It includes preparing raw data for electronic storage, using software tools to collect and/or store data, processing raw data and maintaining records.This unit applies to those working in generalist and specialist roles within the public sector.The skills and knowledge described in this unit must be applied within the legislative, regulatory and policy environment in which they are carried out. Organisational policies and procedures must be consulted and adhered to.Those undertaking this unit would work autonomously consulting others as required, performing complex tasks in a range of familiar contexts.No licensing, legislative or certification requirements apply to unit at the time of publication.
Duration and Setting X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting.

This unit contains no specific industry-mandated assessment conditions. Guidance on suggested and recommended conditions and methods can be found in the Implementation Guide.

Assessors must satisfy the NVR/AQTF mandatory competency requirements for assessors.
Prerequisites/co-requisites
Competency Field General
Development and validation strategy and guide for assessors and learners Student Learning Resources Handouts
Activities 		Slides
PPT 		Assessment 1 Assessment 2 Assessment 3 Assessment 4
Elements of Competency Performance Criteria              
Element: Use software tools to collect and/or store data
  • Use computer technologies in accordance with organisational licensing and manufacturer specifications.
  • Use software to collect, store and retrieve data.
  • Check and verify computer input and output with a suitable person.
  • Code and record data in accordance with organisational and/or professional standards.
  • Store and retrieve data in accordance with accepted standards, with metadata included.
  • Use geographic information system (GIS) and database tools to access and retrieve a range of data.
       
Element: Process raw data
  • Validate data in accordance with statistical standards.
  • Use GIS and spreadsheet tools to retrieve data and present it in a suitable format.
  • Identify spurious or inaccurate data.
  • Ensure data is confidential.
       
Element: Maintain records
  • Manage the dataset in accordance with accepted standards.
  • Design long-term archiving systems in accordance with accepted standards.
  • Perform workplace processes in accordance with relevant quality assurance standards.
  • Validate data to ensure accuracy and consistency of data in the dataset.
       
Element: Use software tools to collect and/or store data
  • Use computer technologies in accordance with organisational licensing and manufacturer specifications.
  • Use software to collect, store and retrieve data.
  • Check and verify computer input and output with a suitable person.
  • Code and record data in accordance with organisational and/or professional standards.
  • Store and retrieve data in accordance with accepted standards, with metadata included.
  • Use geographic information system (GIS) and database tools to access and retrieve a range of data.
       
Element: Process raw data
  • Validate data in accordance with statistical standards.
  • Use GIS and spreadsheet tools to retrieve data and present it in a suitable format.
  • Identify spurious or inaccurate data.
  • Ensure data is confidential.
       
Element: Maintain records
  • Manage the dataset in accordance with accepted standards.
  • Design long-term archiving systems in accordance with accepted standards.
  • Perform workplace processes in accordance with relevant quality assurance standards.
  • Validate data to ensure accuracy and consistency of data in the dataset.
       


Evidence Required

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

PERFORMANCE CRITERIA

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 section.

1. Use software tools to collect and/or store data

1.1 Use computer technologies in accordance with organisational licensing and manufacturer specifications.

1.2 Use software to collect, store and retrieve data.

1.3 Check and verify computer input and output with a suitable person.

1.4 Code and record data in accordance with organisational and/or professional standards.

1.5 Store and retrieve data in accordance with accepted standards, with metadata included.

1.6 Use geographic information system (GIS) and database tools to access and retrieve a range of data.

2. Process raw data

2.1 Validate data in accordance with statistical standards.

2.2 Use GIS and spreadsheet tools to retrieve data and present it in a suitable format.

2.3 Identify spurious or inaccurate data.

2.4 Ensure data is confidential.

3. Maintain records

3.1 Manage the dataset in accordance with accepted standards.

3.2 Design long-term archiving systems in accordance with accepted standards.

3.3 Perform workplace processes in accordance with relevant quality assurance standards.

3.4 Validate data to ensure accuracy and consistency of data in the dataset.

Evidence required to demonstrate competence must satisfy all of the requirements of the elements and performance criteria. If not otherwise specified the candidate must demonstrate evidence of performance of the following on at least one occasion.

applying legislation, regulations, policies and standards relating to statistical data processing

using at least one database management tool

using information technology, including spreadsheets and databases

undertaking critical analysis and problem solving

recordkeeping

reading and interpreting information

using numeracy skills for data analysis/validation

Evidence required to demonstrate competence must satisfy all of the requirements of the elements and performance criteria. If not otherwise specified the depth of knowledge demonstrated must be appropriate to the job context of the candidate.

public sector legislation including WHS and environment, regulations, policies, procedures and guidelines relating to statistical data processing privacy and confidentiality

statistical standards and classifications

data processing concepts and systems

workplace quality assurance standards

management information policies

Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)

Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

ELEMENTS

PERFORMANCE CRITERIA

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 section.

1. Use software tools to collect and/or store data

1.1 Use computer technologies in accordance with organisational licensing and manufacturer specifications.

1.2 Use software to collect, store and retrieve data.

1.3 Check and verify computer input and output with a suitable person.

1.4 Code and record data in accordance with organisational and/or professional standards.

1.5 Store and retrieve data in accordance with accepted standards, with metadata included.

1.6 Use geographic information system (GIS) and database tools to access and retrieve a range of data.

2. Process raw data

2.1 Validate data in accordance with statistical standards.

2.2 Use GIS and spreadsheet tools to retrieve data and present it in a suitable format.

2.3 Identify spurious or inaccurate data.

2.4 Ensure data is confidential.

3. Maintain records

3.1 Manage the dataset in accordance with accepted standards.

3.2 Design long-term archiving systems in accordance with accepted standards.

3.3 Perform workplace processes in accordance with relevant quality assurance standards.

3.4 Validate data to ensure accuracy and consistency of data in the dataset.

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
Use computer technologies in accordance with organisational licensing and manufacturer specifications. 
Use software to collect, store and retrieve data. 
Check and verify computer input and output with a suitable person. 
Code and record data in accordance with organisational and/or professional standards. 
Store and retrieve data in accordance with accepted standards, with metadata included. 
Use geographic information system (GIS) and database tools to access and retrieve a range of data. 
Validate data in accordance with statistical standards. 
Use GIS and spreadsheet tools to retrieve data and present it in a suitable format. 
Identify spurious or inaccurate data. 
Ensure data is confidential. 
Manage the dataset in accordance with accepted standards. 
Design long-term archiving systems in accordance with accepted standards. 
Perform workplace processes in accordance with relevant quality assurance standards. 
Validate data to ensure accuracy and consistency of data in the dataset. 
Use computer technologies in accordance with organisational licensing and manufacturer specifications. 
Use software to collect, store and retrieve data. 
Check and verify computer input and output with a suitable person. 
Code and record data in accordance with organisational and/or professional standards. 
Store and retrieve data in accordance with accepted standards, with metadata included. 
Use geographic information system (GIS) and database tools to access and retrieve a range of data. 
Validate data in accordance with statistical standards. 
Use GIS and spreadsheet tools to retrieve data and present it in a suitable format. 
Identify spurious or inaccurate data. 
Ensure data is confidential. 
Manage the dataset in accordance with accepted standards. 
Design long-term archiving systems in accordance with accepted standards. 
Perform workplace processes in accordance with relevant quality assurance standards. 
Validate data to ensure accuracy and consistency of data in the dataset. 

Forms

Assessment Cover Sheet

PSPGEN063 - Process statistical data
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:

Assessment Record Sheet

PSPGEN063 - Process statistical data

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: