# Engineering Computing

## Video Lectures

Displaying all 130 video lectures.

Lecture 1Play Video |
Solving Set of Linear EquationsExplains how to solve multiple equations simultaneously. Shows an example of how to solve a system of equations with three unknowns. |

Lecture 2Play Video |
Excel: Solving Linear Equations with Gaussian EliminationDemonstrates how to use Gaussian elimination to solve a system of 3 equations with 3 unknowns. |

Lecture 3Play Video |
Excel Solver: IntroductionDescribes how to use the solver function in Excel 2010. |

Lecture 4Play Video |
Excel: Bisection IntroductionIntroduces the bisection method and how to perform bisection in Excel 2010. |

Lecture 5Play Video |
Excel: Bisection ExampleAn example of how to use bisection to find the root of an equation using Excel 2010. |

Lecture 6Play Video |
Excel: Bisection Live MethodInstead of using Solver for a large data array, the bisection live solution method is utilized. |

Lecture 7Play Video |
Excel: Iterative SolutionsExplains how to solve an equation using an iterative approach in Excel 2010. |

Lecture 8Play Video |
Excel: Goal Seek IntroductionExplains how to use goal seek in Excel 2010. |

Lecture 9Play Video |
Excel: Goal Seek ExampleGoal seek is used to find the distance between two objects given their masses and the gravitational force between them. |

Lecture 10Play Video |
POLYMATH: Bubble Temperature Non-Ideal LiquidUses 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 11Play Video |
Excel Solver: Mass and Energy BalancesUses Excel solver to solve two non-linear algebraic equations, which are material and energy balances for a CSTR reactor. |

Lecture 12Play Video |
Excel Solver: Dew Temperature CalculationDetermine the liquid composition and temperature using Excel solver, given the vapor composition and the pressure. |

Lecture 13Play 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 14Play Video |
Excel: Simpson's RuleUse Simpson's rule in a spreadsheet to calculate the integral for a set of data. |

Lecture 15Play Video |
Euler Method for ODEsDemonstrates how the Euler method is used to solve ordinary differential equations (ODEs). |

Lecture 16Play Video |
Excel/Matlab: Euler MethodExplains the Euler method and demonstrates how to perform it in Excel and Matlab. |

Lecture 17Play Video |
Runge-Kutta Method IntroductionReviews how the Runge-Kutta method is used to solve ordinary differential equations. Reviewed by faculty from other academic institutions. |

Lecture 18Play Video |
Solving Linear ODEs AnalyticallyPresents an example from reaction engineering on how to solve a linear ordinary differential equation using an integrating factor. |

Lecture 19Play Video |
POLYMATH: Solving ODEsDemonstrates how to solve systems of ordinary differential equations using POLYMATH software. The example used is from reaction kinetics. |

Lecture 20Play Video |
POLYMATH/Excel: Add-in to Solve ODEsDemonstrates 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 21Play Video |
Non-Linear Regression IntroductionUses non-linear regression to obtain kinetic parameters from kinetic data obtained from an isothermal CSTR. POLYMATH is used to carry out the regression. |

Lecture 22Play Video |
POLYMATH: Non-Linear RegressionDemonstrates 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 23Play Video |
Excel: Regression Fitting (Part I)Explains how to set up regression calculations in Excel 2010 for a simple function. |

Lecture 24Play 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 25Play Video |
Excel: Multiple RegressionExplains how to use multiple regression in Excel 2010. |

Lecture 26Play Video |
Matlab: Model Fitting and RegressionDemonstrates how to model a curve and perform regression in Matlab. |

Lecture 27Play Video |
Matrices Introduction (Part I)An introduction to matrices. |

Lecture 28Play Video |
Matrix Addition and Subtraction (Part II)Explains elemental addition and subtraction of matrices. |

Lecture 29Play Video |
Matrix Multiplication (Part III)Demonstrates how to multiply matrices. |

Lecture 30Play Video |
Matrix Transpose and Determinants (Part IV)Demonstrates how to transpose matrices and calculate determinants. |

Lecture 31Play Video |
Matrix Inverse (Part V)Demonstrates how to calculate the inverse of a matrix and how to use it. |

Lecture 32Play Video |
Excel: Matrix Math (Part I)Explains how to name matrices (arrays) and presents simple array calculations. |

