307587 (v.1) Computing Skills 101

---

 

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.
Text and references listed above are for your information only and current as of September 30, 2003. Please check with the unit coordinator for up-to-date information.
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.
Year Location Period Internal Area External Central External 2004 Bentley Campus Semester 2 Y