June 26, 2011
June 26, 2011
June 29, 2011
22.1402.1 - 22.1402.12
Teaching Spreadsheet-Based Numerical Analysis with Visual Basic for Applications and Virtual InstrumentsThe students’ over reliance upon formulas and routine use of technique in problem solving toooften lead to poor performance in advanced courses and a high attrition rate in the engineering,technology, and science programs. The students’ lack of comprehension of mathematicalconcepts results in time wastage during laboratory experiments, misinterpretations of lab dataand underachievement in standardized science and engineering tests that stress the fundamentals.This problem can be effectively addressed by improving the student’s conceptual understandingand comprehension of the topics covered in introductory science and technology courses. Oneway to achieve this is through interactive learning and teaching and upgrading the existinglaboratories with modern equipment. This will require increased funding and resources. But inrecent years there is a decrease in resource allocation making it increasingly difficult tomodernize the laboratories to provide adequate levels of laboratory and course work anduniversities are under pressure to look for alternative cost effective methods. One way to achievethis is through interactive learning and teaching through the use of software packages likeLabVIEW, Excel and Visual Basic for Applications (VBA).LabVIEW, EXCEL and VBA are currently used in a number of engineering schools andindustries for simulation and analysis. By introducing virtual instrumentation (LabVIEW) andEXCEL/VBA to the existing laboratory facilities and course(s) the students can be well trainedwith the latest design techniques and computer aided instrumentation, design and process controlused throughout industry. This will also allow the students greater interaction with the subjectmatter and improve his/her skills in the use of number of applied engineering software packages.This paper will discuss design and development of interactive instructional modules forNumerical Analysis Course using LabVIEW, EXCEL and VBA.
Swain, N. (2011, June), Teaching Spreadsheet-Based Numerical Analysis with Visual Basic for Applications and Virtual Instruments Paper presented at 2011 ASEE Annual Conference & Exposition, Vancouver, BC. https://peer.asee.org/18647
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2011 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015