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)