The paper presents the application of an Excel spreadsheet as an educational tool for the beam bending calculations. It describes the advantages of using the spreadsheet in engineering education. It also describes the spreadsheet which uses Macaulay's method for beam calculations. The spreadsheet can be applied to both statically determined and indeterminate beams. It calculates the reactions (both forces and moments), shear force and bending moment as well as deflections for any of four typical beam end-fixing conditions (simply supported, cantilever, propped and built-in). The dimensions of the beam, the loads and their location are given by the user. The spreadsheet works as a menu driven program and is designed to be user-friendly. The paper therefore makes a case for the use of spreadsheets in beam bending calculation to improve students understanding and performance in this topic.
scite is a Brooklyn-based organization that helps researchers better discover and understand research articles through Smart Citations–citations that display the context of the citation and describe whether the article provides supporting or contrasting evidence. scite is used by students and researchers from around the world and is funded in part by the National Science Foundation and the National Institute on Drug Abuse of the National Institutes of Health.