Using Computer Spreadsheets in Teaching Mechanisms


2nd European Conference on Mechanism Science, Cassino, Italy, 17 - 20 September 2008, pp.45-53 identifier identifier

  • Publication Type: Conference Paper / Full Text
  • Doi Number: 10.1007/978-1-4020-8915-2_6
  • City: Cassino
  • Country: Italy
  • Page Numbers: pp.45-53
  • Middle East Technical University Affiliated: Yes


In this paper the use of widely available user friendly spreadsheet programs such as Microsoft (R) Excel in teaching mechanisms is explained and its advantages over off-the-shelf programs are shown. Instead of using specific costly programs for the analysis and synthesis of different mechanisms, the students are first thought certain features of Excel and later starting with the analysis of single loop mechanisms, the solution of more complex problems in the analysis and synthesis of mechanisms are attempted. The simulation of mechanisms can be achieved by using the Chart and control toolbox features of Excel. Students are able to prepare their own spreadsheets for the solution of different mechanism problems. In this article different examples using spreadsheet program will be explained and its benefits as an educational tool will be demonstrated.