Dynamic Simulation and Visualization in MS Excel Spreadsheet

Štěpán Hubálovský, Marie Hubálovská

Abstract


One of the most important tasks in teaching of mathematics and science is to use a suitable method for developing of theoretically acquired knowledge. Drawing on their own experience, the authors have found that the best method to be used is the system approach. System approach together with modeling and computer simulation can be understood as one of the most important method in teaching of mathematics and science and simultaneously can be used as suitable method for practical developing of theoretically acquired knowledge. The paper focuses to the theory of modeling, simulation and visualization of solution of real process. The case study, described in the paper, present possibilities of implementation of system approach in creation of mathematical model as well as dynamic computer simulation model, visualization and animation of the process. The case study presents possibility of dynamic visualization of mechanical motion – trajectory of ballistic shot. The solution is demonstrated in MS Excel worksheet and chart.


Back to list of accepted papers