Loughborough University
260510-Smith-TA2010_web.pdf (90.37 kB)
Download file

A novel approach to the use of spreadsheets in structural design

Download (90.37 kB)
online resource
posted on 2011-07-07, 11:06 authored by Phil Barker
This case study has been developed as part of the Engineering Subject Centre Teaching Awards 2010, from data gathered through observations of the teaching component; interviews with the tutor and a student focus group. The Software for Engineering Module in the second year of the Civil Engineering BEng and MEng courses at Dundee University invites students to tackle a real-world, open-ended structural modelling problem in the design of complex, non-standard structures. The aim is to enhance students' problem solving, team work, planning and IT skills, including introducing them to a novel approach for the parametric generation of data sets for use in structural modelling packages using Excel spreadsheets.



  • University Academic and Administrative Support

Research Unit

  • Higher Education Academy Engineering Subject Centre


© Higher Education Academy Engineering Subject Centre, Loughborough University


  • VoR (Version of Record)

Publication date



If reproducing this work please include the following attribution statement: ‘This Teaching Award 2010 Case Study was written by Phil Barker for the Higher Education Academy Engineering Subject Centre, Loughborough University. Copyright © May 2010.’ Tutor in Study: Fraser Smith, Civil Engineering, School of Engineering, Physics and Mathematics, Dundee University


  • en

Usage metrics


    No categories selected