An Application of an Optimization Tool to Solve Problems of Mechanics of Materials

An Application of an Optimization Tool to Solve Problems of Mechanics of Materials

This paper presents a study about using computational tools applied to a particular problem of Mechanics of Materials. Our purpose is, on one hand, to solve a structural problem in order to teach the application of an optimization tool, such as Excel Solver, by means of the calculation of the minimu...

Full description

Saved in:
Bibliographic Details
Published in:Spreadsheets in education Vol. 5; no. 1
Main Authors: Ernesto Juliá Sanchis, Jorge Gabriel Segura Alcaraz, José María Gadea Borrell, Jaime Masiá Vañó
Format: Journal Article
Language:English
Published: McMaster University 01-01-2011
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:This paper presents a study about using computational tools applied to a particular problem of Mechanics of Materials. Our purpose is, on one hand, to solve a structural problem in order to teach the application of an optimization tool, such as Excel Solver, by means of the calculation of the minimum weight in a shaft. On the other hand, we present an active learning methodology based on the creation of spreadsheets that contributes to enhancing the motivation of students. Since the evaluation of the subject takes into account the activity of creating the spreadsheets, the academic results have improved considerably.
ISSN:1448-6156