# CBEN460 & CBEN461 Bioprocess Engineering & LAB

Instructor | John Jechura |

Class Semester Class Location Class Hours |
Fall 2017 |

Office Location Office Hours |
AH 437 |

Phone | 303-273-3197 |

Mines e-mail address | |

Syllabus (CBEN 460 Lecture) |

Page Revisions

Lecture topic outline (associated chapters in text; supplemental text will be made available to class).

Introduction & Basics

- Material Properties & Stoichiometry (Chapter 7)
- Solving simultaneous linear equations: use of Cramer's rule & using capabilities in Excel (sample spreadsheet)
- Half reactions
- Transient Material Balances (Chapter 9)
- Energy Balances (Supplemental Chapter 5)
- General notes for transient mass & energy balances
- Physical property data
- Steam tables
- Data Analysis (Supplemental Chapter 3)
- Enzyme Kinetics (Chapter 3)
- Cell Growth & Decay Kinetics (Chapter 6)

- Productivity in Batch & Continuous Bioreactors (Chapter 9)
- Considerations for going between lab & industrial scale of bioreactors (Chapter 10)
- Tank Mixing, Agitation, & Aeration
- Scale-up
- Sterilization
- Physical Processes
- Fluid & Slurry Flow (Supplemental Chapter 7)
- Heat Transfer (Supplemental Chapter 9)
- Mass Transfer & Transport Phenomena (Supplemental Chapter 10)
- Recovery & Purification of Products (Chapter 11 & Supplemental Chapter 11)
- Moisture Content, Drying, & Evaporation
- Filtration & Centrifugation
- Flocculation & Coagulation
- Purification & Recovery Technologies
- Instrumentation & Control (Chapter 10)

Laboratory topics

Extra instructor notes

Useful VBA (Visual Basic for Applications) code (notes for downloading):

- Linear interpolation
- Spline interpolation
- Interpolation of distillation curves internally using the probability function transformation of yield values. Code allows this to be done using linear interpolation or spline interpolation (on a temperature vs. transformed yield basis).

- The code was originally developed to run with Excel 2000. It has been tested & it runs properly with Excel 2007, 2010, & 2013. Here are notes to incorporate the VBA macros into an Excel 2010 spreadsheet. Below are other sites that describe what needs to be done to allow the macros to work.
- http://support.microsoft.com/kb/919195
- http://www.dummies.com/how-to/content/how-to-set-the-macro-security-level-in-excel-2007.html#comments
- There have been issues if one wants to use these macros on a Mac. Excel 2004 has VBA support built-in but Excel 2008 did not. The latest version are supposed to have VBA support.
- If you are using a version of Excel (or some other spreadsheet) that cannot run these macros then here is a sample spreadsheet for doing the interpolation calculations without requiring macros (the user will have to be careful to copy cells with formulas as necessary). There are separate sheets for linear interpolation (arbitrary X & Y values) and interpolation of cumulative yield data (°F vs. yield%).

Homework Assignments

Quizzes

Exams

Return to Top

Useful External Links