Spreadsheet solution of basic axial force problems of strength of materials

Abstract

In this work, we present a spreadsheet developed for some particular problems of Strength of Materials. This paper is focused on the study of axial force systems, some statically determinate, such as trusses, and some statically indeterminate, such as a load-carrying rigid member supported by a pinned connection and by two axial bars. Starting with simple calculations for a particular problem, students develop the spreadsheet with more advanced calculations. The examples have been modelled on Microsoft Excel software. The aim is that, at the end of the course, students have developed a collection of such spreadsheets. This methodology contributes to enhancing the motivation in the study of the subject, which is the main learning objective.