Use the linked files below to complete Excel Assignment 2, due per the class schedule. Complete these in the order they are listed:

https://elearning.mines.edu/courses/11613/files/593894/download?verifier=UMSavIxyA4ejhgZVRfudJYRtbJkw1Ou4O2hItiLY&wrap=1

https://elearning.mines.edu/courses/11613/files/593886/download?verifier=lm1ySCXLdam6OvAXZkIaEV9OiAmFEMTazDreupbi&wrap=1

Submit your homework as a single MS Word DOC or DOCX upload onto Canvas of the two worksheets, requiring copy-pastes from Excel to the document.

Rubric

Excel2 (Beam Deflection & Revenue and Expenses)

Excel2 (Beam Deflection & Revenue and Expenses)

Criteria Ratings Pts This criterion is linked to a Learning OutcomeBEAM: Equation From Cell E6 1.0 pts Equation From Cell E6 Correct and in Correct Excel Syntax 0.0 pts Incorrect Equation and/or Incorrect Syntax 1.0 pts This criterion is linked to a Learning OutcomeBEAM: Equation From Cell F6 1.0 pts Equation From Cell F6 Correct and in Correct Excel Syntax 0.0 pts Incorrect Equation and/or Incorrect Syntax 1.0 pts This criterion is linked to a Learning OutcomeBEAM: Chart Title 0.5 pts Descriptive Chart Title 0.0 pts Incorrect Equation and/or Incorrect Syntax 0.5 pts This criterion is linked to a Learning OutcomeBEAM: X-Axis Label 0.5 pts X-Axis Label Present AND WITH Units 0.0 pts No Label OR No Units 0.5 pts This criterion is linked to a Learning OutcomeBEAM: Y-Axis Label 0.5 pts Y-Axis Label Present AND WITH Units 0.0 pts No Label OR No Units (unless already deducted for No Units previously) 0.5 pts This criterion is linked to a Learning OutcomeBEAM: Legend & Labels 0.5 pts Legend and Descriptive Labels Present 0.0 pts Labels Not Descriptive or Not Present or No Legend 0.5 pts This criterion is linked to a Learning OutcomeBEAM: Plot & Line Types 0.5 pts Correct Plots of Both Series, Unique Line Types 0.0 pts Incorrect Plot OR Line Types Not Distinct 0.5 pts This criterion is linked to a Learning OutcomeBEAM: Data / Calculations Provided 0.5 pts Data / Calculations Columns Pasted From Spreadsheet 0.0 pts Data / Calculations Columns Missing 0.5 pts This criterion is linked to a Learning OutcomeREV & EXP: Revenue & Expenses Plot 1.0 pts Correct Dependent vs Independent Variables, Axes Labels & Units, Descriptive Title, Descriptive Legend Labels, Unique Line Types with Data Markers 0.5 pts One Error 0.0 pts More than one incorrect item 1.0 pts This criterion is linked to a Learning OutcomeREV & EXP: Profit Plot 1.0 pts Correct Dependent vs Independent Variables, Axes Labels & Units, Descriptive Title, Descriptive Legend Labels, Unique Line Types with Data Markers, Profit Calculation 0.5 pts One Error 0.0 pts More than one incorrect item 1.0 pts This criterion is linked to a Learning OutcomeREV & EXP: Bar Chart of Revenue & Expenses 1.0 pts Axes Labels & Units, Descriptive Title, Descriptive Legend Labels 0.5 pts One Error 0.0 pts More than one incorrect item 1.0 pts This criterion is linked to a Learning OutcomeREV & EXP: Bar Chart of Profit Over Time 1.0 pts Axes Labels & Units, Descriptive Title, Descriptive Legend Labels 0.5 pts One Error 0.0 pts More than one incorrect item 1.0 pts This criterion is linked to a Learning OutcomeREV & EXP: Questions 1.0 pts All Three Questions Answered Correctly 0.5 pts One Error 0.0 pts More than one incorrect item 1.0 pts Total Points: 10.0