Teaching fundamental concepts of coastal engineering using excel spreadsheet

Ahmad Sana*

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

6 Citations (Scopus)


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
Issue number2
Publication statusPublished - Mar 1 2017


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

ASJC Scopus subject areas

  • General Computer Science
  • Education
  • General Engineering


Dive into the research topics of 'Teaching fundamental concepts of coastal engineering using excel spreadsheet'. Together they form a unique fingerprint.

Cite this