MA0276 - Visual Basic Programming for OR
Catalogue Entry
This module assumes knowledge of the basic concepts of spreadsheets and how they can be used to manipulate information. It then builds on this to cover the automation of tasks using macros and the use of Visual Basic programming within Microsoft Excel, thus enabling the construction of customised, user-friendly interfaces for a spreadsheet. A variety of Operational Research problems are used as the basis for this module, although no prior knowledge of OR is required.
Topics covered include simulation, logical programming ideas and debugging. This module can be taken successfully by any student who is prepared to learn the basics of computer programming, and who wishes to learn some practical problem solving skills which may be of benefit in future employment.
Semester
Spring
Lecturer
Recommended Books
There is no recommended text book for this module - full lecture handouts are supplied.
However, the following book, available in the Senghennydd Library, is recommended as additional reading for this module:-
Boonin E, Using Excel Visual Basic for applications (Indianapolis) QA76.73.B3.B6