Teaching Heat Transfer Using Automotive-Related Case Studies with a Spreadsheet Analysis Package

Abstract

Five automotive-related projects used to teach the principles of heat transfer are presented. The projects were completed by students from Ford Motor Company in the Bachelor of Mechanical Engineering programme offered by the University of Detroit Mercy. Students were required to perform their engineering calculations with the spreadsheet package Microsoft Excel™. The objectives for the use of these projects in the heat transfer course were to increase student understanding of and interest in heat transfer principles by presenting problems in a familiar context, to improve the students' ability to use spreadsheets as an engineering analysis tool, and to provide experience in dealing with the open-endedness of real engineering problems. The problem statements and solutions are described, and student performance and reaction are discussed. The projects may serve as useful course material for other instructors of heat transfer, even for students outside the automotive industry.

Get full access to this article

View all access options for this article.

References

‘Engineering education for a changing world’, ASEE project report, ASEE Prism, December (1994).

Incropera

Frank P.

DeWitt

David P.

, Introduction to Heat Transfer, 2nd edn, John Wiley, New York, 1990.

Cross Patricia

, ‘On college teaching’, Journal of Engineering Education, 82(1), 9–14 (1993).

Hale

J. M.

Grant

, ‘A course in the use of computer spreadsheets for mechanical engineering students’, The International Journal of Mechanical Engineering Education, 21(2), 146–155 (1993).

Kharab

Abdelwahab

, ‘Use of a spreadsheet program in a two-dimensional heat conduction problem’, Computer Methods in Applied Mechanics and Engineering, 122, 173–181 (1995).