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

ICADBS408A Mapping and Delivery Guide
Link an RFID system to a database

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICADBS408A - Link an RFID system to a database
Description This unit describes the performance outcomes, skills and knowledge required to transfer radio frequency identification (RFID) data to a database.No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement but users should confirm requirements with the relevant federal, state or territory authority.
Employability Skills This unit contains employability skills.
Learning Outcomes and Application This unit applies to individuals in a range of information and communications technology (ICT) areas who are required to maintain RFID data and make kit available to an RFID system.
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 data mapping and integration requirements
  • Identify and document the format of the data from the RFID system, including data schema
  • Collect required data, target database requirements and implementation details ensuring uniqueness of entries
       
Element: Perform data transition
  • Write and test conversion programs and use conversion tools
  • Ensure clean data take-on by converting according to database requirements
  • Use database adaptors and interfaces for data transition
       
Element: Check data transition
  • Verify that data transition has been completed according to requirements
  • Document programs, procedures and processes according to clients requirements
  • Provide conversion reports to client for sign-off
       


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:

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.

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 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.

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.

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
Identify and document the format of the data from the RFID system, including data schema 
Collect required data, target database requirements and implementation details ensuring uniqueness of entries 
Write and test conversion programs and use conversion tools 
Ensure clean data take-on by converting according to database requirements 
Use database adaptors and interfaces for data transition 
Verify that data transition has been completed according to requirements 
Document programs, procedures and processes according to clients requirements 
Provide conversion reports to client for sign-off 

Forms

Assessment Cover Sheet

ICADBS408A - Link an RFID system to a database
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

ICADBS408A - Link an RFID system to a database

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: