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
The course aims to develop the necessary skills for the production of an IT project in the chemical technology area, using Excel spreadsheet and Matlab software. The students should be able to develop IT projects required for the numerical solution of common problems in chemical technology field.
Program
1. lntroduction to digital systems: concepts and definitions. Strategy and Planning (algorithms).
2. lntroduction and use of MS Excel in technology issues. Features and application areas. Basic concepts: book, sheet and cell. MS Excel spreadsheet structure. Desktop. Toolbar, and trim tabs. Features and basic operations. Formatting variables and spreadsheet. Conditional formatting. Construction and formatting charts. Formulas, functions, operators, and references.
3. MATLAB . Command window, expressions, variables and functions. Vectors and matrices. Matrix calculation functions. 2D and 3D graphics. Special graphics: histograms, bars, slices and functions. Graphic formatting. M-files. Data input and output. Scripts. Development of functions. Operators. Flow control.
4. Applications in chemical technology.
Evaluation Methodology
Bibliography
- Chapman, S. (2008). MATLAB Programming for Engineers. Toronto: Thomson Learning
- Hanselman, D. e Littlefield, B. (2001). Mastering Matlab 6 -A Comprehensive Tutorial and Reference. New Jersey: Prentice-Hall
- Sousa, M. (2011). Fundamental do Excel 2010. Lisboa: FCA -Editora de Informática
- Walkenbach, J. (2010). Microsoft Office Exce/ 2010 Bible. Indianapolis: Wiley Publishing
Teaching Method
During the 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 exercises provided
Software used in class
MS Excel
Mathworks Matlab
