Using computer spreadsheets in engineering and education

Author

Banta, Andrew

Author_Institution

California State Univ., Sacramento, CA, USA

fYear

1988

fDate

22-25 Oct 1988

Firstpage

238

Lastpage

243

Abstract

A Lotus 1-2-3 template worksheet that does calculations and gives the results in their common graphical forms is described for use in two areas of machine design: calculations using the Mohr circle and fatigue failure design. The purpose of these spreadsheet templates is to relieve the user of many of the tedious tasks required to solve design problems. In both templates the ease of performing calculations makes it possible to have the students try several possible solutions to a problem. Particularly in the case of fatigue design this approach is much more realistic than having the students laboriously work through one or two examples of a complicated design

Keywords

computer aided instruction; educational aids; mechanical engineering computing; spreadsheet programs; Lotus 1-2-3 template worksheet; Mohr circle; calculations; common graphical forms; computer spreadsheets; design problems; education; engineering; fatigue failure design; machine design; mechanical engineering; spreadsheet templates; Composite materials; Computer science education; Conference proceedings; Equations; Keyboards; Microcomputers; Programming profession; Silicon compounds; Stress; Writing;

fLanguage

English

Publisher

ieee

Conference_Titel

Frontiers in Education Conference, 1988., Proceedings

Conference_Location

Santa Barbara, CA

Type

conf

DOI

10.1109/FIE.1988.34986

Filename

34986