units

FIT1013

Faculty of Information Technology

Monash University

Undergraduate - Unit

This unit entry is for students who completed this unit in 2014 only. For students planning to study the unit, please refer to the unit indexes in the the current edition of the Handbook. If you have any queries contact the managing faculty for your course or area of study.

print version

6 points, SCA Band 2, 0.125 EFTSL

Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered, or view unit timetables.

LevelUndergraduate
FacultyFaculty of Information Technology
OfferedClayton Second semester 2014 (Day)

Synopsis

Introduction to business application tools and introduction to basic computing concepts. Principles of spreadsheets and relational databases, covering their use for the generation of business plans, reports, financial statements, etc. Both the spreadsheet and database components incorporate an introduction to programming with visual basic for applications (VBA). The database component covers principles of database design. The business application software packages used in the unit are Microsoft Excel and Microsoft Access.

Outcomes

At the completion of this unit, students will have:

  • A sound knowledge of spreadsheet applications which will provide an understanding of business spreadsheet modelling for analysis, reporting and presentation of organisational data;
  • learnt to construct applications using VBA as the language for enhancing the appearance and usability of spreadsheet and database systems;
  • a knowledge of the use of relational databases for analysis, reporting and presentation of organisational information;
  • an appreciation that a knowledge of programming can be used to enhance the utility of office productivity software packages.

Assessment

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

Chief examiner(s)

Workload requirements

Minimum total expected workload equals 12 hours per week comprising:

(a.) Contact hours for on-campus students:

  • Two hours of lectures
  • One 2-hour laboratory

(b.) Additional requirements (all students):

  • A minimum of 2-3 hours of personal study per one hour of contact time in order to satisfy the reading and assignment expectations.

This unit applies to the following area(s) of study

Prohibitions

BUS1010, CSE1720, GCO1851, MMS1401

Additional information on this unit is available from the faculty at: