Information Technology and Programming

Logical-Mathematical Knowledge and English Language for reading the bibliography and online support documentation.

• Theoretical classes (2 hours / week).

Theoretical classes tend to be expository, but promote the active participation of students, asking questions during the discussion of the topics covered and launching challenges for students to submit their solutions through the online academic platform. From the second topic of the theoretical component of the program, students will also use the computer during the theoretical classes to allow greater experimentation and monitoring of the learning of all the concepts taught.

• Practical classes (2 hours / week).

In practical classes, the knowledge acquired in theoretical classes is applied through the resolution of worksheets. The practical classes will be synchronized so that students apply the concepts after being presented in the theoretical classes.

All students must attend at least 2/3 of the practical classes to have access to the regular and supplementary exams. For students who are workers or have a special status provided by law, confirmed by the information provided by Academic Services, there is no minimum attendance. Students who have access to the special season, when it occurs, are exempt from this minimum frequency.

Students are advised to systematically follow the theoretical classes, an indispensable condition for academic achievement and the correct understanding of the subjects. In practical classes, it is not intended to repeat what was taught in the theoretical class, that is, the introduction of the demonstrated concepts.

Goals:

• Provide students with base concepts on Information Technologies.
• Introduce them with programming concepts to implement autonomous and reusable procedures for solving simple engineering problems.
• Transmit the knowledge necessary for the effective use of productivity applications used in the engineering context, in particular the handling of spreadsheets.

Generic skills:

• Application of knowledge.
• Acquire programming concepts and become an efficient user of the main tools used in the day-to-day work of an Industrial Engineer and Manager.

Specific Skills:

• Self-learning programming practice to carry out the exercises on the practice sheets and programming challenges.

• In the specific case of macros and spreadsheet applications, using them in an advanced way to solve engineering problems.

Theoretical component
1. Introduction:
Algorithms. Steps to computationally solve a problem. Construction of algorithms pseudo-code. Elementary concepts. Constants, variables, operators and arithmetic expressions. Arrays. Data Input/Output. Modularisation. Types of Procedures. Arguments. Decision and Repetition Flow Control. Algorithm testing. Computers: architecture and operation. Languages: from machine to user, different paradigms.

2. Programming in Visual Basic for Applications (VBA):
Integrated Development Environment (IDE). Programming concepts covered generically in the previous topic applied to this programming language. Variables, operators and arithmetic expressions. Arrays. Message Boxes. Input Boxes. Modularisation and Macros. Subroutines vs. Functions. Arguments. Passing arguments by Reference or by Value. Decision and Repetition Flow Control. Library functions (Text, Conversions, Date / Time, Validation, Formatting). Error Handling. Excel Objects: Hierarchy and Collections. Properties, Methods, and Events. Selection of objects. Iterating over a collection of objects.

3. Programming in Python:

Integrated Development Environment (IDE). Programming concepts are covered generically in the first topic applied to this programming language. Arrays. Data Input/Output. Modularisation. Decision and Repetition Flow Control. Integrating Python with Excel. User Defined Function (UDF).

Practical component:

1. Advanced MS Excel:
MS Excel Environment. Workbooks, worksheets and cells. Formulas and functions. Relative and absolute references. Name management. Graphics and tables. Conditional formatting. Sorting and filtering data. Data validation and protection. Data import.

2. VBA Programming:

Recording and programming command macros. Programming function macros. Decision and repetition structures. Programming subroutines. Excel objects. Use of library functions.

3. Python Programming:

IDE Setup. Developing and running Python programs. Data Input/Output. Integrating Python with Excel. Manipulating Excel objects in Python. User Defined Functions (UDF)

NAO