Numerical Methods and Programming

Code:

EQ0065

Acronym:

PMN

Keywords
Classification	Keyword
OFICIAL	Physical Sciences (Mathematics)

Instance: 2013/2014 - 2S (of 01-09-2013 to 31-07-2014)

Active?	Yes
Responsible unit:	Department of Chemical Engineering
Course/CS Responsible:	Master in Chemical Engineering

Cycles of Study/Courses

Acronym	No. of Students	Study Plan	Curricular Years	Credits UCN	Credits ECTS	Contact hours	Total Time
MIEQ	116	Syllabus	1	-	6	70	162

Teaching language

Portuguese

Objectives

The course on Programming and Numerical Methods has two main objectives:

I. Introduction to Computer Programming

To obtain a perspective of the importance of using computing for solving Chemical Engineering problems, in particular in the development of concepts and methodologies for computer programming using Visual Basic for Applications (VBA).

II. Introduction to Numerical Methods

To acquire the fundamentals of relevant numerical methods in Chemical Engineering, namely the application of different numerical methods for problem solving, using spreadsheets and VBA programming.

Learning outcomes and competences

Students must be capable of:

• To recognize digital systems equipments and the specific technical terms used in this subject.
• To implement algorithms, develop procedures and codify in VBA.
• To implement problem solutions using different numerical methods using both spreadsheets and VBA programming.
• To understand the advantages and disadvantages in the use of alternative numerical methods.
•  To recognize the importance of error estimates and use error criteria.

Working method

Presencial

Pre-requirements (prior knowledge) and co-requirements (common knowledge)

Not applicable.

Program

I. Introduction to Computer Programming

• Introduction to digital systems: concepts and definition
• Data representatio
• Use of MS Excel in engineering problems
• Programming with Visual Basic for Applications (VBA)
• Constants, variables and expressions
• Intrinsic functions
• Data input and output
• Conditional and cycle structures
• Indexed variables
• External functions

II. Introduction to Numerical Method

• Approximation and errors
• Non-linear equations
• Systems of linear and non-linear equations
• Differentiation and Integration

 

Mandatory literature

Chapra, Steven C.; Numerical methods for engineers. ISBN: 0-07-112180-3
M.M. Dias; Introdução à Programação com VBA , 2004/2005

Complementary Bibliography

Chapra, Steven C.; Power programming with VBA/Excel. ISBN: 0-13-047377-4

Teaching methods and learning activities

TP - Theoretical-practical classes of 90+90 minutes for presentation of the main concepts.

L - Laboratory classes o 180 minutes in computer rooms.

Software

Microsoft Office

Evaluation Type

Distributed evaluation with final exam

Assessment Components

Designation	Weight (%)
Participação presencial	0,00
Teste	100,00
Total:	100,00

Eligibility for exams

Obtaining frequency for regular students depends on not exceeding a maximum of 3 laboratory class misses. Students with frequency from previous years do not need to attend classes. Students who wish to attend must obey the above rules.

Calculation formula of final grade

Final grade is based on the following items:

• T1 - Test #1: to be done during a T class; max 150 minutes; Excel+VBA
• T2 - Test #2: to be done during the exams weeks*; max 150 minutes; MN+(Excel+VBA)
• EF – Final Exam: to be done during the exams weeks*; max 180 minutes; MN+Excel+VBA
• ER – Recourse Exam: to be done during the exams weeks; max 180 minutes; MN+Excel+VBA

* T2 and EF are done at the same time; students choose test/exam at that time

• MT - MiniTests: to be done during T classes; maximum 10 MTs; each MT is worth 0,1 points

Final Grade:

CF = 0,5 * T1 + 0,5 * T2 + MT or CF = EF + MT ou CF = ER + MT

Note: CF can not be higher than 20.

 

Examinations or Special Assignments

Not applicable

Special assessment (TE, DA, ...)

An exam at the corresponding seasons.

Classification improvement

An exam at Recurso season