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

Part B: Course Detail

Teaching Period: Term1 2009

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

2.  Use technology

3.  Select and use program features

 

Performance Criteria:

Elements

1. Identify design brief

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 design tools
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 Assess electronic outputs
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.

4 Maintain electronic design systems
4.1 Designs, patterns or production specifications are created, stored, organised and protected.
4.2 Design programs and equipment are used , maintained and stored.
.


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

• Demonstrations and practical hands-on experience of computer software including word processor, spreadsheet, database, graphic and presentation applications.
• Use of the Internet as a learning tool to conduct research and gather information.
• Use of self-paced software and educational videos to develop skills in using software packages.


Teaching Schedule

 

Week1Session – TopicElement
Performance Criteria
Assessment Tasks
1

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 
2Create 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 
3Create 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.4Table Exercise 1
Table Exercise 2
Create a simple Survey document.
4Creating 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.4Setting Tab Stops
Tab Stop Exercise 1.
Tab Stop Exercise 2.
5Managing 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.4Find and Replace.doc
6Create 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 
7Quiz
 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.440% of assessmentX
8PowerPoint - 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 
9Spreadsheets, 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 
10Formatting 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
11Using 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 
12Linking 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 
13Creating 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 
14Using 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 
 15

IF Functions. 

Ise function to create simple logic to 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 
 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 
16Advanced 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 
17Macros.
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 
18Quiz.

 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.460% of assessment


Learning Resources

Prescribed Texts


References


Other Resources


Overview of Assessment

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


Assessment Tasks

Practical Demonstrationsperformed under test conditions


Assessment Matrix

Course Overview: Access Course Overview