Description

Theory
2

Laboratory
2

Instructors

José Marinho

Contents

1. Excel Spreadsheet
1.1. Advanced Functions and Formulas
1.2. Lookup and Reference Functions
1.3. Pivot Tables, Charts, and Array Formulas
1.4. Introduction to Macros and VBA

2. Introduction to Programming in VBA
2.1. Algorithms
2.1.1. Problem analysis: Data, Algorithm, and Program
2.1.2. Structuring and designing solutions via Flowcharts
2.1.3. Visual Programming with Blocks
2.2. Structure of a VBA Program
2.2.1. Data Types, Variables, Operators, Expressions
2.2.2. Flow control structures: Conditional and Iterative
2.2.3. Functions and Subroutines
2.2.4. Indexed Structures: Arrays

3. Introduction to Programming in MatLab/Octave
3.1. MatLab/Octave Functions
3.2. Matrix Operations
3.3. Structured Programming in MatLab/Octave
3.4. Adding New Functions to MatLab/Octave via Programming

Learning Outcomes

A successful student will be able to recognize problems, identify requirements, and describe solutions within a computational context. The student will be able to interpret, summarize, and compare various alternative solutions. They will also be capable of designing simple algorithms by applying appropriate programming methodologies: analyzing, adapting, and applying existing programs, as well as developing new programs coded in VBA/Matlab/Octave.

Regarding calculation tools such as Excel, students will acquire the ability to recognize key features and benefits, differentiate various functionalities and expand them, demonstrate and illustrate their practical application, manipulate and calculate new data, as well as organize, correlate, and evaluate information efficiently.

- Master and effectively utilize the key functionalities of Excel, including advanced functions, lookup and reference tools, dynamic tables and charts (OB1)
- Analyze, design, and implement algorithms and programs in VBA/Matlab/Octave (OB2)
- Characterize each instruction in a program and its overall impact (OB3)
- Understand existing VBA/Matlab/Octave programs and adapt them to new requirements (OB4)
- Connect and integrate data between Excel and VBA/Matlab/Octave (OB5)
- Research, analyze, and interpret relevant information from the Web for this curricular unit and course, including the use of AI when appropriate (OB6)