ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Pre-Launch Data
2
Air Density (kg/m^3)
yellow means simple data collection or transfer of data
3
Water volume added (mL)
blue means calculation. Enter a formula
4
Dry rocket mass (kg)
5
Insert Vernier Video Analysis Data Here
6
Thrust Video Analysis Data Frame Rate (fps)
7
Numbering from InstructionsQuantity measuredValue (NO UNITS)
8
6Frame Rate (fps -- frames per second)Time, based on Frame RateY positionChange in Y positionMid-Interval Time (s)Average Interval Velocity (m/s)
9
7eY position at time = 0s [Height of Rocket Tip] (m)0NANANA
10
7eVideo frame number at t = 0s#DIV/0!0#DIV/0!0
11
7fFrame number at end of water thrust#DIV/0!0#DIV/0!0
12
7fY Position at end of water thrust#DIV/0!0#DIV/0!0
13
8bVy max -- velocity at end of air thrust -- beginning of coasting phase (m/s)#DIV/0!0#DIV/0!0
14
8cY position at end of air thrust [height of rocket tip] -- beginning of coasting phase (m)#DIV/0!0#DIV/0!0
15
8cTime at end of air thrust -- beginning of coasting phase, from the table (s)#DIV/0!0#DIV/0!0
16
#DIV/0!0#DIV/0!0
17
Problem NumberWater Thrust Phase Calculations and Problems#DIV/0!0#DIV/0!0
18
1Water mass (kg) [In case you haven't taken chemistry, 1L has a mass of 1kg]#DIV/0!0#DIV/0!0
19
2Time at end of water thrust, based on frame number and frame rate (s)#DIV/0!0#DIV/0!0
20
3Average acceleration during air thrust (m/s^2)#DIV/0!0#DIV/0!0
21
4Y displacement during water thrust (m)#DIV/0!0#DIV/0!0
22
5Average velocity during water thrust (m/s)#DIV/0!0#DIV/0!0
23
6Final velocity at end of water thrust (m/s)#DIV/0!0#DIV/0!0
24
7average acceleration during water thrust (m/s^2)#DIV/0!0#DIV/0!0
25
8Total rocket mass just before launch(kg)#DIV/0!0#DIV/0!0
26
9Average rocket mass during water thrust -- assuming, for simplicity, that water flowed out at a constant rate, this is just an average of the rocket's full mass and dry mass (kg)#DIV/0!0#DIV/0!0
27
10Average net force during thrust (N)#DIV/0!0#DIV/0!0
28
11Average rocket weight during thrust (N)#DIV/0!0#DIV/0!0
29
12Average water thrust -- force exerted on rocket by expelled water (N)#DIV/0!0#DIV/0!0
30
#DIV/0!0#DIV/0!0
31
Full Flight Time Data#DIV/0!0#DIV/0!0
32
Numbering from InstructionsEventsElapsed Time (s)#DIV/0!0#DIV/0!0
33
8Rocket reaches apogee (highest point)#DIV/0!0#DIV/0!0
34
8Rocket touches ground#DIV/0!0#DIV/0!0
35
#DIV/0!0#DIV/0!0
36
Descent #DIV/0!0#DIV/0!0
37
4Estimated height at which terminal velocity was reached (m)#DIV/0!0#DIV/0!0
38
4Estimated time at which terminal velocity was reached (s)#DIV/0!0#DIV/0!0
39
4Estimated terminal velocity (m/s)#DIV/0!0#DIV/0!0
40
#DIV/0!0#DIV/0!0
41
#DIV/0!0#DIV/0!0
42
#DIV/0!0#DIV/0!0
43
#DIV/0!0#DIV/0!0
44
#DIV/0!0#DIV/0!0
45
#DIV/0!0#DIV/0!0
46
#DIV/0!0#DIV/0!0
47
#DIV/0!0#DIV/0!0
48
#DIV/0!0#DIV/0!0
49
#DIV/0!0#DIV/0!0
50
#DIV/0!0#DIV/0!0
51
#DIV/0!0#DIV/0!0
52
#DIV/0!0#DIV/0!0
53
#DIV/0!0#DIV/0!0
54
#DIV/0!0#DIV/0!0
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100