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 |
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
Week1 | Session – Topic | Element Performance Criteria |
Assessment Tasks |
1 |
Word Processing. Creating, editing and printing simple documents using Word. 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 | |
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 | |
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. |
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. |
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 |
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 | |
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 assessmentX |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
16 | 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 | |
17 | 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 | |
18 | 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 | 60% 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