The recent works of oscillators are mainly focused on underdamped oscillation. Therefore, the writer proposes an experimental apparatus to demonstrate all types of damped harmonic oscillation. The apparatus utilizes an Arduino for data acquisition and an Excel spreadsheet for data analysis. By using this apparatus, the type of damped harmonic…

It's not surprising that rainbows have received a great deal of attention: in textbooks, in magazines, and on the web. They are, after all, beautiful, fascinating, occasionally awe-inspiring, even a little mysterious. They are an almost perfect blend of natural beauty and simple physics. Has everything that can be said about rainbows already been…

A spreadsheet plotting assignment of real-life data from a racecar is employed to help students master the relationships among speed, acceleration, and distance. The racecar application will capture the imagination and interest of the student. The data is obtained by reading speedometer values from a YouTube video for 40 s as a racecar accelerates…

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…

The present article demonstrates a way of programming using an Excel spreadsheet to teach Fourier series expansion in school/colleges without the knowledge of any typical programming language. By using this, a student learns to approximate partial sum of the n terms of Fourier series for some periodic signals such as square wave, saw tooth wave,…

Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…

In this article, our main objective is to present the use of Microsoft Software Excel 2007/2003 for teaching college and university level curriculum in science and engineering. In particular, we discuss two interesting and fascinating examples of interactive applications of Microsoft Excel targeted for undergraduate students in: 1) computational…

This article is intended to model the ascent of the space shuttle for high school teachers and students. It provides a background for a sufficiently comprehensive description of the physics (kinematics and dynamics) of the March 16, 2009, "Discovery" launch. Our data are based on a comprehensive spreadsheet kindly sent to us by Bill Harwood, the…

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…

Demonstrated in this article are some of the capabilities of a spreadsheet program using data obtained in gas law experiments and a computer interface system. The ability to organize and analyze data which a computer can provide for the student is emphasized. (KR)

Described are several spreadsheet templates which use the functions of iteration and logical look-up which allow students to calculate and graph quantum mechanical functions and to simulate rotational and vibrational energy level and spectra. The templates are listed in the appendix. (KR)