Online Strength of Materials, Excel tutor - Summerstrand, South Africa - TeacherOn

Description

Create an Excel spreadsheet for analyzing beam shear force and bending moment.

Your task includes designing input prompts for variables such as beam dimensions, loads, and moments, with clear instructions and a visual representation of the beam diagram.

The spreadsheet should calculate and graph shear force and bending moment along the beam length, ensuring around 50 data points for accuracy.

Skills required:
Proficiency in Excel for data input, calculation, and graphing.
Understanding of beam mechanics, including reactions, shear force, and bending moment.
Ability to interpret and compare graphs.

Communication:
Clearly label input prompts and graph axes for user understanding.
Provide detailed instructions for entering data and interpreting results.
Include a separate text description explaining the approach used for problem-solving.

Work methodology:
Utilize basic Excel functions without external scripts.
Divide the beam into length increments for precise calculations.
Label key points of interest on graphs, including reactions, maximum/minimum values, and discontinuities.
Ensure graphs adjust automatically based on input values for versatility and accuracy.
Additionally, compare results with an online calculator by including screenshots of inputs, outputs, and graphs in a separate sheet for validation


Level:
Bachelors/Undergraduate


Gender Preference:
None


Meeting options:
Available online - via skype etc.