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 Modeling , Dynamic Simulation and Visualization of Mathematical Functions
One of the most important tasks in teaching of mathematics is to use a suitable method for developing of theoretically acquired knowledge. Drawing on his own experience, the authors have found that the best method to be used is the system approach. System approach is closely connected to the modeling and simulation. Theory of the systems, modeling and simulation are disciplines with its own theory and research methodology. Modeling and computer simulation 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, presents possibility of dynamic visualization of mathematical function. The solution is demonstrated in MS Excel worksheet and chart. Key-Words: Animation, computer simulation, mathematical modeling, system approach, visualization.
Interdisciplinary relations in teaching of programming
The presented article describes one of the potential system approaches to teaching of programming. The focus is given on the interdisciplinary interconnection between physics, informatics and mathematics. First, a simple analysis of the researched process is carried out - that means the decomposition of the light into a colour spectrum on one side and the additive composition of colours on the other side. This is followed by a mathematical description of the composition of colours from three basic components - red, green and blue - on the screen of the computer monitor. The numerical code of the resulting colour is expressed in the binary, hexadecimal and decimal numerical systems. The final part of the paper presents a simple program which enables using a computer monitor for an analysis of the additive composition of colours. It simultaneously demonstrates also advantages and disadvantages of expressing the numerical code of the composed colour in various numerical systems.