[an error occurred while processing this directive] [an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]

Mrs Sue Bedingfield
Lecturer
Phone: +61 3 990 55807
Fax: +61 3 990 55159

Lecturer(s) / Leader(s):

Caulfield

Dr Oshadi Alahakoon
Postgraduate Room
Phone: +61 3 990 31478
Fax: +61 3 990 31077

Introduction

Welcome to FIT9004 - Computer programming for business. This 6 point unit is core for the Master of Business Information Systems. At the completion of this unit students will be able to create an automated Excel business application using the programming language visual basic for applications. The ability to be able to do this is an invaluable asset for a business IT professional.

Unit synopsis

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.

Learning outcomes

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;
  • learnt the fundamentals of OO concepts;
  • gained an understanding of the Excel object model;
  • learnt how to create Excel macros;
  • learnt the basics of programming including variables, data types, control structures, subroutines and functions;
  • learnt to create custom dialog boxes and custom forms using VBA;
  • the ability to create non-trivial applications using Visual Basic for Applications;
  • a knowledge of the fundamentals of spreadsheets which will provide them with an understanding of spreadsheet modelling presentation and analysis using Excel;
  • learnt the fundamentals of OO concepts;
  • learnt the basics of programming including variables, data types, control structures, subroutines and functions;
  • learnt to create custom dialog boxes and custom forms using VBA;
the ability to create non-trivial applications using Visual Basic for Applications;
  • learnt how to create Excel macros;
  • learnt to create executable programs with custom dialog boxes and custom forms using appropriate software tools.

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk

Unit relationships

Teaching and learning method

Teaching approach

Timetable information

For information on timetabling for on-campus classes please refer to MUTTS, http://mutts.monash.edu.au/MUTTS/

Tutorial allocation

On-campus students should register for tutorials/laboratories using the Allocate+ system: http://allocate.its.monash.edu.au/

Unit Schedule

Week Date* Topic References/Readings Key dates
1 19/07/10 Objectives, outline etc. Microsoft Excel 2007, New Perspectives Series, Tutorials 1-5. Lecture notes. Tutorials.  
2 26/07/10 More Excel: range names, working with Record Macro, data validation, if() function, protecting cells. ActiveX controls - using the Controls Toolbox Toolbar Microsoft Excel 2007, New Perspectives Series. Tutorials 6-9 , Zak Tutorial 1 (Concepts, Excel). Lecture notes. Tutorials.  
3 02/08/10 Object and string variables in Excel Chap 1,2 and 3 Mansfield. Zak Tutorials 2,3,4. Lecture notes. Tutorials.  
4 09/08/10 Debugging tools. Chap 4, 5 and 6 Mansfield. Zak Tutorials 5,6. Lecture notes. Tutorials.  
5 16/08/10 Variables and Controls Chap 6 and 9 Mansfield. Zak Tutorials 12 and 13. Lecture notes. Tutorials.  
6 23/08/10 Control structures Chap 9 and 12 Mansfield. Zak Tutorials 7 and 8. Lecture notes. Tutorials.  
7 30/08/10 Test weeks 1-6 Mid Semester test on 1-6 weeks material
8 06/09/10 Repetiton structures and Custom GUIs Chap 11 and 13 Mansfield. Zak Tutorials 9 and 10. Lecture notes. Tutorials.  
9 13/09/10 Built In GUIs Chap 14 Mansfield. Zak Tutorials 11. Lecture notes. Tutorials.  
10 20/09/10 Introduction to Access, Database concepts, Rules for database design, Query window, Reports, Forms. Microsoft Access 2007 New Perspective text. Lecture notes. Tutorials.  
Mid semester break
11 04/10/10 Access maintenance, Indexes, Table Joins, Lookup wizard Lecture notes. Tutorials. Assignment due
12 11/10/10 SQL , Access macros Lecture notes. Tutorials.  
13 18/10/10 Revision Lecture notes. Tutorials.  

*Please note that these dates may only apply to Australian campuses of Monash University. Off-shore students need to check the dates with their unit leader.

Unit Resources

Prescribed text(s) and readings

Mastering VBA for Microsoft Office 2007, Richard Mansfield

Text books are available from the Monash University Book Shops. Availability from other suppliers cannot be assured. The Bookshop orders texts in specifically for this unit. You are advised to purchase your text book early.

Recommended text(s) and readings

For Excel: Microsoft Excel 2007, New Perspectives Series, Parsons, Oja, Ageloff & Carey

For Access: Microsoft Access 2007, New Perspectives Series, Adamski and Finnegan

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

Required software and/or hardware

Microsoft OfficeXP 2007

Software may be:

  • purchased at academic price at some software retailers

Equipment and consumables required or provided

Students studying off-campus are required to have the minimum system configuration specified by the Faculty as a condition of accepting admission, and regular Internet access. On-campus students, and those studying at supported study locations may use the facilities available in the computing labs. Information about computer use for students is available from the ITS Student Resource Guide in the Monash University Handbook. You will need to allocate up to n hours per week for use of a computer, including time for newsgroups/discussion groups.

