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

ICAPRG402A Mapping and Delivery Guide
Apply query language

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICAPRG402A - Apply query language
Description This unit describes the performance outcomes, skills and knowledge required to retrieve and manipulate information stored in information systems using a query language.
Employability Skills This unit contains employability skills.
Learning Outcomes and Application This unit applies to individuals in a range of work environments who are required to extract information from a source, such as database, text file, and eXtensible markup language (XML), by creating and running queries.These individuals may support the job functions of managers and developers. They may work as application support, database support, junior IT administrator, database programmer and data programmer.
Duration and Setting X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting.
Prerequisites/co-requisites Not applicable.
Competency Field
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: Determine the requirements of developing queries
  • Recognise various query-related terminologies
  • Identify the type of data source for a chosen query language
  • Identify and use necessary tools and environment in building queries
       
Element: Write queries to retrieve and sort values
  • Use an expression to retrieve values from a single unit
  • Use an expression to combine values from more than one unit
  • Use an expression to sort values into certain order
       
Element: Write queries to selectively retrieve values
  • Use an expression to filter a sequence based on a predicate or condition
  • Use an expression to filter a subset of sequence based on a predicate or condition
  • Use an expression to extract a specific value by position
       
Element: Perform calculation in queries
  • Use expression to perform calculation on numeric values
  • Use expression to perform operation on text values
  • Use expression to perform operation on date and time values
       


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.

The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.

Overview of assessment

Critical aspects for assessment and evidence required to demonstrate competency in this unit

Evidence of the ability to:

select and use tools in developing, storing and executing queries to extract the appropriate data required for ad hoc reports or to support developers

incorporate calculations using:

control statements

operators

functions.

Context of and specific resources for assessment

Assessment must ensure access to:

tools in:

accessing a data source

developing queries using the chosen query language

specific requirements, including client and functionality

policy and naming standard

resources to aid calculation

appropriate learning and assessment support when required

modified equipment for people with special needs.

Method of assessment

A range of assessment methods should be used to assess practical skills and knowledge. The following examples are appropriate for this unit:

evaluation of candidate’s ability to:

integrate query into larger systems to support application development team

implement programmability objects (such as stored procedures) containing queries stored in an information system to support operational functions

direct observation of candidate using query language to retrieve or manipulate data

verbal or written questioning to assess candidate’s knowledge of the features of the query language.

Guidance information for assessment

Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, where appropriate.

Assessment processes and techniques must be culturally appropriate, and suitable to the communication skill level, language, literacy and numeracy capacity of the candidate and the work being performed.

Indigenous people and other people from a non-English speaking background may need additional support.

In cases where practical assessment is used it should be combined with targeted questioning to assess required knowledge.

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.

Required skills

analytical skills to:

analyse and comprehend interdependencies between data fields

examine and define system requirements for data

review requirements and determine the availability of information

communication skills to:

interact with developer to determine data requirement

interact with end user personnel to determine data requirement

liaise with management on report and result matters

literacy skills to:

produce basic ad hoc report

read and interpret specifications developed by business and technical experts

numeracy skills to:

make basic calculations involving basic arithmetic operations

make estimates and comparisons involving date and time data

problem-solving skills to:

address common problems in operating a computer system

perform basic debugging, such as defining simple problems, locating source of the problems, and providing solutions to problems

technical skills to:

perform basic data-management operations, such as insert, update and delete operations

perform basic operations of a computer system.

Required knowledge

broad knowledge of:

information gathering methods

data analysis

data mining

characteristics of data source

features of information system

typical systems and procedures.

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.

Terminologies may include:

attribute

command

data item

expressions

item type

statement.

Data source may include:

arrays

databases

entities

enumerable classes

objects

text files

eXtensible markup language (XML).

Query language may include:

abstract object query language (AOQL)

XML

Google base query language (GBQL)

Java persistence query language (JPQL)

language integrated query (LINQ)

structured query language (SQL)

xQuery.

Tools may include:

application programming interface (API)

class libraries

database engine

integrated development environment (IDE)

programming language.

Expression may include:

function

operator

statement.

Unit may include:

node

object

result set

table.

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
Recognise various query-related terminologies 
Identify the type of data source for a chosen query language 
Identify and use necessary tools and environment in building queries 
Use an expression to retrieve values from a single unit 
Use an expression to combine values from more than one unit 
Use an expression to sort values into certain order 
Use an expression to filter a sequence based on a predicate or condition 
Use an expression to filter a subset of sequence based on a predicate or condition 
Use an expression to extract a specific value by position 
Use expression to perform calculation on numeric values 
Use expression to perform operation on text values 
Use expression to perform operation on date and time values 

Forms

Assessment Cover Sheet

ICAPRG402A - Apply query language
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

ICAPRG402A - Apply query language

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: