Computer Applications in Civil Engineering

Basic concepts of Mathematics.

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

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.

NAO