Area: | Department of Computing |
Credits: | 25.0 |
Contact Hours: | 5.0 |
Lecture: | 1 x 2 Hours Weekly |
Tutorial: | 1 x 1 Hours Weekly |
Practical: | 1 x 2 Hours Weekly |
Anti Requisite(s): | 4880 (v.3) Information Technology 111 or any previous version
7868 (v.4) Programming in Basic 102 or any previous version
301500 (v.2) Computing Fundamentals 151 or any previous version
|
Syllabus: | Designed for students who have studies TEE Applicable Mathematics. Topics include spreadsheet fundamentals using Excel. Spreadsheets and graphics with Excel. Matrices and linear algebra in Excel. Basic programming concepts. Variables and data types, somesimple program examples. Subroutines and functions in Visual Basic. Built-in functions. Interaction between the User and macros. Control structures. Selection, including, If-Then-Else, Select-Case. Iteration, Do Until loop, Do While loop, For loop. Results presentation in Excel. Introduction to Maple. Graphical representation of data. Roots of equation. Linear equations. Markov matrices. Graphics using Maple. |
| |
Unit Outcomes: | On completion of this unit students will have - Competency in using spreadsheets, specifically Excel. Developed an understanding of the elementary use of programming concepts, and the major issues in programming including variables, data types, control structures, subroutines and functions, and graphics. Gained knowledge and understanding of Visual Basic macros for Excel, a symbolic computation package and computer based algebraic manipulation. |
Texts and references listed below are for your information only and current as of September 30, 2003. Some units taught offshore are modified at selected locations. Please check with the unit coordinator for up-to-date information and approved offshore variations to unit information before finalising study and textbook purchases. |
Unit References: | Orvis W.J. (1996). Excel for Scientists and Engineers. San Francisco, Sybex. Bloch. S.C. (2000). Excel for Engineers and Scientists. New York, J. Wiley and Sons. |
Unit Texts: | No prescribed texts. |
| |
Unit Assessment Breakdown: | Mid semester test 10%, Practical assignment 25%, Theory examination 40%, Weekly/fortnightly tasks 25%. This is a grade/mark assessment. |
Field of Education: | 20100 Computer Science (Narrow Grouping) | HECS Band (if applicable): | 2 |
|
Extent to which this unit or thesis utilises online information: | Supplemental | Result Type: | Grade/Mark |
|
Availability
| Year | Location | Period | Internal | Area External | Central External | | 2004 | Bentley Campus | Semester 2 | Y | | |
Area
External | refers to external course/units run by the School or Department, offered online or through Web CT, or offered by research. |
Central
External | refers to external course/units run through the Curtin Bentley-based Distance Education Area |
|
