Q$2(100$ marks$)$

Determine the slope and deflection equations for the beam shown below.

$(50$ marks$)$ Implement these equations in EXCEL in order to determine the rotation and deflection at $0\mathrm{.}2$ metre intervals along the beam. Create an EXCEL plot of the deflected shape of the beam. $(30$ marks$)$ Calculate the rotation in radians at the support points $($A and D$)$ and the maximum deflection in the beam. Compare these hand$-$calculated values to the corresponding EXCEL values.

$(20$ marks$)$

Given: $E=30k\frac{N}{m}{m}^2$ and $I=5{10}^{8}m{m}^4.$