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
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: |
<font face="Times New Roman" size="3"> </font>
<font face="Times New Roman" size="3"> </font> |
|
Element: |
3. Select and use program features |
|
Performance Criteria: |
<font face="Times New Roman" size="3"> </font>
<font face="Times New Roman" size="3"> </font> |
|
Element: |
1. Determine work requirements |
|
Performance Criteria: |
<font face="Times New Roman" size="3"> </font>
<font face="Times New Roman" size="3"> </font> |
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
<font face="Times New Roman" size="3"> </font>
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>
<font face="Times New Roman" size="3"> </font>
Use the Intod.xls file to demonstrate concepts.
Costing Sheets and BOM
Build a Cash Flow Budget
<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
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>
<font face="Times New Roman" size="3"> </font>
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>
<font face="Times New Roman" size="3"> </font>
week 4
Progressive assessment 1 – 30%
Sorting data
Grouping data
Simple Filter<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
week 5<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
* 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>
<font face="Times New Roman" size="3"> </font>
week 6<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Creating and Editing Charts
Selecting the most suitable chart for presenting information.
Labelling the data.
Chart exercise
<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Week 7<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Text to Columns
Pivot Tables
Create to tables, analyse marketing data
Charts
<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Week 8<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
IF Functions.
Introduce simple IF functions into models to test data.
<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Week 9<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
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>
<font face="Times New Roman" size="3"> </font>
Week 10<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Progressive assessment 2 – 30%<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Week 11<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
IF Functions.
Nested IF functions
Using AND and OR in logical test
<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Week 12<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
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>
<font face="Times New Roman" size="3"> </font>
Week 13<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Index Functions
Using the Match function.
<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
week 14<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
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>
<font face="Times New Roman" size="3"> </font>
Week 15<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
What If Analysis
Goal Seeker
Quick Revision Sheet
<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Week 16<o:p></o:p>
<font face="Times New Roman" size="3"> </font>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
<font face="Times New Roman" size="3"> </font>
IT Test 1 30%<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
Students must display a basic understanding of some of the rudimentary functions availabe to buyers in Excel<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
IT Test 2 30%<o:p></o:p>
<font face="Times New Roman" size="3"> </font>
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>
<font face="Times New Roman" size="3"> </font>
IT Test 3 40%<o:p></o:p>
<font face="Times New Roman" size="3"> </font>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