Practical Example: Spreadsheets (Excel) in Engineering
Designing a Concrete Mix Proportioning Spreadsheet
Problem Statement: An engineer needs to design a spreadsheet to automatically calculate the required weight of water, cement, fine aggregate, and coarse aggregate for 1 cubic meter of concrete based on a given water-cement ratio and absolute volume method.
Step-by-Step Solution
0 of 4 Steps Completed1
Practical Example: Introduction to MATLAB
Solving a System of Linear Equations for Truss Analysis
Problem Statement: Use MATLAB to solve a system of linear equations representing the joint forces in a simple 2D truss. The system is , where is the coefficient matrix, is the load vector, and is the unknown member forces.
Step-by-Step Solution
0 of 3 Steps Completed1
Practical Example: SDLC & Version Control
Using Git for Collaborative Structural Software Development
Problem Statement: Two software engineers are collaboratively writing a new Python module to calculate beam deflections. Explain how they use Git (Version Control) to manage changes without overwriting each other's work.
Step-by-Step Solution
0 of 3 Steps Completed1
Practical Example: Spreadsheets for Earthwork
Earthwork Volume Calculation in Excel
Problem Statement: Calculate the volume of "Cut" and "Fill" using the Average End Area Method across a distance of 20 meters, given two stations
A and B with respective cut and fill areas.Step-by-Step Solution
0 of 4 Steps Completed1
Practical Example: MATLAB Scripting
Plotting Data in MATLAB
Problem Statement: Write a simple MATLAB script to generate and plot a sine wave over a 10-second interval.
Step-by-Step Solution
0 of 2 Steps Completed1