BAElogo
BAE 200: COMPUTER METHODS IN BIOLOGICAL ENGINEERING
Instructor: Dr. Mike Burchell












Fall 2009: Tentative Lecture and Lab Schedule 
Week
Lecture Lab
1
None
8/20/09 - Class introduction, Syllabus, Computer resources (logging in, email, course web resources)
Lab 1 Class Intro
Computing Resources
2
8/25/09
-Introduction to Engineering Problem Solving  - Approaches and Tools
(Engineering Computations - Chapter 1)
Week 2 Class Lecture

8/27/09 -
Introduction to problem solving, importance of units, significant figures review, and engineering communication
(Engineering Computations - Chapter 1)
BAE focus areas - Water Resources and Bioprocessing
Week 2 Lab Lecture       Week 2 Lab Worksheet       Week 2 Lab Hwk
3 9/01/09 - Introduction to MATLAB  Environment
(Engineering Computations -
Chapter 1 sections 1.3.2-1.3.3
Chapter 3 sections 3.1-3.3)

Week 3 Class Lecture

9/03/09
-MATLAB  Lab Exercises - Solving Simple Engineering Problems 
(Engineering Computations - Chapter 3)
Week 3 Lecture and Activities                Week 3 Lab Hwk
4
9/08/09
-MATLAB
User defined functions, relational and logical operators,  if, else, and elseif statements
(Engineering Computations - Chapter 3 and 4)
Week 4 Class Lecture

9/10/09
-MATLAB  Lab Exercises -  User defined functions, relational and logical operators,  if, else, and elseif statements
(Engineering Computations - Chapter 3, 4, and 5)
Week 4 Lab Lecture and Activities               Week 4 Lab Hwk
F_C Program and Function
BAE focus area -  Stormwater Engineering

5
9/15/09
-MATLAB  -  Programming - Looping
(for and while loops)
(Engineering Computations - Chapter 4)
Week 5 Class Lecture

9/17/09
-MATLAB  Lab Exercises - Programming using Loops (reference Plotting)
(Engineering Computations - Chapter 4 and 5)
Week 5 Lab  Homework Hints                      Week 5 Lab Hwk

BAE focus area -  Bioprocessing

6
9/22/09
-MATLAB  
Matrices and solving simultaneous equations
(Engineering Computations - Chapter 7 and 8)
Week 6 Class Lecture

9/24/09
-MATLAB  Lab Exercises - Matrix computations, solving simultaneous equations, and interpolation
 (reference Functions and Plotting)
(Engineering Computations - Chapter 7 and 8)
Week 6 Lab Excercises      Week 6 Lab Hwk

7

9/29/09
-MATLAB

Week 7 Example Program - Combining for loops and conditional statements

Test 1 Review



10/01/09
-  Introduction  to TK Solver (Tutorial Video)

Week 7 Lab Excercises

Week 7 Introduction to TK Solver (Reference ONLY)

NO LAB HOMEWORK
8

10/06/09
TEST 1 - Engineering problem solving and MATLAB

10/08/09 No Lab - Fall Break
9
10/13/09

Dr. Grant Ellington
Traction and Tractor Drawbar Power
(BAE - 1/4 scale tractor team)
Week 9 Class Lecture


10/15/09
-TKSolver  -   Iterative Solutions
Traction and Tractor Drawbar Power
Week 9 Homework


10 10/20/09 -  Introduction to Excel 2007
(Engineering Computations - Chapter 2)

Week 10 Class Lecture

Week 10 Class Activity Sheet

Class Excel Spreadsheet
(download to your laptop!)


10/22/09 - Excel 2007 Lab exercises - Using the Ribbon, Formatting,  Naming cells, Manipulating data, Printing and Plotting
(Engineering Computations - Chapter 2 and 5)

        
Week 10 Activities                                   Week 10 Homework
              Week 10 Spreadsheet                            Week 10 Raw Data

BAE focus area - Coastal Stormwater Engineering
11
10/27/09
- Excel 2007 Functions
(Engineering Computations - Chapter 2)

Week 11 Class Lecture
Week 11 Pre-lab Activities




10/29/09
- Excel 2007 Lab exercises - Using Excel Functions, Operators and Plotting  (Engineering Computations - Chapter 2 and 5)

Week 11 Homework

BAE focus areas -  Stormwater Engineering and Bioprocessing
12
11/03/09
- Excel 2007  Statistics
 
Dr. Tom Whitaker

Sampling methods and data analysis used in determining Aflatoxin contamination of agricultural commodities
Week 12 Guest Lecture
Week 12 Activity Spreadsheet

11/05/09
- Excel 2007 Lab exercises - Statistics

Guest lecturer - Mr. Andy Slate

Week 12 Homework
Excel Sampling Spreadsheet
Helpful Plotting Hints

BAE focus area - Food Safety and Biohazard Control
13
11/10/09
- Excel 2007
Dr. Linguan Wang
Air Quality Concerns of Particulate Matter
Week 13 Guest Lecture


11/12/09
- Excel 2007 Lab exercises - Log-normal distributions used in determining air quality particle size distributions
Week 13 Homework
Week 13 Lab Template

BAE focus area - Air Quality

Test 2 Review

14 11/17/09 - TEST 2 - TK Solver and Excel 2007

11/19/09
- Excel 2007 Lab exercises - Tables, Pivot Tables, and Pivot Charts
Week 14 Activities
Week 14 Activity Excel Data
Week 14 Homework
Week 14 Homework Excel Data
15

11/24/09
Excel 2007 Utilizing Solver
 (Engineering Computations - Chapter 8)
Week 15 Lecture
Week 15 Homework
Week 15 Excel Template
11/26/09 - No Lab Thanksgiving
16
12/01/09
Week 16 Guest Lecture
Demo Excel Workbook
Dr. Rod Huffman
Recorded Macros and Programming with VBA


12/03/09
Lab Practical -
Programming with MATLAB, TK Solver
and Excel 2007
17
12/08/09 Course Wrap-up and Lab Practical discussion
No Lab - Final Exams
Final Exam 12/15/09 8:00-11:00 - FINAL EXAM (3 hours)