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:
analyse the requirements for the project
develop and design a database algorithm to match client requirements
communication skills to:
liaise with the client
understand client requirements
initiative and enterprise skills to:
create a database on a hosted service
research hosting requirements of the database
literacy skills to:
create the necessary documentation to document code
write end user documentation
planning and organisational skills to:
deliver a product that responds to client requirements
deliver the product by the due date
problem-solving skills to:
deliver a robust solution to a specific database requirement
translate an ER diagram to a database.
Required knowledge
basic knowledge of open platforms, including browsers and databases
creation of entities, attributes and populating fields using both software solutions and script based input
data-modelling techniques to design a database
database design, modelling and implementation
internet operation related to web servers and clients
naming conventions
security restrictions on servers, incorporating some theoretical concepts
best practice communication and accessibility for audiences with special needs.
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.
Documentation may include: | audit trails International Organization for Standardization (ISO), International Electrotechnical Commission (IEC) and Australian Standards (AS) standards naming standards project-management templates report-writing protocols version control. |
Appropriate person may include: | authorised business representative client supervisor. |
Language may include: | Access Informix Microsoft Structured Query Language (MS SQL) MySQL Oracle Postgre Structured Query Language (Postgre SQL) Sybase. |
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