Numerical Methods and Programming

Code:

EQ0065

Acronym:

PMN

Keywords
Classification	Keyword
OFICIAL	Physical Sciences (Mathematics)

Instance: 2012/2013 - 2S

Active?	Yes
Responsible unit:	Department of Chemical and Biological 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	115	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 definitions
• Data representation
• 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 Methods

• 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

Description	Type	Time (hours)	Weight (%)	End date
Attendance (estimated)	Participação presencial	85,00	0,00
Test T1	Teste		50,00
Test T2 / Final Exam	Teste		50,00
	Total:	-	100,00

Eligibility for exams

Obtaining frequency for regular students depends on:

• Maximum of 3 laboratory class misses
• At least 7 MTs done in TP classes

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 TP 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 wish test/exam to take at that time

Final Grade for students who are attending to classes:

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

Final Grade for students who are not attending to classes:

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

 

Examinations or Special Assignments

Not applicable

Special assessment (TE, DA, ...)

An exam at the corresponding seasons.

Classification improvement

An exam at Recurso season