Publication in the Diário da República: Despacho n.º 15239/2016 - 19/12/2016
4.5 ECTS; 1º Ano, 1º Semestre, 30,0 T + 30,0 PL , Cód. 81423.
Lecturer
- José Manuel Quelhas Antunes (1)(2)
(1) Docente Responsável
(2) Docente que lecciona
Prerequisites
Not applicable
Objectives
To develop the necessary skills for the production of an IT project in the chemical technology area, using Excel spreadsheet and Matlab software. To implement IT projects required for the numerical solution of common problems in the field of chemical technology.
Program
1. Introduction to Digital Systems: concepts and definitions. Strategy and Planning (algorithms).
2. Introduction and use of MS Excel in technology problems. Features and application areas. Basic concepts: Book, leaf and cell notion. Structure of the MS Excel spreadsheet. Work environment. Toolbar, ribbon, and separators. Basic features and operations. Formatting variables and spreadsheet. Conditional formatting. Construction and formatting of graphics. Formulas, functions, operators, and references.
3. MATLAB. Work environment. Commands, expressions, variables, and functions. Vectors and arrays. Matrix calculation functions. 2D and 3D Graphics. Special graphs: histograms, bars, slices and functions. Graphics formatting. M-Files. Data input and output. Scripts. Development of functions. Operators. Flow control.
4. Applications in the field of chemical technology.
Computational Practical tasks:
I-Calculations in chemical technology and Treatment of experimental data with MS Excel
II-Calculations and creation of modular programs in Mathworks Matlab to solve problems of chemical technology.
Evaluation Methodology
Continuous Assessment: Conducted through two practical computational tasks carried out during the semester. The final grade in continuous assessment is obtained by weighting the results of the practical tasks, with Task I accounting for 20% and Task II for 80%. Students who fail to attend at least two-thirds of the mandatory PL classes, as stipulated by the current Academic Regulations, will be excluded from the final assessment. In the different official exam periods, practical computational tests will be administered, weighted at 100%.
Bibliography
- Chapman, S. (2008). MATLAB Programming for Engineers. Toronto: Thomson Learning
- Littlefield, B. e Hanselman, D. (2011). Mastering Matlab 8 -A Comprehensive Tutorial and Reference. New Jersey: Prentice-Hall
- Sousa, M. (2011). Fundamental do Excel 2010. Lisboa: FCA -Editora de Informática
- Walkenbach, J. (2018). Microsoft Office Exce/ 2019 Bible. Indianapolis: Wiley Publishing
Teaching Method
In lectures the main concepts are explained, demonstrating the application of these whenever possible. ln practical classes are proposed, in coordination with the evolution of the lectures, the resolution by the students of provided exercises.
Software used in class
MS Excel
Mathworks Matlab
