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.
Required skills
analytical skills to review and detect inconsistencies in database design
communication skills to liaise with users, particularly during the prototype phase
literacy skills to:
document user-training requirements
prepare reports and technical documentation
planning and organisational skills to:
complete tasks within required timeframe
complete tasks using organisation’s business structures
problem-solving skills to debug errors in coding
technical skills to:
convert and validate data during implementation
encrypt and authenticate database security features
install and use proprietary software
model data, particularly during the design and development phases
program structured query language (SQL), particularly during the development phase.
Required knowledge
overview knowledge of:
database management system (DBMS) fundamentals related to overall unit of competency, particularly during the design phase
OHS principles and responsibilities in regard to self and others while working in an IT environment
detailed knowledge of:
functions and features of databases
logical data model, particularly related to developing a prototype
object-model design concepts, particularly related to developing data structures, queries, screens and reports
object-oriented data model, particularly related to developing a prototype
physical design concepts, particularly related to developing a prototype
run time facilities related to implementing live database and operation of prototype
SQL programming language.
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.
Database may include: | DB2 Informix Ingres Microsoft SQL (MS SQL) server Mini SQL (mSQL) MySQL Oracle Postgre Structured Query Language (Postgre SQL) Sybase. |
Documentation may follow: | audit trails International Organization for Standardization (ISO), International Electrotechnical Commission (IEC) and Australian Standards (AS) standards naming standards project management templates report writing principles version control. |
Client may include: | clubs external organisations individuals internal departments internal employees. |
Database management system may include: | distributed or centralised online partitioned geographically thematically distributed. |
Requirements may relate to: | business network people in the organisation system. |
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