Numerical Methods and Programming

Base Knowledge

Mathematics of secondary school.

Teaching Methodologies

Direct individualized study:

1 –  Resolution of exercises

2 –  Practical assignments on spreadsheets

3 –  Programming of functions and procedures

Learning Results

The purpose of this course is to promote, in the student that successfully completes it, the competencies listed below. As a result of the learning process, the student: 1. Knows the concepts of both matrix and determinant and their applications for solving linear systems; 2. Uses numerical analysis techniques, to find zeros of functions and uses polynomial interpolation; 3. Uses structured programming and object-oriented languages; 4. Uses the main office software tools.

Program

Competence 1: 1.1. Matrices; 1.2. Determinants; 1.3. Linear systems.

Competence 2: 2.1. Zeros of functions; 2.2. Polynomial interpolation.

Competence 3: 3.1. Systems of treatment of information.

Competence 4: 4.1. Programming functions; 4.2. Programming procedures.

Competence 5: 5.1. Word processing; 5.2. Spreadsheet; 5.3 Other information technology.

Curricular Unit Teachers

Grading Methods

Avaliação Por Exame
  • - Exame - 100.0%
Avaliação Contínua
  • - Trabalho de processamento de texto - 10.0%
  • - Teste 2 - 55.0%
  • - Teste 1 - 35.0%

Internship(s)

NAO

Bibliography

Support materials for the Curricular Unit available on the inforStudent platform (https://inforestudante.ipc.pt)

Cabral, Isabel, Saiago, Carlos e Perdigão, Cecı́lia. Álgebra Linear: Teoria, Exercícios Resolvidos e Exercícios Propostos com Soluções. Escolar Editora, 2018. ISBN: 978-9725925386

Lay, David, McDonald, Judi e Lay, Steven. Álgebra Linear e suas Aplicações. LTC – Livros Tecnicos e Cientificos, 2013. ISBN: 9788521634959

Pina, Heitor. Métodos Numéricos. Escolar Editora, 2010. ISBN: 978-9725922842

Walkenbach, John. Excel 2016 Bible. Wiley Publishing, 2015. ISBN: 978-1119-067511

Kusleika, Michael. Excel 2016 Power Programming with VBA. John Wiley & Sons Inc, 2016. ISBN 9781119067726

Lambert, Joan. Microsoft Word 2016 Step by Step. Microsoft Press, 2015. ISBN 978-0735697775

Link:

https://support.microsoft.com/