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!
Abstract 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.
AbstractList 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.
Author Ernesto Juliá Sanchis
Jorge Gabriel Segura Alcaraz
José María Gadea Borrell
Jaime Masiá Vañó
Author_xml – sequence: 1
  fullname: Ernesto Juliá Sanchis
– sequence: 2
  fullname: Jorge Gabriel Segura Alcaraz
– sequence: 3
  fullname: José María Gadea Borrell
– sequence: 4
  fullname: Jaime Masiá Vañó
BookMark eNqtjEFqwzAQRUVpoWmbO-gChjiWFXtpQkK7KAmp92KsjNsJssbIItCcPm6dI-RvHv_x-S_i0bPHBzFLlSoSneb6WcyH4bQYk6VK52omDpWXVd87shCJveRWgpe7PlJHl0nVzE5Gll_szij3gRuH3fC3_ET7A57sVCBiIHDDm3hqR-D8xlfxsd3U6_fkyHAyfaAOwq9hIPMvOHwbCJGsQ9M0ZbloWsiOulUF5gWs7CrXmC1TgHJZZPf8ugINBVtx
ContentType Journal Article
DBID DOA
DatabaseName Directory of Open Access Journals
DatabaseTitleList
Database_xml – sequence: 1
  dbid: DOA
  name: Directory of Open Access Journals
  url: http://www.doaj.org/
  sourceTypes: Open Website
DeliveryMethod fulltext_linktorsrc
Discipline Education
EISSN 1448-6156
ExternalDocumentID oai_doaj_org_article_bb990bfa3d6f48e58a7c756e321aa928
GroupedDBID 123
2WC
ADBBV
ALMA_UNASSIGNED_HOLDINGS
BCNDV
E3Z
GROUPED_DOAJ
M~E
O2D
OK1
P2P
TR2
XSB
ID FETCH-doaj_primary_oai_doaj_org_article_bb990bfa3d6f48e58a7c756e321aa9283
IEDL.DBID DOA
IngestDate Tue Oct 22 15:04:20 EDT 2024
IsOpenAccess true
IsPeerReviewed true
IsScholarly true
Issue 1
Language English
LinkModel DirectLink
MergedId FETCHMERGED-doaj_primary_oai_doaj_org_article_bb990bfa3d6f48e58a7c756e321aa9283
OpenAccessLink https://doaj.org/article/bb990bfa3d6f48e58a7c756e321aa928
ParticipantIDs doaj_primary_oai_doaj_org_article_bb990bfa3d6f48e58a7c756e321aa928
PublicationCentury 2000
PublicationDate 2011-01-01
PublicationDateYYYYMMDD 2011-01-01
PublicationDate_xml – month: 01
  year: 2011
  text: 2011-01-01
  day: 01
PublicationDecade 2010
PublicationTitle Spreadsheets in education
PublicationYear 2011
Publisher McMaster University
Publisher_xml – name: McMaster University
SSID ssj0000314654
Score 3.5925412
Snippet 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...
SourceID doaj
SourceType Open Website
Title An Application of an Optimization Tool to Solve Problems of Mechanics of Materials
URI https://doaj.org/article/bb990bfa3d6f48e58a7c756e321aa928
Volume 5
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
link http://sdu.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwrV07T8MwED5BJxZEeYhHQR5YIxI7idMxQKsy8BDtwBZd7IuEVGJEU34_uTjiMTGA5MWW5fP5cfbZd98BnIckEZNW-lVhFgcxGhOgRhsYRaVNkaNbs3PybK7vnrLrCcPkfIb6YpswDw_sB-6iLFt5WVaobFrFGSUZaqOTlJSMEMfSu_mG6TdlqpPBKmKgsB9A_N2JMd2B7f6qJ3JPYggbVO9ylOTeomIPHvNa5F8fyMJVAmtx327il947UiycW4rGiblbvpN48NFfVlzzlthn99n4DDZ-Je3DzXSyuJoF3KHi1UNJFAzu3BW0LBc9y8VvLKsDGNSupkMQKpRjNFoqBrJLrG2Vl6jMEkIkKa3UR3D5d3rH_9HICWz551hOIxg0b2s6hc2VXZ91U_cB-A6n4g
link.rule.ids 315,782,786,2106
linkProvider Directory of Open Access Journals
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=An+Application+of+an+Optimization+Tool+to+Solve+Problems+of+Mechanics+of+Materials&rft.jtitle=Spreadsheets+in+education&rft.au=Ernesto+Juli%C3%A1+Sanchis&rft.au=Jorge+Gabriel+Segura+Alcaraz&rft.au=Jos%C3%A9+Mar%C3%ADa+Gadea+Borrell&rft.au=Jaime+Masi%C3%A1+Va%C3%B1%C3%B3&rft.date=2011-01-01&rft.pub=McMaster+University&rft.eissn=1448-6156&rft.volume=5&rft.issue=1&rft.externalDBID=DOA&rft.externalDocID=oai_doaj_org_article_bb990bfa3d6f48e58a7c756e321aa928