Mechanical Engineering Commons^™

Using Spreadsheet Programs In Teaching Machine Design, Cheng Y. Lin, Gary R. Crossman

Engineering Technology Faculty Publications

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 …