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

Part B: Course Detail

Teaching Period: Term1 2010

Course Code: MIET6060C

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

School: 350T Fashion & Textiles

Campus: Brunswick Campus

Program: C6086 - Advanced Diploma of Fashion and Textiles Merchandising

Course Contact : Russell Edis

Course Contact Phone: +61 3 99259496

Course Contact Email:russell.edis@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:

1.1Type of work to be performed is determined
1.2Required Technology is identified
1.3Software applications to be used are identified if required
1.4Data input or information sources to be used are identified
2.1 Ergonomic conditions are established as required
2.2 Key features of technology are identified
2.3 Technology is started and shut down according to workplace practices
2.4 Technology is used according to workplace practices and workplace OH&S practices
2.5 Assistance is accessed if required
2.6 Impact of technology use on production of TCF product is explained and related to the work role

3.1 Software application menus are navigated to access information
3.2 Information or data is entered, changed or removed as required
3.3 Information or data is saved and stored according to workplace practices
3.4 Key features of software application are identified


Learning Outcomes



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

1 Word Processing. Creating, editing simple documents
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, and use information to search for documents stored on the system.
Printing documents to PDF format
Inserting symbols.
Using the endnote and footnote feature
Use manuals and on-line help to solve problems.
Text Editing.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
 Assignment Cover Sheet


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.
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
 Header and Footer Exercise


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.


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.
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
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.
Find and Replace.doc

5 Create and edit the Auto-text items.
Create edit and apply Styles
Create and edit Table of Contents and Indexes 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 TOC.doc
Styles.doc
AutoText.doc


6 Quiz. - Practical assessment using computer technology
40% of assessment


7 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


8 Formatting a worksheet

Creating a Worksheet.

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
Protecting a Worksheet.
Format.xls.
Format Exercise 2.xls.


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

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


10 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


11 Creating and Editing Charts
Selecting the most suitable chart for presenting information 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 Creating Charts, Chart Exercise1, Chart Exercise 3


12 Using VLOOKUP functions.
Identify the components of a function. Use 0 or 1 switch exact matches or over a range.

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 VLOOKUP Examples
Fabric Calculator


13 IF Functions.
IF functions, create simple logic in worksheet.
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
IF Examples.xls.


14 Using the advanced filter feature
Set up the structures in an Excel worksheet to create a database.

Use simple macro to automate filter process.
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
Database Names.xls
PhoneList.xls

15 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
Macros.
Record simple macros, apply macros to buttons.

Record macros through demonstration. Distinguish between absolute and relative macros. Create buttons to activate macro.
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 Excel Macro Exercise


16 Quiz. - Practical assessment using computer technology 60% of assessment


Learning Resources

Prescribed Texts


References


Other Resources


Overview of Assessment

Quiz. - Practical assessment using computer technology


Assessment Tasks

Graphics Quiz Illustrator and Photoshop


Assessment Matrix

Course Overview: Access Course Overview