Methodological proposal of financial modelling using dynamic scenarios from multivariable data tables
by J.D. González-Ruiz; Eduardo Duque; Alejandro Peña; Jovani Jiménez; Héctor Alejandro Patiño
International Journal of Technology Enhanced Learning (IJTEL), Vol. 10, No. 3, 2018

Abstract: This paper aims at proposing a methodological strategy for teaching the modelling of dynamic scenarios from Multivariable Data Tables using Microsoft Excel as a technological tool. It provides a step-by-step guide for improving the teaching-learning method on the development of financial models, which could also be used in other areas. The methodology allows identifying the most important aspects of developing financial models so students-professors could be guided towards a more pedagogical approach promoting the incorporation of technological tools in the classroom. This work plays a pivotal role in financial modelling teaching since it provides relevant elements leading to the development of systematic thinking among university students based on cognitive activities. Also, various contributions to research on the teaching-learning process in modelling are discussed. For validating the proposal, an airport's financial valuation was used as a case study. As a result, this paper contributes to increasing the role of computational tools and students-professors involvement in the development of systemic thinking and cognitive skills.

Online publication date: Thu, 28-Jun-2018

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Technology Enhanced Learning (IJTEL):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email