Engineering Computing

Video Lectures

Displaying all 130 video lectures.
Lecture 1
Solving Set of Linear Equations
Play Video
Solving Set of Linear Equations
Explains how to solve multiple equations simultaneously. Shows an example of how to solve a system of equations with three unknowns.
Lecture 2
Excel: Solving Linear Equations with Gaussian Elimination
Play Video
Excel: Solving Linear Equations with Gaussian Elimination
Demonstrates how to use Gaussian elimination to solve a system of 3 equations with 3 unknowns.
Lecture 3
Excel Solver: Introduction
Play Video
Excel Solver: Introduction
Describes how to use the solver function in Excel 2010.
Lecture 4
Excel: Bisection Introduction
Play Video
Excel: Bisection Introduction
Introduces the bisection method and how to perform bisection in Excel 2010.
Lecture 5
Excel: Bisection Example
Play Video
Excel: Bisection Example
An example of how to use bisection to find the root of an equation using Excel 2010.
Lecture 6
Excel: Bisection Live Method
Play Video
Excel: Bisection Live Method
Instead of using Solver for a large data array, the bisection live solution method is utilized.
Lecture 7
Excel: Iterative Solutions
Play Video
Excel: Iterative Solutions
Explains how to solve an equation using an iterative approach in Excel 2010.
Lecture 8
Excel: Goal Seek Introduction
Play Video
Excel: Goal Seek Introduction
Explains how to use goal seek in Excel 2010.
Lecture 9
Excel: Goal Seek Example
Play Video
Excel: Goal Seek Example
Goal seek is used to find the distance between two objects given their masses and the gravitational force between them.
Lecture 10
POLYMATH: Bubble Temperature Non-Ideal Liquid
Play Video
POLYMATH: Bubble Temperature Non-Ideal Liquid
Uses POLYMATH software to solve non-linear algebraic equations that arise in vapor-liquid equilibrium calculations. This screencast builds off the one titled, "Bubble Temperature: Non Ideal Liquid".
Lecture 11
Excel Solver: Mass and Energy Balances
Play Video
Excel Solver: Mass and Energy Balances
Uses Excel solver to solve two non-linear algebraic equations, which are material and energy balances for a CSTR reactor.
Lecture 12
Excel Solver: Dew Temperature Calculation
Play Video
Excel Solver: Dew Temperature Calculation
Determine the liquid composition and temperature using Excel solver, given the vapor composition and the pressure.
Lecture 13
Excel Solver: Real Gas Expansion (Part 2)
Play Video
Excel Solver: Real Gas Expansion (Part 2)
Uses the Peng-Robinson equation of state spreadsheet from Elliott & Lira's textbook (www.chethermo.net/software) and Excel solver to calculate the final conditions for a real gas expanding into a vacuum. "Real Gas Expansion" describes the problem setup in detail. Reviewed by faculty from other academic institutions.
Lecture 14
Excel: Simpson's Rule
Play Video
Excel: Simpson's Rule
Use Simpson's rule in a spreadsheet to calculate the integral for a set of data.
Lecture 15
Euler Method for ODEs
Play Video
Euler Method for ODEs
Demonstrates how the Euler method is used to solve ordinary differential equations (ODEs).
Lecture 16
Excel/Matlab: Euler Method
Play Video
Excel/Matlab: Euler Method
Explains the Euler method and demonstrates how to perform it in Excel and Matlab.
Lecture 17
Runge-Kutta Method Introduction
Play Video
Runge-Kutta Method Introduction
Reviews how the Runge-Kutta method is used to solve ordinary differential equations. Reviewed by faculty from other academic institutions.
Lecture 18
Solving Linear ODEs Analytically
Play Video
Solving Linear ODEs Analytically
Presents an example from reaction engineering on how to solve a linear ordinary differential equation using an integrating factor.
Lecture 19
POLYMATH: Solving ODEs
Play Video
POLYMATH: Solving ODEs
Demonstrates how to solve systems of ordinary differential equations using POLYMATH software. The example used is from reaction kinetics.
Lecture 20
POLYMATH/Excel: Add-in to Solve ODEs
Play Video
POLYMATH/Excel: Add-in to Solve ODEs
Demonstrates how to use POLYMATH to solve ordinary differential equations (ODEs) by transferring the POLYMATH program into Excel 2010 in order to take advantage of Excel's capabilities.
Lecture 21
Non-Linear Regression Introduction
Play Video
Non-Linear Regression Introduction
Uses non-linear regression to obtain kinetic parameters from kinetic data obtained from an isothermal CSTR. POLYMATH is used to carry out the regression.
Lecture 22
POLYMATH: Non-Linear Regression
Play Video
POLYMATH: Non-Linear Regression
Demonstrates how to use POLYMATH software to carry out non-linear regression to determine kinetic parameters from tabulated data. Uses the same data presented in the screencast titled Non-Linear Regression Introduction.
Lecture 23
Excel: Regression Fitting (Part I)
Play Video
Excel: Regression Fitting (Part I)
Explains how to set up regression calculations in Excel 2010 for a simple function.
Lecture 24
Excel: Regression Fitting (Part II)
Play Video
Excel: Regression Fitting (Part II)
Explains how to set up regression calculations in Excel 2010 for more complex functions than presented in part 1 of this series.
Lecture 25
Excel: Multiple Regression
Play Video
Excel: Multiple Regression
Explains how to use multiple regression in Excel 2010.
Lecture 26
Matlab: Model Fitting and Regression
Play Video
Matlab: Model Fitting and Regression
Demonstrates how to model a curve and perform regression in Matlab.
Lecture 27
Matrices Introduction (Part I)
Play Video
Matrices Introduction (Part I)
An introduction to matrices.
Lecture 28
Matrix Addition and Subtraction (Part II)
Play Video
Matrix Addition and Subtraction (Part II)
Explains elemental addition and subtraction of matrices.
Lecture 29
Matrix Multiplication (Part III)
Play Video
Matrix Multiplication (Part III)
Demonstrates how to multiply matrices.
Lecture 30
Matrix Transpose and Determinants (Part IV)
Play Video
Matrix Transpose and Determinants (Part IV)
Demonstrates how to transpose matrices and calculate determinants.
Lecture 31
Matrix Inverse (Part V)
Play Video
Matrix Inverse (Part V)
Demonstrates how to calculate the inverse of a matrix and how to use it.
Lecture 32
Excel: Matrix Math (Part I)
Play Video
Excel: Matrix Math (Part I)
Explains how to name matrices (arrays) and presents simple array calculations.
Lecture 33
Excel: Matrix Math (Part II)
Play Video
Excel: Matrix Math (Part II)
Explains how to use the built-in functions for matrix (array) math in Excel 2010.
Lecture 34
Excel: Array Formulas
Play Video
Excel: Array Formulas
Shows how to use array formulas in Excel 2010 to perform matrix calculations.
Lecture 35
Introduction to Matlab
Play Video
Introduction to Matlab
Demonstrates several ways to solve a derivative using Matlab.
Lecture 36
Matlab: Basic Functions
Play Video
Matlab: Basic Functions
Overview of common functions used in Matlab programming, including trigonometric and array functions.
Lecture 37
Matlab: Plots
Play Video
Matlab: Plots
Describes how to use Matlab to graph equations and experimental data.
Lecture 38
Matlab: Files and Functions
Play Video
Matlab: Files and Functions
Shows how to use m-files, anonymous functions, and user defined functions in Matlab.
Lecture 39
Matlab: Solvers
Play Video
Matlab: Solvers
Uses built-in solvers in Matlab to find the roots of an equation, the solution to a non-linear equation, and the area under a curve.
Lecture 40
Matlab: Solver Functions
Play Video
Matlab: Solver Functions
Shows how to combine arguments with solver functions in Matlab to simplify repetitive calculations.
Lecture 41
Matlab: Programming Structures
Play Video
Matlab: Programming Structures
Describes different programming structures used in Matlab.
Lecture 42
Introduction to Excel (Part I)
Play Video
Introduction to Excel (Part I)
An introduction to using Excel 2010 -- formatting and manipulating of cells is explained.
Lecture 43
Introduction to Excel (Part II)
Play Video
Introduction to Excel (Part II)
An introduction to using Excel 2010 -- file menu is explained.
Lecture 44
Introduction to Excel (Part III)
Play Video
Introduction to Excel (Part III)
An introduction to using Excel 2010 -- the use of tabs in the ribbon are explained.
Lecture 45
Importing Data into Excel
Play Video
Importing Data into Excel
Demonstrates how to import data into Excel 2010.
Lecture 46
Data Tables in Excel
Play Video
Data Tables in Excel
Explains how to use data tables in Excel 2010 when only one variable is changing.
Lecture 47
Data Tables in Excel: Two Independent Variables
Play Video
Data Tables in Excel: Two Independent Variables
Explains how to use data tables in Excel 2010 when two variables are changing.
Lecture 48
Formatting Numbers in Excel
Play Video
Formatting Numbers in Excel
Demonstrates several ways to format numbers in Excel 2010.
Lecture 49
Naming Cells in Excel
Play Video
Naming Cells in Excel
Demonstrates how to name cells and manage named cells in Excel 2010.
Lecture 50
Formatting in Excel
Play Video
Formatting in Excel
Presents some simple formatting tips for Excel 2010.
Lecture 51
Entering an Equation into Excel
Play Video
Entering an Equation into Excel
Explains how to input an equation into Excel 2010 using an engineering example.
Lecture 52
Excel: Linearize and Plot Non-Linear Equations
Play Video
Excel: Linearize and Plot Non-Linear Equations
Demonstrates how to linearize and plot non-linear equations using Excel 2010.
Lecture 53
Excel: Overview of Scatter and Line Plots
Play Video
Excel: Overview of Scatter and Line Plots
Explains the differences in and the uses of scatter and line plots in Excel 2010.
Lecture 54
Excel: Scatter Plots
Play Video
Excel: Scatter Plots
Explains how to make a scatter plot using Excel 2010.
Lecture 55
Excel: Line Plots
Play Video
Excel: Line Plots
Explains how to make a line plot using Excel 2010.
Lecture 56
Excel: Overview of Pie Charts and Bar Graphs
Play Video
Excel: Overview of Pie Charts and Bar Graphs
Discusses the differences between and the best uses of pie charts and bar graphs in Excel 2010.
Lecture 57
Excel: Pie Charts
Play Video
Excel: Pie Charts
Explains how to make a pie chart in Excel 2010.
Lecture 58
Excel: Bar Graphs
Play Video
Excel: Bar Graphs
Explains how to make a bar graph using Excel 2010.
Lecture 59
Excel: 3D Plots
Play Video
Excel: 3D Plots
Explains how to create a three-dimensional surface plot in Excel 2010.
Lecture 60
Excel: Trend Lines
Play Video
Excel: Trend Lines
Explains how to graph trend lines in Excel 2010.
Lecture 61
Excel Macros
Play Video
Excel Macros
Demonstrates how to use the macro recorder to write a simple program in VBA/Excel.
Lecture 62
VBA Basics
Play Video
VBA Basics
Introduces how to copy, paste, clear, and assign macros a button using VBA.
Lecture 63
Import/Export Data Using VBA
Play Video
Import/Export Data Using VBA
Demonstrates how to import data into VBA from Excel and export data from VBA into Excel.
Lecture 64
VBA Programs (Part I)
Play Video
VBA Programs (Part I)
Discusses types of sequence and selection code in VBA.
Lecture 65
VBA Programs (Part II)
Play Video
VBA Programs (Part II)
Discusses types of repetition code in VBA.
Lecture 66
Message Boxes in VBA
Play Video
Message Boxes in VBA
Introduction to message boxes in Visual Basic for Applications.
Lecture 67
User Forms in Excel
Play Video
User Forms in Excel
A simple user form is created using VBA for Excel 2010.
Lecture 68
User Forms: Check Boxes (Part I)
Play Video
User Forms: Check Boxes (Part I)
The check box control in VBA is demonstrated for Excel 2010.
Lecture 69
User Forms: Message Boxes (Part II)
Play Video
User Forms: Message Boxes (Part II)
The message box function in VBA is explained for Excel 2010.
Lecture 70
User Forms: Calculations (Part III)
Play Video
User Forms: Calculations (Part III)
Explains how to perform a calculation within a user form in VBA.
Lecture 71
User Forms: Multiple Inputs (Part IV)
Play Video
User Forms: Multiple Inputs (Part IV)
Uses inputs from multiple user forms to perform a calculation.
Lecture 72
User Forms: Performing Functions (Part V)
Play Video
User Forms: Performing Functions (Part V)
Designs a sophisticated user form that calculates either the surface area or volume of a 3D shape using VBA.
Lecture 73
User Forms: Example 1 (Part VI)
Play Video
User Forms: Example 1 (Part VI)
Develops a user form in VBA to calculate taxes given income and marital status.
Lecture 74
Excel User Form: Heat Exchanger Cost Estimator
Play Video
Excel User Form: Heat Exchanger Cost Estimator
Uses VBA to develop a user form to estimate the cost of a heat exchanger given type of heat exchanger, internal heat exchange area, construction material, and inflation.
Lecture 75
Arrays in VBA
Play Video
Arrays in VBA
Explains how to manipulate arrays using VBA.
Lecture 76
VBA Subs and Functions with Arrays
Play Video
VBA Subs and Functions with Arrays
Examples of how to write subroutines involving arrays in Excel using Visual Basic for Applications.
Lecture 77
Bisection Method in VBA
Play Video
Bisection Method in VBA
Demonstrates how write VBA code to solve a problem using the bisection method.
Lecture 78
Changing Units in an Equation
Play Video
Changing Units in an Equation
Demonstrates how to convert the Arrhenius equation from SI to English units. Reviewed by faculty from other academic institutions.
Lecture 79
Windows 7 Introduction
Play Video
Windows 7 Introduction
Introduction to the Windows 7 operating system.
Lecture 80
Numerically Solve ODEs with Mathematica (Part I)
Play Video
Numerically Solve ODEs with Mathematica (Part I)
Demonstrates how to use the Mathematica function NDSolve to solve two ordinary differential equations numerically. This is an initial value problem for a batch reactor with a single reaction.
Lecture 81
Numerically Solve ODEs with Mathematica (Part II)
Play Video
Numerically Solve ODEs with Mathematica (Part II)
Uses the solution from the Mathematica 1 screencast to show how to format a plot.
Lecture 82
Plot Equations with Mathematica
Play Video
Plot Equations with Mathematica
Shows how to plot two equations in Mathematica and how to make multiple plots for different values of one parameter in one equation. The equations used are the mass and energy balances for an adiabatic CSTR.
Lecture 83
Multiple Steady-States in a CSTR with Interactive Simulation
Play Video
Multiple Steady-States in a CSTR with Interactive Simulation
Presents the mass and energy balances for a steady-state CSTR in which a reversible reaction takes place. The equations are plotted (product concentration vs. temperature) with an interactive Mathematica demonstration and the effects of changing feed temperature, heat transfer coefficient, and reverse rate constant are presented.
Lecture 84
Creating Interactive Simulations in Mathematica
Play Video
Creating Interactive Simulations in Mathematica
Demonstrates how to use the Manipulate command in Mathematica to create interactive graphical output from the solution of two ordinary differential equations. The equations used are for two reactions in a batch reactor.
Lecture 85
Non-Linear Regression in Mathematica
Play Video
Non-Linear Regression in Mathematica
Demonstrates how to use non-linear regression in Mathematica to determine kinetic parameters. Uses the NonlinearModelFit function in Mathematica.
Lecture 86
Basic Subroutine in VBA
Play Video
Basic Subroutine in VBA
Creates a basic subroutine in VBA to perform simple calculations.
Lecture 87
Creating a Scatter Plot Using Regression Analysis
Play Video
Creating a Scatter Plot Using Regression Analysis
Plots experimental and theoretical data using regression analysis.
Lecture 88
Dynamic Naming of Arrays in Excel
Play Video
Dynamic Naming of Arrays in Excel
Shows how to dynamically name arrays in Excel using the vlookup function and the offset function.
Lecture 89
VBA: Coding Do Loops
Play Video
VBA: Coding Do Loops
Codes different types of do loops in VBA.
Lecture 90
VBA: Data Extraction
Play Video
VBA: Data Extraction
Shows how to extract data from multiple Excel files using VBA.
Lecture 91
VBA: Do Loop Example
Play Video
VBA: Do Loop Example
Example of input validation using the do loop function in VBA.
Lecture 92
VBA: For-Next Loop
Play Video
VBA: For-Next Loop
Explains for-next loops in VBA for fixed iterations.
Lecture 93
VBA: Two-Way If Then
Play Video
VBA: Two-Way If Then
Example of a simple two-way if then statement in VBA.
Lecture 94
VBA Macros: Relative vs. Absolute Referencing
Play Video
VBA Macros: Relative vs. Absolute Referencing
Compares relative and absolute referencing when recording a VBA macro.
Lecture 95
VBA: For-Next Loop Examples
Play Video
VBA: For-Next Loop Examples
Examples of iterating through vectors and arrays in VBA using for-next loops.
Lecture 96
VBA: One-Way If Then
Play Video
VBA: One-Way If Then
Simple example of the one-way if then function in VBA.
Lecture 97
VBA: Performing String Searches
Play Video
VBA: Performing String Searches
Describes how to perform string searches in Excel using VBA.
Lecture 98
VBA: User-Defined Functions
Play Video
VBA: User-Defined Functions
Example of how to create a user-defined function in VBA.
Lecture 99
Simple VBAs from Scratch
Play Video
Simple VBAs from Scratch
Shows several examples of how to write simple subs in Visual Basic for Applications in Microsoft Excel.
Lecture 100
Introduction to Aspen Plus: Choosing a Property Method
Play Video
Introduction to Aspen Plus: Choosing a Property Method
Introduces Aspen Plus and describes the various property methods available.
Lecture 101
Introduction to Aspen Plus: Building a Flow Sheet
Play Video
Introduction to Aspen Plus: Building a Flow Sheet
Demonstrates how to build a flowsheet in Aspen Plus by modeling a two-stream heat exchanger.
Lecture 102
Introduction to Aspen Plus: Data Input & Running the Simulation
Play Video
Introduction to Aspen Plus: Data Input & Running the Simulation
Explains how to input data and run a simulation in Aspen Plus. Uses the flowsheet developed in the screencast "Introduction to Aspen Plus: Building a Flowsheet."
Lecture 103
Introduction to Aspen Plus: Convergence & Presentation of Results
Play Video
Introduction to Aspen Plus: Convergence & Presentation of Results
Provides a detailed overview of simulation convergence and presentation of results in Aspen Plus. Uses the data developed in the screencast "Introduction to Aspen Plus: data input & running the simulation."
Lecture 104
Introduction to Aspen Plus: Chlorobenzene Plant
Play Video
Introduction to Aspen Plus: Chlorobenzene Plant
Applies the fundamentals discussed in the Introduction to Aspen Plus screencasts to a industrially relevant chlorobenzene plant.
Lecture 105
Aspen Plus: Reactor Types
Play Video
Aspen Plus: Reactor Types
Provides an overview of the various types of reactor simulator blocks found in Aspen Plus.
Lecture 106
Aspen Plus: Reactor Example Problem
Play Video
Aspen Plus: Reactor Example Problem
Demonstrates the use of reactor models through an example problem on the production of ethyl acetate in Aspen Plus.
Lecture 107
Aspen Plus - Reactors: Chlorobenzene Plant
Play Video
Aspen Plus - Reactors: Chlorobenzene Plant
Applies the concept of reactors to the chlorobenzene plant simulation developed in the screencast "Introduction to Aspen Plus: Chlorobenzene Plant."
Lecture 108
Aspen Plus: Flash Separators
Play Video
Aspen Plus: Flash Separators
Demonstrates a flash separator model in Aspen Plus.
Lecture 109
Aspen Plus: DSTWU
Play Video
Aspen Plus: DSTWU
Explains how to use a DSTWU separator model in Aspen Plus.
Lecture 110
Aspen Plus: RadFrac
Play Video
Aspen Plus: RadFrac
Refines the DSTWU model from the screencast "Aspen Plus: DSTWU" using a RadFrac model in Aspen Plus.
Lecture 111
Aspen Plus - Separators: Chlorobenzene Plant
Play Video
Aspen Plus - Separators: Chlorobenzene Plant
Applies the concept of separators to the chlorobenzene plant simulation developed in the screencast "Introduction to Aspen Plus: Chlorobenzene Plant."
Lecture 112
Aspen Plus: Shortcut Heat Exchanger Method
Play Video
Aspen Plus: Shortcut Heat Exchanger Method
Demonstrates how to use the shortcut heat exchanger method in Aspen Plus.
Lecture 113
Aspen Plus: Detailed Heat Exchanger Method
Play Video
Aspen Plus: Detailed Heat Exchanger Method
Explains the detailed heat exchanger method in Aspen Plus.
Lecture 114
Aspen Plus: Double Heater Method
Play Video
Aspen Plus: Double Heater Method
Explains how to use two heater models to simulate a heat exchanger in Aspen Plus.
Lecture 115
Aspen Plus - Heat Exchangers: Chlorobenzene Plant
Play Video
Aspen Plus - Heat Exchangers: Chlorobenzene Plant
Applies the concept of heat exchangers to the chlorobenzene plant simulation developed in the screencast "Introduction to Aspen Plus: Chlorobenzene Plant."
Lecture 116
Aspen Plus: Pumps
Play Video
Aspen Plus: Pumps
Explains how to use a pump simulator block in Aspen Plus.
Lecture 117
Apsen Plus: Compressors
Play Video
Apsen Plus: Compressors
Details the use of compressors in Aspen Plus.
Lecture 118
Aspen Plus: Pipes
Play Video
Aspen Plus: Pipes
Explains how to model different types of process piping in Aspen Plus.
Lecture 119
Aspen Plus: Valves
Play Video
Aspen Plus: Valves
Explains how to simulate a valve in Aspen Plus.
Lecture 120
Aspen Plus - Pressure Changers: Chlorobenzene Plant
Play Video
Aspen Plus - Pressure Changers: Chlorobenzene Plant
Applies the concept of pressure changers to the chlorobenzene plant simulation developed in the screencast "Introduction to Aspen Plus: Chlorobenzene Plant."
Lecture 121
Aspen Plus: Chlorobenzene Plant
Play Video
Aspen Plus: Chlorobenzene Plant
Runs the simulation of a chlorobenzene plant. Check out the previous screencasts in playlist to see how the flow sheet was developed.
Lecture 122
Aspen Plus: Chlorobenzene Plant Cost
Play Video
Aspen Plus: Chlorobenzene Plant Cost
Demonstrates an economic analysis of a chlorobenzene plant designed in Aspen Plus. Analysis done using Microsoft Excel.
Lecture 123
Laplace Transforms: Partial Fractions (Imaginary Roots)
Play Video
Laplace Transforms: Partial Fractions (Imaginary Roots)
Shows how to solve equations in the Laplace domain that contain imaginary roots and convert them into the time domain.
Lecture 124
Laplace Transforms: Real Translation Theorem
Play Video
Laplace Transforms: Real Translation Theorem
Explores dead time in the Laplace domain and the usage of the real translation theorem.
Lecture 125
Laplace Transforms: Graphs
Play Video
Laplace Transforms: Graphs
Converts a graphical function in the time domain into the Laplace domain using the definition of a Laplace transfer.
Lecture 126
Combo Boxes in Excel
Play Video
Combo Boxes in Excel
Uses Visual Basic for Applications (VBA) and Microsoft Excel software to code combo boxes.
Lecture 127
Binomial Distribution
Play Video
Binomial Distribution
Derives binomial distribution for data analysis and gives an example.
Lecture 128
Geometric Distribution
Play Video
Geometric Distribution
Derives geometric distribution for data analysis and gives an example.
Lecture 129
Negative Binomial Distribution
Play Video
Negative Binomial Distribution
Derives the negative binomial distribution for data analysis and gives an example.
Lecture 130
Hypergeometric Distribution
Play Video
Hypergeometric Distribution
Derives the hypergeometric distribution for data analysis and gives an example.