1B40 COMPUTING: WEEK 9 Department of Physics & Astronomy, University College London

All work should be completed in the session for which it is set. Work carried over for marking in the following week will only receive half the credit. Note that the session ends at 5:30pm, and work should be marked by this time.

This week you should complete the following task:

• VBA task 3 (writing function procedures)

For the exercises in this task you need to write some Function procedures to carry out three-dimensional vector operations, such as scalar product, vector product and magnitude.  You then use these basic building blocks in slightly more complex problems.

This week's lecture covered controlling flow, and input/output and messages in VBA.