Document Type

Conference Paper

Publication Date


Publication Title

Proceedings of the 2002 American Society for Engineering Education Annual Conference & Exposition


(1-9) 7.1276

Conference Name

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.


© 2002 American Society for Engineering Education, ASEE Annual Conference Proceedings, Montreal, Canada, June 16-19, 2002.

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.