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

Part B: Course Detail

Teaching Period: Term2 2015

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

Tallal Khan

tallal.khan@rmit.edu.au

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:

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<o:p></o:p>

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.<o:p></o:p>

3.2 Outputs are presented to appropriate personnel to assess accuracy and completeness.
3.3 improvements are made as required.<o:p></o:p>

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.<o:p></o:p>

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 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.<o:p></o:p>

Use the Intod.xls file to demonstrate concepts.
Costing Sheets and BOM
Build a Cash Flow Budget
<o:p></o:p>

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.
<o:p></o:p>

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

week 4
Progressive assessment 1 – 30%
Sorting data
Grouping data
Simple Filter<o:p></o:p>

week 5<o:p></o:p>

* 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.<o:p></o:p>

week 6<o:p></o:p>

Creating and Editing Charts
Selecting the most suitable chart for presenting information.
Labelling the data.
Chart exercise
<o:p></o:p>

Week 7<o:p></o:p>

Text to Columns
Pivot Tables
Create to tables, analyse marketing data
Charts
<o:p></o:p>

Week 8<o:p></o:p>

IF Functions.
Introduce simple IF functions into models to test data.
<o:p></o:p>

Week 9<o:p></o:p>

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
<o:p></o:p>

Week 10<o:p></o:p>

Progressive assessment 2 – 30%<o:p></o:p>

Week 11<o:p></o:p>

IF Functions.
Nested IF functions
Using AND and OR in logical test
<o:p></o:p>

Week 12<o:p></o:p>

VLOOKUP functions.
HLOOKUP funcions
Identify the components of a function. Use 0 or 1 switch exact matches or over a range
<o:p></o:p>

Week 13<o:p></o:p>

Index Functions
Using the Match function.
<o:p></o:p>

week 14<o:p></o:p>

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.
<o:p></o:p>

Week 15<o:p></o:p>

What If Analysis
Goal Seeker
Quick Revision Sheet
<o:p></o:p>

Week 16<o:p></o:p>

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%<o:p></o:p>

Students must display a basic understanding of some of the rudimentary functions availabe to buyers in Excel<o:p></o:p>

IT Test 2 30%<o:p></o:p>

Students must display a basic understanding more advanced functions availabe to buyers in Excel. This may include Vlookup, Advanced Filters, Macros and Combo boxes<o:p></o:p>

IT Test 3 40%<o:p></o:p>

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

Other Information

For the report, students need to submit their work in hard copy to offering teacher in person. A completed and signed assignment sheet must be attached to assignment before submission. Failing to submit work on time will be penalized by 5% of the assessment marks per day later than the due date

Course Overview: Access Course Overview

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

Part B: Course Detail

Index

Explore

Admin essentials

Learning support

Services and facilities

Work and study opportunities

Library

Explore

My employment

Services and tools

Teaching and student resources

Research support

Intranets