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 |
Performance Criteria: |
1.1Type of work to be performed is determined |
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