Lecture 33Play Video |
Excel: Matrix Math (Part II)Explains how to use the built-in functions for matrix (array) math in Excel 2010. |

Lecture 34Play Video |
Excel: Array FormulasShows how to use array formulas in Excel 2010 to perform matrix calculations. |

Lecture 35Play Video |
Introduction to MatlabDemonstrates several ways to solve a derivative using Matlab. |

Lecture 36Play Video |
Matlab: Basic FunctionsOverview of common functions used in Matlab programming, including trigonometric and array functions. |

Lecture 37Play Video |
Matlab: PlotsDescribes how to use Matlab to graph equations and experimental data. |

Lecture 38Play Video |
Matlab: Files and FunctionsShows how to use m-files, anonymous functions, and user defined functions in Matlab. |

Lecture 39Play Video |
Matlab: SolversUses 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 40Play Video |
Matlab: Solver FunctionsShows how to combine arguments with solver functions in Matlab to simplify repetitive calculations. |

Lecture 41Play Video |
Matlab: Programming StructuresDescribes different programming structures used in Matlab. |

Lecture 42Play Video |
Introduction to Excel (Part I)An introduction to using Excel 2010 -- formatting and manipulating of cells is explained. |

Lecture 43Play Video |
Introduction to Excel (Part II)An introduction to using Excel 2010 -- file menu is explained. |

Lecture 44Play Video |
Introduction to Excel (Part III)An introduction to using Excel 2010 -- the use of tabs in the ribbon are explained. |

Lecture 45Play Video |
Importing Data into ExcelDemonstrates how to import data into Excel 2010. |

Lecture 46Play Video |
Data Tables in ExcelExplains how to use data tables in Excel 2010 when only one variable is changing. |

Lecture 47Play Video |
Data Tables in Excel: Two Independent VariablesExplains how to use data tables in Excel 2010 when two variables are changing. |

Lecture 48Play Video |
Formatting Numbers in ExcelDemonstrates several ways to format numbers in Excel 2010. |

Lecture 49Play Video |
Naming Cells in ExcelDemonstrates how to name cells and manage named cells in Excel 2010. |

Lecture 50Play Video |
Formatting in ExcelPresents some simple formatting tips for Excel 2010. |

Lecture 51Play Video |
Entering an Equation into ExcelExplains how to input an equation into Excel 2010 using an engineering example. |

Lecture 52Play Video |
Excel: Linearize and Plot Non-Linear EquationsDemonstrates how to linearize and plot non-linear equations using Excel 2010. |

Lecture 53Play Video |
Excel: Overview of Scatter and Line PlotsExplains the differences in and the uses of scatter and line plots in Excel 2010. |

Lecture 54Play Video |
Excel: Scatter PlotsExplains how to make a scatter plot using Excel 2010. |

Lecture 55Play Video |
Excel: Line PlotsExplains how to make a line plot using Excel 2010. |

Lecture 56Play Video |
Excel: Overview of Pie Charts and Bar GraphsDiscusses the differences between and the best uses of pie charts and bar graphs in Excel 2010. |

Lecture 57Play Video |
Excel: Pie ChartsExplains how to make a pie chart in Excel 2010. |

Lecture 58Play Video |
Excel: Bar GraphsExplains how to make a bar graph using Excel 2010. |

Lecture 59Play Video |
Excel: 3D PlotsExplains how to create a three-dimensional surface plot in Excel 2010. |

Lecture 60Play Video |
Excel: Trend LinesExplains how to graph trend lines in Excel 2010. |

Lecture 61Play Video |
Excel MacrosDemonstrates how to use the macro recorder to write a simple program in VBA/Excel. |

Lecture 62Play Video |
VBA BasicsIntroduces how to copy, paste, clear, and assign macros a button using VBA. |

Lecture 63Play Video |
Import/Export Data Using VBADemonstrates how to import data into VBA from Excel and export data from VBA into Excel. |

Lecture 64Play Video |
VBA Programs (Part I)Discusses types of sequence and selection code in VBA. |

Lecture 65Play Video |
VBA Programs (Part II)Discusses types of repetition code in VBA. |

Lecture 66Play Video |
Message Boxes in VBAIntroduction to message boxes in Visual Basic for Applications. |

Lecture 67Play Video |
User Forms in ExcelA simple user form is created using VBA for Excel 2010. |

