Teaching physics using Microsoft Excel-II

Abstract

Abstract Conventional teaching is rapidly changing, and online and simulated software are adding up in teaching. Simulations on spreadsheets have become popular due to their ubiquitous and easily understandable. In this paper, we demonstrate three physics topics: the motion of a charged particle in a uniform magnetic field, the motion of a projectile, and the simple harmonic motion of a simple pendulum. The third example is a demonstration of an experiment on a simple pendulum to find the time period of a simple pendulum and study the amplitude’s effect on it. Students can perform the whole experiment on the spreadsheet in real-time.