Study resources

Study resources we will provide for your study are:

For DE students: the FIT9004 web site on MUSO, where lecture slides, weekly tutorial requirements, assignment specifications, sample solutions and supplementary material will be posted.

Assessment

Overview

Examination (2.5 hours): 60%; In-semester assessment: 40%

Faculty assessment policy

To pass a unit which includes an examination as part of the assessment a student must obtain:

  • 40% or more in the unit's examination, and
  • 40% or more in the unit's total non-examination assessment, and
  • an overall unit mark of 50% or more.

If a student does not achieve 40% or more in the unit examination or the unit non-examination total assessment, and the total mark for the unit is greater than 50% then a mark of no greater than 49-N will be recorded for the unit.

The unit is assessed with one assignment, one test and a three hour closed book examination.
To pass the unit you must:

*attempt the assignment, test and the examination

and obtain:

*40% or more in the unit's examination


* no less that 40% overall in the non-examination assessment


* achieve no less than 50% overall from all assessments for the unit

Assignment tasks

Assignment coversheets

Assignment coversheets are available via "Student Forms" on the Faculty website: http://www.infotech.monash.edu.au/resources/student/forms/
You MUST submit a completed coversheet with all assignments, ensuring that the plagiarism declaration section is signed.

Assignment submission and return procedures, and assessment criteria will be specified with each assignment.

Assignment submission and preparation requirements will be detailed in each assignment specification. Submission must be made by the due date otherwise penalties will be enforced. You must negotiate any extensions formally with your campus unit leader via the in-semester special consideration process: http://www.infotech.monash.edu.au/resources/student/equity/special-consideration.html.

  • Assignment task 1
    Title:
    Tutorial tasks - to be completed each week during class
    Description:
    A maximum of 10% is awarded for all the 12 weekly tutorials.
    Weighting:
    10%
    Criteria for assessment:
    Assignment work in the unit is fully described, along with the assessment criteria, on the assignment page of the Moodle-based unit web site.
    Due date:
  • Assignment task 2
    Title:
    assignment
    Description:
    This is an individual assignment involving development of a system using the concepts and features of the unit content.
    Weighting:
    20%
    Criteria for assessment:
    Assignment work in the unit is fully described, along with the assessment criteria, on the assignment page of the Moodle-based unit web site. A peer assessment form is also completed by all students to ensure fair  distribution of marks.
    Due date:
    08/10/2010
  • Assignment task 3
    Title:
    Mid semester test
    Description:
    A test based on the materials covered in Weeks 1-6 will be conducted in Week 7.
    Weighting:
    10%
    Criteria for assessment:
    As given in the unit assessment policy above.
    Due date:

Examination

  • Weighting:
    60%
    Length:
    2.5 hours
    Type (open/closed book):
    Closed book
    Electronic devices allowed in the exam:
    None
See Appendix for End of semester special consideration / deferred exams process.

Due dates and extensions

Please make every effort to submit work by the due dates. It is your responsibility to structure your study program around assignment deadlines, family, work and other commitments. Factors such as normal work pressures, vacations, etc. are not regarded as appropriate reasons for granting extensions. Students are advised to NOT assume that granting of an extension is a matter of course.

Students requesting an extension for any assessment during semester (eg. Assignments, tests or presentations) are required to submit a Special Consideration application form (in-semester exam/assessment task), along with original copies of supporting documentation, directly to their lecturer within two working days before the assessment submission deadline. Lecturers will provide specific outcomes directly to students via email within 2 working days. The lecturer reserves the right to refuse late applications.

A copy of the email or other written communication of an extension must be attached to the assignment submission.

Refer to the Faculty Special consideration webpage or further details and to access application forms: http://www.infotech.monash.edu.au/resources/student/equity/special-consideration.html

Late assignment

If you believe that your assignment will be delayed because of circumstances beyond your control such as illness you should apply for an extension before the due date. Medical certificates or certification supporting your application may be required. Assignments submitted after the due date may incur a penalty for lateness. An assignment submitted more than seven days after the due date may be given a score of zero. If you anticipate being late then discuss the situation with your unit lecturer as early as possible; your unit lecturer will decide how many marks you will be penalised for each day your assignment is late, and whether or not any extension is warranted.

Assignments received after the due date will normally be subject to a penaltyof 5% per day, including weekends. Assignments received later than oneweek (seven days) after the due date will not normally be accepted. Insome cases, this period may be shorter if there is a need to release sample solutions.

Return dates

Students can expect assignments to be returned within two weeks of the submission date or after receipt, whichever is later.

Appendix

Please visit the following URL: http://www.infotech.monash.edu.au/units/appendix.html for further information about:

  • Continuous improvement
  • Unit evaluations
  • Communication, participation and feedback
  • Library access
  • Monash University Studies Online (MUSO)
  • Plagiarism, cheating and collusion
  • Register of counselling about plagiarism
  • Non-discriminatory language
  • Students with disability
  • End of semester special consideration / deferred exams
[an error occurred while processing this directive]