Teaching fundamental concepts of coastal engineering using excel spreadsheet

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

A Microsoft-Excel spreadsheet was developed using Visual Basic for Applications (VBA) functions to calculate fundamental wave properties using linear wave theory, simple wave transformations, tidal elevations, tsunami travel time, wind wave growth parameters, design wave heights using Raleigh's probability distribution, breakwater dimensions, and longshore sediment transport rates. This spreadsheet was used in teaching an undergraduate coastal engineering course. The students were found to be motivated to study the subject matter with the help of VBA functions and develop their own applications in coastal engineering. This spreadsheet may be helpful to the practicing engineers as well for calculations relevant to some important wave parameters that are used in the design of coastal structures.

Original languageEnglish
Pages (from-to)304-310
Number of pages7
JournalComputer Applications in Engineering Education
Volume25
Issue number2
DOIs
Publication statusPublished - Mar 1 2017

Fingerprint

Coastal engineering
Spreadsheets
Teaching
engineering
engineer
travel
Tsunamis
Breakwaters
student
Sediment transport
Travel time
Probability distributions
Students
Engineers
time

Keywords

  • Coastal Engineering
  • Linear Wave Theory
  • Microsoft-Excel Spreadsheet
  • VBA
  • wave properties

ASJC Scopus subject areas

  • Computer Science(all)
  • Education
  • Engineering(all)

Cite this

Teaching fundamental concepts of coastal engineering using excel spreadsheet. / Sana, Ahmad.

In: Computer Applications in Engineering Education, Vol. 25, No. 2, 01.03.2017, p. 304-310.

Research output: Contribution to journalArticle

@article{dcf1211e2ab54329a0e1a4e742ab2e04,
title = "Teaching fundamental concepts of coastal engineering using excel spreadsheet",
abstract = "A Microsoft-Excel spreadsheet was developed using Visual Basic for Applications (VBA) functions to calculate fundamental wave properties using linear wave theory, simple wave transformations, tidal elevations, tsunami travel time, wind wave growth parameters, design wave heights using Raleigh's probability distribution, breakwater dimensions, and longshore sediment transport rates. This spreadsheet was used in teaching an undergraduate coastal engineering course. The students were found to be motivated to study the subject matter with the help of VBA functions and develop their own applications in coastal engineering. This spreadsheet may be helpful to the practicing engineers as well for calculations relevant to some important wave parameters that are used in the design of coastal structures.",
keywords = "Coastal Engineering, Linear Wave Theory, Microsoft-Excel Spreadsheet, VBA, wave properties",
author = "Ahmad Sana",
year = "2017",
month = "3",
day = "1",
doi = "10.1002/cae.21798",
language = "English",
volume = "25",
pages = "304--310",
journal = "Computer Applications in Engineering Education",
issn = "1061-3773",
publisher = "John Wiley and Sons Inc.",
number = "2",

}

TY - JOUR

T1 - Teaching fundamental concepts of coastal engineering using excel spreadsheet

AU - Sana, Ahmad

PY - 2017/3/1

Y1 - 2017/3/1

N2 - A Microsoft-Excel spreadsheet was developed using Visual Basic for Applications (VBA) functions to calculate fundamental wave properties using linear wave theory, simple wave transformations, tidal elevations, tsunami travel time, wind wave growth parameters, design wave heights using Raleigh's probability distribution, breakwater dimensions, and longshore sediment transport rates. This spreadsheet was used in teaching an undergraduate coastal engineering course. The students were found to be motivated to study the subject matter with the help of VBA functions and develop their own applications in coastal engineering. This spreadsheet may be helpful to the practicing engineers as well for calculations relevant to some important wave parameters that are used in the design of coastal structures.

AB - A Microsoft-Excel spreadsheet was developed using Visual Basic for Applications (VBA) functions to calculate fundamental wave properties using linear wave theory, simple wave transformations, tidal elevations, tsunami travel time, wind wave growth parameters, design wave heights using Raleigh's probability distribution, breakwater dimensions, and longshore sediment transport rates. This spreadsheet was used in teaching an undergraduate coastal engineering course. The students were found to be motivated to study the subject matter with the help of VBA functions and develop their own applications in coastal engineering. This spreadsheet may be helpful to the practicing engineers as well for calculations relevant to some important wave parameters that are used in the design of coastal structures.

KW - Coastal Engineering

KW - Linear Wave Theory

KW - Microsoft-Excel Spreadsheet

KW - VBA

KW - wave properties

UR - http://www.scopus.com/inward/record.url?scp=85011395242&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=85011395242&partnerID=8YFLogxK

U2 - 10.1002/cae.21798

DO - 10.1002/cae.21798

M3 - Article

VL - 25

SP - 304

EP - 310

JO - Computer Applications in Engineering Education

JF - Computer Applications in Engineering Education

SN - 1061-3773

IS - 2

ER -