MATLAB & SPREADSHEET APPLICATIONS FOR CIVIL ENGINEERING (1BCVL307A)

MATLAB & SPREADSHEET APPLICATIONS FOR CIVIL ENGINEERING

Course Code 1BCVL307A 
Scheme 2025
Type of Course Ability Enhancement Course (Laboratory)
Semester III
Teaching Hours/Week (L :T : P) 28 (0:0:2) 
CIE Marks 50
Total Hours of Pedagogy CI( L :T):LI(P):SL:TW 30 (0:0:28:2) 
SEE Marks 50
Credits 1 
Total Marks 100
Type of Examination Practical 
Exam Hours 03

SET OF EXPERIMENTS (LI =28 hours)

Students shall perform practical exercises related to:

1. Introduction to MATLAB environment, command window, variables, matrices, and basic plotting.

2. Arithmetic operations, unit conversions, and engineering calculator using MATLAB.

3. Solution of simultaneous equations relevant to structural and water resources problems.

4. Plotting of load–deflection, stress–strain, and discharge–head graphs using MATLAB.

5. Interpolation and curve fitting for civil engineering data.

6. Numerical differentiation and integration for engineering applications.

7. Spreadsheet creation for civil engineering calculations using formulas and cell referencing.

8. Preparation of quantity estimation sheet for a simple building component.

9. Rate analysis sheet for common civil engineering items.

10. Data entry, sorting, filtering, and conditional formatting for field/lab data in spreadsheets.

11. Statistical analysis of test data using spreadsheet functions, averages, standard deviation, and charts.

12. Regression analysis and trendline-based prediction using spreadsheet tools.

Suggested Learning Resources

Text Books

1. Chapra, S. C. Applied Numerical Methods with MATLAB for Engineers and Scientists, McGraw-Hill Education, 4th Edition, 2018.

2. Attaway, S. MATLAB: A Practical Introduction to Programming and Problem Solving, ButterworthHeinemann, 4th Edition, 2019.

3. Bansal, R. K. A Textbook of Engineering Mechanics and Spreadsheet Applications, Laxmi Publications, 1st Edition, 2020.

4. Dhanpat Rai & Company MS Excel for Engineers and Analysts, Dhanpat Rai Publications, 2nd Edition, 2021.

5. Borah, D. Computational Methods in Civil Engineering Using MATLAB, Khanna Publishers, 1st Edition, 2022.

Reference Books

1. Rao, S. S. Numerical Methods for Engineers, Elsevier, 7th Edition, 2018.

2. Kreyszig, E. Advanced Engineering Mathematics, Wiley, 10th Edition, 2011.

3. Dewri, H. Spreadsheet Modeling for Civil and Structural Engineering, McGraw-Hill, 1st Edition, 2020.

4. Chapra, S. C., and Canale, R. P. Numerical Methods for Engineers, McGraw-Hill Education, 8th Edition, 2016.

5. Perry, L. Excel Applications for Engineers, Pearson, 2nd Edition, 201