Electrical Engineering - Power Systems
COMPUTATIONAL CALCULUS
Description
Laboratory
3
Instructors
José Marinho
Contents
1. Excel Spreadsheet
1.1. Advanced Functions and Formulas
1.2. Lookup and Reference Functions
1.3. Pivot Tables and Charts, Array Formulas
1.4. Introduction to Macros and VBA
2. Introduction to VBA Programming
2.1. Structure of a VBA Program
2.2. Data Types, Variables, Operators, Expressions
2.3. Flow Control Structures: Conditional and Repetitive
2.4. Functions and Subroutines
2.5. Indexed Structures: Arrays
3. Introduction to Programming in MatLab/Octave
3.1. MatLab/Octave Functions
3.2. Matrix Operations
3.3. Programming in MatLab/Octave
3.4. Adding New Functions to MatLab/Octave via Programming
Learning Outcomes
The overall educational objective of Cálculo Computacional is to develop skills in the use of computer applications for analysis, representation and relationship of information.
The specific educational objectives of Computational Calculation are:
- Represent and relate information in a spreadsheet (OB1).
- Process spreadsheet data to extract specific information aligned with analysis requirements (OB2).
- Understand and develop programs in VBA and Matlab/Octave (OB3).
- Matrix programming in Matlab/Octave using specific functions (OB4).
- Extend application functionalities using proprietary programming languages (OB5).
- Link data between Excel and VBA/Matlab/Octave (OB6).
- Research, analyze, and interpret relevant information from the Web for the subject and course, including the use of AI when appropriate (OB7).