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 Completed
1

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 Ax=bA\mathbf{x} = \mathbf{b}, where AA is the coefficient matrix, b\mathbf{b} is the load vector, and x\mathbf{x} is the unknown member forces.

Step-by-Step Solution

0 of 3 Steps Completed
1

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 Completed
1

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 Completed
1

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 Completed
1