[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]

Academic Overview

Learning Objectives

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.

Graduate Attributes

Monash prepares its graduates to be:
  1. responsible and effective global citizens who:
    1. engage in an internationalised world
    2. exhibit cross-cultural competence
    3. demonstrate ethical values
  2. critical and creative scholars who:
    1. produce innovative solutions to problems
    2. apply research skills to a range of challenges
    3. communicate perceptively and effectively

Assessment Summary

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

Assessment Task Value Due Date
Tutorials 10% To be completed each week during class
Mid semester test 10% Week 8
Assignment 20% 14 October 2011
Examination 1 60% To be advised

Teaching Approach

Lecture and tutorials or problem classes
This teaching and learning approach provides facilitated learning, practical exploration and peer learning.

Feedback

Our feedback to You

Types of feedback you can expect to receive in this unit are:
  • Informal feedback on progress in labs/tutes
  • Graded assignments with comments
  • Test results and feedback
  • Other: Solutions to tutes

Your feedback to Us

Monash is committed to excellence in education and regularly seeks feedback from students, employers and staff. One of the key formal ways students have to provide feedback is through SETU, Student Evaluation of Teacher and Unit. The University's student evaluation policy requires that every unit is evaluated each year. Students are strongly encouraged to complete the surveys. The feedback is anonymous and provides the Faculty with evidence of aspects that students are satisfied and areas for improvement.

For more information on Monash's educational strategy, and on student evaluations, see:
http://www.monash.edu.au/about/monash-directions/directions.html
http://www.policy.monash.edu/policy-bank/academic/education/quality/student-evaluation-policy.html

Previous Student Evaluations of this unit

If you wish to view how previous students rated this unit, please go to
https://emuapps.monash.edu.au/unitevaluations/index.jsp

Required Resources

Microsoft Office 2010

Software will be available for use in University computer labs.

Software may be:

  • purchased at educational prices from some software retailers.



Unit Schedule

Week Activities Assessment
0   No formal assessment or activities are undertaken in week 0
1 Unit Outline and Objectives Tutorial Week 1
2 More Excel: range names, working with Record Macro, data validation, if() function, protecting cells. ActiveX controls - using the Controls Toolbox Toolbar Tutorial Week 2
3 Object and string variables in Excel Tutorial Week 3
4 Debugging tools Tutorial Week 4
5 Variables and Controls Tutorial Week 5
6 Control structures Tutorial Week 6
7 Repetiton structures and Custom GUIs No Tutorial; Test preparation (sample paper)
8 Test (during lecture) Tutorial Week 8; Mid semester test; Assignment discussion
9 Built In GUIs Tutorial Week 9
10 Introduction to Access, Database concepts, Rules for database design, Query window, Reports, Forms. Tutorial Week 10
11 Access maintenance, Indexes, Table Joins, Lookup Wizard Tutorial Week 11; Assignment due 14 October, 2011
12 SQL, Access macros Assignment demos
  SWOT VAC No formal assessment is undertaken SWOT VAC
  Examination period LINK to Assessment Policy: http://policy.monash.edu.au/policy-bank/
academic/education/assessment/
assessment-in-coursework-policy.html

*Unit Schedule details will be maintained and communicated to you via your MUSO (Blackboard or Moodle) learning system.

Assessment Requirements

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

Assessment Tasks

Participation

  • Assessment task 1
    Title:
    Tutorials
    Description:
    Tasks will be given during tutorial classes based on lectures from the previous week.See unit outline for a description of the materials covered in tutorials.
    Weighting:
    10%
    Criteria for assessment:

    The assessment criteria is fully described during each tutorial.

    Due date:
    To be completed each week during class
  • Assessment task 2
    Title:
    Mid semester test
    Description:
    A test based on the materials covered in Weeks 1 - 6 will be conducted in Week 8.
    Weighting:
    10%
    Criteria for assessment:

    Students must demonstrate a comprehensive knowledge of the lecture materials and tutorial tasks from weeks 1 to 6.

    Due date:
    Week 8
  • Assessment task 3
    Title:
    Assignment
    Description:
    This is an individual assignment involving the development of a system using the concepts and features of the unit content.
    Weighting:
    20%
    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:
    14 October 2011

Examinations

  • Examination 1
    Weighting:
    60%
    Length:
    2.5 hours
    Type (open/closed book):
    Closed book
    Electronic devices allowed in the exam:
    None

Assignment submission

It is a University requirement (http://www.policy.monash.edu/policy-bank/academic/education/conduct/plagiarism-procedures.html) for students to submit an assignment coversheet for each assessment item. Faculty Assignment coversheets can be found at http://www.infotech.monash.edu.au/resources/student/forms/. Please check with your Lecturer on the submission method for your assignment coversheet (e.g. attach a file to the online assignment submission, hand-in a hard copy, or use an online quiz).

Extensions and penalties

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.

Returning assignments

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

Other Information

Policies

Monash has educational policies, procedures and guidelines, which are designed to ensure that staff and students are aware of the University's academic standards, and to provide advice on how they might uphold them. You can find Monash's Education Policies at:
http://policy.monash.edu.au/policy-bank/academic/education/index.html

Key educational policies include:

Student services

The University provides many different kinds of support services for you. Contact your tutor if you need advice and see the range of services available at www.monash.edu.au/students The Monash University Library provides a range of services and resources that enable you to save time and be more effective in your learning and research. Go to http://www.lib.monash.edu.au or the library tab in my.monash portal for more information. Students who have a disability or medical condition are welcome to contact the Disability Liaison Unit to discuss academic support services. Disability Liaison Officers (DLOs) visit all Victorian campuses on a regular basis

READING LIST:

For Excel:

Microsoft Excel 2010, New Perspectives Series, Parsons, Oja, Ageloff & Carey, ISBN 978-0-538-74291-7

For Access:

Microsoft Access 2010, New Perspectives Series, Adamski and Finnegan, ISBN 0-538-79847-5

For VBA:

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

Mansfield, Mastering VBA for Office 2010, ISBN 978-0-470-63400-4

[an error occurred while processing this directive]