Lecture Help

Back to 303 homepage Excel VBA shortcut

Download FLV player Here to view videos

Flvplayer.doc   Note that I gave it a .doc extension. Save the file to your machine and change the .doc extension to .exe extension. Double-click it and it should extract itself and install.

Some Power Points for your viewing pleasure

A Year in Hungary  Open the file and play the slide show, the music should be familiar. This was a Fulbright year in Hungary mixing business with pleasure.

First Series on Basics

My Spreadsheet Attempt for Analog Models

"Ya know, ladies love wood....." Here is some context for further research (10 minutes each)

Part 1  Part 2  Part 3  Part 4  Part 5   (Right click save-as since they may not run directly from the website

Help with Excel

Need some help with spreadsheets and the like?

Try the Excel VBA bar above

Help with Statistics

This should make you feel better anyway  Torture Numbers PDF

Statistical Tests PDF handout

Statistical tests handout

Statistics tutorial

A pdf document and a separate Excel spreadsheet to accompany it

Statistics tutorial

Statistics Spreadsheet

Steel

Links to the Steelmaking videos from YouTube  for the flash video, you must "Save As" onto your local drive

1. Introduction 2. Raw Materials 3. Blast Furnace 4. Basic Oxygen
5. Secondary 6. Continuous Casting 7. Hot Rolling 8. Seamless Pipe
9. Tubes 10. Cold Bending 11. Cold Sections 12. Cold Rolling
13. Coatings 14. Friction Stir Weld  Samurai Sword 1  Samurai Sword 2
Samurai Sword 3  Samurai Sword 4  Samurai Sword 5  Samurai Record 

 

 

 

 

 

 

A link to corrosion discussion in steel

Corrosion Doctors

Corrosion Modules to look at

Set 1 Introduction        Set 2 Chemistry of Corrosion

Set 3 Corrosion Electrochemistry    Set 4 Corrosion Thermodynamics

Set 5 Corrosion Kinetics        Set 6 Recognizing Corrosion

Set 7 Corrosion Cells            Set 8 Water Corrosion

Set 9 Air Corrosion

US Steel construction of Metal building and roofing basics

Steel Roofs

Welding

Some of the fabrication vids I showed in class

Short PDF on Welding     Fabrication Guide

FCAW system     Flux Core Welding

Python System     Welding for Skyscrapers     Nice little building at UNC-Charlotte

Explosion Welding    Thermite Welding   Induction Welding

Lincoln Electric welding knowledge base for welding information, check it out.

Knowledge | Lincoln Electric

Aluminum

Aluminum Presentations

Aluminum Lecture   LifeCycleCosts

 

Some Aluminum Links for you

Alcan Primary Metal - BC - Homepage

Life-cycle costing analysis

eciv303 Rebitzer-presentation.pdf

Making architechtural models of buildings (I thought it was interesting)

eciv 303 Seely_SM_Thesis.pdf

Aggregates, Rock, Blasting

Here are the blasting videos I showed in class

700 Tonnes     Overburden Shot      Quarry Blast

One additional vid for you Tchikovski fans   Dance of the Detonators

Here are some references/presentations we looked at

Aggregates Lecture          Rock Formation Lecture   

Rock Fragmentation    Questions about rock fragmentation

A very good blasting reference for highway work

FHwA Rock Blasting (38Mbyte PDF)      OhioDOT(3-pager)

Portland Cement Virtual Tour

PCA: Take a Virtual Plant Tour

Concrete

Portland Cement Lecture (ppt)       PC Concrete Mix and Place Lecture

Wood

Wood Lecture(ppt)                        Southern Pine Structural Wood Design

Second Exam Study Guide

Study guide  a work in progess.

Mechanical Properties

Here are some spreadsheets to help out in looking at Stress-Strain behavior

Hyperbolic Curve-Fit

ECIV 303 Soil Stress-strain.xls  (right-click, Save As)

Hyperbolic, Ramberg-Osgood, Behavior

ECIV 303 R-O StressStrain.xls (right-click, Save As)