Note: This is an archived Handbook entry from 2008.Search for this in the current handbook
|Dates & Locations:|| |
This subject has the following teaching availabilities in 2008:Semester 2, - Taught on campus.
Timetable can be viewed here. For information about these dates, click here.
|Time Commitment:||Contact Hours: One 3-hour class per week (Semester 2). |
Total Time Commitment: Not available
|Recommended Background Knowledge:||None|
|Non Allowed Subjects:||None|
|Core Participation Requirements:||
For the purposes of considering request for Reasonable Adjustments under the Disability Standards for Education (Cwth 2005), and Student Support and Engagement Policy, academic requirements for this subject are articulated in the Subject Overview, Learning Outcomes, Assessment and Generic Skills sections of this entry.
It is University policy to take all reasonable steps to minimise the impact of disability upon academic study, and reasonable adjustments will be made to enhance a student's participation in the University's programs. Students who feel their disability may impact on meeting the requirements of this subject are encouraged to discuss this matter with a Faculty Student Adviser and Student Equity and Disability Support: http://services.unimelb.edu.au/disability
CoordinatorMr S. Taylor
|Subject Overview:||The following topics will be covered: Using Excel: basic worksheet skills, functions and the function wizard, worksheet formatting and graphics, problem solving tools; Solver, Goalseek and the Analysis Toolpak, data management tools, subtotalling, consolidation, sorting, filtering and pivot tables. Integration with other applications: establishing links with other applications through ODE and OLE, accessing data in external databases using Microsoft Query Visual Basic for Applications: programming principles, variables and control structures, writing Excel functions, object orientated programming and Excel subroutines, communicating with the user through message boxes, input boxes and dialogue boxes, working with the menu system creating add-ins.|
|Assessment:||A 2-hour end-of-semester examination (50%) and two computer-based assignments totalling not more than 2000 words (50%).|
|Breadth Options:|| |
This subject is not available as a breadth subject.
|Fees Information:||Subject EFTSL, Level, Discipline & Census Date|
|Generic Skills:||On successful completion of this subject students should be able to: |
On successful completion of this subject, students should have improved the following generic skills:
|Notes:||This subject is only available to students enrolled in the Postgraduate Diploma in Finance, the Master of Financial Management or the Master of Accounting.|
Master of Accounting |
Master of Accounting
Master of Financial Management
Postgraduate Diploma in Finance
Download PDF version.