Industrial Engineering and Management
INTRODUCTION TO COMPUTER PROGRAMMING
Description
Laboratory
4
Instructors
Paula Correia Tavares
Contents
1 - Excel Spreadsheet
1.1- Basic Concepts, Conditional and Automatic Formatting
1.2- Functions and Formulas
1.3- Sort functions, Filters, Series, Graphics
1.4- Search and Reference Functions
1.5- Data Validation, Pivot Tables, Matrix Formulas
1.6- Introduction to Macros and VBA
2 - Introduction to Programming in VBA
2.1- The IDE "EXCEL+VBA": objects, I/O operations
2.2- Problems analysis and program development: data structure, algorithm and program
2.3- Data Types and Variables
2.4- Operators and Expressions
2.5- Flow control structures: conditional and repetitive
2.6- Functions and Subroutines
2.7- Indexed structures: arrays
2.8- Forms and Graphic Controls
3 - PowerBI Tool
3.1 - Basic Concepts
3.2 - Introduction to PowerBI Usage
Learning Outcomes
An approved student will be able to recognize problems, identify and describe requirements related to the operation of a computational system.
The student will be able to interpret, summarize and compare several solutions and he will be able to design algorithms applying appropriate programming methodologies: analyze, adapt and apply existing programs and develop new programs, coded in VBA.
With tools, like Excel and PowerBI, students will be able to enumerate their main features and advantages, distinguish the various features and use them conveniently.
More specifically they should:
CO1. Understand and apply some of the features of Excel.
CO2. Understand and develop algorithms and VBA programs.
CO3. Understand existing VBA programs and adapt them to new requirements.
CO4. Report data between Excel and VBA, and vice versa.
CO5. Understand and develop programs with a graphical interface (VBA).
CO6. Understand and apply some of the features of PowerBI