A popular game played in each broadcast of the United States television game show “The Price is Right” has contestants spinning a large wheel comprised of twenty different monetary values (in 5-cent increments from $0.05 to $1.00). A player wins by scoring closest to, without exceeding, $1.00. Players may accomplish this in one or a total of two spins. We develop a spreadsheet modeling exercise, useful in an introductory undergraduate Spreadsheet Analytics course, to simulate the spinning of the wheel and to determine optimal spinning strategies.

Electromagnetics is arguably one of the most challenging courses in any electrical engineering curriculum. A solid foundation in vector calculus and a good intuition based on physical grounds are the normal requirements for a student to successfully complete this course. This paper presents a simple, yet powerful approach to introducing boundary-value problems arising in electrostatics. The principles of electrostatics find numerous applications such as electrostatic machines, lightning rods, gas purification, food purification, laser printers, and crop spraying, to name a few.

This paper focuses on the use of spreadsheets for solving electrostatic boundary-value problems. Sample problems that introduce the finite difference and the finite element methods are presented. The geometries included in the problems are sufficiently nontrivial for hand calculation or analytical solution, but reasonably manageable using spreadsheets. Although specialized software is available for this purpose, oftentimes such sophistication tends to obscure the mathematical underpinnings of the solution methods. Spreadsheets offer a transparent alternative - perhaps proximate to hand calculation - for students to better appreciate the numerical methods for solving boundary-value problems.