NTISthis.com

Evidence Guide: ICAPRG402A - Apply query language

Student: __________________________________________________

Signature: _________________________________________________

Tips for gathering evidence to demonstrate your skills

The important thing to remember when gathering evidence is that the more evidence the better - that is, the more evidence you gather to demonstrate your skills, the more confident an assessor can be that you have learned the skills not just at one point in time, but are continuing to apply and develop those skills (as opposed to just learning for the test!). Furthermore, one piece of evidence that you collect will not usualy demonstrate all the required criteria for a unit of competency, whereas multiple overlapping pieces of evidence will usually do the trick!

From the Wiki University

 

ICAPRG402A - Apply query language

What evidence can you provide to prove your understanding of each of the following citeria?

Determine the requirements of developing queries

  1. Recognise various query-related terminologies
  2. Identify the type of data source for a chosen query language
  3. Identify and use necessary tools and environment in building queries
Recognise various query-related terminologies

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify the type of data source for a chosen query language

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Identify and use necessary tools and environment in building queries

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Write queries to retrieve and sort values

  1. Use an expression to retrieve values from a single unit
  2. Use an expression to combine values from more than one unit
  3. Use an expression to sort values into certain order
Use an expression to retrieve values from a single unit

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to combine values from more than one unit

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to sort values into certain order

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Write queries to selectively retrieve values

  1. Use an expression to filter a sequence based on a predicate or condition
  2. Use an expression to filter a subset of sequence based on a predicate or condition
  3. Use an expression to extract a specific value by position
Use an expression to filter a sequence based on a predicate or condition

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to filter a subset of sequence based on a predicate or condition

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use an expression to extract a specific value by position

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Perform calculation in queries

  1. Use expression to perform calculation on numeric values
  2. Use expression to perform operation on text values
  3. Use expression to perform operation on date and time values
Use expression to perform calculation on numeric values

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use expression to perform operation on text values

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use expression to perform operation on date and time values

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Assessed

Teacher: ___________________________________ Date: _________

Signature: ________________________________________________

Comments:

 

 

 

 

 

 

 

 

Instructions to Assessors

Evidence Guide

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.

Required Skills and Knowledge

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.

Range Statement

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.