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

ICTICT207 Mapping and Delivery Guide
Integrate commercial computing packages

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICTICT207 - Integrate commercial computing packages
Description
Employability Skills
Learning Outcomes and Application This unit describes the skills and knowledge required to manipulate, convert and integrate data between two or more different commercial software applications.It applies to individuals who require foundation skills and knowledge to use information and communications technology (ICT) in any ICT business or office environment.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Duration and Setting X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting.

Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the general information and communications technology (ICT) industry, and include access to:

a personal computer (PC) and printer

software currently used in industry

documents detailing organisational style guide and policy

documents or information containing data suitable for use with multiple computing packages.

Assessors must satisfy NVR/AQTF assessor requirements.
Prerequisites/co-requisites
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 work requirements
  • Identify the task requirement
  • Select appropriate software and file formats to perform required work
  • Obtain organisational documentation, such as procedures, manuals and guides, and use when appropriate
       
Element: Integrate data across different software application packages
  • Create a mailing list using a database, spreadsheet or address book, and merge mailing list with another document
  • Use software application package conversion tool to convert data from one format to another to enable additional work on the converted data
  • Save data to a new file format
  • Import objects from another software application package and modify as required to produce a required outcome
  • Export data to another software application package to produce a required outcome
  • Create a link between one software application package and another, and use this to update information to a document
       
Element: Save and retrieve data with the aid of help functions
  • Save data to disk
  • Convert data to a new file format
  • Re-access data and check information
  • Access user help documentation or other resources for basic difficulties with software application package
       


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.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Determine work requirements

1.1 Identify the task requirement

1.2 Select appropriate software and file formats to perform required work

1.3 Obtain organisational documentation, such as procedures, manuals and guides, and use when appropriate

2. Integrate data across different software application packages

2.1 Create a mailing list using a database, spreadsheet or address book, and merge mailing list with another document

2.2 Use software application package conversion tool to convert data from one format to another to enable additional work on the converted data

2.3 Save data to a new file format

2.4 Import objects from another software application package and modify as required to produce a required outcome

2.5 Export data to another software application package to produce a required outcome

2.6 Create a link between one software application package and another, and use this to update information to a document

3. Save and retrieve data with the aid of help functions

3.1 Save data to disk

3.2 Convert data to a new file format

3.3 Re-access data and check information

3.4 Access user help documentation or other resources for basic difficulties with software application package

Evidence of the ability to:

select appropriate software and file formats

create mailing list and merge with another document

manipulate and integrate data between commercial application software following organisational procedures.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual must:

outline current business practices related to preparing reports

identify features and functions of commercial computing packages

identify import and export software functions

outline processes for linking documents

outline workplace health and safety (WHS) principles and responsibilities for ergonomics

identify software packages used by the organisation

outline strategies for integrating commercial computing packages

outline the use of input and output devices.

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.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Determine work requirements

1.1 Identify the task requirement

1.2 Select appropriate software and file formats to perform required work

1.3 Obtain organisational documentation, such as procedures, manuals and guides, and use when appropriate

2. Integrate data across different software application packages

2.1 Create a mailing list using a database, spreadsheet or address book, and merge mailing list with another document

2.2 Use software application package conversion tool to convert data from one format to another to enable additional work on the converted data

2.3 Save data to a new file format

2.4 Import objects from another software application package and modify as required to produce a required outcome

2.5 Export data to another software application package to produce a required outcome

2.6 Create a link between one software application package and another, and use this to update information to a document

3. Save and retrieve data with the aid of help functions

3.1 Save data to disk

3.2 Convert data to a new file format

3.3 Re-access data and check information

3.4 Access user help documentation or other resources for basic difficulties with software application package

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 the task requirement 
Select appropriate software and file formats to perform required work 
Obtain organisational documentation, such as procedures, manuals and guides, and use when appropriate 
Create a mailing list using a database, spreadsheet or address book, and merge mailing list with another document 
Use software application package conversion tool to convert data from one format to another to enable additional work on the converted data 
Save data to a new file format 
Import objects from another software application package and modify as required to produce a required outcome 
Export data to another software application package to produce a required outcome 
Create a link between one software application package and another, and use this to update information to a document 
Save data to disk 
Convert data to a new file format 
Re-access data and check information 
Access user help documentation or other resources for basic difficulties with software application package 

Forms

Assessment Cover Sheet

ICTICT207 - Integrate commercial computing packages
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

ICTICT207 - Integrate commercial computing packages

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: