Description

Theory/Practice
1

Laboratory
2

Instructors

Nuno Filipe Malheiro

Contents

CP1 - Excel Spreadsheet (60%)
1.1-Basic Concepts, Conditional and Automatic Formatting
1.2-Functions and Formulas
1.3-Order functions, Filters, Series, Graphics
1.4-Search and Reference Functions
1.5-Data Validation, Pivot Tables
1.6-Introduction to Macros and VBA

CP2 - Functional programming development (40%)
2.1-LAMBDA concept
2.2-LAMBDA & LET usage
2.3-The integrated development environment: Advanced Formula Environment
2.4-Advanced functions using LAMBDAS
2.4.1-MAP
2.4.2-FILTER
2.4.3-SCAN
2.4.4-REDUCE
2.5-Recursive algorithms using LAMBDAS

Learning Outcomes

CO1 - Apply scientific calculation tools, suitable for computationally resolving problems related to the course.
CO2 - Analyse problems, aiming at their resolution using computational resources.
CO3 - Create new functionalities, suitable for solving specific problems.