MATH 4051: Comp Expl & Generation of Data: Modeling in Excel
University of North Carolina, Charlotte
This is a project course. Grades are based on four to five projects that utilize spreadsheet technology. Includes an introduction to a major spreadsheet, such as Excel. Assigned projects may be selected from a range of topics that include: Data Analysis and Exploration; Dynamical Models and Difference Equations (Epidemics, Harvesting Models, Population Dynamics, Predator-Prey Models); Physical Models (projectile motion, including air resistance, orbits of celestial bodies, heat propagation); Combinatorics and Probability (birthday problem, genetics, simulation of distributions); Optimization (inventory control, apportionment algorithms); Financial Mathematics (Stock Price Simulation, Pricing of Derivatives); Business Simulations (Net Present Value Comparisons and Risk Evaluation, Sensitivity Analyses). Completed projects must include written descriptions, explanation, and evaluation along with appropriate working spreadsheets that accomplish the assigned objectives.
Average GPA: 2.94
Grade distribution records: 447 students across 20 terms.
Grade distribution
| Grade | Students | Percent |
|---|---|---|
| A | 161 | 36.0% |
| B | 136 | 30.4% |
| C | 78 | 17.4% |
| D | 20 | 4.5% |
| F | 22 | 4.9% |
| W | 15 | 3.4% |
Based on 447 student grade records across 20 terms and 3 professors.
Instructors
- Elizabeth Bumgardner 304 students, Average GPA 3.14
- Gary Crosby 123 students, Average GPA 2.38
- Pramesh Subedi 20 students, Average GPA 3.47