Physicists create spreadsheets customarily to carry out numerical calculations and to display their results in a meaningful, nice-looking way. Spreadsheets can also be used to display a vivid geometrical model of a physical system. This statement is illustrated with an example taken from geometrical optics: images formed by a thin lens. A careful…

Here we present an inexpensive proposal to experimentally study Faraday's law of induction. The experiment uses low-cost materials, a computer with a sound card and a smartphone, both running free software. A value proportional to the induced electromotive force is measured with the computer's sound card and the data related to the magnetic field…

In this study, a pendulum experimental tool with a light-based timer has been developed to measure the period of a simple pendulum. The obtained data was automatically recorded in an Excel spreadsheet. The intensity of monochromatic light, sensed by a 3DU5C phototransistor, dynamically changes as the pendulum swings. The changed intensity varies…

What follows is a description of the procedure for a directed-study in which a student, guided by a faculty member, attempted to identify potentially habitable exoplanets using actual data available online from NASA's "Kepler" Mission.

A low-cost chaos dynamics lab is developed for quantitative demonstration of the butterfly effect using a magnetic pendulum. Chaotic motion is explored by recording magnetic time series. Students analyze the data in Excel® to investigate the butterfly effect as well as the reconstruction of the strange attractor using time delay plots. The lab…

This paper gives an account of an experiment in which thirty-three high school students of ages 17-19 developed spreadsheet numerical models of satellite and space probe motion. The models are free to download. A survey was carried out to find out the students' opinion of the lessons.

Some of the results from the electrostatics portion of introductory physics are particularly difficult for students to understand and/or believe. For students who have yet to take vector calculus, Gauss's law is far from obvious and may seem more difficult than Coulomb's. When these same students are told that the minimum potential…

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…

Physics education researchers have scientifically established the fact that the understanding of new concepts and interpretation of incoming information are strongly influenced by the preexisting knowledge and beliefs of students, called epistemological beliefs. This can lead to a gap between what students actually learn and what the teacher…

The objective of this article is to graphically illustrate to the students the physical phenomenon of motion of charged particle under the action of simultaneous electric and magnetic fields by simulating particle motion on a computer. Differential equations of motions are solved analytically and path of particle in three-dimensional space are…

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…

Spreadsheets can be a powerful tool when it comes to teaching physics. From data analysis and graphing to animated simulations, Excel[R] is a very versatile program for the educator and learner alike. This paper describes and supports another use for Excel through Reflective Formative Assessment Spreadsheets (RFAS). To illustrate the use of RFAS,…

Explains that thinking like a physicist involves an understanding of the scientific methods of inquiry and the ability to use these methods in investigations. Describes two simple experiments in which high school and college students measure physical constants and make an easy analysis of their experimental data by applying the tools offered by…

Describes a way of incorporating animations into spreadsheets using Excel software. (WRM)

Presents a lab experiment to demonstrate application of the iterative capability of spreadsheets. Activity involves a variable spacing parallel-plate capacitor and an electrometer. (PR)