• MEM11020B - Perform advanced warehouse computer operations

MEM11020B
Perform advanced warehouse computer operations

This unit covers identifying programs appropriate to the purpose, manipulating data for analysis and/or report generation and editing the program where required.

Application

This unit applies to advanced operations on warehouse computer information systems. It identifies the level of computer skills needed rather than the inventory system or product knowledge required.

Band: A

Unit Weight: 4


Prerequisites

Path 1

MEM16008A

Interact with computing technology


Elements and Performance Criteria

ELEMENT

PERFORMANCE CRITERIA

1. Identify programs appropriate to purpose

1.1. The range of programs available on the system is identified.

1.2. Correct selection of word processing, spreadsheet, database or special purpose program is made.

2. Manipulate data for analysis and/or report generation

2.1. Data is manipulated through merging of files, transfer of information between programs or other strategies to generate desired outcome.

3. Edit program

3.1. Categories in warehouse information system are created/deleted to cater for changes in stock lines.

3.2. Report formats are generated and/or modified.

3.3. Access control requirements are identified.

Required Skills

Required skills

Look for evidence that confirms skills in:

selecting and accessing program appropriate to task

performing data input and manipulation, editing programs, and formatting reports and production

identifying required program outputs

checking and clarifying task-related information

generating and modifying reports

producing accurate records related to the warehouse operations

Required knowledge

Look for evidence that confirms knowledge of:

application, features/functions and operation of relevant computer programs

stock control systems

recording requirements of enterprise

access control requirements

safe work practices and procedures

Evidence Required

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

A person who demonstrates competency in this unit must be able to identify programs appropriate to purpose, manipulate data for analysis and/or report generation and edit the program. Competency in this unit cannot be claimed until all prerequisites have been satisfied.

Critical aspects for assessment and evidence required to demonstrate competency in this unit

Assessors must be satisfied that the candidate can competently and consistently perform all elements of the unit as specified by the criteria, including required knowledge, and be capable of applying the competency in new and different situations and contexts.

Context of and specific resources for assessment

This unit may be assessed on the job, off the job or a combination of both on and off the job. Where assessment occurs off the job, that is the candidate is not in productive work, then an appropriate simulation must be used where the range of conditions reflects realistic workplace situations. The competencies covered by this unit would be demonstrated by an individual working alone or as part of a team. The assessment environment should not disadvantage the candidate.

This unit could be assessed in conjunction with any other units addressing the safety, quality, communication, materials handling, recording and reporting associated with identifying programs appropriate to purpose, manipulating data for analysis and/or report generation and editing the program or other units requiring the exercise of the skills and knowledge covered by this unit.

Method of assessment

Assessors should gather a range of evidence that is valid, sufficient, current and authentic. Evidence can be gathered through a variety of ways including direct observation, supervisor's reports, project work, samples and questioning. Questioning techniques should not require language, literacy and numeracy skills beyond those required in this unit of competency. The candidate must have access to all tools, equipment, materials and documentation required. The candidate must be permitted to refer to any relevant workplace procedures, product and manufacturing specifications, codes, standards, manuals and reference materials.

Guidance information for assessment


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.

Programs

Word processing, spreadsheet, database or special purpose programs

Data

Suppliers, pricing, stock in hand, shortages, invoicing, ordering, budget, reporting

Categories

Stock control, customers, suppliers, address/contact details, billing, debtor information


Sectors

Unit sector


Competency Field

Materials handling


Employability Skills

This unit contains employability skills.


Licensing Information

Not Applicable