NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ781580
Record Type: Journal
Publication Date: 2008-Jan
Pages: 7
Abstractor: Author
Reference Count: 8
ISSN: ISSN-0031-9120
Preparing Content-Rich Learning Environments with VPython and Excel, Controlled by Visual Basic for Applications
Prayaga, Chandra
Physics Education, v43 n1 p88-94 Jan 2008
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.)
Institute of Physics Publishing. The Public Ledger Building Suite 929, 150 South Independence Mall West, Philadelphia, PA 19106. Tel: 215-627-0880; Fax: 215-627-0879; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A