You are here:

Preparing Content-Rich Learning Environments with VPython and Excel, Controlled by Visual Basic for Applications
ARTICLE

Physics Education Volume 43, Number 1, ISSN 0031-9120

Abstract

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 capabilities of MS Office. MS Office provides the user interface for data input. The data are stored in a text file, which is read by VPython and used in 3D graphical simulations. Use of the interface is illustrated by working through an example of the motion of a charged particle in a magnetic field. A user interface designed in Excel allows the student to input data on the charge and the mass of the particle, the initial conditions and the magnetic field. The data are then saved in a text file. VPython reads the data and renders the 3D graphics visualization of the motion. Interactivity is ensured since the student can change the data and directly observe the changes in motion. (Contains 6 figures.)

Citation

Prayaga, C. (2008). Preparing Content-Rich Learning Environments with VPython and Excel, Controlled by Visual Basic for Applications. Physics Education, 43(1), 88-94. Retrieved November 26, 2020 from .

This record was imported from ERIC on April 18, 2013. [Original Record]

ERIC is sponsored by the Institute of Education Sciences (IES) of the U.S. Department of Education.

Copyright for this record is held by the content creator. For more details see ERIC's copyright policy.

Keywords