ICTPRG528 Perform ICT data conversion
ICT50118 Diploma of Information Technology
Record of Assessment Outcome
Student name: Student ID:
Summary of evidence gathering techniques used for this assessment: O Written Assessment O Practical Assessment O Presentation
The evidence presented is:
O Valid O Sufficient O Authentic O Current
Unit result: Competent O Not Competent O
The student has been provided with feedback and informed of the assessment result and the reason for the decision.
Assessor name: Date assessed:
Assessor signature:
RTO contact info@scei.edu.au
Student declaration on assessment outcome
I have been provided with feedback on the evidence I have provided. I have been informed of the assessment result and the reason for the decision.
Student name: Date:
Student signature:
Reasonable Adjustment
Was reasonable adjustment applied to any of the assessment tasks? (please tick) Yes O No O
If yes, tick which assessment task(s) it was applied to.
O Written Assessment O Practical Assessment O Presentation
Provide a description of the adjustment applied and why it was applied.
Name of assessor: Assessor signature:
Name of student: Student signature:
Student Declaration
Plagiarism constitutes extremely serious academic misconduct and severe penalties are associated with it. By signing below, you are declaring that the attached work is entirely your own (or where submitted to meet the requirements of an approved group assessment, is the work of the group). I certify that
? I have read and understood the Southern Cross Education Institute’s PP77 Assessment and submission policy and procedures.
? This assessment is all my own work, and no part of this assessment has been copied from another person.
? I have not allowed my work to be copied by another person.
? I have a copy of this work and will be able to reproduce within 24 hours if requested.
I give my consent for Southern Cross Education Institute to examine my work electronically by relevant plagiarism software programs.
Student signature: .......................................................... Date: ......../........../................
Assessment Outcome Summary and Feedback
Assessment Task 1 – Written Assessment
Submission No. Result Date
Assessed Assessor Name Assessor Signature
O First submission O S O NS
O Re-submission 1 O S O NS
O Re-submission 2 O S O NS
S = Satisfactory NS = Not Satisfactory
Feedback to the Student:
Assessment Task 2 – Practical Assessment
Submission No. Result Date
Assessed Assessor Name Assessor Signature
O First submission O S O NS
O Re-submission 1 O S O NS
O Re-submission 2 O S O NS
S = Satisfactory NS = Not Satisfactory
Feedback to the Student:
Assessment Task 3 – Presentation
Submission No. Result Date
Assessed Assessor Name Assessor Signature
O First submission O S O NS
O Re-submission 1 O S O NS
O Re-submission 2 O S O NS
S = Satisfactory NS = Not Satisfactory
Feedback to the Student:
Student Instructions
This unit describes the skills and knowledge required to translate information and communications technology (ICT) data from one format to another, by means of a data conversion process.
To achieve competency the following assessment tasks must be successfully completed in the time allocated with the essential resources. Your trainer/assessor will give you the due date to submit the assessments and provide you with feedback after assessing your work.
Refer to the table below for the summary of assessment tasks for this unit:
Assessment Task
Number Assessment Type Notes
1 Written Assessment To be completed by the due date provided by the trainer/assessor
2 Practical Assessment To be completed by the due date provided by the trainer/assessor
3 Presentation Date of presentation to be arranged with trainer/assessor. Will be conducted during class time.
• Students will be given the Student assessment at the beginning of the unit
• Students may need to spend some hours outside the class hours without supervision to complete the assessments
• All assessment tasks must be satisfactory to achieve competency in the unit
• All the units of competency must be deemed competent to complete the qualification and obtain a certificate
• The assessment requirement for this unit are presented clearly in the Unit of Competency located at https://training.gov.au/Training/Details/ICTPRG528 • In the Student assessment, you must be able to:
o Answer all questions o Complete all assessment tasks within the required timeframe o Complete all assessments tasks to a satisfactory standard • The following resources are required for this assessment:
• appropriate documentation and resources normally used in the workplace
• business documentation
• appropriate learning and assessment support when required
• computer with internet access
• Access to word processing, spreadsheet and PowerPoint software
Reasonable adjustment
For information on reasonable adjustment please refer to the Student handbook located at:
http://www.scei.edu.au/documents/international/Student_handbook.pdf
Record of assessment outcome
After all of the assessment evidence has been gathered from the assessment tasks for this unit/cluster of units of competency the Record of Assessment stating your result will be completed.
Information for the Student
If you do not understand any part of the unit or the assessments you are required to undertake, please talk with your trainer/assessor. It is important that you understand all of the aspects of the learning and assessment process that you will be undertaking. This will make it easier for you to learn and be successful in your studies.
Assessment Task 1 – Written Assessment
Instructions for completion
STUDENT
• You are required to answer all questions in Assessment Task 1 – Written Assessment
• Responses to the questions must be typed (not hand written)
• Use of correct grammar and spelling is required to demonstrate foundational skills
• Use of APA referencing must be used where original sources other than your own have been used – to avoid plagiarism
• Write your name, Student ID, the assessment task and the name of the unit of competency on each piece of paper you attach to this assessment document
• Submit to your trainer/assessor by the due date
DUE DATE • The trainer/assessor will inform you of the due date
The due date for this task is _____________________________
1. Explain the following steps to plan for a successful data conversion from one file format to other file format or one data file to other data file
• Understand the existing data file or data store or table or database.
• Recognize the risks involved in data conversion (one file format to the other format , one database system to the other, one table to other table)
• Feedback Questionnaire for stakeholders
• Steps involved in system backup
• Steps involved in mapping data fields of old and new systems.
• Steps involved in rectification of rejected data (fields or records)
• Steps involved in test data conversion
• Steps involved in full volume conversion
• Prepare parameters (values) to validate conversion data
2. Explain the following actions that you need to take when you perform data conversion.
• Estimate time frame for data conversion • Prepare the system for data conversion
• Procedure for backup data stores/data files.
• Perform the data conversion (export/ import) without affecting operational database/data file.
• Perform the data conversion
• Document the results ( include successful data conversion or rejected data fields or records)
3. List three data conversion tools and data modeling techniques?
Assessment Task 2 – Practical Assessment
Instructions for completion • Read this assessment task, complete all the requirements and submit to the trainer/assessor by the due date
• Assessment tasks must be typed (not hand written)
• Use of correct grammar and spelling is required to demonstrate foundational skills
• Use of APA referencing must be used where original sources other than your own have been used – to avoid plagiarism
• Write your name, student ID, the assessment task and the name of the unit of competency on each piece of paper you submit for assessment
Due Date • The trainer/assessor inform you of the due date
The due date for this task is _____________________________
You are required to run this program and create a step by step procedure in a separate word document. The procedure you outline should indicate that you are competent in converting string to numbers. You are required to:
• Analyse the string data
• Perform the conversion from string to number
To be assessed as competent, you will need to run the program using at least 3 pairs of input and show the output of this program to the assessor.
Note to learners:
Frequently, a program ends up with numeric data in a string object—a value entered by the user, for example. The number subclasses that wrap primitive numeric types ( Byte, Integer, Double, Float, Long, and Short) each provide a class method named ‘valueOfthat’ converts a string to an object of that type. Here is an example, ValueOfDemo, that gets two strings from the command line, converts them to numbers, and performs arithmetic operations on the values:
public class ValueOfDemo {
public static void main(String[] args) {
// this program requires two
// arguments on the command line
if (args.length == 2) {
// convert strings to numbers
float a = (Float.valueOf(args[0])).floatValue(); float b = (Float.valueOf(args[1])).floatValue();
// do some arithmetic
System.out.println(-a + b = - +
(a + b));
System.out.println(-a - b = - +
(a - b));
System.out.println(-a * b = - +
(a * b));
System.out.println(-a / b = - +
(a / b));
System.out.println(-a % b = - +
(a % b));
} else {
System.out.println(-This program - +
-requires two command-line arguments.-);
}
}
}
You should demonstrate the following to your facilitator:
Criteria C NYC
Gather the data that requires conversion
Consider the backup procedures for the data
Map the data fields of new and the old system
Find the validation requirements such as data legal ranges
Action taken on the rejected data
Write and test the code to convert data as per the specifications
Estimated time for data conversion
Security features to protect data
Implement conversion program modules
Document the reasons for the rejected data
Document the results of the conversion process and submit to your facilitator
Assessment Task 3 – Presentation
Instructions for completion • Read this assessment task, complete all the requirements and submit to the trainer/assessor by the due date
• Presentation must be in PowerPoint - a minimum of five slides
• Presentation should be engaging to ensure it holds audience attention
• Presentation is 15 minutes in duration with an additional 5 minutes for questions and answers
• Use of correct grammar and spelling is required to demonstrate foundational skills
• Use APA referencing when using or quoting other sources
• Write your name, student ID, the assessment task and the name of the unit of competency on each piece of paper you submit for assessment
Due Date • The trainer/assessor inform you of the due date
The due date for this task is _____________________________
In this Assessment, you are required to present the Java program which you have created in Assessment Task 2 to your audience who has no prior knowledge of this topic. You are required to create a power point presentation which outlines step by step procedures of the program. The presentation should be detailed and show the audience how you carried out the following:
• Analyse the string data
• Perform the conversion from string to number • Software and Hardware requirements.
• Data conversion tools and data modelling methods used.
You will be given 15 minutes in class to deliver your presentation. At the end of the presentation you will have a 5 minutes question and answer session. The presentation should be simple, easy to understand and relatable to your audience.
Your trainer and assessor will be assessing you on:
• Communication skills to present information to others
• Audience engagement
• Information technology skills
• Literacy skills to present information that is easily understood by others
• Planning and organisational skills to plan, prioritise and monitor own work
• Research skills to gain and maintain relevant and current industry privacy and ethical information • Covering all items listed above
• Knowledge of the subject presented
Assessment Criteria
• define the inherent data requirements of both old and upgraded, or new systems
• remodel data to achieve successful conversion
• back up data prior to conversion
• Effectively code conversion programs.