Medical physics uses physics knowledge in medicine or healthcare. The question surrounding the methods of measuring temperature is important in medicine. The aim of this article is to explore the possibilities of using Microsoft Excel to study thermometers. The physical concepts and laws related to temperature measurement have been considered. The…

This paper presents the usage of an Excel spreadsheet for studying charged particle dynamics in the presence of uniform electric and magnetic fields. The equation of motion of the charged particle is developed under different conditions and the data is obtained in an Excel spreadsheet under variation of parameters such as the velocity of charged…

In this work we discuss the intricacies of a simulation using the MS Excel spreadsheet that allows to study in detail the process of heat transfer between two reservoirs at different temperatures through a conducting rod when heat losses are neglected. The proposed physical model computes the time dependence of the reservoir temperatures and…

Harmonics arise naturally from the resonances in strings and pipes. A video demonstration (Ruiz 2016 "YouTube: Tuba Harmonics" (https://youtu.be/souhEzOP9c4)) is provided where a tubist (coauthor Holmes) produces a phenomenal 24 harmonics using a single tuba pipe length by controlling the buzz of his lips. The frequencies of the…

Excel spreadsheets are used as an excellent tool in physics laboratory experiments related to wave optics. This paper presents a simple way to simulate diffraction of waves through a slit using Excel spreadsheets without any tedious programming. These simulations are used to visualize the effect of variation of different parameters such as number…

A fun activity is presented using singing wine glasses for introductory physics students. Students tune a white wine glass and a red wine glass to as many semitones as possible by filling the glasses with the appropriate amounts of water. A smart phone app is used to measure the frequencies of equal-temperament tones. Then plots of frequency…

In the teaching of physics at upper secondary school level (K10-K12), the students are generally taught to solve problems analytically, i.e. using the dynamics describing a system (typically in the form of differential equations) to compute its evolution in time, e.g. the motion of a body along a straight line or in a plane. This reduces the scope…

A freely available, easy-to-use Excel spreadsheet for performing linear least-squares fits for (x, y) data with errors in both coordinates is described. (Contains 1 table and 1 figure.)

A simple interface between VPython and Microsoft (MS) Office products such as Word and Excel, controlled by Visual Basic for Applications, is described. The interface allows the preparation of content-rich, interactive learning environments by taking advantage of the three-dimensional (3D) visualization capabilities of VPython and the GUI…

In this exercise the US Standard Atmosphere is used as "data" that a student is asked to model by deriving equations to reproduce it with the help of spreadsheet and graphing software. The exercise can be used as a laboratory or an independent study for a student of introductory physics to provide an introduction to scientific research…

Describes how to fit binocular observations of the planets to a theoretical model of circular orbits using a modern computer spreadsheet, from which fundamental data about the solar system may be deduced. (AIM)

Describes how a spreadsheet is used to fit a circular orbit model to observations of Jupiter's moons made with a small telescope. Kepler's Third Law and the inverse square law of gravity are observed. (AIM)