Base Knowledge
Logical-Mathematical Knowledge and English Language for reading the bibliography and online support documentation.
Teaching Methodologies
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.
Learning Results
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:
- Presenting some productivity applications used in the Engineering context, such as spreadsheet processing.
- Ability to create and develop spreadsheets and forms to automatize tasks.
- Ability to use the main everyday tools for an Industrial Engineer.
Program
Theoretical component
1 Introduction to Programming:
Algorithms. Steps to computationally solve a problem. Construction of algorithms pseudo-code. Elementary concepts. Constants, variables, operators and arithmetic expressions. Arrays. Modularisation. Types of Procedures. Arguments. Decision and Repetition Flow Control.
2 Programming in Visual Basic:
Data types. Concepts covered generically in the previous topic applied to this programming language. Variables, operators and arithmetic expressions. Arrays. Message Boxes. Input Boxes. Modularisation. Subroutines vs. Functions. Arguments. Passing arguments by Reference or by Value. Library functions (Text, Conversions, Date / Time, Validation, Formatting). Error Handling.
3 Visual Basic for Applications (VBA):
Interface objects. Excel Objects: Hierarchy and Collections. Properties, Methods, and Events. Selection of objects. Iterating over a collection of objects. Forms and Controls. Advanced techniques to access and visualise information.
Practical component
1 – Advanced MS Excel:
- MS Excel Environment.
- Worksheets, Workbooks and Cells.
- Formulas and Functions.
- Graphics and Tables.
- Sorting and filtering data.
- Document and range protecting.
- Data import.
2 – VBA Programming:
- Recording and programming command macros.
- Relative and absolute references.
- Programming function macros.
- Decision and repetition structures.
- Programming subroutines.
- Excel and interface objects.
- Use of library functions.
- Creating forms.
Curricular Unit Teachers
Internship(s)
NAO
Bibliography
Suggested:
- Liluyoud Cury de Lacerda, José Marcio Benite Ramos, Sara Luize Oliveira Duarte. Lógica de programação. Ed. UFMT. Available online.
- Almeida, Paula de Fátima Peres Teixeira. Excel: macros e aplicações. Edições Sílabo. ISBN 978-972-618-457-7
- Notes and material are made available by teachers on the online academic platform.
Additional:
- Carvalho, Adelaide. Exercícios resolvidos com Excel para economia & gestão. FCA Editora. ISBN 972-722-472-5
- Alexander, Michael & Kusleika, Dick. Excel 2019 Power Programming with VBA. Wiley. ISBN 978-111-951-492-3
- Carvalho, Adelaide. Automatização em Excel: 69 exercícios. FCA Editora. ISBN 978-972-722-872-0