# Engineering Computing

### Course Description

LearnChemE features faculty prepared engineering education resources for students and instructors produced by the Department of Chemical and Biological Engineering at the University of Colorado Boulder and funded by the National Science Foundation, Shell, and the Engineering Excellence Fund. In this course, LearnChemE explains computing in engineering, specifically on using Excel and other software to aid in engineering calculations.

Not yet rated

### Video Lectures & Study Materials

Visit the official course website for more study materials: http://www.learncheme.com/home

# Lecture Play Lecture
1 Solving Set of Linear Equations (005:11) Play Video
2 Excel: Solving Linear Equations with Gaussian Elimination (008:42) Play Video
3 Excel Solver: Introduction (006:11) Play Video
4 Excel: Bisection Introduction (007:31) Play Video
5 Excel: Bisection Example (006:47) Play Video
6 Excel: Bisection Live Method (008:05) Play Video
7 Excel: Iterative Solutions (003:26) Play Video
8 Excel: Goal Seek Introduction (004:34) Play Video
9 Excel: Goal Seek Example (005:48) Play Video
10 POLYMATH: Bubble Temperature Non-Ideal Liquid (004:47) Play Video
11 Excel Solver: Mass and Energy Balances (003:50) Play Video
12 Excel Solver: Dew Temperature Calculation (007:06) Play Video
13 Excel Solver: Real Gas Expansion (Part 2) (005:37) Play Video
14 Excel: Simpson's Rule (004:36) Play Video
15 Euler Method for ODEs (007:16) Play Video
16 Excel/Matlab: Euler Method (008:36) Play Video
17 Runge-Kutta Method Introduction (005:39) Play Video
18 Solving Linear ODEs Analytically (003:52) Play Video
19 POLYMATH: Solving ODEs (005:45) Play Video
20 POLYMATH/Excel: Add-in to Solve ODEs (006:38) Play Video
21 Non-Linear Regression Introduction (004:57) Play Video
22 POLYMATH: Non-Linear Regression (003:22) Play Video
23 Excel: Regression Fitting (Part I) (0011:28) Play Video
24 Excel: Regression Fitting (Part II) (008:50) Play Video
25 Excel: Multiple Regression (005:34) Play Video
26 Matlab: Model Fitting and Regression (009:11) Play Video
27 Matrices Introduction (Part I) (005:04) Play Video
28 Matrix Addition and Subtraction (Part II) (004:05) Play Video
29 Matrix Multiplication (Part III) (005:56) Play Video
30 Matrix Transpose and Determinants (Part IV) (004:40) Play Video
31 Matrix Inverse (Part V) (006:40) Play Video
32 Excel: Matrix Math (Part I) (005:36) Play Video
33 Excel: Matrix Math (Part II) (006:10) Play Video
34 Excel: Array Formulas (005:19) Play Video
35 Introduction to Matlab (008:09) Play Video
36 Matlab: Basic Functions (005:48) Play Video
37 Matlab: Plots (004:46) Play Video
38 Matlab: Files and Functions (004:42) Play Video
39 Matlab: Solvers (008:25) Play Video
40 Matlab: Solver Functions (008:15) Play Video
41 Matlab: Programming Structures (009:42) Play Video
42 Introduction to Excel (Part I) (007:04) Play Video
43 Introduction to Excel (Part II) (005:48) Play Video
44 Introduction to Excel (Part III) (007:17) Play Video
45 Importing Data into Excel (008:09) Play Video
46 Data Tables in Excel (004:56) Play Video
47 Data Tables in Excel: Two Independent Variables (005:07) Play Video
48 Formatting Numbers in Excel (005:36) Play Video
49 Naming Cells in Excel (003:44) Play Video
50 Formatting in Excel (009:53) Play Video
51 Entering an Equation into Excel (005:44) Play Video
52 Excel: Linearize and Plot Non-Linear Equations (007:14) Play Video
53 Excel: Overview of Scatter and Line Plots (006:28) Play Video
54 Excel: Scatter Plots (005:11) Play Video
55 Excel: Line Plots (004:54) Play Video
56 Excel: Overview of Pie Charts and Bar Graphs (007:23) Play Video
57 Excel: Pie Charts (005:30) Play Video
58 Excel: Bar Graphs (005:16) Play Video
59 Excel: 3D Plots (007:27) Play Video
60 Excel: Trend Lines (008:09) Play Video
61 Excel Macros (003:25) Play Video
62 VBA Basics (007:04) Play Video
63 Import/Export Data Using VBA (008:41) Play Video
64 VBA Programs (Part I) (0010:17) Play Video
65 VBA Programs (Part II) (006:49) Play Video
66 Message Boxes in VBA (006:19) Play Video
67 User Forms in Excel (007:51) Play Video
68 User Forms: Check Boxes (Part I) (005:42) Play Video
69 User Forms: Message Boxes (Part II) (005:26) Play Video
70 User Forms: Calculations (Part III) (004:02) Play Video
71 User Forms: Multiple Inputs (Part IV) (005:57) Play Video
72 User Forms: Performing Functions (Part V) (0013:56) Play Video
73 User Forms: Example 1 (Part VI) (005:04) Play Video
74 Excel User Form: Heat Exchanger Cost Estimator (006:03) Play Video
75 Arrays in VBA (007:16) Play Video
76 VBA Subs and Functions with Arrays (009:45) Play Video
77 Bisection Method in VBA (008:22) Play Video
78 Changing Units in an Equation (004:16) Play Video
79 Windows 7 Introduction (006:19) Play Video
80 Numerically Solve ODEs with Mathematica (Part I) (006:03) Play Video
81 Numerically Solve ODEs with Mathematica (Part II) (005:08) Play Video
82 Plot Equations with Mathematica (006:14) Play Video
83 Multiple Steady-States in a CSTR with Interactive Simulation (006:05) Play Video
84 Creating Interactive Simulations in Mathematica (008:09) Play Video
85 Non-Linear Regression in Mathematica (009:39) Play Video
86 Basic Subroutine in VBA (007:30) Play Video
87 Creating a Scatter Plot Using Regression Analysis (004:51) Play Video
88 Dynamic Naming of Arrays in Excel (006:29) Play Video
89 VBA: Coding Do Loops (007:45) Play Video
90 VBA: Data Extraction (007:06) Play Video
91 VBA: Do Loop Example (007:01) Play Video
92 VBA: For-Next Loop (005:11) Play Video
93 VBA: Two-Way If Then (006:03) Play Video
94 VBA Macros: Relative vs. Absolute Referencing (005:05) Play Video
95 VBA: For-Next Loop Examples (0010:25) Play Video
96 VBA: One-Way If Then (004:53) Play Video
97 VBA: Performing String Searches (0010:09) Play Video
98 VBA: User-Defined Functions (006:37) Play Video
99 Simple VBAs from Scratch (007:12) Play Video
100 Introduction to Aspen Plus: Choosing a Property Method (002:17) Play Video
101 Introduction to Aspen Plus: Building a Flow Sheet (001:52) Play Video
102 Introduction to Aspen Plus: Data Input & Running the Simulation (003:54) Play Video
103 Introduction to Aspen Plus: Convergence & Presentation of Results (002:14) Play Video
104 Introduction to Aspen Plus: Chlorobenzene Plant (002:04) Play Video
105 Aspen Plus: Reactor Types (001:57) Play Video
106 Aspen Plus: Reactor Example Problem (004:46) Play Video
107 Aspen Plus - Reactors: Chlorobenzene Plant (003:26) Play Video
108 Aspen Plus: Flash Separators (002:26) Play Video
109 Aspen Plus: DSTWU (003:12) Play Video
110 Aspen Plus: RadFrac (003:21) Play Video
111 Aspen Plus - Separators: Chlorobenzene Plant (001:59) Play Video
112 Aspen Plus: Shortcut Heat Exchanger Method (002:45) Play Video
113 Aspen Plus: Detailed Heat Exchanger Method (004:03) Play Video
114 Aspen Plus: Double Heater Method (001:25) Play Video
115 Aspen Plus - Heat Exchangers: Chlorobenzene Plant (002:02) Play Video
116 Aspen Plus: Pumps (002:32) Play Video
117 Apsen Plus: Compressors (001:12) Play Video
118 Aspen Plus: Pipes (002:59) Play Video
119 Aspen Plus: Valves (001:34) Play Video
120 Aspen Plus - Pressure Changers: Chlorobenzene Plant (001:23) Play Video
121 Aspen Plus: Chlorobenzene Plant (002:07) Play Video
122 Aspen Plus: Chlorobenzene Plant Cost (004:58) Play Video
123 Laplace Transforms: Partial Fractions (Imaginary Roots) (009:56) Play Video
124 Laplace Transforms: Real Translation Theorem (006:17) Play Video
125 Laplace Transforms: Graphs (006:03) Play Video
126 Combo Boxes in Excel (0012:34) Play Video
127 Binomial Distribution (007:09) Play Video
128 Geometric Distribution (004:58) Play Video
129 Negative Binomial Distribution (009:27) Play Video
130 Hypergeometric Distribution (009:11) Play Video