Computer Applications in Civil Engineering

Base Knowledge

Basic concepts of Mathematics.

Teaching Methodologies

The concepts are introduced first and then are applied in problem solving based on Microsoft Excel software.

Learning Results

Identify and use the main features of a spreadsheet; add new features using programming; interpret, model and solve simple engineering problems using a spreadsheet.


  1. Fundamentals of Microsoft Excel (version 2021/Office 365).
  2. Formulas and functions.
  3. Information organization.
  4. Charts.
  5. Advanced data analysis: pivot tables and pivot tables; scenarios; goal-seeking.
  6. Importing and exporting information.
  7. Excel programming: automation of tasks through Macros;  Visual Basic for Applications (VBA) programming language.

Curricular Unit Teachers




Smart, M. (2022a). Learn Excel 365 essential skills with The Smart Method (6th ed.).
Smart, M. (2022b). Learn Excel 365 expert skills with The Smart Method (6th ed.).
Alexander, M., & Kusleika, D. (2022). Microsoft Excel 365 bible. John Wiley and Sons.