ChEn263 — 2018 Course Notes
Excel
Lecture 1 – Introduction to Excel
Lecture 2 – Functions and Plots
- Lecture 2 Notes
- Lecture 2 Example Spreadsheet
- Velocity data for last example: text file, csv file
Lecture 3 – Linear Equations
Lecture 4 – Non-Linear Equations
Lecture 5 – Curve Fitting
Lecture 6 – Numerical ODEs
Python
Lecture 7 – Introduction to Python
- Lecture 7 Notes
- Lecture 7 Python Installation Guide
- Lecture 7 Example 1: Hello World
- Lecture 7 Example 2: Keywords and Operators
- Lecture 7 Practice 1: GPA, Key
Lecture 8 – Functions and Conditionals
- Lecture 8 Notes
- Lecture 8 Example 1: Conditionals
- Lecture 8 Practice 1: Conditionals, Key
- Lecture 8 Example 2: Functions
- Lecture 8 Practice 2: Functions, Key
Lecture 9 – Arrays and Loops
- Lecture 9 Notes
- Lecture 9 Example 1: Arrays
- Lecture 9 Practice 1: Arrays, Key
- Lecture 9 Example 2: Loops
- Lecture 9 Practice 2: Loops, Key
Lecture 10 – Plotting
- Lecture 10 Notes
- Lecture 10 Example: Plotting
- Lecture 10 Practice 1: Review, Key
- Lecture 10 Practice 2: Plotting, Key
Lecture 11 – File I/O and Debugging
- Lecture 11 Notes
- Lecture 11 Example 1: Debugging
- Lecture 11 Example 2: File IO
- Lecture 11 Practice 1: Debugging, Key
- Lecture 11 Practice 2: File IO, Key
Lecture 12 – Linear and Non-linear Equations
- Lecture 12 Notes
- Lecture 12 Example 1: Linear Equations
- Lecture 12 Example 2: Non-linear Equations
- Lecture 12 Practice 1: Linear Equations, Key
- Lecture 12 Practice 2: Non-linear Equations, Key
Lecture 13 – Fitting and Interpolation
- Lecture 13 Notes
- Lecture 13 Example 1: Fitting vs. Interpolation
- Lecture 13 Example 2: Fitting and Interpolation Syntax
- Lecture 13 Practice 1: Fitting vs. Interpolation, Key
- Lecture 13 Practice 2: Fitting, Key, Data
- Lecture 13 Practice 3: Interpolation, Key, Data
Lecture 14 – Numerical Integration
- Video Notes
- Lecture 14 Notes
- Lecture 14 Example 1: Python Quadrature Syntax
- Lecture 14 Practice 1: Trapezoidal Rule, Key
- Lecture 14 Practice 2: Python Quadrature, Key
Lecture 15 – Numerical ODEs
- Video Notes
- Lecture 15 Notes
- Lecture 15 Example 1: Python ODE Solver
- Lecture 15 Practice 1: Systems of ODEs, Key
- Lecture 15 Practice 2: Python ODE Solver, Key
Lecture 16 – Jupyter Notebook and Symbolic Math
- Lecture 16 Notes
- Lecture 16 Examples
(For .ipynb files right click on the file and “Save link as …”) - Lecture 16 Practice 1: Jupyter Notebook, Key
- Lecture 16 Practice 2: Symbolic Math, Key
Lecture 17 – Macros, VBA, xlwings
- Lecture 17 Notes
- Lecture 17 VBA Handout
- Lecture 17 xlwings Handout
- Lecture 17 Example 1: Toluene Heat Capacity
- Lecture 17 Example 2: XLWings
MathCAD
Lecture 18 – Intro to MathCAD
Lecture 19 – Functions, Arrays and Linear Equations
Lecture 20 – Plotting and Nonlinear Equations
Lecture 21 – Nonlinear Equations II
Lecture 22 – Interpolation and Curve Fitting
- Lecture 22 Notes
- Lecture 22 MathCAD File
- Lecture 22 Practice Problems, Key
- Lecture 22 Data Files Lec_22-Ex_A.dat, Lec_22-Ex_C.dat, Lec_22-Practice_PartC.dat