prof-rossetti / georgetown-opim-557-201803

Computer-based Decision Support Systems - Spring 2018

OPIM 557: Computer-based Decision Support Systems

This repository contains resources for instructing a graduate business school course on creating decision support systems in MS Excel using the Visual Basic for Applications (VBA) programming language.

See the Syllabus for more information about the course, and the Canvas site for a comprehensive calendar of events and due dates.

Course Materials

Instructional Units

• Unit 1
• Unit 2
• Unit 3
• Unit 4
• Unit 5
• Unit 6

Notes

• Information Systems
• ActiveX Controls
• Excel Objects
• VBA Programming

Assignments

• Excel Objects Assignment
• ActiveX Controls Assignment
• Industry Insights Assignment

Projects

• Retirement Savings Calculator
• Executive Dashboard
• Stock Trading Recommendation System

Ungraded Practice Exercises

• Processing Spreadsheet Data
• Processing CSV Strings
• Issuing Web Requests

Weekly Check-ins

Please submit this Check-in Form each week, sometime between Thursday morning and 11:59pm on Sunday.

Your responses help the professor evaluate and improve instructional methods on an ongoing basis in an effort to provide the best possible experience for current and future students.

Contributing

License

georgetown-opim-557-201803's Issues

Add Notes on Range.End

For next semester, include notes onRange.End (docs: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-end-property-excel).