lab3_demo1

lab3_demo1 - and used in formulas on the Trajectory sheet....

This preview shows pages 1–5. Sign up to view the full content.

Comments Page 1 Flight of an Arrow In this model the distance an arrow flies in a horizontal direction from the position of the archer, given an initial velocity, is calculated for a number of different launch angles. The archer is assumed to have zero height! And the ground is assumed to be perfectly horizontal pl Note that if the launch angle is 0 (the arrow is fired horizontally) the distance it travels is 0; and if the arrow is fired straight up (launch angle 90) the distance it travels is also zero. Notice that the  arrow travels the greatest distance if the launch angle is 45 degrees. The workbook demonstrates the use of a number of new spreadsheet features. Firstly, parameters of the model are entered on a separate worksheet (called the Parameters sheet) given names (in this case g for the gravitational constant, and V for the initial velocity of the arrow,

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: and used in formulas on the Trajectory sheet. Try changing the value of the initial velocity and observe that the graph changes accordingly. Do not change the gravitational constant - that is constant throughout the (known) Universe! Secondly, a graph is incorporated into the Trajectory worksheet. Graphs are clearly very useful for visual presentation of information. Comments Page 2 lane t), Parameters Page 3 Model Parameters Initial velocity: 11 m/sec Gravitational constant: 9.8 m/sec 2 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 0.0 2.0 4.0 6.0 8.0 10.0 12.0 14.0 Parameters Page 4 5 80 85 90 Column B Trajectory Page 5 Launch Angle Distance 5 2.14 10 4.22 15 6.17 20 7.94 25 9.46 30 10.69 35 11.6 40 12.16 45 12.35 50 12.16 55 11.6 60 10.69 65 9.46 70 7.94 75 6.17 80 4.22 85 2.14 90...
View Full Document

This note was uploaded on 07/16/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.

Page1 / 5

lab3_demo1 - and used in formulas on the Trajectory sheet....

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online