Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

Required Skills

Evidence Required

Critical Aspects of Evidence

Integrated demonstration of all elements of competency and their performance criteria

Databases are appropriate to task requirements and efficient input of data

Underpinning Knowledge

At this level the learner must demonstrate understanding of a broad knowledge base incorporating some theoretical concepts

Relevant legislation from all levels of government that affects business operation especially in regard to Occupational Health and Safety and environmental issues equal opportunity industrial relations and antidiscrimination

Organisational policy and procedures on

saving and backing up files

format of workplace reports documents

energy and resource conservation

databases including entry

database reports strategy

simple formulae

Underpinning Skills

Numeracy skills in relating to creating simple queries and using simple formulae

Ability to relate to people from a range of social cultural and ethnic backgrounds and physical and mental abilities

Resource Implications

The learner and trainer should have access to appropriate documentation and resources normally used in the workplace These may include

workplace reference materials such as style guides

computer equipment with database software

English dictionary

Consistency of Performance

In order to achieve consistency of performance evidence should be collected over a set period of time which is sufficient to include dealings with an appropriate range and variety of situations

Contexts of Assessment

Competency is demonstrated by performance of all stated criteria including paying particular attention to the critical aspects and the knowledge and skills elaborated in the Evidence Guide and within the scope as defined by the Range Statement

Assessment must take account of the endorsed assessment guidelines in the Business Services Training Package

Assessment of performance requirements in this unit should be undertaken in an actual workplace or simulated environment

Assessment should reinforce the integration of the key competencies and the business services common competencies for the particular AQF level Refer to the Key Competency Levels at the end of this unit

Key Competency Levels

Collecting analysing and organising information to determine the most appropriate database format

Communicating ideas and information through the production of effective database reports

Planning and organising activities to determine queries formulae and input data

Working with teams and others to determine database outputs and printing requirements

Using mathematical ideas and techniques while using queries and formulae in the database

Solving problems using manuals and online help

Using technology to create and use databases

Please refer to the Assessment Guidelines for advice on how to use the Key Competencies

Critical Aspects of Evidence

Integrated demonstration of all elements of competency and their performance criteria

Databases are appropriate to task requirements and efficient input of data

Underpinning Knowledge

At this level the learner must demonstrate understanding of a broad knowledge base incorporating some theoretical concepts

Relevant legislation from all levels of government that affects business operation especially in regard to Occupational Health and Safety and environmental issues equal opportunity industrial relations and antidiscrimination

Organisational policy and procedures on

saving and backing up files

format of workplace reports documents

energy and resource conservation

databases including entry

database reports strategy

simple formulae

Underpinning Skills

Numeracy skills in relating to creating simple queries and using simple formulae

Ability to relate to people from a range of social cultural and ethnic backgrounds and physical and mental abilities

Resource Implications

The learner and trainer should have access to appropriate documentation and resources normally used in the workplace These may include

workplace reference materials such as style guides

computer equipment with database software

English dictionary

Consistency of Performance

In order to achieve consistency of performance evidence should be collected over a set period of time which is sufficient to include dealings with an appropriate range and variety of situations

Contexts of Assessment

Competency is demonstrated by performance of all stated criteria including paying particular attention to the critical aspects and the knowledge and skills elaborated in the Evidence Guide and within the scope as defined by the Range Statement

Assessment must take account of the endorsed assessment guidelines in the Business Services Training Package

Assessment of performance requirements in this unit should be undertaken in an actual workplace or simulated environment

Assessment should reinforce the integration of the key competencies and the business services common competencies for the particular AQF level Refer to the Key Competency Levels at the end of this unit

Key Competency Levels

Collecting analysing and organising information to determine the most appropriate database format

Communicating ideas and information through the production of effective database reports

Planning and organising activities to determine queries formulae and input data

Working with teams and others to determine database outputs and printing requirements

Using mathematical ideas and techniques while using queries and formulae in the database

Solving problems using manuals and online help

Using technology to create and use databases

Please refer to the Assessment Guidelines for advice on how to use the Key Competencies

Range Statement

Legislation, codes and national standards relevant to the workplace which may include:

award and enterprise agreements and relevant industrial instruments

relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination

relevant industry codes of practice

Organisational policy and procedures may include:

log-on procedures

password protection

storage / location of data

standard formats

author's instructions

use of templates

Ergonomic requirements may include:

workstation height and layout

chair height, seat and back adjustment

screen position

keyboard and mouse position

document holder

avoiding radiation from computer screens

noise minimisation

Work organisation may include:

mix of repetitive and other activities

exercise breaks

Conservation techniques may include:

double-sided paper use

re-used paper for rough drafts (observing confidentiality requirements)

recycling used and shredded paper

utilising power-save options for equipment

Software functions may include:

field definitions / attributes

inserting / deleting blank lines and spaces

altering field widths

adding, deleting, moving, re-labeling fields

repeating (if available)

calculate/formula

formatting fields

formatting text

data protection

headers/footers

table, form and report wizards

Simple formulae may include:

combinations of above

Report formatting may include:

alignment on page

enhancements to format - borders, patterns and colours

enhancements to text

headers/footers

Data may include:

Checking may include:

accuracy of data

spelling, electronically and manually

accuracy of formulae with calculator

outcome of sorting / filtering

ensuring instructions with regard to content and format have been followed

Designated timelines may include:

timeline agreed with supervisor/person requiring database

timeline agreed with internal/external client

Printing may include:

Storage of data may include:

storage in electronic folders / sub-folders

storage on hard/floppy disk drives, CD ROM, tape backup

organisation policy for backing up files

organisation policy for filing hard copies of databases

filing locations

authorised access

Legislation, codes and national standards relevant to the workplace which may include:

award and enterprise agreements and relevant industrial instruments

relevant legislation from all levels of government that affects business operation, especially in regard to Occupational Health and Safety and environmental issues, equal opportunity, industrial relations and anti-discrimination

relevant industry codes of practice

Organisational policy and procedures may include:

log-on procedures

password protection

storage / location of data

standard formats

author's instructions

use of templates

Ergonomic requirements may include:

workstation height and layout

chair height, seat and back adjustment

screen position

keyboard and mouse position

document holder

avoiding radiation from computer screens

noise minimisation

Work organisation may include:

mix of repetitive and other activities

exercise breaks

Conservation techniques may include:

double-sided paper use

re-used paper for rough drafts (observing confidentiality requirements)

recycling used and shredded paper

utilising power-save options for equipment

Software functions may include:

field definitions / attributes

inserting / deleting blank lines and spaces

altering field widths

adding, deleting, moving, re-labeling fields

repeating (if available)

calculate/formula

formatting fields

formatting text

data protection

headers/footers

table, form and report wizards

Simple formulae may include:

combinations of above

Report formatting may include:

alignment on page

enhancements to format - borders, patterns and colours

enhancements to text

headers/footers

Data may include:

Checking may include:

accuracy of data

spelling, electronically and manually

accuracy of formulae with calculator

outcome of sorting / filtering

ensuring instructions with regard to content and format have been followed

Designated timelines may include:

timeline agreed with supervisor/person requiring database

timeline agreed with internal/external client

Printing may include:

Storage of data may include:

storage in electronic folders / sub-folders

storage on hard/floppy disk drives, CD ROM, tape backup

organisation policy for backing up files

organisation policy for filing hard copies of databases

filing locations

authorised access