Handbook home
Financial Spreadsheeting (FNCE90045)
Graduate courseworkPoints: 12.5On Campus (Parkville)
For information about the University’s phased return to campus and in-person activity in Winter and Semester 2, please refer to the on-campus subjects page.
About this subject
- Overview
- Eligibility and requirements
- Assessment
- Dates and times
- Further information
- Timetable(opens in new window)
Contact information
Semester 1
Ian O'Connor
Email: ianpo@unimelb.edu.au
Semester 2
Ian O'Connor
Email: ianpo@unimelb.edu.au
Please refer to the LMS for up-to-date subject information, including assessment and participation requirements, for subjects being offered in 2020.
Overview
Availability | Semester 1 Semester 2 |
---|---|
Fees | Look up fees |
The following topics will be covered: Financial Applications using Excel: basic spreadsheeting skills, functions and the function wizard, worksheet formatting and graphics. Financial problem solving tools: Solver, Goalseek and the Analysis Toolpak. Data management tools, subtotalling, consolidation, sorting filtering and pivot tables. Programming principles with applications to finance: object orientated programming, variable and control structures, writing Excel financial functions and subroutines, and creating add-ins. Communicating with the user of financial applications through message boxes, input boxes and dialogue boxes.
Intended learning outcomes
On successful completion of this subject students should be able to:
- Use all the built-in features of Microsoft Excel;
- Explain the principles of object-orientated programming;
- Apply the principles of object-oriented programming to the development of Visual Basic for Applications programs;
- Integrate various programming structures and concepts to build complex programs;
- Evaluate strategies for finding and fixing computer programming errors;
- Design computer programs that implement solutions in an efficient and effective manner.
Generic skills
On successful completion of this subject, students should have improved the following generic skills:
- Oral communication
- Written communication
- Collaborative learning
- Problem solving
- Team work
- Statistical reasoning
- Application of theory to practice
- Interpretation & analysis
- Critical thinking
- Synthesis of data and other information
- Evaluation of data and other information
- Using computer software
- Accessing data and other information from a range of sources
Last updated: 3 November 2022
Eligibility and requirements
Prerequisites
This subject is only available to:
- Students enrolled in the Postgraduate Diploma in Finance and the Master of Finance;
- Students enrolled in the Master of Management who have completed FNCE90018 Corporate Financial Policy and FNCE90056 Investment Management.
Code | Name | Teaching period | Credit Points |
---|---|---|---|
FNCE90018 | Corporate Financial Policy |
Semester 1 (On Campus - Parkville)
Semester 2 (On Campus - Parkville)
|
12.5 |
FNCE90056 | Investment Management |
Semester 2 (On Campus - Parkville)
Semester 1 (On Campus - Parkville)
|
12.5 |
Corequisites
None
Non-allowed subjects
None
Inherent requirements (core participation requirements)
The University of Melbourne is committed to providing students with reasonable adjustments to assessment and participation under the Disability Standards for Education (2005), and the Assessment and Results Policy (MPF1326). Students are expected to meet the core participation requirements for their course. These can be viewed under Entry and Participation Requirements for the course outlines in the Handbook.
Further details on how to seek academic adjustments can be found on the Student Equity and Disability Support website: http://services.unimelb.edu.au/student-equity/home
Last updated: 3 November 2022
Assessment
Due to the impact of COVID-19, assessment may differ from that published in the Handbook. Students are reminded to check the subject assessment requirements published in the subject outline on the LMS
Description | Timing | Percentage |
---|---|---|
Two computer-based assignments each worth 25%. Due in Weeks 8 and 12
| From Week 8 to Week 12 | 50% |
End-of-semester examination
| During the examination period | 50% |
Last updated: 3 November 2022
Dates & times
- Semester 1
Principal coordinator Ian O'Connor Mode of delivery On Campus (Parkville) Contact hours One 3-hour class per week Total time commitment 170 hours Teaching period 2 March 2020 to 7 June 2020 Last self-enrol date 13 March 2020 Census date 30 April 2020 Last date to withdraw without fail 5 June 2020 Assessment period ends 3 July 2020 Semester 1 contact information
Ian O'Connor
Email: ianpo@unimelb.edu.au
- Semester 2
Principal coordinator Ian O'Connor Mode of delivery On Campus (Parkville) Contact hours One 3-hour class per week Total time commitment 170 hours Teaching period 3 August 2020 to 1 November 2020 Last self-enrol date 14 August 2020 Census date 21 September 2020 Last date to withdraw without fail 16 October 2020 Assessment period ends 27 November 2020 Semester 2 contact information
Ian O'Connor
Email: ianpo@unimelb.edu.au
Time commitment details
Estimated total time commitment of 170 hours per semester
Additional delivery details
Each student is to provide their own laptop or notebook computer, with Windows 10 and MS Excel, (Office 365 version) at every class. Windows 10 and Microsoft Office 365 is provided for current students, see details at:
https://studentit.unimelb.edu.au/study/software-locations#downloadable-software
Last updated: 3 November 2022
Further information
- Texts
Prescribed texts
You will be advised of prescribed texts by your lecturer.
- Related Handbook entries
This subject contributes to the following:
Type Name Course Master of Management (Accounting and Finance) Course Master of Finance Course Master of Management (Finance) - Available through the Community Access Program
About the Community Access Program (CAP)
This subject is available through the Community Access Program (also called Single Subject Studies) which allows you to enrol in single subjects offered by the University of Melbourne, without the commitment required to complete a whole degree.
Entry requirements including prerequisites may apply. Please refer to the CAP applications page for further information.
- Available to Study Abroad and/or Study Exchange Students
This subject is available to students studying at the University from eligible overseas institutions on exchange and study abroad. Students are required to satisfy any listed requirements, such as pre- and co-requisites, for enrolment in the subject.
Last updated: 3 November 2022