CIVL 3010 CE ANALYSIS
Course coordinator:  Dr. Prabhakar Clement, Arthur Feagin Chair Professor of Civil Engineering
Room number:  Harbert 212
My webpage:  http://www.eng.auburn.edu/~clemept/
Course information

Why should I take this class, what are the requirements?
  Please click here

Aim: 
This web page provides resources to better understand CE anlayis course material.  Our goal is to teach the basics of computer programming and applied mathematics to model and solve practical engineering problems.  Learning applied mathematics and progamming is good for you.  If, for some reason, you are still wondering why should I learn all these mundane math and computer programming ideas--Please Don't Ask, Just Do It!

How to play the video files?  You can click on the link and if your windows media player is properly installed it should automatically download and play the video.  If it does not play then right click on the link and choose save link as option to save the windows media file (wmv file) in your hard disk and then open it in a video player that can play wmv files.  MAC users should install Flip4MAC to play wmv files.  You can also use Quicktime if you have installed WMV player option in it.  In summary, you can play the video in windows media player, FlipMAC or Quicktime, and they are all free video players. You can Google and find one of these free players on the web.  In rare cases, I have noticed that your player may not buffer properly and you will not be able to fast forward or rewind.  If that happens, right click on the windows media player (some cases need to select tools after the right clicking on top) and go to "more options" and under "Performance" tab you select network buffering buttom and set 5 to 20 seconds or more for buffering.

TO DOWNLOAD ZIPPED VERSION OF THE ENTIRE COURSE (Click here)

Week Videos
PDF files
Week-1
Introduction to EXCEL (power point lecture)
EXCEL ppt slides

How to use EXCEL Solver tool to fit data - EXCEL demo lecture
LAB1/HW1

Hammer and feather falling video
Solver notes


Journal paper



Week-2
Introduction to VB part1 (power point lecture - part 1) VB introduction ppt

Introduction to VB part2 (power point lecture - part 2)Debugging notes

VB Debugging-Part1 - tutorial lecture
LAB-2

VB Debugging-Part 2 - tutorial lectureHW-2



Week-3
Introduction to if-then-else (power point)
If-then & loops ppt

Introduction to Loops - part-1 (power point)
LAB3

Introduction to Loops - part 2 (power point)
HW3

Loops tutorial problem


Loops & if-then-else tutorial




Week-4
Trapezoidal rule  (powerpoint)
Numerical integral ppt

Simpson's rule (power point)
Lab4

Application to civil engineering problems (power point)
HW4






Week-5
Sub programs/ subroutines (power point)
ppt slides

Functions (power point)
HW5


LAB5



Week-6
Introduction to matrix algebra   (power point)
ppt slides

Matrix operation using EXCEL (tutorial)
Lab6

Determinant and Cramer's Rule
HW6



Week-7
Introduction to arrays  (power point)
ppt slides

Array vb tutorial-1 Matrix addition
Lab 7

Array vb tutorial-2 - Matrix multiplication with a vector HW7

Array vb tutorial-3 matrix multiplication



Week-8
Gauss Elimination lecture1 (watch before Oct 4th)
ppt slides

Gauss elimination - lecture 2  (watch before oct 4th) Lab/HW8

Using guass elimination code vb lecture (watch before oct 11th) Download Gauss solver




APPLICATIONS

Weeks-9&10
Truss analysis - Basics Lecture 1 (watch before Oct 11th)

Truss analysis - Basics Lecture 2 (watch before Oct 11th)

Truss analysis - Basics Lecture 3 (watch before Oct 11th)

EXAMPLE FOR STIFFNESS MATRIX (Oct 13th class lecture)


MATRIX PARTITIONING (Oct 13th class lecture)

Coding project - Part-1 lecture (watch before Oct 12th)


Part-2 lecture (watch before Oct 12th)

Part-3 lecture (watch before Oct 12th)

Part-4 lecture (watch before Oct 12th)

How to prepare input Example-1 (watch before Oct 18th) Download buggy code

How to prepare inputs examples 2,3,4  (watch before Oct 18th) Two bar HW problem

Details of buggy code (watch before Oct 18th)

Download user manual

Week-11
Non linear equations and applications



Week-12 Numerical soluton to ODEs

Week-13
EXCEL - windows. pop-ups and fun stuff!
Lab handout


Game-1 (tic-tac)


Game-2 (word search)


Sample report