FIT1013 IT for business - Semester 2, 2010

Clayton

Prohibitions

Teaching approach

The approach to teaching and learning include a weekly two-hour lecture and a two-hour (tutorial/laboratory). Additionally, each student should spend a minimum of 8 to 12 hours for personal study every week much of which will require the use of a computer to reinforce concepts covered in lectures.

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

*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.

Prescribed text(s) and readings

Microsoft Office Access 2007, Adamski and Finnegan Comprehensive version Course Technology

Microsoft Office Excel 2007, Parsons, Oja, Ageloff & Carey Comprehensive version Course Technology

These textbooks are available from the Monash UniversityBookshops as a single wrapped copy.   

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

Recommended text(s) and readings

The recommended reading list for this unit is available at http://www.lib.monash.edu/resourcelists.

Required software and/or hardware

Office XP (Excel 2007 and Access 2007)

Equipment and consumables required or provided

Study resources

Study resources we will provide for your study are:

• Unit guide outlining administrative information for the unit
• Lecture slides
• Tutorial worksheets
• Assignment specifications
• Sample exam questions in week 13 

Overview

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.

Laboratory tasks - these will be assessed each week during tutorials 10%

Excel assignment -5%

Class Test 10%

Excel VBA assignment - 15%

Examination - 60%

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:

  Assignment 1

  Description:

  Data analysis using PivotTables.

  Weighting:

  5%

  Criteria for assessment:

  The assessment for this assignment will be based on your ability to:

  • Analyse a structured range of data using a PivotTable to analyse the data.
  • Use the analysis to provide a summary report of recommendations.
  • Use a PivotChart to substantiate the analysis and recommendations.

  Due date:

  TBA

• Assignment task 2

  Title:

  Assignment 2

  Description:

  Creating an application using Excel visual basic for applications.

  Weighting:

  15%

  Criteria for assessment:

  The assessment criteria will be based your ability to perform the following tasks:
  

  • Write Macros (sub procedures) using VBA in Microsoft Excel
  • Use appropriate data types, to declare and use variables and/or constants
  • Use the Workbook, Worksheet and Range objects
  • Write event procedures for some Excel and VBA objects.
  • Use other objects as necessary
  • Use repetition and selection structures in VBA code
  • Perform data validation on user input
  • Use the Vlookup() worksheet function in VBA code
  • Construct arithmetic expressions in VBA code.
  • Follow appropriate rules relating to the scope of variables
  • Design user forms, using a variety of common graphic-controls (graphic-objects)

  Due date:

  TBA

• Assignment task 3

  Title:

  Class Test

  Description:

  The test will be based on materials from weeks 1-7 inclusive

  Weighting:

  10%

  Criteria for assessment:

  Due date:

  Week 8 lecture, 10th September

• Assignment task 4

  Title:

  Tutorial tasks

  Description:

  These should be completed each week during tutorials

  Weighting:

  A maximum of 10% is awarded for the 12 weekly tutorials.

  Criteria for assessment:

  Individual assessment

  Due date:

  During the relevant tutorial

Examination

• Weighting:

  60%

  Length:

  2 hours

  Type (open/closed book):

  Closed book

  Electronic devices allowed in the exam:

  None

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

Late assignments will be accepted only with the permission of the lecturer. Except in the case of medical reasons, submission of late assignments will normally result in a penalty of 10% per day late.

Return dates

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