In BAMS 580D students receive instruction in the use of the latest OR tools and technologies. Students become familiar with commercial software applications commonly used in practice, and learn how to develop OR applications using these products. The curriculum features courses, tutorials, and seminars in the use of software packages including statistical applications, databases, simulation modeling packages, optimization solvers, mathematical modeling languages, and the MS Office Suite with Visual Basic applications.<\/p>\n
A large part of the course is learning to program in Visual Basic for Applications and to use it in conjunction with Excel and Access. To build upon the database content, instruction is also\u00a0 provided in SQL (Structured Query Language) and relational databases.<\/p>\n
All the course activities take place in the lab, so be sure to activate your Sauder Computer Lab account: go to the link http:\/\/www.sauder.ubc.ca\/lts\/labs<\/a> and follow the instructions. Activation takes from an hour to one day so you should do this as early as possible.<\/p>\n Session 1: Getting started with VBA Session 2: Storing and retrieving data<\/strong><\/p>\n Session 3. VBA Forms Session 4. Introduction to databases<\/strong><\/p>\n Session 5. SQL Queries<\/strong><\/p>\n Session 6. Summarizing Data<\/strong><\/p>\n
\n<\/strong><\/p>\n\n
\n
\n<\/strong><\/p>\n\n
\n
\n