Course Information

Course

Subject:	Chemical Engineering
Views:	260,588

Educator

Name:	University of Colorado (University of Colorado)
Type:	University

Visit Official Website

Please support this content provider by Donating Now

Donate to University of Colorado

Engineering Computing

Video Lectures

Displaying all 130 video lectures.

Lecture 1 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 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 Play Video	Excel Solver: Introduction Describes how to use the solver function in Excel 2010.
Lecture 4 Play Video	Excel: Bisection Introduction Introduces the bisection method and how to perform bisection in Excel 2010.
Lecture 5 Play Video	Excel: Bisection Example An example of how to use bisection to find the root of an equation using Excel 2010.
Lecture 6 Play Video	Excel: Bisection Live Method Instead of using Solver for a large data array, the bisection live solution method is utilized.
Lecture 7 Play Video	Excel: Iterative Solutions Explains how to solve an equation using an iterative approach in Excel 2010.
Lecture 8 Play Video	Excel: Goal Seek Introduction Explains how to use goal seek in Excel 2010.
Lecture 9 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 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 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 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 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 Play Video	Excel: Simpson's Rule Use Simpson's rule in a spreadsheet to calculate the integral for a set of data.
Lecture 15 Play Video	Euler Method for ODEs Demonstrates how the Euler method is used to solve ordinary differential equations (ODEs).
Lecture 16 Play Video	Excel/Matlab: Euler Method Explains the Euler method and demonstrates how to perform it in Excel and Matlab.
Lecture 17 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 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 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 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 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 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 Play Video	Excel: Regression Fitting (Part I) Explains how to set up regression calculations in Excel 2010 for a simple function.
Lecture 24 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 Play Video	Excel: Multiple Regression Explains how to use multiple regression in Excel 2010.
Lecture 26 Play Video	Matlab: Model Fitting and Regression Demonstrates how to model a curve and perform regression in Matlab.
Lecture 27 Play Video	Matrices Introduction (Part I) An introduction to matrices.
Lecture 28 Play Video	Matrix Addition and Subtraction (Part II) Explains elemental addition and subtraction of matrices.
Lecture 29 Play Video	Matrix Multiplication (Part III) Demonstrates how to multiply matrices.
Lecture 30 Play Video	Matrix Transpose and Determinants (Part IV) Demonstrates how to transpose matrices and calculate determinants.
Lecture 31 Play Video	Matrix Inverse (Part V) Demonstrates how to calculate the inverse of a matrix and how to use it.
Lecture 32 Play Video	Excel: Matrix Math (Part I) Explains how to name matrices (arrays) and presents simple array calculations.
Lecture 33 Play Video	Excel: Matrix Math (Part II) Explains how to use the built-in functions for matrix (array) math in Excel 2010.
Lecture 34 Play Video	Excel: Array Formulas Shows how to use array formulas in Excel 2010 to perform matrix calculations.
Lecture 35 Play Video	Introduction to Matlab Demonstrates several ways to solve a derivative using Matlab.
Lecture 36 Play Video	Matlab: Basic Functions Overview of common functions used in Matlab programming, including trigonometric and array functions.
Lecture 37 Play Video	Matlab: Plots Describes how to use Matlab to graph equations and experimental data.
Lecture 38 Play Video	Matlab: Files and Functions Shows how to use m-files, anonymous functions, and user defined functions in Matlab.
Lecture 39 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 Play Video	Matlab: Solver Functions Shows how to combine arguments with solver functions in Matlab to simplify repetitive calculations.
Lecture 41 Play Video	Matlab: Programming Structures Describes different programming structures used in Matlab.
Lecture 42 Play Video	Introduction to Excel (Part I) An introduction to using Excel 2010 -- formatting and manipulating of cells is explained.
Lecture 43 Play Video	Introduction to Excel (Part II) An introduction to using Excel 2010 -- file menu is explained.
Lecture 44 Play Video	Introduction to Excel (Part III) An introduction to using Excel 2010 -- the use of tabs in the ribbon are explained.
Lecture 45 Play Video	Importing Data into Excel Demonstrates how to import data into Excel 2010.
Lecture 46 Play Video	Data Tables in Excel Explains how to use data tables in Excel 2010 when only one variable is changing.
Lecture 47 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 Play Video	Formatting Numbers in Excel Demonstrates several ways to format numbers in Excel 2010.
Lecture 49 Play Video	Naming Cells in Excel Demonstrates how to name cells and manage named cells in Excel 2010.
Lecture 50 Play Video	Formatting in Excel Presents some simple formatting tips for Excel 2010.
Lecture 51 Play Video	Entering an Equation into Excel Explains how to input an equation into Excel 2010 using an engineering example.
Lecture 52 Play Video	Excel: Linearize and Plot Non-Linear Equations Demonstrates how to linearize and plot non-linear equations using Excel 2010.
Lecture 53 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 Play Video	Excel: Scatter Plots Explains how to make a scatter plot using Excel 2010.
Lecture 55 Play Video	Excel: Line Plots Explains how to make a line plot using Excel 2010.
Lecture 56 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 Play Video	Excel: Pie Charts Explains how to make a pie chart in Excel 2010.
Lecture 58 Play Video	Excel: Bar Graphs Explains how to make a bar graph using Excel 2010.
Lecture 59 Play Video	Excel: 3D Plots Explains how to create a three-dimensional surface plot in Excel 2010.
Lecture 60 Play Video	Excel: Trend Lines Explains how to graph trend lines in Excel 2010.
Lecture 61 Play Video	Excel Macros Demonstrates how to use the macro recorder to write a simple program in VBA/Excel.
Lecture 62 Play Video	VBA Basics Introduces how to copy, paste, clear, and assign macros a button using VBA.
Lecture 63 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 Play Video	VBA Programs (Part I) Discusses types of sequence and selection code in VBA.
Lecture 65 Play Video	VBA Programs (Part II) Discusses types of repetition code in VBA.
Lecture 66 Play Video	Message Boxes in VBA Introduction to message boxes in Visual Basic for Applications.
Lecture 67 Play Video	User Forms in Excel A simple user form is created using VBA for Excel 2010.
Lecture 68 Play Video	User Forms: Check Boxes (Part I) The check box control in VBA is demonstrated for Excel 2010.
Lecture 69 Play Video	User Forms: Message Boxes (Part II) The message box function in VBA is explained for Excel 2010.
Lecture 70 Play Video	User Forms: Calculations (Part III) Explains how to perform a calculation within a user form in VBA.
Lecture 71 Play Video	User Forms: Multiple Inputs (Part IV) Uses inputs from multiple user forms to perform a calculation.
Lecture 72 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 Play Video	User Forms: Example 1 (Part VI) Develops a user form in VBA to calculate taxes given income and marital status.
Lecture 74 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 Play Video	Arrays in VBA Explains how to manipulate arrays using VBA.
Lecture 76 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 Play Video	Bisection Method in VBA Demonstrates how write VBA code to solve a problem using the bisection method.
Lecture 78 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 Play Video	Windows 7 Introduction Introduction to the Windows 7 operating system.
Lecture 80 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 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 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 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 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 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 Play Video	Basic Subroutine in VBA Creates a basic subroutine in VBA to perform simple calculations.
Lecture 87 Play Video	Creating a Scatter Plot Using Regression Analysis Plots experimental and theoretical data using regression analysis.
Lecture 88 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 Play Video	VBA: Coding Do Loops Codes different types of do loops in VBA.
Lecture 90 Play Video	VBA: Data Extraction Shows how to extract data from multiple Excel files using VBA.
Lecture 91 Play Video	VBA: Do Loop Example Example of input validation using the do loop function in VBA.
Lecture 92 Play Video	VBA: For-Next Loop Explains for-next loops in VBA for fixed iterations.
Lecture 93 Play Video	VBA: Two-Way If Then Example of a simple two-way if then statement in VBA.
Lecture 94 Play Video	VBA Macros: Relative vs. Absolute Referencing Compares relative and absolute referencing when recording a VBA macro.
Lecture 95 Play Video	VBA: For-Next Loop Examples Examples of iterating through vectors and arrays in VBA using for-next loops.
Lecture 96 Play Video	VBA: One-Way If Then Simple example of the one-way if then function in VBA.
Lecture 97 Play Video	VBA: Performing String Searches Describes how to perform string searches in Excel using VBA.
Lecture 98 Play Video	VBA: User-Defined Functions Example of how to create a user-defined function in VBA.
Lecture 99 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 Play Video	Introduction to Aspen Plus: Choosing a Property Method Introduces Aspen Plus and describes the various property methods available.
Lecture 101 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 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 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 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 Play Video	Aspen Plus: Reactor Types Provides an overview of the various types of reactor simulator blocks found in Aspen Plus.
Lecture 106 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 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 Play Video	Aspen Plus: Flash Separators Demonstrates a flash separator model in Aspen Plus.
Lecture 109 Play Video	Aspen Plus: DSTWU Explains how to use a DSTWU separator model in Aspen Plus.
Lecture 110 Play Video	Aspen Plus: RadFrac Refines the DSTWU model from the screencast "Aspen Plus: DSTWU" using a RadFrac model in Aspen Plus.
Lecture 111 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 Play Video	Aspen Plus: Shortcut Heat Exchanger Method Demonstrates how to use the shortcut heat exchanger method in Aspen Plus.
Lecture 113 Play Video	Aspen Plus: Detailed Heat Exchanger Method Explains the detailed heat exchanger method in Aspen Plus.
Lecture 114 Play Video	Aspen Plus: Double Heater Method Explains how to use two heater models to simulate a heat exchanger in Aspen Plus.
Lecture 115 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 Play Video	Aspen Plus: Pumps Explains how to use a pump simulator block in Aspen Plus.
Lecture 117 Play Video	Apsen Plus: Compressors Details the use of compressors in Aspen Plus.
Lecture 118 Play Video	Aspen Plus: Pipes Explains how to model different types of process piping in Aspen Plus.
Lecture 119 Play Video	Aspen Plus: Valves Explains how to simulate a valve in Aspen Plus.
Lecture 120 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 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 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 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 Play Video	Laplace Transforms: Real Translation Theorem Explores dead time in the Laplace domain and the usage of the real translation theorem.
Lecture 125 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 Play Video	Combo Boxes in Excel Uses Visual Basic for Applications (VBA) and Microsoft Excel software to code combo boxes.
Lecture 127 Play Video	Binomial Distribution Derives binomial distribution for data analysis and gives an example.
Lecture 128 Play Video	Geometric Distribution Derives geometric distribution for data analysis and gives an example.
Lecture 129 Play Video	Negative Binomial Distribution Derives the negative binomial distribution for data analysis and gives an example.
Lecture 130 Play Video	Hypergeometric Distribution Derives the hypergeometric distribution for data analysis and gives an example.