Lecture 68Play Video |
User Forms: Check Boxes (Part I)The check box control in VBA is demonstrated for Excel 2010. |

Lecture 69Play Video |
User Forms: Message Boxes (Part II)The message box function in VBA is explained for Excel 2010. |

Lecture 70Play Video |
User Forms: Calculations (Part III)Explains how to perform a calculation within a user form in VBA. |

Lecture 71Play Video |
User Forms: Multiple Inputs (Part IV)Uses inputs from multiple user forms to perform a calculation. |

Lecture 72Play 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 73Play Video |
User Forms: Example 1 (Part VI)Develops a user form in VBA to calculate taxes given income and marital status. |

Lecture 74Play Video |
Excel User Form: Heat Exchanger Cost EstimatorUses 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 75Play Video |
Arrays in VBAExplains how to manipulate arrays using VBA. |

Lecture 76Play Video |
VBA Subs and Functions with ArraysExamples of how to write subroutines involving arrays in Excel using Visual Basic for Applications. |

Lecture 77Play Video |
Bisection Method in VBADemonstrates how write VBA code to solve a problem using the bisection method. |

Lecture 78Play Video |
Changing Units in an EquationDemonstrates how to convert the Arrhenius equation from SI to English units. Reviewed by faculty from other academic institutions. |

Lecture 79Play Video |
Windows 7 IntroductionIntroduction to the Windows 7 operating system. |

Lecture 80Play 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 81Play Video |
Numerically Solve ODEs with Mathematica (Part II)Uses the solution from the Mathematica 1 screencast to show how to format a plot. |

Lecture 82Play Video |
Plot Equations with MathematicaShows 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 83Play Video |
Multiple Steady-States in a CSTR with Interactive SimulationPresents 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 84Play Video |
Creating Interactive Simulations in MathematicaDemonstrates 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 85Play Video |
Non-Linear Regression in MathematicaDemonstrates how to use non-linear regression in Mathematica to determine kinetic parameters. Uses the NonlinearModelFit function in Mathematica. |

Lecture 86Play Video |
Basic Subroutine in VBACreates a basic subroutine in VBA to perform simple calculations. |

Lecture 87Play Video |
Creating a Scatter Plot Using Regression AnalysisPlots experimental and theoretical data using regression analysis. |

Lecture 88Play Video |
Dynamic Naming of Arrays in ExcelShows how to dynamically name arrays in Excel using the vlookup function and the offset function. |

Lecture 89Play Video |
VBA: Coding Do LoopsCodes different types of do loops in VBA. |

Lecture 90Play Video |
VBA: Data ExtractionShows how to extract data from multiple Excel files using VBA. |

Lecture 91Play Video |
VBA: Do Loop ExampleExample of input validation using the do loop function in VBA. |

Lecture 92Play Video |
VBA: For-Next LoopExplains for-next loops in VBA for fixed iterations. |

Lecture 93Play Video |
VBA: Two-Way If ThenExample of a simple two-way if then statement in VBA. |

Lecture 94Play Video |
VBA Macros: Relative vs. Absolute ReferencingCompares relative and absolute referencing when recording a VBA macro. |

Lecture 95Play Video |
VBA: For-Next Loop ExamplesExamples of iterating through vectors and arrays in VBA using for-next loops. |

Lecture 96Play Video |
VBA: One-Way If ThenSimple example of the one-way if then function in VBA. |

Lecture 97Play Video |
VBA: Performing String SearchesDescribes how to perform string searches in Excel using VBA. |

Lecture 98Play Video |
VBA: User-Defined FunctionsExample of how to create a user-defined function in VBA. |

Lecture 99Play Video |
Simple VBAs from ScratchShows several examples of how to write simple subs in Visual Basic for Applications in Microsoft Excel. |

Lecture 100Play Video |
Introduction to Aspen Plus: Choosing a Property MethodIntroduces Aspen Plus and describes the various property methods available. |

Lecture 101Play Video |
Introduction to Aspen Plus: Building a Flow SheetDemonstrates how to build a flowsheet in Aspen Plus by modeling a two-stream heat exchanger. |

