About this paper

Appears in:
Pages: 2224-2235
Publication year: 2009
ISBN: 978-84-612-9801-3
ISSN: 2340-1117

Conference name: 1st International Conference on Education and New Learning Technologies
Dates: 6-8 July, 2009
Location: Barcelona ,Spain

TEACHING STRUCTURAL AND STRESS ANALYSIS USING EXCEL AND VISUAL BASIC FOR APPLICATION

K. El-Sawy, A. Sweedan

United Arab Emirates University (UNITED ARAB EMIRATES)
This paper reports on using Microsoft Excel coupled with Visual Basic for Application (VBA) in teaching two courses for the students in the Civil & Environmental Engineering Department in the United Arab Emirates University. The first course covers the use of the Stiffness Matrix Method for the analysis of 2D trusses, beams and frames. The latter has a more advanced content by focusing on 2D solid elements, plates and shells. Throughout offering of both courses, the authors guide students to develop different user-defined VBA functions to be used in Excel spreadsheets to derive the solution of different structural analysis problems. The paper also proposes a new method in Excel that may be used to eliminate possible cheating (e-cheating) when students exchange files using e-mail, Bluetooth or any other mean. The proposed method has been used successfully by the authors to minimize e-cheating and copying among students.
@InProceedings{ELSAWY2009TEA,
author = {El-Sawy, K. and Sweedan, A.},
title = {TEACHING STRUCTURAL AND STRESS ANALYSIS USING EXCEL AND VISUAL BASIC FOR APPLICATION},
series = {1st International Conference on Education and New Learning Technologies},
booktitle = {EDULEARN09 Proceedings},
isbn = {978-84-612-9801-3},
issn = {2340-1117},
publisher = {IATED},
location = {Barcelona ,Spain},
month = {6-8 July, 2009},
year = {2009},
pages = {2224-2235}}
TY - CONF
AU - K. El-Sawy AU - A. Sweedan
TI - TEACHING STRUCTURAL AND STRESS ANALYSIS USING EXCEL AND VISUAL BASIC FOR APPLICATION
SN - 978-84-612-9801-3/2340-1117
PY - 2009
Y1 - 6-8 July, 2009
CI - Barcelona ,Spain
JO - 1st International Conference on Education and New Learning Technologies
JA - EDULEARN09 Proceedings
SP - 2224
EP - 2235
ER -
K. El-Sawy, A. Sweedan (2009) TEACHING STRUCTURAL AND STRESS ANALYSIS USING EXCEL AND VISUAL BASIC FOR APPLICATION, EDULEARN09 Proceedings, pp. 2224-2235.
User:
Pass: