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

Part B: Course Detail

Teaching Period: Term2 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 Email: amanpreet.singh@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

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

None

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

Element:

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.

Element:

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

Element:

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.


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
Charts
 

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


References


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 availabe to buyers in Excel

IT Test 2 30%

Students must display a basic understanding more advanced functions availabe to buyers in Excel. This may include Vlookup, 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 selction, customer invoice generator etc.


Assessment Matrix

Course Overview: Access Course Overview