Lecture 102Play Video |
Introduction to Aspen Plus: Data Input & Running the SimulationExplains 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 103Play Video |
Introduction to Aspen Plus: Convergence & Presentation of ResultsProvides 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 104Play Video |
Introduction to Aspen Plus: Chlorobenzene PlantApplies the fundamentals discussed in the Introduction to Aspen Plus screencasts to a industrially relevant chlorobenzene plant. |

Lecture 105Play Video |
Aspen Plus: Reactor TypesProvides an overview of the various types of reactor simulator blocks found in Aspen Plus. |

Lecture 106Play Video |
Aspen Plus: Reactor Example ProblemDemonstrates the use of reactor models through an example problem on the production of ethyl acetate in Aspen Plus. |

Lecture 107Play Video |
Aspen Plus - Reactors: Chlorobenzene PlantApplies the concept of reactors to the chlorobenzene plant simulation developed in the screencast "Introduction to Aspen Plus: Chlorobenzene Plant." |

Lecture 108Play Video |
Aspen Plus: Flash SeparatorsDemonstrates a flash separator model in Aspen Plus. |

Lecture 109Play Video |
Aspen Plus: DSTWUExplains how to use a DSTWU separator model in Aspen Plus. |

Lecture 110Play Video |
Aspen Plus: RadFracRefines the DSTWU model from the screencast "Aspen Plus: DSTWU" using a RadFrac model in Aspen Plus. |

Lecture 111Play Video |
Aspen Plus - Separators: Chlorobenzene PlantApplies the concept of separators to the chlorobenzene plant simulation developed in the screencast "Introduction to Aspen Plus: Chlorobenzene Plant." |

Lecture 112Play Video |
Aspen Plus: Shortcut Heat Exchanger MethodDemonstrates how to use the shortcut heat exchanger method in Aspen Plus. |

Lecture 113Play Video |
Aspen Plus: Detailed Heat Exchanger MethodExplains the detailed heat exchanger method in Aspen Plus. |

Lecture 114Play Video |
Aspen Plus: Double Heater MethodExplains how to use two heater models to simulate a heat exchanger in Aspen Plus. |

Lecture 115Play Video |
Aspen Plus - Heat Exchangers: Chlorobenzene PlantApplies the concept of heat exchangers to the chlorobenzene plant simulation developed in the screencast "Introduction to Aspen Plus: Chlorobenzene Plant." |

Lecture 116Play Video |
Aspen Plus: PumpsExplains how to use a pump simulator block in Aspen Plus. |

Lecture 117Play Video |
Apsen Plus: CompressorsDetails the use of compressors in Aspen Plus. |

Lecture 118Play Video |
Aspen Plus: PipesExplains how to model different types of process piping in Aspen Plus. |

Lecture 119Play Video |
Aspen Plus: ValvesExplains how to simulate a valve in Aspen Plus. |

Lecture 120Play Video |
Aspen Plus - Pressure Changers: Chlorobenzene PlantApplies the concept of pressure changers to the chlorobenzene plant simulation developed in the screencast "Introduction to Aspen Plus: Chlorobenzene Plant." |

Lecture 121Play Video |
Aspen Plus: Chlorobenzene PlantRuns the simulation of a chlorobenzene plant. Check out the previous screencasts in playlist to see how the flow sheet was developed. |

Lecture 122Play Video |
Aspen Plus: Chlorobenzene Plant CostDemonstrates an economic analysis of a chlorobenzene plant designed in Aspen Plus. Analysis done using Microsoft Excel. |

Lecture 123Play 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 124Play Video |
Laplace Transforms: Real Translation TheoremExplores dead time in the Laplace domain and the usage of the real translation theorem. |

Lecture 125Play Video |
Laplace Transforms: GraphsConverts a graphical function in the time domain into the Laplace domain using the definition of a Laplace transfer. |

Lecture 126Play Video |
Combo Boxes in ExcelUses Visual Basic for Applications (VBA) and Microsoft Excel software to code combo boxes. |

Lecture 127Play Video |
Binomial DistributionDerives binomial distribution for data analysis and gives an example. |

Lecture 128Play Video |
Geometric DistributionDerives geometric distribution for data analysis and gives an example. |

Lecture 129Play Video |
Negative Binomial DistributionDerives the negative binomial distribution for data analysis and gives an example. |

Lecture 130Play Video |
Hypergeometric DistributionDerives the hypergeometric distribution for data analysis and gives an example. |