Monash University Handbook 2010 Undergraduate - Unit

Level	Undergraduate
Faculty	Faculty of Information Technology
Offered	Clayton Second semester 2010 (Day)
Leader(s)	Ms Sue Bedingfield

Synopsis

Introduction to the Internet, World Wide Web and business application tools. 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 macros. The database component covers principles of database design. The business application software packages used in the unit are Microsoft Excel and Microsoft Access.

Objectives

At the completion of this unit students will have:

• gained an overall understanding of the Web and its relationship to current business practice;
• learnt the fundamentals of relational databases, which will provide them with an understanding of the relational model, database design and query construction;
• learnt the fundamentals of spreadsheets which will provide them with an understanding of spreadsheet modelling, presentation and analysis;
• learnt fundamental program construction skills using VBA.
• learnt to construct applications using VBA as the language for enhancing the appearance and useability of database and spreadsheet systems.

A knowledge and understanding of:

• the use of data representation and analysis tools in the Microsoft Office suite of applications;
• the design and creation of a multi-page web site for a specific purpose;
• the use of web sites to enhance the business opportunities of an organisation;
• the use of relational databases to capture and maintain the persistent information required by organisations;
• the use of relational databases for analysis and presentation of organisational information;
• the use of spreadsheets for analysis and presentation of organisational data;
• the appropriateness of these tools in varying organisational circumstances.

Developed attitudes that enable them to have:

• an appreciation that Business Systems are better designed and managed by professionals with a sound knowledge of the technologies used to build these systems;
• an appreciation that business software tools can directly enhance the productivity of people achieving business goals;
• an appreciation of a cohesive structure to a web site as beneficial for both the developers of the web site and the customers who use the web site for interaction with the company;
• an appreciation of the benefits and limitations of the relational model as an efficient and versatile structure for storing and retrieving information;
• an appreciation that a knowledge of programming can be used to enhance the utility of office productivity software packages.

Developed the skills to:

• create a small web site implemented in XHTML;
• construct a small business application using Excel and VBA macro enhancements;
• develop a small business application using Access and VBA macro enhancements;
• use fundamental SQL skills for tasks such as creating retrievals and joins of data tables.

Assessment

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

Contact hours

2 hrs lectures/wk, 2 hrs laboratories/wk

Prohibitions

BUS1010, CSE1720, GCO1851, MMS1401

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

http://www.infotech.monash.edu.au/units/fit1013