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

Part B: Course Detail

Teaching Period: Term2 2013

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

Marianne Centner

marianne.centner@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:

1.  Determine work requirements

2.  Use technology

3.  Select and use program features

 

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,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.
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

National Element Code & Title: LMTGN2010B Operate computing technology in a Textiles, Clothing and Footwear workplace
Element: 1. Determine work requirements
2. Use technology
3. Select and use program features
 


Teaching Schedule

Week1 Session – Topic Element
Performance Criteria Assessment Tasks
Word Processing. Creating, editing and printing simple documents using Word.
Using the menu, tool-bars. viewing the document
Change Page setup
Change margin settings
Change the page orientation.
Line spacing
Paragraph formatting, alignment, numbering
Bullets and Numbering Paragraphs
Superscripts and subscripts
Document Properties, apply names, keywords, use information to search for documents stored on the system.
Inserting symbols.
Using the endnote and footnote feature
Use manuals and on-line help to solve problems.
Text Editing.doc
Assignment Cover Sheet 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 2: Create and edit Headers and Footers.
Use page numbering, filename and path codes
Use Section Breaks to have different headers and footers in the document.
Change Page Orientation.
Change the starting page numbers in documents..
Format and edit simple documents using columns. Header and Footer Exercise 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 3: Create tables within a document, edit and print documents.
Merge and split cells, change the table and cell properties. Apply boarders, change specifications.
Use the examples of garment specification documents.
Inserting other files in a document. Use examples of Illustrator drawings, and Fabric Folio.
Use tables to create positioning map 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4 Table Exercise 1
Table Exercise 2
Create a simple Survey document.
Week 4: Creating and editing documents with Tab Stops. Identify the tab stops used for text and numbers.
Inserting, editing and manipulating graphics in a file. Re-size a picture and layout on page. 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4 Setting Tab Stops
Tab Stop Exercise 1.
Tab Stop Exercise 2.
Week 5: Managing electronic documents, finding documents on the network.
Using the Search and Replace text tools. Emphasize “whole words” feature to change particular words compared with a set of characters.
Use the Word-Art feature to create a Watermark effect on every page of a document. Place the watermark in the header centre object vertically and horizontally. 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4 Find and Replace.doc
Week 6: Create and edit the Auto-text items.
Create edit and apply Styles
Create and edit Table of Contents and Indexes TOC.doc
Styles.doc
AutoText.doc 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 7: Quiz 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4 40% of assessment
Week 8: PowerPoint - Creating Effective and Interesting Presentations.
Size of text, colour text and background, the amount of text per slide.
Create different slide formats. Create, edit, delete, move slides.
Format slide backgrounds, colour.
Create build and transition effects. Emphasize no build effects.
Apply images for example maps, fashion images.
Use graphics, charts, and tables.
Using Templates to create a simple presentation, of ten slides.
Apply footer details to master slide.
Build own templates. Apply images and text.
When to use animations in the presentations. Ten Page presentation 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 9: Spreadsheets, introduction to Excel. Design and Construct a spreadsheet. Use formula and enter data accurately. Assign attributes to data. Name and save correctly.
Edit and manipulate data.
Using data protection techniques in a model.
Formula (BODMAS)
Moving around the worksheet using GOTO F5.
Use manuals and online help to solve problems.
Use the Intod.xls file to demonstrate concepts. 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 10: Formatting a worksheet
Creating a Worksheet.
Protecting a Worksheet.
Format.xls.
Format Exercise 2.xls. 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 11: Using formula in worksheets.
Using Excel as a financial modelling tool.
Functions - Count, Max, Min, Average.
Using Names in formula, using GOTO with names.
Writing formula using Relative and Absolute cell references.
Date Functions. Create a calendar using formula to generate dates.
Format and print a spreadsheet document.
Formula Exercise
Merchandising Maths Exercise
Mark-ups and Margins.
Markdown Exercise, Creating a What-If-Analysis 1 and 2.
Break-Even Exercise.
Costing Sheets. 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 12: 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 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 13: Creating and Editing Charts
Suggested exercise Creating Charts, Chart Exercise1, Chart Exercise 3 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 14: Using VLOOKUP functions.
Suggested exercise VLOOKUP Examples
Fabric Calculator 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 15: IF Functions.
IF functions, create simple logic in worksheet. Suggested exercise IF Examples.xls. 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Week 16: Using the advanced filter feature
Set up the structures in an Excel worksheet to create a database.
Use simple macro to automate filter process.
Database Names.xls
PhoneList.xls 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Advanced Filter Feature
Queries using Multiple queries, for example more than one city, and selecting between a range of numbers
Correcting problems with database
Reference document (Word) - Using Excel as a Database
Clothing Survey Exercise
Pivot Tables
Clothing Survey Exercise 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Macros.
Record simple macros, apply macros to buttons.
Record macros through demonstration. Distinguish between absolute and relative macros. Create buttons to activate macro.
Excel Macro Exercise 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
Quiz. 1.1, 1.2, 1.3, 1.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6, 3.1, 3.2, 3.3,3.4
 


Learning Resources

Prescribed Texts


References


Other Resources


Overview of Assessment

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


Assessment Tasks

Test 1 75% Excel
Test 2 25% Word


Assessment Matrix

Course Overview: Access Course Overview