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…

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,…

Throughout the general chemistry lab curriculum, a common shortcoming is the way in which students measure, record, and manipulate quantitative data. From initial measurements with different digital and analog instruments to proper conversions, calculations, and comparisons, students are often expected to be experts before they have been taught…

Equilibrator is a Microsoft Excel program for learning about chemical equilibria through modeling, similar in function to EQS4WIN, which is no longer supported and does not work well with newer Windows operating systems. Similar to EQS4WIN, Equilibrator allows the user to define a system with temperature, initial moles, and then either total…

The aim of this study is to scrutinize the characteristics of conceptual meaning making when students engage with virtual worlds in combination with a spreadsheet with the aim to develop graphs. We study how these tools and the representations they contain or enable students to construct serve to influence their understanding of energy resource…

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…

A description of the Microsoft Excel spreadsheet simulation, Anharmonicity.xls that can be used to smoothly and continuously switch a plotted function and its quadratic approximation is presented. It can be used in a classroom demonstration or incorporated into a student-centered computer-laboratory exercise to examine the qualitative behavior of…

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…

We describe a computer tutorial that introduces the concept of the steady state in enzyme kinetics. The tutorial allows students to produce graphs of the concentrations of free enzyme, enzyme-substrate complex, and product versus time in order to learn about the approach to steady state. By using a range of substrate concentrations and rate…

Describes two spreadsheets for producing acid-base titration curves, one uses relatively simple cell formulae that can be written into the spreadsheet by inexperienced students and the second uses more complex formulae that are best written by the teacher. (JRH)

Describes a computer applications course developed for undergraduate biology students (primarily sophomores) to teach word processing, database and spreadsheet programs, graphing programs, telecommunications, and file transfer procedures. AppleWorks software is discussed, course content is explained, and the microcomputer laboratory is described.…