Copy of Lab 5 - Energy and Work - Rubric
pdf
keyboard_arrow_up
School
University of Massachusetts, Amherst *
*We aren’t endorsed by this school
Course
151
Subject
Mathematics
Date
Feb 20, 2024
Type
Pages
4
Uploaded by ConstableWorldAardvark38
Lab 5 - Energy and Work - Rubric [28
points total]
1.
[1 point] Use Eqs (1) and (7) to derive an
algebraic
expression relating the work done on
the iOLab to the velocity of the iOLab.
K = ½ mv^2
W = ∆k = kf - ki = ½ mfvf^2 - ½ mfvf^2
mf = mi
W = 1/2mvf^2 - 1/2mvf^2 = 1/2m(vf^2-vi^2)
Excellent
Poor
Correct algebraic expression relating the
work to the change in velocity.
1 point
missing or nonsense algebra.
0 points
2.
[10 points, 1 point per recorded measurement] Record your measurements of force,
displacement, and velocities in the Google Sheet Lab 5 - Energy and Work - Student
Copy. The values of force will all be the same because the force is constant.
3.
[2 points] Calculate the velocity squared in the spreadsheet:
a.
In cell D2 enter the equation =C2*C2.
b.
Use the autofill to complete the rest of the calculations.
Excellent
Poor
Correct value is present in the spreadsheet.
2 points
missing or nonsense values.
0 points
4.
[2 points] Calculate the work in the spreadsheet:
a.
In cell E2 enter the equation =A2*B2.
b.
Use the autofill to complete the rest of the calculations.
Excellent
Poor
Correct value is present in the spreadsheet.
2 points
missing or nonsense values.
0 points
5.
[3 points] Make a scatter plot of work vs. velocity squared.
a.
Click on the top of the column with Velocity Squared (m/s)^2 values (Column D).
b.
Press and hold the Ctrl key and click on the top of the column with the Work (J)
values (Column E).
c.
Release Ctrl key and open the Insert menu and select Chart.
d.
The Charter Editor will open. In Setup choose Chart Type > Scatter Chart,
e.
Make sure X-axis indicates Velocity Squared (m/s)^2
f.
Make sure the Series indicates IWork (J). If Velocity Squared (m/s)^2 is in the
Series remove it.
g.
In Customize > Chart & axis titles add axes titles with units to your graph.
h.
Copy and paste your plot into this document below here:
Excellent
Good
Need Work
Poor
Complete and correct
graph with correct
axis labels/units.
3 points
Mostly Correct graph
with axis labels/units.
Minor errors or
missing features.
2 points
Incomplete graph
with major error or
missing features.
1 point
Incorrect graph or
missing.
0 points
6.
[3 points] Look closely at your graph of work vs. velocity squared and you will see it
should be linear. What does the slope of work vs. velocity squared represent? Hint: look
back at your answer to question 4.
Work vs Velocity is basically half the mass and it represents the acceleration of the object. This
relationship has a relation to graph 4 as equation shows work and involves variables related to
velocity.
Excellent
Good
Needs work
Poor
Clearly identifies the
relationship between
work and velocity
squared and
connects the
relationship to
answer to question 4.
3 points
Identifies the
relationship between
work and velocity
squared with minor
inconsistencies
connecting the
relationship to
answer to question 4.
2 points
Inconsistency
Identifying the
relationship between
work and velocity
squared with major
inconsistencies
connecting the
relationship to
answer to question 4.
1points
Not attempted or
unclear rambling.
0 points
7.
[2 points] Use the built in function LINEST to determine the best slope of work vs.
velocity squared.
a.
In an empty cell G2 enter =LINEST(range of y,range of x,1,1).
b.
The range of y should be the range of cells with the values of work in Column E.
c.
The range of x should be the range of cells with the values of velocity squared in
Column D.
Excellent
Needs work
Poor
Correctly uses LINEST().
2 points
Incorrectly uses LINEST().
1 point
Missing or nonsense
calculation.
0 points
8.
[1 point] Calculate the t-score for your measured value of the mass. Your calculation
should be done in your spreadsheet. Remember the t-score should be a positive
number, so use the function ABS(
-
) in your calculation.
t-score
0.5426
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
9.
[1 point] Calculate the probability
using =T.DIST.2T( ,
) using your values of the
t-score
and
.
p-value
0.6022
10. [3 points] Compare the mass of your iOLab with the best fit slope you found from the
LINEST analysis in question 10. Do the two values agree with each other? Explain your
reasoning.
The mass of iolab is 0.207 and the best fit slope from linest is 0.231. I believe that these two
values are somewhat similar and close to each other.
Excellent
Good
Needs work
Poor
Clear and complete
comparison of the
two measurements of
mass and
explanation of
agreement/disagree
ment with each other.
3 points
Unclear OR
incomplete
comparison of the
two measurements of
mass OR explanation
of
agreement/disagree
ment with each other.
2 points
Unclear AND/OR
incomplete
comparison of the
two measurements of
mass AND/OR
explanation of
agreement/disagree
ment with each other.
1 point
Not attempted or
unclear rambling.
0 points