Course Title: Operate computing technology in a Textiles, Clothing and Footwear workplace

Part B: Course Detail

Teaching Period: Term1 2016

Course Code: MIET6060C

Course Title: Operate computing technology in a Textiles, Clothing and Footwear workplace

School: 350T Fashion & Textiles

Campus: Brunswick Campus

Program: C4219 - Certificate IV in Fashion and Textiles Merchandising

Course Contact : Amanpreet Singh

Course Contact Phone: 9925 9163

Course Contact

Name and Contact Details of All Other Relevant Staff

Saravanan Thangavel

Nominal Hours: 50

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Pre-requisites and Co-requisites


Course Description

This course covers the skills and knowledge required to access and use computing technology used in a TCF workplace.

National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

LMTGN2009B Operate computing technology in a Textiles, Clothing and Footwear workplace


3. Select and use program features

Performance Criteria:

3.1 Outputs generated using electronic design programs are assessed against design specifications and production requirements.
3.2 Outputs are presented to appropriate personnel to assess accuracy and completeness.
3.3 improvements are made as required.


1.  Determine work requirements

Performance Criteria:

1.1 Design specifications are identified and interpreted.
1.2 Suitable programs ansd equipment are identified.
1.3 Garment considerations are identified.
1.4 Productions requirements are identified.


2. Use technology

Performance Criteria:

2,1 Design programs and equipment are used to create required designs, patterns or production specifications.
2.2 Design programs and equipment are used to modify and edit designs, patterns or production specifications.
2.3 Design programs and equipment are used to test designs, patterns or production specifications.
2.4 Design programs and equipment are used according to OH&S specifications

Learning Outcomes

On successful completion of this course you will have developed and applied the skills and knowledge required to demonstrate competency in the above elements.

Details of Learning Activities

Workshops will be conducted on using computer and MS office at workplace.

Teaching Schedule

Week Workshop Topic
week 1
Introduction to Excel.
Use simple formula and enter data accurately.
Name and save correctly.
Edit and manipulate data.
Worksheet protection, locking and unlocking cells in a model.
Formula, order of operation
Moving around the worksheet using GOTO F5.
Use the Intod.xls file to demonstrate concepts.
Costing Sheets and BOM
Build a Cash Flow Budget

week 2
Formatting a worksheet
Conditional Formatting
Writing formula using Relative and Absolute cell references.
Using formula to analyse marketing data.
Markup and Margins exercise
Markdown exercise
Paste Special exercise
Printing - Print selections, headers and footers. Printing large sections of a worksheet to multiple pages.

week 3
Functions - Count, Counta Max, Min, Average.
Using Names in formula, create, delete and modify names.
Navigation using names GOTO.
Using Cell comments

week 4
Progressive assessment 1 – 30%
Sorting data
Grouping data
Simple Filter

week 5
* Advanced Filter
Queries using Multiple queries, for example more than one city, and selecting between a range of numbers.
Correcting problems with database.
Record simple macros, apply macros to buttons.
Clothing Survey Exercise,
Record macros through demonstration. Distinguish between absolute and relative macros. Create buttons to activate macro
Phone List exercise.
Staff database exercise.

week 6
Creating and Editing Charts
Selecting the most suitable chart for presenting information.
Labelling the data.
Chart exercise

Week 7
Text to Columns
Pivot Tables
Create to tables, analyse marketing data

Week 8
IF Functions.
Introduce simple IF functions into models to test data.

Week 9
Linking worksheets and workbooks.
Use the Paste Special, Paste Link option to combine worksheet and workbook data.
Note the difference between Paste Value, and Paste Link
Linking Records – Sales data.doc
Quick Revision Sheet

Week 10
Progressive assessment 2 – 30%
Week 11
IF Functions.
Nested IF functions
Using AND and OR in logical test

Week 12
VLOOKUP functions.
HLOOKUP funcions
Identify the components of a function. Use 0 or 1 switch exact matches or over a range

Week 13
Index Functions
Using the Match function.

week 14
Macro for going to the end of the List
Appending data
Use the concept of a relative macro to demonstrate the process of appending data to lists.

Week 15
What If Analysis
Goal Seeker
Quick Revision Sheet

Week 16
Final assessment 40%


Learning Resources

Prescribed Texts


Other Resources

Overview of Assessment

In this course assessments will take place through practical activities and demonstrations.

Assessment Tasks

IT Test 1 30%
Students must display a basic understanding of some of the rudimentary functions available to buyers in Excel
IT Test 2 30%
Students must display a basic understanding more advanced functions available to buyers in Excel. This may include V-lookup, Advanced Filters, Macros and Combo boxes

IT Test 3 40%
Students must use Excel to produce a solution that will benefit a fashion related company. Solutions may include data selection, customer invoice generator etc.

Assessment Matrix

Course Overview: Access Course Overview