NotesFAQContact Us
Collection
Advanced
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ852930
Record Type: Journal
Publication Date: 2009
Pages: 13
Abstractor: As Provided
Reference Count: 10
ISBN: N/A
ISSN: ISSN-0047-2395
Microsoft Excel Software Usage for Teaching Science and Engineering Curriculum
Singh, Gurmukh; Siddiqui, Khalid
Journal of Educational Technology Systems, v37 n4 p405-417 2008-2009
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 physics and physics education; and 2) computer and medical sciences. We demonstrate the tremendous amount of computational power of the most recent Microsoft Excel 2007 Software, which is employed here to perform simulations of a projectile (may be a missile) launched from an airplane so as to hit a target on the ground using the simplest assumption of no air resistance during the projectile motion in air and that of rolling of nine dice with six surfaces. For projectile motion, kinematic equations based on Newton's laws of uniform motion have been employed to simulate projectile trajectory. We are going to prove through a plot of vertical distance as a function time that the projectile motion undergoes a parabolic path. However, modification in the simulation equations of the projectile motion, which includes the effect of air resistance, change in gravitational force with altitude, curvature in the surface of Earth, Coriolis force due to Earth's spin motion about its axis of rotation, and wind speed, will be discussed in very near future. We will also plot a graph of normalized total score versus the maximum score for rolling of nine dice like in casino games. (Contains 4 figures.)
Baywood Publishing Company, Inc. 26 Austin Avenue, P.O. Box 337, Amityville, NY 11701. Tel: 800-638-7819; Tel: 631-691-1270; Fax: 631-691-1770; e-mail: info@baywood.com; Web site: http://baywood.com
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A