|
This page contains links to files we are making available for FTP download. Click on the appropriate
link under the Formats section of a file's description to begin downloading.
A definition of the file formats along with
required helper applications are available at the bottom of this page. All file sizes are approximate.
Contents by Class Week Distributed
Note that the dates above are one week off due to the ice storm. Correct
dates are below.
01/12/09
Course syllabus (PDF, 56k)
Excel Textbook Website
(Contains errata, link)
Previous Edition Textbook Chapter 1 (PDF,
4500k) (posted until texts arrive)
Excel Precourse Assessment
(PDF, 84k)
Lecture 1 Example Worksheet
(xls, 15k)
The Great Big Black Box (pdf, 192k)
Making The Toolbox Useful (pdf, 308k)
01/19/08
Previous Edition Textbook Chapter 2
(PDF, 3500k) (posted until texts arrive)
Plotting Example Worksheet
(xls, 17.5k)
Plotting
Example Worksheet 2 (xlsx, 13k)
Logical function
example (.xls, 13.5k)
Workshop 1 (pdf, 192k)
Workshop 2 (pdf, 168k)
Workshop 2 data (.prn text file,
273k)
The One Thousand Word Lecture (pdf, 217k)
Engineering
Art (pdf, 110k)
HW3 Data (txt, 3k)
Back to Top
01/26/09
Microsoft Excel 2003 training (link)
Microsoft Excel 2007 training (link)
Matrix lecture worksheets
(xls, 20.5k)
Enhance Your Functionality (pdf, 90.7k)
Units, Dimensions, and Numbers (pdf, 92k)
The
Matrix, Previsited (pdf, 147k)
02/09/09
Workshop 3 (pdf, 111k)
Material balance
worksheet (xls, 13.5k)
Material
Balances (pdf, 323k)
02/16/09
Workshop 4
(pdf, 74k)
Linearization Supplements (pdf,
288k)
Regression Example (xls,
16k)
Regression Examples 2 (xls,
26.5k)
Regressing into Data Analysis (pdf, 120k)
Not
Exactly a Tangent (pdf, 110k)
02/23/09
Workshop 5 (pdf,
130k)
Workshop 6 (pdf,
122k)
Study Guide Exam 1 (pdf,
56k)
Some online
Excel quizzes (link)
Iterative
Solutions Examples (xls, 15.5k)
Tools
for Solvation (pdf, 806k)
Additional Uses of
Solver (xls, 36k)
03/02/09
Excel Project
(pdf, 112k)
03/09/09
Spring Break!
03/16/09
Plotting example (m-file, 1k)
Workshop
7 (pdf,
113k)
Introduction to Matlab
(pdf, 159k)
Painting a Picture with Words (pdf, 248k)
03/23/09
Programming Examples
(zip, 1.4k)
Programming in Matlab (pdf, 74k)
It
Was Born For This (pdf, 44k)
The Fine Art of Curves (pdf, 177k)
03/30/09
Workshop
8 (pdf,
66k)
Curve Fit Examples
(zip, 1k)
Project
2 (pdf,
77k)
A Few Function Functions (pdf, 51k)
04/06/09
Exam 2 Study Guide
(pdf, 64k)
Introduction to programming in Excel examples (xls, 25k)
I'll
Do It My Way (pdf, 108k)
04/13/09
Exam 2
Excel Function example (xls,
24k)
The Structure of Programming (pdf, 49k)
04/20/09
Conditional Examples
(xlsm, 15k)
Loops Examples
((xls, 34k)
VBA Project Assignment
(pdf, 343k)
HW 13 Template (xlsm,
35k)
If (Not Now) Then When (pdf, 40k)
Going Loopy
(pdf, 78k)
We now return to your regularly scheduled programming (pdf, 69k)
04/27/09
Workshop
9: Go
With The Flowchart (pdf, 95k)
Final Exam Study Guide (pdf,
64k)
05/04/09
Lookup tables
and statistics examples (xls, 20.5k)
And
the Kitchen Sink (pdf, 87k)
05/02/08
.pdf Adobe Acrobat File. Get the free reader
at the Adobe Website
.exe Windows executable program
.zip Windows archive file
.doc Microsoft Word file
.xls Microsoft Excel spreadsheet
| 
