European Union Portugal 2020 - Agriculture and Rural Development Foundation for Science and Technology European University Foundation
Suggestions, Compliments, Complaints Terms & Conditions of Use Projects Co-financed by the European Union
©2024 Instituto Politécnico de Coimbra. Todos os direitos reservados.

Search

Computer Applications in Civil Engineering

Home / Unidades Curriculares / 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.

Program

  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

Alexandra Maria Galvão Ribeiro

Internship(s)

NAO

Bibliography

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.