Define here the original reasons for the introduction of the unit

UGPSC 5/06 Reasons for Change Update to objectives, unit content, assessment, and prohibitions. Updates are made as part of the routine unit review to improve the quality of the unit.

2004 update to recommended reading and prohibitions.

This unit is available for students of the Faculty of Business and Economics who are doing the following degrees:

• Bachelor of Business and Commerce (course 2224) - required when completing a sequence in information technology
• Bachelor of Business and Electronic Commerce (course 1717) - a core unit.
• Bachelor of Business (course 1714) - required if completing the sequence in information technology

At the completion of this unit, students will : Have a knowledge of the fundamentals of spreadsheets which will provide them with an understanding of spreadsheet modelling presentation and analysis using Excel. Have learnt the fundamentals of OO concepts. Have gained an understanding of the Excel object model. Have learnt how to create Excel macros. Have learnt the basics of programming including variables, data types, control structures, subroutines and functions. Have learnt to create custom dialog boxes and custom forms using VBA. Have the ability to create non-trivial applications using Visual Basic for Applications. Have an understanding of the Internet and XHTML.

There are no attitudinal or values-based objectives for this unit.

At the completion of this unit, students will : Have learnt how to create Excel macros. Have learnt to create executable programs with custom dialog boxes and custom forms using appropriate software tools.

At the completion of this unit, students will : Have had the opportunity to work co-operatively with a team of IT peers on the development of computer programs.

ASCED code: 020103

This unit provides an introduction to the principles and practice of programming for business applications. This includes an overview of spreadsheet modelling and a detailed introduction to programming with Excel including general programming concepts, the syntax and semantics of a current business programming language, design and development of graphical user interfaces.

This unit provides an introduction to the principles and practice of programming for business applications. This includes an overview of spreadsheet modelling and a detailed introduction to programming with Excel including general programming concepts, the syntax and semantics of a current business programming language, design and development of graphical user interfaces.

Zak, Microsoft Visual Basic for Applications, 0-619-00020-1

On-campus and Off-campus modes

40% practical assignments, 60% formal examination (2.5 hours). Students must pass the examination in order to pass the unit.

Lectures address themes such as recognising problem description and program design. Students be introduced to theory and concepts that provide an overview to the essence of programming in relation to problem solving and designing solutions to programming problems. The laboratory sessions will be used primarily, not to introduce new material, but to place the lecture material into a practical context. Students will develop systems involving programming and spreadsheet development in a GUI enviroment.

40% practical assignments, 60% formal examination (2.5 hours). Students must pass the examination in order to pass the unit.

Assignments and examinations will test the application of knowledge and concepts to demonstrate an understanding of spreadsheet modelling, design solutions for programming problems including those in relation to spreadsheet modelling, the creation and testing of solutions and the creation, analysis and debugging of programs.

6

12 hours per week for 13 weeks

On-campus classes will need access to a lecture theatre with data projection facilities, and preferably network access for 2 hours per week. (This unit is taught in conjunction with GCO1810.)

Each group of 18 on-campus students will require access to a PC lab for tutorial/workshop sessions for 2 hours each week.

For each campus where this unit is taught:

One lecturer. One tutor for each laboratory or studio group of 18 students.

• Software Title: Microsoft Visual Studio.NET 2003
• Vendor: Microsoft
• Version: 2003 (or 2005)
• OS: MS Windows XP
• License Details: I believe there is an agreement between Monash and Microsoft.
• Are we currently licensed: Yes
• If (Yes), who is the contact person for this software?:
• The software is to be installed and accessed from a: Client/Workstation
• Type of license: Site License
• In what week will you commence using the software in class? Semester 1 (Week 1)
• Nominated Staff For Acceptance Testing Software: Shane Moore (for 2005)

This is an existing unit at Gippsland campus, with a current library approval.

Gippsland School of Computing and Information Technology - 100%