| 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 lecture | HW-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
|
|
|
|
|
|
|