Visit ECU Homepage
This unit information may be updated and amended immediately prior to semester. To ensure you have the correct outline, please check it again at the beginning of semester.
This unit provides students with the skills required to undertake financial analysis and modelling using Microsoft Excel. With the intensive use of Excel in businesses, these skills are highly desired by employers. The unit covers both the conceptual and practical aspects of financial analysis and modelling. Besides providing students with a powerful Excel toolkit, this unit also teaches students the construction of financial models, giving consideration to architecture, user interface, error handling, and flexibility.
Students must pass 2 units from ECF6102, ECF6110
On completion of this unit students should be able to:
Students attend a weekly three-hour seminar including a one-hour question-and-answer session. Through their weekly classes and homework, students will learn an array of Excel functions and modelling skills, which are crucial for building complex single-workbook financial models. The learning experience of students will be further enhanced by building two single-workbook models in a team setting. The two projects require students to critically appraise the possible usage of the Excel functions they have learned and to generate ideas on innovative ways of using the functions to achieve the goals of the projects. The projects also help students to develop their written communication skills through organising and writing the user guides and documenting their procedures for other modellers. To be successful in their two projects, students will need to communicate effectively and work productively with others from diverse academic backgrounds, cultures, viewpoints, and technical competencies.
GS1 GRADING SCHEMA 1 Used for standard coursework units
Students please note: The marks and grades received by students on assessments may be subject to further moderation. All marks and grades are to be considered provisional until endorsed by the relevant Board of Examiners.
| Type | Description | Value |
|---|---|---|
| Project | Project 1 | 20% |
| Project | Project 2 | 20% |
| Examination ^ | Final examination | 60% |
^ Mandatory to Pass
^ Mandatory reference
For the purposes of considering a request for Reasonable Adjustments under the Disability Standards for Education (Commonwealth 2005), inherent requirements for this subject are articulated in the Unit Description, Learning Outcomes and Assessment Requirements of this entry. The University is dedicated to provide support to those with special requirements. Further details on the support for students with disabilities or medical conditions can be found at the Access and Inclusion website.
Edith Cowan University has firm rules governing academic misconduct and there are substantial penalties that can be applied to students who are found in breach of these rules. Academic misconduct includes, but is not limited to:
Additionally, any material submitted for assessment purposes must be work that has not been submitted previously, by any person, for any other unit at ECU or elsewhere.
The ECU rules and policies governing all academic activities, including misconduct, can be accessed through the ECU website.
ECF6130|1|1
This unit information may be updated and amended immediately prior to semester. To ensure you have the correct outline, please check it again at the beginning of semester.
This unit provides students with the skills required to undertake financial analysis and modelling using Microsoft Excel. With the intensive use of Excel in businesses, these skills are highly desired by employers. The unit covers both the conceptual and practical aspects of financial analysis and modelling. Besides providing students with a powerful Excel toolkit, this unit also teaches students the construction of financial models, giving consideration to architecture, user interface, error handling, and flexibility.
Students must pass 2 units from ECF6102, ECF6110
On completion of this unit students should be able to:
Students attend a weekly three-hour seminar including a one-hour question-and-answer session. Through their weekly classes and homework, students will learn an array of Excel functions and modelling skills, which are crucial for building complex single-workbook financial models. The learning experience of students will be further enhanced by building two single-workbook models in a team setting. The two projects require students to critically appraise the possible usage of the Excel functions they have learned and to generate ideas on innovative ways of using the functions to achieve the goals of the projects. The projects also help students to develop their written communication skills through organising and writing the user guides and documenting their procedures for other modellers. To be successful in their two projects, students will need to communicate effectively and work productively with others from diverse academic backgrounds, cultures, viewpoints, and technical competencies.
GS1 GRADING SCHEMA 1 Used for standard coursework units
Students please note: The marks and grades received by students on assessments may be subject to further moderation. All marks and grades are to be considered provisional until endorsed by the relevant Board of Examiners.
| Type | Description | Value |
|---|---|---|
| Project | Project 1 | 20% |
| Project | Project 2 | 20% |
| Examination ^ | Final examination | 60% |
^ Mandatory to Pass
^ Mandatory reference
For the purposes of considering a request for Reasonable Adjustments under the Disability Standards for Education (Commonwealth 2005), inherent requirements for this subject are articulated in the Unit Description, Learning Outcomes and Assessment Requirements of this entry. The University is dedicated to provide support to those with special requirements. Further details on the support for students with disabilities or medical conditions can be found at the Access and Inclusion website.
Edith Cowan University has firm rules governing academic misconduct and there are substantial penalties that can be applied to students who are found in breach of these rules. Academic misconduct includes, but is not limited to:
Additionally, any material submitted for assessment purposes must be work that has not been submitted previously, by any person, for any other unit at ECU or elsewhere.
The ECU rules and policies governing all academic activities, including misconduct, can be accessed through the ECU website.
ECF6130|1|2