**Commented index for EXCEL-worksheets.**
Related Sites:

Finite math using EXCEL (at Prentice Hall),
written by Ravathi Narasimhan.

Seminar talk (slides and links), November 1998.

*Most of the worksheets indexed here were prepared for
specific purposes in specific classes, and some may be hard
to follow outside that context.
We will continue to get more general-purpose examples and
more accessible instructions,
aiming at eventually getting one coherent library.
Suggestions and feedback are always
welcome.*

EXCEL
skills: Detailed listing of skills and links to sample worksheets.
(Kawski, 6/98)
Directory
listing (filenames only in ftp-directory).
fx.xls:
A programmed demo making a table for a function of a scalar variable, incl.
plot, fill-down, and relative addresses. (Kawski,
1997)
arclength.xls:
Demo (incl.pictures) for estimating arclength of parabola compared to arc of the sine.
((no exciting EXCEL features))
(Kawski, 1999)
continuity.xls:
Interactive live WORKSHEET for zooming on a graph for continuity at point.
Focus on continuity at a point, epsilon-delta characterization.
((Minor bugs: For some combination of function y=f(x),
value of delta and eps the scaling of the
axes is far from optimal.))
(
Kawski, 9/98)
derivative.xls:
Interactive live WORKSHEET for zooming on a graph for derivative at point.
Focus on approximability by linear function,
Precursor to epsilon-delta characterization.
((Minor bugs: For some combination of function y=f(x),
value of delta and eps the scaling of the
axes is far from optimal.))
(
Kawski, 9/98)
quadratic.xls:
MODEL WORKSHEET for manually fitting a curve through data points: Enter
comments, data, make a table from formula, define names, simultaneoulsy
plot data points and function graph, format the chart.
For elaborate
step-by-step instructions see here.
(
Kawski, 6/98)
discover_e.xls:
Numerical differenntiation of functions a^x and b^x.
Overlay graphs of a^x, b^x and their numerical derivatives.
Observe that derivatives are constant multiples of orig function.
Vary values of a, b (and of numerical differentiation increment h)
until obvious match happens. Further exploration: Find the
multiplicative constant as function of base a.
(Kawski, 10/1998)
exponent.xls:
A ready-to-use workbook to graphically demonstrate that the families
of functions y=a^x and y=b^(kx) with b fixed agree. Simply tune
several values of k until graphs match.
(Kawski, 9/1998)
dydx.xls:
A programmed demo for numerical approximations for derivative of a function
fo a single variable. Various difference quotients compared: backward,
central, forward etc. (Kawski,
1997)
linear3.xls:
A quick VERY INTERACTIVE look at tables and graphs of linear functiosnof
two variables z=mx+ny+b. What do the coefficients tell? (Kawski,
1997)
linear.xls:
Tables of linear functions (single variable review, focus functions of
two variables): Recognizing linearity, completing tables with few given
data, finding formula for a linear function from e.g. three data-points.
(Kawski, 1997)
carloan.xls:
Table of a function for 2 variables (monthly payments). (Kawski,
1997)
partials.xls:
Tables and plots for first and second order partial derivatives (incl.
mixed partials) from numerical differentiation. Successive differentiation
versus directly using second order divided differences. (Kawski,
1997)
discriminant.xls:
A VERY INTERACTIVE worksheet to get a feel for the discriminant: saddles
- maxima - minima (Kawski,
1997)
chnrule.xls:
Chain-rule numerically: Composing a t -> (x,y) -> z. (Kawski,
1997)
heateqn.xls:
A template for the numerical solution of the heat equation. (Essentially
a specification of the IC and boundary data, and a ready-made workspace
for the calculations.) (Kawski,
1997)
heatsoln.xls:
A sample numerical solution of the heat equation.
(Kawski, 1997)
elliptic.xls:
A template for the numerical solution of Laplace's equation.
This is brandnew, has not been used in class and is intended
for demonstrations. Conceivable uses include exploration of
numerical instabilities etc.
(
Kawski, 1998)
speed.xls:
Three different parameterizations of the circle.
Plots and tables illustrate effects clearly.
(
Kawski, 1998)
**
Fourier approx of heartbeat for calculus II:
**

heartbeat.xls:
Sample data of electro-cardiogram for Fourier analysis.
(
heartsol.xls sample solution,
heartbeat.html proud picture).
Sample data of electro-cardiogram for Fourier analysis.
See also
MATLAB-pages
(
Kawski, 1999)