Excel as Tool for Modeling , Dynamic Simulation and Visualization ofMechanical Motion
One of the most important tasks in teaching of mechanics is to use a suitable method for developing of theoreticallyacquired knowledge. Drawing on her own experience, the author has found that the best method to be used is the system approach.System approach is closely connected to the modeling,computer simulation and dynamic visualization. Theory of the systems, modeling and computer simulation are disciplines with its own theory and research methodology. Modeling and computer simulation (M&S) can be understand as one of the most important method in teaching of mathematics and simultaneously can be use as suitable method for practical developing of theoretically acquired knowledge. Case study, described in the paper, presentspossibility of dynamic visualization of mechanical motion – trajectory of ballistic shot. The solution is demonstrated in MS Excel worksheet and chart. Key-Words:Animation, computer simulation, mathematical modeling, system approach, visualization.
MS Excel as Tool for Simulation of Static and Dynamic Systems
Many universities are realizing that modeling and simulation is becoming an important tool in finding the strategy for solving and understanding numerous and diverse problems. The paper we first briefly introduce the theory of system approach, modeling and simulation as a method of multidisciplinary and system approach to education. Secondly, the two case studies illustrating step by step process of development of modeling, computer simulation, visualization and animation will be introduced. The cases studies will present possibility of simulation of static as well as dynamic systems in MS Excel worksheet and chart. Key-Words: -Animation, Computer simulation, Dynamic system, Mathematical modeling, Static system, System approach, Visualization
Modelling of real kinematics situation as a method of the system approach to the algorithm development thinking
- O ne of the most important tasks in teaching of algorithm development and programming is to use a suitable method of developing theoretical knowledge of algorithm development and programming. Drawing on his own experience, the author has found that the best method to be used is the system approach. This method, described in the paper, is presented through the computer simulation of physical problems from the sphere of the kinematics of solid bodies. To be more specific, the solution of the problem of the trajectory modelling of the motion of a cylinder over the edge of two planes is presented. The solution is demonstrated progressively – it starts with the physical and mathematical analysis of the problem, then the algorithm development is presented and it finishes with the programming in MS Excel worksheet, through which the solution and visualization of the problem is reached. A case study of the system approach as a suitable method of the algorithm development thinking is presented in the paper step by step; the text also emphasizes interdisciplinary learning of university students.