VBA Assessment 1 – Due Week 6 (7 March)

Hopefully I have designed something in which you can take your time, get things right, get some good marks, and show off what you can do. You are advised to complete VBA Lab 3 first. 

I recommend watching the Week 5 lectures, but perhaps it might suit students to complete VBA Assessment 1 before looking at Lab 4 and Week 5 Exercises. Do not let VBA Assessment slide very late as you will need time to prepare for Written Assessment 1. Really you should be looking to complete VBA Assessment 1 a few days before the due date. There will be no lab in Week 6 in order to give you more time.

Written Assessment 1 – Week 7

25% Written Assessment 1, based on Weeks 1-5, so everything up to p.73.

It will be a one hour assessment, but I am going to give ye 15 minutes grace, as well as 15 minutes to upload. The test will run therefore from 09.30 to 11.00, Tuesday 9 March. It is open book — you can use your manual, any Canvas materials, as well as Excel/VBA.

40% of the marks will be numerical methods (Euler, TTT, Heun); finding approximations like p.34, Q.1-3, p.37, Q.1-3, p.48, Q.1-4 (non-Excel parts of Q.4), p.60, Q.4-7.

30% of the marks will be numerical analysis; understanding these methods and their errors like p.34, Q. 4, p.38, Q.4-6. p.49, Q.5-8

15% will be neither; like p.17, Q. 1-2, p.40, Q.1-3, p.60, Q.1-3

15% will be Runge-Kutta, like p.72, Q.1-2.

More information about practicalities in Week 6.

Week 5


There are 82 minutes of lectures. You could schedule about 2 hours to watch them and take the notes in your manual. You might need this extra time above 82 minutes because you will want to pause me. You should also take note of any confusions you have to ask about in the regular Q & A.

Lab 4

Lab 4 may not be up until 18 February, and can be attempted after watching the lectures above (submission not live until 20 February).

Theory Exercises and Q & A

p.60, Q.1-7

p.72, Q.1-3

Q & A to ask about Theory Exercises or anything else every Tuesday 12.30 (waiting room open 12.25).

Week 6

We will look at boundary value problems (in particular the Shooting Method and Goal Seek).

There will be no lab in order to give you time to complete VBA Assessment 1.


This is provisional and subject to change.

  1. Week 6, 25% First VBA Assessment, Based (roughly) on Weeks 1-4
  2. Week 7, 25 % In-Class Written Test, Based (roughly) on Weeks 1-5
  3. Week 11, 25% Second VBA Assessment, Based (roughly) on Weeks 6-9
  4. Week 12, 25% Written Assessment(s), Based on Weeks 6-11


Study should consist of

  • doing exercises from the notes
  • completing VBA exercises

Student Resources

Please see Student Resources  for information on the Academic Learning Centre, etc..