Proceedings of the 2002 American Society for Engineering Education Annual Conference & Exposition
2002 ASEE Annual Conference and Exposition, Montreal, Canada, June 16-19, 2002
This paper presents an approach on using spreadsheets to teach machine design. It also lists detailed procedures on how to implement the teaching scheme. Results show that spreadsheet programs can help students organize their design procedures. By using the characteristics of spreadsheet programs, students do not have to repeat the same calculation and can get the alternate solution of a design almost instantly when given different values on the inputs. When compared to the method taught by using calculators, students can significantly improve their performance on homework problems and tests. From teaching evaluations, their interest in taking such a course increases. In addition, instructors can give more problems to students during tests and therefore can evaluate the students' performance more objectively.
Original Publication Citation
Lin, C. Y., & Crossman, G. R. (2002). Using spreadsheet programs in teaching machine design. Paper presented at the 2002 ASEE Annual Conference & Exposition, Montreal, Canada.
Lin, Cheng Y. and Crossman, Gary R., "Using Spreadsheet Programs in Teaching Machine Design" (2002). Engineering Technology Faculty Publications. 109.