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) Lead Professor
(2) Teaching Professor
Prerequisites
Not applicable
Objectives
To develop competences in the use of computational tools for solving problems in Chemical Technology. Students are expected to acquire basic knowledge of algorithms and develop skills in using MS Excel and MATLAB for data processing, calculations, graphical representation, and the development of computational solutions applied to Chemical Technology.
Program
1. Introduction to digital systems: concepts and definitions. Strategy and planning. Algorithms.
2. Introduction to and use of MS Excel in technology problems. Features and application areas. Basic concepts: workbook, worksheet and cell. Spreadsheet structure and working environment. Basic features and operations. Data and spreadsheet formatting. Conditional formatting. Creation and formatting of charts. Formulas, functions, operators and references.
3. MATLAB. Working environment. Commands, expressions, variables and functions. Vectors and matrices. Matrix calculation functions. 2D and 3D plots. Special plots. Plot formatting. M-files. Data input and output. Scripts. Function development. Operators. Flow control.
4. Applications in Chemical Technology.
Practical Computational Tasks:
I - Chemical Technology calculations and experimental data processing using MS Excel.
II - Calculations and development of modular programs in MathWorks MATLAB for solving Chemical Technology problems.
Evaluation Methodology
Continuous assessment: The final grade is based on an individual written test (30%) and an integrated computational project (70%), developed in five phases using Excel and MATLAB.
Final assessment: The final grade is based on a practical computational assessment (70%) and an individual written test (30%).
Students who attend fewer than two thirds of the mandatory PL classes, or who do not complete the Integrated Project, are excluded from final assessment. In official final assessment periods, practical computational tests account for 100% of the final grade.
Any written or practical assessment, including individual or group assignments, may, whenever there are substantiated doubts regarding the authorship or authenticity of the submitted work, be subject to a complementary assessment, convened by the lecturer for the purpose of clarifying such doubts. Failure to attend this assessment, except for a duly justified reason, or failure to provide the clarification required to confirm the authorship or authenticity of the assessed material may result in a revision of the grade awarded, including the total or partial disregard of elements whose authorship or authenticity has not been demonstrated. The grade resulting from the complementary assessment shall prevail, in respect of the elements covered by it, for the purposes of the final grade.
Bibliography
- Chapman, S. (2008). MATLAB Programming for Engineers. Toronto: Thomson Learning
- Hanselman, D. e Littlefield, B. (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
T classes introduce the main concepts and demonstrate their application. In PL classes, students solve Chemical Technology problems using MS Excel and MATLAB.
Software used in class
MS Excel
Mathworks Matlab
