Course Title: TCF Computer Aided Design & Management Systems
Part B: Course Detail
Teaching Period: Term1 2008
Course Code: ISYS5573L
Course Title: TCF Computer Aided Design & Management Systems
School: 350T Fashion & Textiles
Campus: Brunswick Campus
Program: C5165 - Diploma of Textiles Clothing and Footwear
Course Contact : Russell Edis
Course Contact Phone: +61 3 9925 9139
Course Contact Email:russell.edis@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Kelly Pascoe
+61 3 9925 9177
kelly.pascoe@rmit.edu.au
Location:
Building: 511
Level: 1
Room: 7
Nominal Hours: 180
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
To provide learners with skills, knowledge and attitudes to become competent to:
• Use a range of advanced functions within software package. The packages include a word processing, spreadsheet, graphic, presentation and database package.
• Produce complex word-processed documents, spreadsheet models using formula and functions and effectively and in a timely manner.
• Manage, manipulate and present information in database files.
• Use industry standard software and hardware to create, manipulate, manage and print images and illustrations.
• Use the internet to conduct research.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
BSATEC401A Produce Complex Documents |
Element: |
BSATEC401/01 Establish document design and structure |
Performance Criteria: |
• Requirements of the task are identified. |
Element: |
BSATEC401/02 Develop template or macros for document design |
Performance Criteria: |
• Templates and macros are developed and used to ensure consistency of design and layout. |
Element: |
BSATEC401/03 Produce documents |
Performance Criteria: |
• Data is entered and edited accurately. |
Element: |
BSATEC401/04 Save file and exit system |
Performance Criteria: |
• Document is saved ad stored in appropriate directory or folder. |
National Element Code & Title: |
LMTPDCL01A Assist In Prepar Of Prelim Design Concepts 03/ |
Element: |
LMTPDCL01A/01 Interpret design brief within specified guidelines |
Performance Criteria: |
• Design parameters are clarified, in consultation with designer, sales team, management and/or client, where required. |
Element: |
LMTPDCL01A/02 Research relevant information within specified guidelines |
Performance Criteria: |
• Trends in fabrics, etc. are researched for performance, colour, availability, care/maintenance requirements and suitability to project or design. |
Element: |
LMTPDCL01A/03 Contribute to design concepts |
Performance Criteria: |
• Preliminary concepts are worked out in conjunction with others to identify possibilities. |
Element: |
LMTPDCL01A/04 Contribute to the presentation of design/s |
Performance Criteria: |
• Own role and relationship to others for the presentation meeting is determined and rehearsed. |
National Element Code & Title: |
LMTPDCL03A Select And/Or Modify Patterns Or Blocks 05/5 |
Element: |
LMTPDCL03A/01 Interpret the design |
Performance Criteria: |
• Design a sketch/drawing is interpreted and clarified with designer or senior patternmaker as required. |
Element: |
LMTPDCL03A/02 Select a pattern |
Performance Criteria: |
• Specifications are read and interpreted, in consultation with others as required. |
Element: |
LMTPDCL03A/03 Modify existing pattern |
Performance Criteria: |
• Steps required to modify the pattern are determined. |
Element: |
LMTPDCL03A/04 Test pattern |
Performance Criteria: |
• Pattern is tested for feasibility by making a prototype or toile. |
Element: |
LMTPDCL03A/05 Maintain records |
Performance Criteria: |
• Records are maintained and reports prepared, where necessary, in accordance with enterprise procedures. |
National Element Code & Title: |
LMTPRGN03A Participate On Production Planning Process 02/ |
Element: |
LMTPRGN03A/01 Confirm production requirements |
Performance Criteria: |
• Projected requirements regarding stock supplies, product quantities, quality and delivery schedules are confirmed. |
Element: |
LMTPRGN03A/02 Gather specific production information |
Performance Criteria: |
• Specific information relating to production capacity is obtained and/or confirmed. |
Element: |
LMTPRGN03A/03 Participate in planning meetings |
Performance Criteria: |
• Specific requirements for the meeting are confirmed. |
Element: |
LMTPRGN03A/04 Maintain records |
Performance Criteria: |
• Production planning records are maintained and reports prepared, where necessary, in accordance with enterprise procedures. |
National Element Code & Title: |
LMTQAGN02A Coordinate External Quality Assurance 03/4 |
Element: |
LMTQAGN02A/01 Assess external suppliers/customers |
Performance Criteria: |
• Assessment and evaluation of suppliers capability and/or quality system is conducted. |
Element: |
LMTQAGN02A/02 Liaise with external suppliers/customers |
Performance Criteria: |
• Specifications of materials, services and/or equipment to be supplied are identified and documented in accordance with workplace procedures. |
Element: |
LMTQAGN02A/03 Check for conformance to specifications |
Performance Criteria: |
• Conformance of materials/products from external supplier is established against specifications. |
Element: |
LMTQAGN02A/04 Maintain records |
Performance Criteria: |
• Records are maintained and reports prepared, where necessary, in accordance with enterprise procedures. |
National Element Code & Title: |
RUAAG5501BCA Develop A Marketing Plan 03/7 |
Element: |
RUAG5501BC/01 Determine business and financial requirements |
Performance Criteria: |
• The cash flow capacity of each production option for the property is determined. |
Element: |
RUAG5501BC/02 Obtain and analyse market information |
Performance Criteria: |
• Behaviour of factors influencing price, supply and demand is monitored. |
Element: |
RUAG5501BC/03 Develop marketing plan |
Performance Criteria: |
• Estimates of product quality and quantity are made. |
Element: |
RUAG5501BC/04 Implement marketing plan |
Performance Criteria: |
• Market conditions are monitored to the marketing plan. |
Element: |
RUAG5501BC/05 Evaluate the marketing plan |
Performance Criteria: |
• Performance indicators are identified. |
Learning Outcomes
Refer to other sections of guide
Details of Learning Activities
PLANNED LEARNING EXPERIENCES:
• 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
Week Starting Topic:
18/02/2008 Course Outline and requirements. Process of saving work either on USB memory, floppy disk, or e-mailed to oneself (RMIT e-mail account preferred)
Processes for logging on to network, changing passwords (Ctrl+Alt+Del)
Help Desk for log on problems telephone 992- 58888.
Logging on to Home drive from outside RMIT.
Netstorage address https://netstorage.rmit.edu.au/NetStorage/
Word Processing. Creating, editing and printing simple documents using Word.
Using the menu, tool-bars. viewing the document
Page setup
Margins
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.
Endnotes and footnotes
Use manuals and on-line help to solve problems.
25/02/2008 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. . More advanced document codes for re-setting total page numbers in document.
Format and edit simple documents using columns.
3/03/2008 Fashion Week No Formal Classes
10/03/2008 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.
17/03/2008 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.
24/03/2008 Easter Break
31/03/2008 Easter Break
7/04/2008 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.
14/04/2008 Create and edit the Auto-text items.
Create edit and apply Styles
Create and edit Table of Contents and Indexes
21/04/2008 Create and print simple mail-merge documents and labels
Use Word documents as well as Excel spreadsheets. Emphasize the importance of having no space at the top of the page for the database files. Setup list in Word and Excel.
Create and print complex queries mail-merge documents. Use multiple qualifiers.
28/04/2008 Mail Merge. Create mailing labels using Avery L7159 as the default label
5/05/2008 Creating Templates.
Create Assignment structure template with tables of contents, page numbers and styles, logos, headers and footers.
12/05/2008 Working with toolbars, reset the toolbars.
Tracked changes and comments in a document
19/05/2008 Creating simple macros, recording the macro through example (not writing code).
Creating buttons to activate the macro.
26/05/2008 Creating simple macros
2/06/2008 Review
9/06/2008 Word Processing - Topic Test
16/06/2008 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.
23/06/2008 PowerPoint
Semester One - Session Two 2008
Week Starting Topic:
18/02/2008 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.
25/02/2008 Formatting a worksheet
Creating a simple GANTT Chart, (use cell formatting, fill colour and text tools).
3/03/2008 Fashion Week No formal Classes
10/03/2008 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.
17/03/2008 Using LOOKUP functions.
VLOOKUP Examples (series of worksheet with examples of function)
24/03/2008 Easter Break
31/03/2008 Easter Break
7/04/2008 Using LOOKUP functions.
14/04/2008 Functions - IF
21/04/2008 IF functions using AND OR function
Nested IF Functions
Using the & operator to string functions together.
28/04/2008 Topic Test.
File to be submitted to Submissions folder, fully document. Use naming structure Group Test Name
5/05/2008 Date Functions. Create a calendar using formula to generate dates.
Format and print a spreadsheet document.
12/05/2008 Creating and Editing Charts
19/05/2008 Database
Set up the structures in an Excel worksheet to create a database. Database
26/05/2008 Queries using Multiple queries, for example more than one city, and selecting between a range of numbers
Reference document (Word) - Using Excel as a Database
Correcting problems with database
2/06/2008 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
Global Logistics Documents
9/06/2008 Pivot Tables
16/06/2008 Macros. Record simple macros, apply macros to buttons, modify button image. (students are not expected to write code for their macros but they need to have the capacity to access the VBA editor)
Record macros through demonstration. Distinguish between absolute and relative macros. Create buttons to activate macro.
23/06/2008 Topic Test.
File to be submitted to Submissions folder, fully document. Use naming structure Group Test Name
Learning Resources
Prescribed Texts
References
Other Resources
Essential Learning Resources students need to subject:
Data disks and recommended textbook.
Overview of Assessment
Refer to Assessment Tasks
Assessment Tasks
Learners need to demonstrate by means of a range of assessment tasks that they can:
1. Create and present information for an audience using presentation tools (Power Point). 3%
2. Design and apply suitable styles and formats to word-processed documents. Check for accuracy and layout. Save documents in specific folders on a computer system and correctly documented files. Develop templates and macros to ensure consistency of design and layout. 24%
3. Manage, manipulate and present information using a spreadsheet application. Use charts, advanced formula and functions to ensure the accurate completion of tasks within designated timelines. 25%
4. Manage, manipulate and present information using a database application. Create tables and set relationships within database. Create queries and reports. Construct forms from queries and tables and change the controls. 24%
5. Create and manipulate image designs and illustrations from design briefs according to enterprise standards for mood boards and presentations. 24%
• Assessment timeline: Progressive assessments plus a unit test on completion. This will include assignments, and practical demonstration of skills
• Learners can make a claim for Approved Prior Learning on entry to the course
• Criteria for your results HD (high distinction – indicative score 80-100%) or DI (distinction – indicative score 70-79%) or CR (credit – indicative score 60-69%) or PA (pass – indicative score 50-59%) or NN (fail – indicative score 0-49%).
Assessment Matrix
Course Overview: Access Course Overview