Numerical Methods and Programming

Mathematics of secondary school.

Direct individualized study:

1 –  Resolution of exercises

2 –  Practical assignments on spreadsheets

3 –  Programming of functions and procedures

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.

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.

Continuous assessment

Test T1 (weight of 40%):

Matrices, Determinants and Linear systems: 25%

Spreadsheet in MS Excel: 15%

Test T2 (weight of 50%):

Zeros of functions: 12%

Polynomial interpolation: 12%

Spreadsheet in MS Excel: 15%

Visual Basic for Applications: 11%

Word processing (weight of 10%)

The final classification (on a scale of 0 to 20) results from the weighted average of the evaluation of the three components mentioned above, 0,40xT1+0,50xT2+0,10xW, rounded to two decimal places.

The student is approved if the weighted average is equal to or higher than 9,50 points. If the students achieve a weighted average of at least 8,0 points, they may be given the opportunity to answer a question, either orally or in writing, in an attempt to reach the minimum passing grade of 9,5 points.

Assessment by final exam

Assessment with only one written test with a weight of 100%.

The student is approved if the score on the written test is equal to or higher than 9,50 points. If the students achieve a score of at least 8,0 points, they may be given the opportunity to answer a question, either orally or in writing, in an attempt to reach the minimum passing grade of 9,5 points.

Note: The alternatives for specific situations provided for in the law will comply with what is provided for in the "Regulamento Académico do 1º ciclo de estudos da Escola Superior Agrária de Coimbra".

NAO