All of these files can be viewed in a web browser, although some of them have macros in them and the macros will not work properly on the web. Anything listed below with an asterick, *, has a macro. To best view one of thesefiles, save it to your computer then open it up from Excel.

**Note: If Excel won't let you run the macros contained in these files then prior to opening them in Excel you must select a security level of medium under the Tools menu (Tools...Macro...Security)

* Limits.xls Exploring limits graphically and numerically. (Calculus)

* DeltaEpsilon.xls Visualizing what is happening with deltas and epsilons on a graph. (Calculus)

SecantsAndTangents.xls Exploring numerically and graphically what happens in the definition of the derivative when delta x approaches 0. (Calculus)

* IntegralApproximations.xls Explore graphically and numerically Riemann sums (using left and right endpoints) as well as the trapezoidal rule when n approaches infinity. (Calculus)

Concavity.xls Exploring concavity. (Calculus)

* NewtonsMethod.xls See what happens in each step of Newton's Method. (Calculus)

TaylorPolynomials.xls See Taylor polynomials used to approximate some common functions. (Calculus)

AlternatingSeriesTest.xls See a graph of partial sums being plot and get a visualization of why |S-S_n|£a_n+1. (Calculus)

GraphsOfQuadraticSurfaces.xls See the 3D plot of the surface of f(x,y) = A x² + B y² + C along with a plot of some level curves. Explore the relationship between the graph and the level curves. Explore how the constants A, B, and C effect the graphs. (Calculus)

---

* SlopeFields.xls Draw slope fields. Explore what happens in Euler's method and the improved Euler's method. (Differential Equations)

---

* ConfidenceIntervals.xls Visualize a confidence interval with real random data. Discover how each variable effects the calculation of the confidence interval. Go through many trials and discover how many times a data point lies within the interval (and compare to the % in the confidence level). (Statistics)

* DistributionOfXBar.xls A simulation to see how the distribution of sample means is "normal". (Statistics)

---

GraphsOfTrigFunctions.xls Graph trig functions. (Trigonometry)

DefOfTrigFunctions.xls Definition of trig functions using the unit circle. (Trigonometry)

LawOfSines.xls Explores the ambiguous cases in the law of sines. (Trigonometry)

* PolarGraphs.xls See polar graphs being drawn. (Trigonometry)

---

ConstructAnOpenBox.xls See an animated version of a box being constructed by folding up the flaps after 4 corners were cut out. Then play around with the size of the corners to explore what length will generate a box of maximum volume. (Algebra)

LinesOfConstancy.xls See an animation of how corner points will achieve a maximum and minimum of an objective function over a fixed feasible region (the feasible region cannot be changed on this file but the objective function can). (Linear Programming)

---

The following are files used for graphing functions. This is not used for classroom demonstration, but rather for creating pictures of graphs for exams, worksheets, lecture notes, . . . I use this to create pictures that can easily be copied and pasted into Microsoft Word. There are many versions below, the only differences between the different files is how the gridlines (if any) appear and the color used to draw the graphs of the functions.
* CreateAGraph.xls
* CreateAGraph(NoGridlines).xls
* CreateAGraph(DashedGridlines).xls   (light gridlines)
* CreateAGraph(DashedGridlines2).xls   (very light gridlines)

* CreateAGraph_AllBlue.xls
* CreateAGraph_AllBlue(NoGridlines).xls
* CreateAGraph_AllBlue(DashedGridlines).xls   (light gridlines)
* CreateAGraph_AllBlue(DashedGridlines2).xls   (very light gridlines)

   

Email: bsmith@parkland.edu