Browse > Article
http://dx.doi.org/10.3795/KSME-C.2014.2.1.021

Application of MS Excel in Teaching Statics  

Kim, Youngheub (Dept. of Mechanical Engineering, Dongyang Mirae Univ.)
Publication Information
Transactions of the KSME C: Technology and Education / v.2, no.1, 2014 , pp. 21-28 More about this Journal
Abstract
As one of the most famous spreadsheet programs that is widely applied to a variety of fields in business, MS Excel has also been used for educational purposes due to its feature of wide accessibility, enabling students to use the program through almost any kind of PC that now exists. The program is mainly used for numerical analysis and formulae applications in the fields of science and engineering. This paper shall provide the key to understanding the application of MS Excel to teaching Statics through the illustration of its essential functions for education. Also, the development process of the analysis program using macros and VBA(Visual Basic for Applications) is described for the deeper comprehension of advanced applications. Students were not only able to solve the Statics problems using basic features of MS Excel, but also discovered new systematic methods of approaching complex problems and developed application programs using macros and VBA.
Keywords
Excel; Statics; Nonlinear Equation; Sheet Function; Macro; VBA; Engineering Education;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Kawamura, T., 2012, "Introduction to Numerical Analysis Using Excel," CIR Corp.
2 Sah, J.Y., 2012, "Numerical Analysis Using Excel for Introduction to Engineering," Dooyang Press
3 Meriam, J.L. and Kraige, L.G., 2010, "Engineering Mechanics: Statics," 6th ed., Bumhan Book Co. Ltd