Computer Applications
Code: 102397 ECTS Credits: 6| Degree | Type | Year | Semester |
|---|---|---|---|
| 2500897 Chemical Engineering | FB | 2 | 1 |
Contact
- Name:
- Fco. J Guerrero Camacho
- Email:
- FranciscoJavier.Guerrero@uab.cat
Use of Languages
- Principal working language:
- catalan (cat)
- Some groups entirely in English:
- No
- Some groups entirely in Catalan:
- Yes
- Some groups entirely in Spanish:
- No
Teachers
- Joan Albiol Sala
- Sergio Fornes Albert
- Julio Octavio Pérez Cañestro
Prerequisites
It is advisable to have basic math knowledge to successfully completed Linear Algebra and Calculus I courses.
Objectives and Contextualisation
Objectives and Contextualisation
The main aim of this course is to train the students in developing a basic understanding about computer science:
- Acquiring notions of using MS Excel and Matlab software to solve Chemical Engineering problems.
- Acquiring notions of numerical methods fundamentals to solve Chemical Engineering problems.
Skills
Apply acquired knowledge to solve common Chemical Engineering problems by using MS Excel and Matlab software. More in detail:
- Achieve practical knowledge in the application of MS Excel for solving Chemical Engineering problems.
- Achieve practical knowledge in MATLAB programming for solving Chemical Engineering problems.
- Achieve basic notions of most elementary numerical methods for solving Chemical Engineering problems.
Competences
- Demonstrate basic knowledge of the use and programming of computers, and apply the applicable IT resources to chemical engineering.
- Develop personal attitude.
- Develop personal work habits.
Learning Outcomes
- Apply the most basic numerical methods to solve chemical engineering problems.
- Describe the limitations of computers as digitally programmable systems.
- Develop independent learning strategies.
- Maintain a proactive and dynamic attitude with regard to one’s own professional career, personal growth and continuing education. Have the will to overcome difficulties.
- Manage available time and resources. Work in an organised manner.
- Prevent and solve problems.
- Use spreadsheets and numerical programming environments to solve chemical engineering problems.
- Work autonomously.
Content
Students will be able to access to all learning content through Moodle platform.
Unit 1 Microsoft Excel. Applications to Chemical Engineering problems
1.1. Software working environment. Basic operators and formulae
1.2. Preprogramed functions in Excel
1.3. Graphical representations and regressions
1.4. Logical statements
1.5. Vectors and matrices
1.6 Numerical integration and derivation
1.7. MS Excel tools and complements: Solver
Unit 2 MATLAB. Programming language
2.1. Introduction and MATLAB characteristics
2.2. Operators with different variables, vectors and matrices.
2.3. Commands files and functions
2.4. Basic statements for programming in MATLAB: for … end, while …end, if…elseif….else…end
2.5. Graphs
2.6. Polynomial operators
2.7 Solving lineal and non-lineal systems of equations
2.8 Approximation and interpolation
2.9 Derivation and integration
2.10 Solving ordinary differential equations
It must be noted that the course program could be modified (reducing o prioritizing key content) depending on the adaptations and evolution of the working conditions imposed by the University/school due to COVID19. Any major change would be notified through Virtual Campus.
Methodology
The course structure is:
a) Theory classes where basical concepts and methods fundamentals are explained. Theses classes will be done in virtual format duet to Health authorities’ requirements. During the weekend before to theory classes, all the content will be explained in a video with the purpose of using the class itself to solve or clarify possible doubts.
b) Practical Classes (with computers) where theoretical concepts are developed through solving different problems by using MS Excel and Matlab. Theses classes will be also done in virtual format duet to Health authorities’ requirements.
The proposed teaching methodology may experience some modifications depending on the restrictions to face-to-face activities enforced by health authorities.
Activities
| Title | Hours | ECTS | Learning Outcomes |
|---|---|---|---|
| Type: Directed | |||
| Practical classes with computer | 36 | 1.44 | 1, 7 |
| Theoretical classes | 12 | 0.48 | 1, 2, 7 |
| Type: Autonomous | |||
| Autonomous computer practise | 70 | 2.8 | 1, 7 |
| Autonomous study | 23 | 0.92 | 1, 2, 7 |
Assessment
Different practical exercises will done along the academic year that must be submited at the of the class. If the exercicies marked as mandatory are not submited before the deadline, there will be a penalty for those students that are matriculated for the first time.
To pass de course it is mandatory to obtain an averaged mark less than 5.0/10 in the continued evaluation. If final mark is below 5.0/10, it is possible to pass de course by doing a test that includes all the academic contents and that is equal to the percentage of partial tests. To access to second-chance examination it is necessary that students have been evaluated in two thirds of total qualification tests. Thus, students that have not been evaluated more than 67% of total evaluative activities will get “Not evaluated” mark.
10% assistance mark will only be taken into account if averaged mark from partial tests are not less than 4.5/10.
High honours mark will be obtained with a final qualification not less than 9.0/10 and not over 5% of total matriculated students.
Notwithstanding anything to other disciplinary measures, those students that incur in different irregularities such as copy, plagiarism, allowing copying and so on., will obtain a 0 mark in the continued evaluation. If those irregularities are detected during second chance test, the academic course will be directly suspended.
Student’s assessment may experience some modifications depending on the restrictions to face-to-face activities enforced by health authorities.
Assessment Activities
| Title | Weighting | Hours | ECTS | Learning Outcomes |
|---|---|---|---|---|
| Partial test 1 | 20% | 3 | 0.12 | 1, 2, 5, 6, 8, 7 |
| Partial test 2 | 35% | 3 | 0.12 | 1, 2, 5, 6, 8, 7 |
| Partial test 3 | 35% | 3 | 0.12 | 1, 2, 5, 6, 8, 7 |
| Submission of obligatory exercises | 10% | 0 | 0 | 1, 2, 3, 5, 4, 6, 8, 7 |
Bibliography
Basic bibliography
1. Excel 2007- La biblia- John Walkenbach. Anaya Multimedia ISBN: 8441522114 84-415-2211-4
2. Resolución de problemas de Ingeniería Química y Bioquímica con Polymath, Excel y Matlab. M.B. Cutlip y M. Shacham. Pearson Educación S.A. Madrid. 2008. ISBN: 978-84-8322-461-8.
3. Matlab con aplicaciones a la ingeniería, física y finanzas. David Lopez Bàez. (2008) ISBN: 978-970-15-1137-4.
4. Métodos numéricos para ingenieros. Steven C. Chapra & Raymond P. Canale. Ed. (2003) McGrwHill. ISBN: 970-10-3965-3
Complemmentary bibliography
1. Matlab. An introduction with applications. Amos Gilat (2008) ISBN 978-0-470-10877-2
2. Essential MATLAB for Engineers and Scientists. Brian D. Hahn & Daniel T. Valentine. (2007) Elsevier. ISBN 13: 9-78-0-75-068417-0
3. Numerical Methods. Germund Dahlquist & Ake Bjorck. Prentice-Hall series in automatic computation. ISBN 0-13-627315.7.1974
Links
http://www.mathworks.es/academia/student_center/tutorials/
http://office.microsoft.com/es-hn/training/default.aspx
http://www.mathworks.es/matlabcentral/
http://www.mathworks.es/academia/student_center/tutorials/