NTISthis.com

Evidence Guide: ICADBS408A - Link an RFID system to a database

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

 

ICADBS408A - Link an RFID system to a database

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

Determine data mapping and integration requirements

  1. Identify and document the format of the data from the RFID system, including data schema
  2. Collect required data, target database requirements and implementation details ensuring uniqueness of entries
Identify and document the format of the data from the RFID system, including data schema

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Collect required data, target database requirements and implementation details ensuring uniqueness of entries

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Perform data transition

  1. Write and test conversion programs and use conversion tools
  2. Ensure clean data take-on by converting according to database requirements
  3. Use database adaptors and interfaces for data transition
Write and test conversion programs and use conversion tools

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Ensure clean data take-on by converting according to database requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Use database adaptors and interfaces for data transition

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Check data transition

  1. Verify that data transition has been completed according to requirements
  2. Document programs, procedures and processes according to clients requirements
  3. Provide conversion reports to client for sign-off
Verify that data transition has been completed according to requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Document programs, procedures and processes according to clients requirements

Completed
Date:

Teacher:		 Evidence:

 

 

 

 

 

 

 

Provide conversion reports to client for sign-off

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:

identify formats of RFID system output and data fields in database

analyse, write, install and test conversion programs

identify format of data fields of database

write or obtain, and install conversion software

compile entries in database reports.

Context of and specific resources for assessment

Assessment must ensure access to:

conversion tools

database software

networked computers

organisational guidelines

RFID equipment specifications

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:

direct observation of candidate configuring an RFID system and database using a range of equipment in a variety of scenarios

evaluation of candidate’s documentation that includes programs, procedures and processes

review of candidate-generated conversion reports.

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 determine data objects required, data structures and business requirements

communication skills to liaise with clients to discuss issues

literacy skills to generate database and sample reports

technical skills to:

build a database using a commercially available database product, including Microsoft Structured Query Language (MS SQL) Server 7.0, Oracle and Sybase

register a data source name (DSN)

use appropriate database data formats

use appropriate RFID data formats

use data conversion programs

use hypertext markup language (HTML) or eXtensible markup language (XML)

use ISO/IEC standard 15962:2004 as a reference

use website administration software and site server utilities.

Required knowledge

client database data structures

client data management and data security policy and procedures

data analysis, particularly in determining data types and data structures and query and report design

data source names in use by the organisation

open database connection (ODC)

primary files and transaction logs to confirm appropriate database activity

quality assurance practices

software tools

system data requirements

system’s current functionality

website foundations.

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.

Database may include:

commercial off-the-shelf (COTS) database packages

object-relational databases

proprietary databases

relational databases

software:

Access connected to a structured query language (SQL) server

DB2

Informix

Ingres

Microsoft SQL (MS SQL) server

Mini SQL (mSQL)

MySQL

Oracle

Sybase.

Conversion programs may be in:

object-oriented language

procedural programming language.

Conversion tools may include:

analysis of data quality:

QDB or Analyze

WizRule

Unitech Systems Inc

cleansing data:

Integrity

Enterprise or Integrator

data-mart management

extraction and transformation:

Evolutionary Technologies International (ETI) extract

InfoPump, InfoHub, InfoRefiner and InfoSuite

Passport

Warehouse Manager.