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 is designed to introduce the conceptual and practical aspects of financial modelling using Microsoft Excel spreadsheets. A spreadsheet solution is usually prepared for one's own use while a spreadsheet model is constructed with possible distribution in mind. A spreadsheet model is, therefore, a major step up from a spreadsheet solution and requires a much more disciplined approach with consideration given to architecture, user interface, error handling, and flexibility.
Students must pass 1 units from ECF2226
On completion of this unit students should be able to:
On-campus students attend a three hour workshop which will be divided into 3 sections. To start there will be revision of the take home material from the previous week. During this time students will need to explain their model and demonstrate how they have arrived at a solution. There will also be an opportunity for the students to assist others who may not have found a suitable solution to the problem at hand. The next section of the class will involve explanation and discussion of the relevant topic for that week. Finally students will begin to develop a model that will provide a solution to the problem raised earlier. Students will be shown a suggested outline which they will need to adapt accordingly. By its very nature, problem solving using spreadsheets may take many different paths. When forecasting there may be more than one solution. Students will need to critically evaluate the problem and develop their own solution. Off-campus students will be supplied with course materials to review each week via Blackboard and are expected to attempt assigned questions from each topic. Regular online access is required.
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 | Single-workbook model | 15% |
| Assignment | Assignment | 25% |
| Examination ^ | Final Examination | 60% |
| Type | Description | Value |
|---|---|---|
| Project | Single-workbook model | 15% |
| Assignment | Assignment | 25% |
| 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.
ECF3120|2|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 is designed to introduce the conceptual and practical aspects of financial modelling using Microsoft Excel spreadsheets. A spreadsheet solution is usually prepared for one's own use while a spreadsheet model is constructed with possible distribution in mind. A spreadsheet model is, therefore, a major step up from a spreadsheet solution and requires a much more disciplined approach with consideration given to architecture, user interface, error handling, and flexibility.
Students must pass 1 units from ECF2226
On completion of this unit students should be able to:
On-campus students attend a three hour workshop which will be divided into 3 sections. To start there will be revision of the take home material from the previous week. During this time students will need to explain their model and demonstrate how they have arrived at a solution. There will also be an opportunity for the students to assist others who may not have found a suitable solution to the problem at hand. The next section of the class will involve explanation and discussion of the relevant topic for that week. Finally students will begin to develop a model that will provide a solution to the problem raised earlier. Students will be shown a suggested outline which they will need to adapt accordingly. By its very nature, problem solving using spreadsheets may take many different paths. When forecasting there may be more than one solution. Students will need to critically evaluate the problem and develop their own solution. Off-campus students will be supplied with course materials to review each week via Blackboard and are expected to attempt assigned questions from each topic. Regular online access is required.
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 | Single-workbook model | 15% |
| Assignment | Assignment | 25% |
| Examination ^ | Final Examination | 60% |
| Type | Description | Value |
|---|---|---|
| Project | Single-workbook model | 15% |
| Assignment | Assignment | 25% |
| 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.
ECF3120|2|2