IT Applications as a Didactic Tool in the Teaching of Math (Using of Spreadsheet to Programming) (original) (raw)
Related papers
Spreadsheet as a didactic tool to teach and learn financial math
In this document we propose a methodology to teach financial mathematics, using a spreadsheet as a didactic tool. We describe the traditional education process in a specific topic of mathematics, “debt restructuring and modeling with equivalent-equation” from the theoretical explanation to design a financial simulator programmed in a spreadsheet. After this, the result will be verified and validated by the designed software.
SSRN Electronic Journal, 2008
Technology based teaching of accounting curriculum is widely researched by accounting educators. This paper reports the findings of the use of computers and Microsoft Excel spreadsheet program as a means to reflect on, and to enhance prior learning, of financial accounting, managerial accounting and finance concepts and problems, through a financial modelling subject, in an undergraduate program in an Australian regional university. Data were collected from the researched university's formal feedback systems, Student Feedback on Subjects (SFS), and archived course materials, over a three year period (2003-2005). Using pattern matching approach (Yin, 2003), data were analyzed for making generalizations about the effectiveness of spreadsheet software usage as a pedagogical and educational tool. The study finds that spreadsheet based teaching and learning equip students with computer literacy, and spreadsheet application skills in the areas of management accounting and finance. The study also finds that the students with a few years' of work experience outperform the students without any work experience, and appreciation of the course among the students without work experience is lower than their counterpart with a few years' of work experience. The study has implications for accounting educators, in that difficult to learn accounting and finance concepts can be taught using a spreadsheet based modelling subject; this can provide significant insight into the relationships among numerous variables, which are difficult to manipulate and solve manually, in a traditional chalk and talk teaching environment.
Development of Spreadsheet-Based Applications for Learning of Financial Management
2018
Spreadsheet based applications are needed by students and lecturers to expedite the financial management learning process. The aim of the research was to produce a spreadsheet-based application for financial management that can be used for real learning. Spreadsheet-based application for financial management includes cash, accounts receivable, inventory, fixed assets, liabilities, equity, financial ratios, and time value of money management. his study uses a qualitative approach with descriptive methods. The research model used was adapted from the research and development model with stages: 1) analysis of the needs of teaching materials; 2) development of a draft spreadsheet-based application for financial management; 3) testing draft spreadsheet-based applications for financial management. The results of the study is a spreadsheet-based application for financial management can be used in real learning. The test results show that spreadsheet-based applications have given the same r...
Use of Spreadsheets to Teach Mathematical Applications in Economics
International Journal of Sciences, 2019
The use of spreadsheets is increasing with the passage of time. Concepts are made clear and problems are made easier to understand by teaching economics using spreadsheets. In the contemporary world new concepts are evolving fast where mathematical formulations and graphical analysis are a requirement. In this regard the use of spreadsheets saves time for tedious computations as well as makes available new styles and techniques. The use of computers in economic analysis is increasing and there is a growing computational environment and extensive use of functions with content-specific templates employed in teaching methods. In modern times students of economics and people from different professions carry out routine work with the help of MS office and Excel spreadsheets. These can be used for simulating the impact of movements in conic sections by economists and mathematicians studying a plethora of phenomena. Students of economics, physics and mathematics must learn how to exploit s...
Feasibility of Spreadsheet Based Financial Management Learning Materials
Proceedings of the International Conference on Social Science 2019 (ICSS 2019), 2019
The purpose of the study is to describe and test the feasibility of spreadsheet-based financial management learning materials. This descriptive study focused on the feasibility testing of spreadsheet-based financial management learning materials. The test subjects were expert and user groups. The data obtained in this study were quantitative and qualitative. Quantitative data obtained from the assessment questionnaire using a Likert scale. Qualitative data were suggestions on the questionnaire. The learning materials assessment by experts consisted of the feasibility of content, presentation, language, and graphics. The learning materials assessment by users consisted of the learning materials display, the learning indicators, the content of learning, the interest, and the help of the use of learning materials. The analysis used the percentage analysis technique that is by comparing the percentage of assessment and the percentage of the assessment scale. The results showed that spre...
Using computerized business simulations and spreadsheet models in accounting education: a case study
Accounting Education, 2004
When teaching accounting to undergraduate students, tutors face a number of challenges. There is the challenge of "instrumentality" as students are motivated to study accountancy not because of some inherent love, or proven ability, for the subject, but for vocational reasons linked to future extrinsic reward . Further challenges, possibly linked to instrumentality, are in the approaches to learning adopted by some students where surface learning is favoured to deep learning. Finally, students of accounting at University often lack concrete experience to enhance their learning, possibly causing them to adopt learning style preferences favouring abstract conceptualisation. Students adopting such learning style preferences can often perform well in methods of assessment favouring theoretical aspects of accountancy. Indeed, there is evidence that many accounting tutors lack concrete experience, further endorsing the status quo. This paper outlines the use of a computer simulation in an attempt to combat some of the challenges faced by accounting educators by providing an opportunity for concrete experience in an educational setting. It argues that the use of such a simulation is more in keeping with learning theories developed in educational psychology in general and experiential learning in particular. It presents an opportunity for students to develop algorithmic thinking, to use spreadsheet-modelling skills in a realistic setting, to enhance cognition in understanding the "whole" of a business problem and to reduce instrumentality through the intrinsic enjoyment of problem based learning.
Teaching of financial mathematics using Maple
Teaching Mathematics and Computer Science, 2008
The paper deals with the application of computer algebra system Maple in teaching of financial mathematics. In the Czech Republic financial mathematics is included in the curricula of grammar and secondary school. Therefore, this subject is also taught at pedagogical faculties. Most concepts of financial mathematics are difficult to understand for students. In the paper we show the ways of facilitation understanding these concepts using tools of Maple. The main result is in preparing special maplets which enable interactive studying of the principles of such concepts. Each of these maplets deals with particular financial problem from real life, e.g. mortgage credit, consumer credit, credit card etc.
Using Microsoft Excel to solve and illustrate mathematical problems
2008
At the University of Kaposvár in BSc and BA education we introduced a new course for the first year students. This course has two objectives. The first year students have significant differences in mathematics. My colleague Klingné Takács Anna writes about this problem in his articel. We use Microsoft Excel to solve and illustrate mathematical problems in Calculus and Excel Solver in Optimization. I will write about why we use Excel and I would like to demonstrate how we harmonise the traditional education of the mathematics and the opportunities provided by the Excel. Change in numbers of mathematics classes Let's have a look how the number of periods have changed compared to the one before the introduction of the Bologna process. Now there is Finance and Agricultural rural development to offer for the students at Kaposvár University at the Faculty of Economic Science. I compare the number of mahs classes to the number of maths classes at 5 year long university courses with similar content. Before 2006 undergraduate students studied for 5 year at Business and management course and Agribusiness course. Subjects and number of subjects per week taught by Mathematics Departement it can be seen in the first two lines of my table. Since the beginning of Bologna process Finance and Agricultural rural development courses are run. The latter two can be seen in lines 3 and 4.
Spreadsheets, graphics calculators and mathematics education
Over recent years, spreadsheets have been increasingly recognised as having a role in teaching and learning mathematics, but have continued to suffer the limitation of requiring access to computers. This paper summarises some of the potential benefits of spreadsheet use and briefly assesses some of the available research about it in schools. A spreadsheet application for a calculator is described and interpreted in terms of its capacity to handle the essential features of spreadsheets. The comparative merits of calculator and computer spreadsheets are discussed. Some ways in which calculator spreadhseets might be used for teaching and learning mathematics are outlined.