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

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% 20 May 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 Date* Activities Assessment
    0 21/02/11   No formal assessment or activities are undertaken in week 0
    1 28/02/11 Unit Outline and Objectives Tutorial Week 1
    2 07/03/11 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 14/03/11 Object and string variables in Excel Tutorial Week 3
    4 21/03/11 Debugging tools Tutorial Week 4
    5 28/03/11 Variables and Controls Tutorial Week 5
    6 04/04/11 Control structures Tutorial Week 6
    7 11/04/11 Repetiton structures and Custom GUIs No Tutorial; Test preparation (sample paper)
    8 18/04/11 Test (during lecture) Tutorial Week 8; Mid semester test; Assignment discussion
    Mid semester break
    9 02/05/11 Built In GUIs Tutorial Week 9
    10 09/05/11 Introduction to Access, Database concepts, Rules for database design, Query window, Reports, Forms. Tutorial Week 10
    11 16/05/11 Access maintenance, Indexes, Table Joins, Lookup Wizard Tutorial Week 11; Assignment due 20 May 2011
    12 23/05/11 SQL, Access macros Assignment demos
      30/05/11 SWOT VAC No formal assessment is undertaken SWOT VAC

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

    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.
      Weighting:
      10%
      Criteria for assessment:

      The assessment criteria is fully described on the assignment page of the Moodle-based unit web site.

      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:

      To be advised.

      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 is fully described on the assignment page of the Moodle-based unit web site.
      A peer assessment form is also completed by all students to ensure a fair distribution of marks.

      Due date:
      20 May 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

    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.

    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

    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

    Recommended Reading

    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]