Broadly speaking, the course is about evidence-based decision-making. It is intended for students with a background in Excel and VBA who want to learn how to use spreadsheets to develop business and financial models and communicate the results. Model building is different from the usual Excel skills as it focuses more on the analytical/mathematical aspects than on data wrangling, and requires some basic familiarity with economic/financial models and data analysis tools. We will start with problems where the inputs are deterministic and we must decide on optimal allocation of resources. We will then advance to problems with stochastic inputs and explore solutions either through simulation or through optimization of goal functions. Through this work we will develop the appropriate programming skills (VBA) and learn to effectively use Excel to implement our models and display the results of our analyses.
||Gen Ed Area Dept:
NSM QAC, SBS QAC|
|Course Format: Laboratory||Grading Mode: Student Option|
||Prerequisites: QAC151 AND ECON300
||Fulfills a Major Requirement for: None
||Past Enrollment Probability: Not Available
|SECTION 01 - 4th Quarter|
|Special Attributes: CQC|
|Major Readings: Wesleyan RJ Julia Bookstore
Case studies and journal articles (available on-line)
|Examinations and Assignments: |
This course will have weekly quizzes, homework assignments and a final project. The readings will be posted on the Moodle course page. Starting with week 2, you must come to class prepared and familiar with the assigned readings.
|Additional Requirements and/or Comments: |
QAC 151 (working with Excel) or equivalent experience is a prerequisite for the course. In addition, an introductory statistics/data analysis background is expected and that is why ECON300 is listed as a formal prerequisite. Pre-req overrides will be approved by the Professor for students who satisfy these basic requirements through other course work.
Please Note: The course meets the second half of the semester (4th Quarter)
|Instructor(s): Oleinikov,Pavel V Times: ....R.. 07:10PM-10:00PM; Location: ALLB204; |
|Total Enrollment Limit: 19||SR major: 0||JR major: 0|| || |
|Seats Available: 7||GRAD: X||SR non-major: 7||JR non-major: 7||SO: 5||FR: 0|
|Drop/Add Enrollment Requests|
|Total Submitted Requests: 4||1st Ranked: 0||2nd Ranked: 0||3rd Ranked: 0||4th Ranked: 0||Unranked: 4|