During the pandemic and lockdown situations of the last few years, we transitioned to online, physical, and hybrid education approaches at various times. We had difficulty teaching multiple calculus and analytical geometry units online. In light of the current situation, a graphical user interface (GUI) teaching tool has been developed to teach…

In many science and engineering undergraduate programmes, physics courses are fundamental and can be seen as a potential place where students can develop complementary abilities such as the computational thinking process. The present work proposes and describes the learning science and engineering with electronic spreadsheets cycle (LSEESC)…

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…

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…

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

When students of the of the physical sciences transition from school to university, they discover that knowledge of calculus is as vital as arithmetic, and that there is precious little useful information written without calculus. However, the lack of calculus in pre-university physics studies persists, especially in its application to the…

Electricity is taught in junior high school science in Australia and many other countries. While electricity is all around us and one would say that its context and relevance are obvious, students generally do not find learning about electricity engaging. The objective of this paper is to describe the development and evaluation of an open inquiry…

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…

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…

This paper provides the formula for the elevation angle at which a projectile has to be fired in a vacuum from a general position to hit a target at a given distance. A spreadsheet application that models the trajectory is presented, and the problem of finding the points of shot and impact of a projectile moving in a vacuum if three points of the…

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…

Each year our physical science class for pre-service elementary teachers launches water-powered rockets based on the activity from NASA. We analyze the rocket flight using data from frame-by-frame video analysis of the launches. Before developing the methods presented in this paper, we noticed our students were mired in calculation details while…

SpaceShipTwo is a private spaceplane project which is intended for space tourism. Very few details about its construction and flight characteristics are available for the public, but with proper numerical methods some interesting results can be obtained using secondary school mathematics. An exercise about SpaceShipTwo can be used as a…