MATH 4051

Computer Exploration and Generation of Data

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.

Units: 3.0