A staple of many spreadsheet-based management science courses is the use of Excel for activities such as model building, sensitivity analysis, goal seeking, and Monte-Carlo simulation. What might those things look like if carried out using Python? We describe a teaching module in which Python is used to do typical Excel-based modeling and…

There are a variety of discrete facility location models that have practical relevance for operations management and management science courses. Integer linear programming (ILP) is the standard technique for solving such problems. An alternative approach that is often conceptually appealing to students is to pose the problem as one of finding the…

Single-period inventory models with uncertain demand are very well known in the business analytics community. Typically, such models are rule-based functions, or sets of functions, of one decision variable (order quantity) and one random variable (demand). In academics, the models are taught selectively and usually not completely. Students are…

By using a sample of 1st-year undergraduate business students, this study dealt with the development of simple (deterministic and non-optimization) spreadsheet models of income statements within an introductory course on business informatics. The study examined students' errors in doing this for business situations of their choice and found three…

Many instructors in subjects such as economics are frequently concerned with how to teach technical material to undergraduate students with limited mathematical backgrounds. One method that has proven successful for the authors is to connect theoretically sophisticated material with actual data. This enables students to see how the theory relates…

Describes a method for inducing a theoretical model of a series of events that occur in an ongoing process. A data analysis method that transforms narrative data into event histories is explained, a spreadsheet display that compares event histories is described, and future research is suggested. (17 references) (LRW)

Presents examples that illustrate how spreadsheets can be used to ask and answer all sorts of scientific questions given suitable automation of useful spreadsheet procedures. Examples include data exploration, data analysis, project presentation, simulations, and students writing their own models. (Author/JRH)

Introduces students to the study of dynamical systems through a number of learning activities that explore functions in general and linear and exponential functions in particular. Students use calculators to interpret graphs, find patterns in tables of data, and also use algebra. (DDR)