Subject Outline PDF

Preview

Summary

Subject Outline...

Description

Faculty of Engineering SUBJECT OUTLINE Subject Code: CIVL296 Subject name: Engineering Computing Pre-requisite: Nil Co-requisite: Nil Credit points: 6 Offered: Autumn Session 2011, Wollongong Campus CONTACTS Subject Coordinator/Lecturer: Dr Martin Liu Building 4, Room 126 (02) 4221 3035

Location: Phone: email:

[email protected]

Consultation Times:

Monday: 10:00am-12:00pm Friday: 2:00pm-4:00pm

Subject Lecturer: Dr Ting Ren Location:

Building 4, Room G43

Phone:

(02) 4221 4186

email:

[email protected]

Consultation Times:

Tuesday 10.30am - 12.30pm Wednesday 10.30am - 12.30pm

Subject Lecturer: Dr Jan Nemcik Location:

Building 4, Room 138

Phone:

(02) 4221 4492

email:

[email protected]

Consultation Times:

Tuesday 13.30am - 15.30pm Thursday 13:30am - 15:30pm

Subject Lecturer: Dr Lijun Su Location:

Building 4, Room 136

Phone:

(02) 4221 3385

email:

[email protected]

Subject Lecturer: Dr Geng Xueyu Location:

Building 1, Room 103

Phone:

(02) 4221 3457

email:

[email protected]

Learning Outcomes On successful completion of this subject students should be able to: Learning Outcome (i)

understand the applications of computers to solving

UoW Engineering Graduate Capabilities 1, 2, 3, 4

(ii) (iii)

engineering problems; use Microsoft EXCEL to analyse experimental data and solve numerical problems; write computer programs to solve engineering problems using EXCEL VBA programming language.

1, 2, 3, 4 1, 2, 3, 4, 5

University Graduate Attributes and Engineering Graduate Capabilities The relationship between the Engineering Graduate Capabilities and the University of Wollongong Graduate Attributes can be seen in the table below. UoW Graduate Quality

Engineering Graduate Capability

Informed

1. Professional knowledge, grounding and awareness 2. Information literacy, gathering and processing 3. Research, analysis and evaluation 4. Problem solving skills

Independent Learners Problem Solvers Effective Communicators

Responsible

5. Written communication 6. Oral communication 7. Teamwork 8. Respect for views, values, culture of others 9. Ethics and professionalism 10. Sustainability, societal and environmental impact

Subject Outline This subject introduces students to computer techniques in solving engineering problems, including spreadsheets applications and programming in EXCEL with VBA. EXCEL spreadsheet fundamentals: paste functions, graphics, Lookup tables, nested IF function, adding control buttons to worksheets, numerical and matrix applications. Advanced features of EXCEL including macros, user-defined functions and programming with VBA. Lecture and Laboratory Schedule Group

Day

Class Time

Room

Lecturer

Group 1 Monday

12.30pm - 16.30pm

17.110B

Dr Martin Liu

Group 2 Monday

12.30pm - 16.30pm

4.122

Dr Ting Ren

Group 3 Monday

12.30pm - 16.30pm

17.105

Dr Jan Nemcik

Group 4 Wednesday

13.30pm - 17.30pm

4.122

Dr Xueyu Geng & Dr Lijun Su

Recent Improvements Based on feedback from students and research on teaching and learning, some techniques for solving advanced numerical problems in excel spreadsheet and VBA programming are introduced for their future engineering profession as well as their thesis work. Learning and Teaching Materials Lecture notes in details are available in the e-learning space. No text book is suggested. Purchases: Students are required to obtain storage devices/ memory sticks for storing their programs and data. Reference book

th

Introduction to EXCEL, 4 edition, David C. Kuncicky, Pearson. VBA for the 2007 Microsoft Office System, Paul McFedries, NB Students should note that this is not an exhaustive list and students should use the library catalogue and databases to locate additional resources.. ASSESSMENT GUIDELINES Criteria 1. EXCEL Assignment 1 (released Week 4, due Week 5) (i), (ii), (iii), (iv). 2. EXCEL Class test 1 (Week 6) (i), (ii), (iii), (iv), (v). 3. VBA Assignment 2(released Week 9, due Week 10) (i), (ii), (iii), (iv). 4. VBA Class test 2 (Week 13) (i), (ii), (iii), (iv), (v).

15% 35% 15% 35%

Submission of Tutorials and Assignments and Penalties for Late Work Assignments make up part of the assessment for this subject and MUST be submitted, via WebCT, by the due date. Assignments will be released on the Monday of the specified week and must be submited by 10.00 am on the Friday of the following week. For LATE ASSIGNMENT, a deduction of 10% of the full mark per day is applied. Class exams must be submitted via WebCT, during the laboratory session. Your progressive marks will be placed on the University's SOLS (Student OnLine Services) in the week after the submission date. Details of referencing system to be used in written work Please see http://www.library.uow.edu.au/resourcesbytopic/UOW026621.html Use of internet resources and restrictions placed on use of internet resources There are no restrictions on students accessing information from the internet, however, students must acknowledge all sources and should not copy information verbatim as this has no academic merit (i.e. no marks are awarded for this type of information) even when referenced correctly. Attendance Requirements The University Code of Practice Students states that it is the responsibility of students to attend all lectures, tutorials, seminars and practical work as stipulated in the subject outline. Attendance at laboratory classes is compulsory. Unless documentation supporting the reason for non-attendance is submitted, failure to attend all laboratory classes will result in a Technical Fail being recorded as your grade. University and Faculty Policies Students should make themselves aware of the University and/or Faculty Policies regarding plagiarism, special consideration, supplementary examinations and other educational issues and student matters. Further information can be found in the Faculty Policy document available from the EEC or at: http://www.uow.edu.au/eng/about/policy/index.html Plagiarism Students are responsible for submitting original work for assessment, without plagiarising or cheating, abiding by the University's policy on plagiarism as set out in the University Handbook under Universities Policy Directory and in Faculty Handbooks and subject guides. Plagiarism has led to the expulsion from the University. Further information on plagiarism and acknowledgement practice can be found in the Faculty Policy document, with full details available at: http://www.uow.edu.au/eng/about/policy/UOW058648.html Tutors/Markers Tutor/Marker Ms Nayoma Tennakoon Mr Dalin Cai Mr Chen Cao

e-mail address [email protected] [email protected] [email protected]

Mr Lei Zhang Mr Tin Nguyen Ms Udeshini Pathirage Mr Kumara Wanayalage

[email protected] [email protected] [email protected] [email protected]

CIVL296 Weekly Schedule Week

Topics

1

EXCEL Basics

2

EXCEL Graphics and Regression

3

IF function, LOOKUP function and Controls

4

Numerical and engineering applications with EXCEL

5

Matrix operations and solution of equations with EXCEL

6

Test 1 : EXCEL module

7

EXCEL macros and user-written functions in EXCEL

8

Programming in EXCEL with VBA

9

VBA and conditional statements using If - Endif structure

10

VBA and repetitive calculations using For - Next structure

11

Advanced VBA programming- Working with forms

12

Numerical and engineering applications with VBA and Using VBA with external files

13

Test 2 : VBA module

Drs Martin Liu, Ting Ren, Jan Nemcik, Xueyu Geng, and Lijun Su February 2011...