Lecture I
30/9/2008

Solving equations

·  Function graphing

·  Mid-point rule

·  Goal Seek and Solver

Handout-1.pdf

references:

·  Graphing Functions in Excel

·  Bisection method

·  Goal Seek and Solver in Microsoft Excel 2003

Coursework-1
hand-in date:
14/10/2008

Marking criteria

Lecture II
7/10/2008

Matrix operations

·  Matrix manipulations: matrices and arrays

·  Solving simultaneous linear equations

·  Writing VBA matrix functions

Handout-2.pdf

references:

·  Matrix Operations in Excel

·  Writing Your First VBA Function in Excel

·  Creating and Managing Array in VBA

·  Loop Structures in VBA

Coursework-2
hand-in date:
21/10/2008

Marking criteria

Lecture III
14/10/2008

Power series and
iterative solution of equations

Handout-3.pdf

references:

·  Writing Your First VBA Function in Excel

Coursework-3
hand-in date:
28/10/2008

The following discussion forum,
Estimating Trigonometry Function,
provides useful information for
problem 1 in the coursework.

Marking criteria

Solutions

Lecture IV
21/10/2008

Numerical integration

Handout-4.pdf

No coursework, the
three courseworks
are evenly weighted.

Laura Ferns
Benjamin Adams
Olivier Lesnicki
Lindah Ireri
Nuno Palma
Matthew Freeman
Nisim Shushan
Charlie Knight
Xiaoxue Wang
Michael Walher

Muhammedanas Ahmed
Hamid Aria
Asif Asrar
Wei Bai
Fazal Bariali
Francis Robertson
Yu Wu