QAC 171
Fall 2019
| Section:
01
|
Broadly speaking, this 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 (e.g., VBA) and learn to effectively use Excel to implement our models and display the results of our analyses. |
|
| Credit: .25 |
Gen Ed Area Dept:
NSM QAC, SBS QAC |
| Course Format: Laboratory Course | Grading Mode: Student Option |
| Level: UGRD |
Prerequisites: QAC151 AND ECON300 |
|
Fulfills a Requirement for: None |
|
Past Enrollment Probability: 90% or above |
| SECTION 01 - 2nd Quarter | | Special Attributes: CQC |
| 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: 17 | GRAD: X | SR non-major: 5 | JR non-major: 5 | SO: 5 | FR: 4 |
| Drop/Add Enrollment Requests | | | | | |
| Total Submitted Requests: 0 | 1st Ranked: 0 | 2nd Ranked: 0 | 3rd Ranked: 0 | 4th Ranked: 0 | Unranked: 0 |
|