CEE 3804

Computer Applications in Civil Engineering

Syllabus

Dates	Topics Covered	Lectures	Reading	Practice Files
Week 1	Computers as Engineering Tools Review of computer basics Problem solving	Lecture 1: Course Introduction and Logistics Lecture 2: Brief History	Notes 1 - Course Introduction Notes 2 - Computer Arithmetic Notes 3 - Excel Review Quick Links Computer History Museum Supercomputer List and Rankings (Top500) Virginia Tech System X Cluster Virginia Tech Advanced Research Computing	Taylor series expansion file Car data Autobahn data Grades_file (practice vlookup)
Week 2	Excel (Functions in Excel)	Lecture 3: Computer Arithmetic and Excel Basics Lecture 4: Excel Basics: Part 2 Lecture 5: Excel Functions	Notes 4 - Excel Data Handling and Pivot Tables	Concatenation example ACME Company loan example Classification example Pavement Thickness example Construction assets_cat   Construction_firm Trucks_maint_cost Airports_data US_Population Database_practice
Week 3	Excel (Functions in Excel)	Lecture 6: Excel Pivot Tables and Charts Lecture 7: Excel Database Functions	Notes 5 - Optimization (General) Notes 6 - Minimization Problems Notes 7 - Excel Solver and Optimization	Osaka Bay Problem gps_data file Lake_Pollution_Control Minimum of a Function Airline_Fleet_Assignment
Week 4	Advanced Excel routines in problem solving Optimization	Lecture 8: Linear Programming and Optimization: Part 1 Lecture 9: Linear Programming and Optimization: Part 2 Lecture 10: Linear Programming and Optimization: Part 3 (Minimization Problems)	Notes 7.5 - VBA Basics Notes 8 - VBA and Macros	AddTwoNumbers AddTwoNumbers_Box SimpleLoop LoopAndConcatenation ConstructionEquipment1_blank ConstructionEquipment2_blank
Week 5	Basic programming principles	Lecture 11: VBA: Part 1 Lecture 12: VBA: Part 2 Lecture 13: VBA: Part 3 Lecture 14: VBA: Functions and Subroutines Lecture 15: VBA: Subroutine Examples Lecture 16: VBA: User Interfaces	Notes 9 - Data Types and Language Fundamentals Notes 15 - GUI and Interfaces	Pavement_Thickness_Function Modified_Kicker_Subroutine Kicker_withDeclarations Kicker_with AngleTable Kicker_withCrudePlot CPUTime No Declarations CPUTime with Declarations Boolean Demo Use of VarType Function Passing By Value or Reference Runway Capacity File kicker_withControls.xls Kicker with Controls 2 Kicker with Controls 3
Week 6	Variables, Data Types and Subroutines in VBA Crude Graphic User Interface (Form)	Lecture 17: Matlab Introduction Lecture 18: Matlab Basic Vector Calculations and Branching Example Lecture 19: Matlab Basics Lecture 20: Matlab Input and Output Methods Lecture 21: Matlab Input and Output Methods Part 2 Lecture 22: Matlab Input and Output Methods Part 3 Lecture 23: Matlab Input/Output Methods Part 4	Notes 10 - Introduction to Matlab Additional LP Practice (with Matlab) Practice Problem Link to CHM Magnetic Tapes	Input File Examples GPS Data Analysis (.m file) GPS Data File 1 (text file) GPS Data File 2 (text file) Read data using Textscan Bridges of the world (text file) Read Excel data using xlsread Bridges of the world (Excel file) Analysis of Bridges of the World Output File Examples Save to Binary Example (SAVE) Save to Excel Example (XLSWRITE) for Windows Save to Excel Example (XLSWRITE) for Macintosh Export to Excel using Writetable command (new and preferred method) Save to Text File Example (FPRINTF) Save to ASCII fomat (DLMWRITE) Sample Data Files Rainfall rate data Traffic flow data Runway occupancy data Flexural strength data
Week 7	Matlab as computing engine General functionality Scalar and array operations Plot capabilities Scripts	Lecture 24: Matlab Vector Operations and Plots Lecture 25: Matlab Plots (Part 2)	Notes 11 - Matrices in Matlab	MatrixOperations_Practice.m beamCalculationExample.m std_for_loop.m array_prealloc.m vector_ops.m Beam_problem_PointLoad_ForLoop.m sample2d_comet.m sample2d_graphs.m subplot_demo.m gtext_demo.m sample3d_graphs.m sample3d_stem.m sample3d_plot3.m traffic
Week 8	Linear equations and applications to engineering problems Matrix computations
Week 9	Creating Matlab Functions	Lecture 26: Matlab Functions Lecture 27: Matlab Functions (Part 2)	Notes 12 - Functions in Matlab	pavement_cbr.m thickness_plot.m thickness.m normalDist_Analysis.m normal mach.m isam.m atmosphere cantileverBeam.m callingCantileverBeam.m speedDistanceCalculator.m callingSpeedDistanceCalculator.m
Week 10	Decisions and Loops in Programming		Notes 12.5 (TBC)
Week 11	More on functions	Lecture 28: Matlab Curve Fit and Polynomials Lecture 29: Matlab Numerical Integration	Notes 13 - Advanced Functions in Matlab (updated 2020) Basic Regression in Matlab and Excel	Sample Friction Data Interpolation Example Car data Numeric file StudyAircraftData Aircraft data numeric file demo_for_Meshgrid Area Under_Runoff_function Runoff_function Runoff Calculation using theTrapezoidal Rule (Matlab)
Week 12	Numerical Integration Numerical Differentiation	Lecture 30: Matlab Ordinary Diff. Equations Lecture 31: Matlab Ordinary Diff. Equations (Part 2)	Notes 8 - Numerical Integration Article on Semi-active Tuned Mass-Dampers	Numerical_Integration_Samples (Excel) Matlab_Integration_Sample Matlab_Function (for Integration Sample) Trapezoidal Rule (Matlab) HS train analysis (Matlab) trainDynamics (Matlab function) Mass-spring system function for Mass-Spring system
Week 13	Solving Differential Equations Simulink	Lecture 32: Matlab Simulink (Part 1) Lecture 33: Matlab Simulink (Part 2) Lecture 34: Matlab Simulink (Examples 1) Lecture 35: Matlab Simulink (Examples 2)	Notes 14 - Differential Equations / Simulink Notes 14.5 - Applications of Simulink	cooling.m ftemp.m  Highway Investment Model Files Highway_3.m fhwy3_rev.m InClass_Practice_Simulink_Model Car_following_Model.slx Runway_Arresting_System.mdl WaterControlModelBaseline.slx WaterControlModel_variableDemand.slx
Week 14	Structures and Databases	Lecture 36: Matlab Data Structures (Part 1) Lecture 37: Databases (Part 1) Lecture 38: Databases (Part 2) Review of Exam 2	Matlab Data Structures Matlab Data Structures (2)	Read data using Textscan Bridges of the world (text file) Read Excel data using xlsread Bridges of the world (Excel file) Airport Struct File USA Map file Flight Plan structure file (mat) Manipulating struct files sample Manipulating flight plan data file Database_practice (car data file)
Week 15	Databases	Lecture 39: Databases (Part 3 MS Access Example) Lecture 40: Databases (Part 4 MS Access Example) Lecture 41: Final Remarks	Database Notes 1 Database Notes 2 Database Notes 3 Closing Remarks	Sample Database (MyBooks) Completed MyBooks v3 Sample Excel Table (Airports) Sample Excel Table (Runways) Construction assets_cat
Week 16	Final Exam		Per Virginia Tech Schedule	May 3, 2024 (Between 10:05 AM and 12:05 PM ) Section 09M