Information Technology and Programming

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

Lectures (2 hours / week). Practical classes (2 hours / week). The lectures are expository but tend to promote the active participation of students, by asking and answering questions about the topics being exposed. In practical classes, the knowledge acquired in lectures is applied by solving proposed exercises.

The evaluation consists of a written exam (given in the respective periods or in phases during the semester), a practical test on the computer lab about Advanced Excel and a Working project about Programming and Excel implement extra classes. Specifically: The exam worth 12 values of the final grade (60%); The practical test worth 4 values of the final grade (20%) and the Working project 8 values (20%). These values (excepting the exam) are distributed along a continuous evaluation over a semester.

Goals: Provide students with base concepts on Information Technologies. Introduce them with programming concepts in order to implement autonomous and reusable procedures for solving simple problems of engineering. Presenting some productivity applications used in the Engineering context.
Generic skills: Application of knowledge. Self-learning mode on implementing a working project.
Specific Skills: Introducing main concepts on communication and information technology; Presenting some productivity applications used in the Engineering context, such as: text, presentation and worksheet processing; Ability to create and develop spreadsheets and forms to automatize tasks. Thus, the following outcomes are expected to be learned: Identify, classify and understand the main subjects related to Information Technology; Ability to use the main everyday tools for an Industrial Engineer.

1 Introduction to Programming: Construction of algorithms. Elementary concepts. Constants, variables, operators and arithmetic expressions. Arrays. Modularization. Types of Procedures. Passing arguments by reference and by value. Decision and Repetition Flow Control.
2 Programming in Visual Basic: Types of data. Concepts covered generically in the previous topic applied in this programming language. Passing arguments by Reference and by Value. Library functions (Text, Conversions, Date / Time, Validation, Formatting). Error Handling. Message Boxes.
3 Visual Basic for Applications (VBA): Interface objects. Excel Objects: Hierarchy and Collections. Properties, Methods, and Events. Forms and Controls. Access to online services.
Lab Classes
I – Worksheet Processing: MS Excel Environment and Worksheets, Workbooks and Cells. Fomula and Functions. Graphs and Tables. Sorting and filtering data. Document and range protecting. Data import.
II -Programming em VBA.

NAO