This book demonstrates some of the ways in which Microsoft Excel® may be used to solve numerical problems in the field of physics. But why use Excel in the first place? Certainly, Excel is never going to out-perform the wonderful symbolic algebra tools tha

This book demonstrates some of the ways in which Microsoft Excel® may be used to solve numerical problems in the field of physics. But why use Excel in the first place? Certainly, Excel is never going to out-perform the wonderful symbolic algebra tools tha

This book covers essential Microsoft EXCEL®'s computational skills while analyzing introductory physics projects. Topics of numerical analysis include; multiple graphs on the same sheet, calculation of descriptive statistical parameters, a 3-point interpolation, the Euler and the Runge-Kutter methods to solve equations of motion, the Fourier transform to calculate the normal modes of a double pendulum, matrix calculations to solve coupled linear equations of a DC circuit, animation of waves and Lissajous figures, electric and magnetic field calculations from the Poisson equation and its 3D surface graphs, variational calculus such as Fermat's least traveling time principle and the least action principle. Nelson's stochastic quantum dynamics is also introduced to draw quantum particle trajectories.

SMath is a free mathematical notebook program similar to Mathcad that provides many options for studying and solving complex mathematical equations. This book is a primer providing a concise but thorough introduction that keeps physics at a fairly low leve

This book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel® by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel® workbooks are available for each chapter and there is nothing to buy or install.

This book offers a comprehensive overview of the theoretical background and practice of physics teaching and learning and assists in the integration of highly interesting topics into physics lessons. Researchers in the field, including experienced educators, discuss basic theories, the methods and some contents of physics teaching and learning, highlighting new and traditional perspectives on physics instruction. A major aim is to explain how physics can be taught and learned effectively and in a manner enjoyable for both the teacher and the student. Close attention is paid to aspects such as teacher competences and requirements, lesson structure, and the use of experiments in physics lessons. The roles of mathematical and physical modeling, multiple representations, instructional explanations, and digital media in physics teaching are all examined. Quantitative and qualitative research on science education in schools is discussed, as quality assessment of physics instruction. The book is of great value to researchers involved in the teaching and learning of physics, to those training physics teachers, and to pre-service and practising physics teachers.