Lab 2 by lanyuehua


									Lab 2 – Maximum Range of a Projectile

q Lab 2 (Chapter 3, Lesson 3) involves a projectile being fired upward at an angle to the horizontal,    .
You are to program the spreadsheet Excel (a similar substitute software program is permissible) to determine

the maximum injection angle,         , that will result in the greatest downrange distance, R. Assume vo = 10
m/s and g is approximated as g = 10 m/s2. Fill in the data table, and answers for the blanks and complete the
graph (properly labeled and annotated) in the Lab Answer Sheet at the end of this lab. {Hint: watch out for
conversion problems from radians to degrees in Excel} . Send in this Lab Answer Sheet only when all of the
labs are completed. These can be sent via USPS (postal), or scanned and sent as pdf or picture files (e.g., tif,
gif, etc.) or by any other method of your choice as long as the Answer Sheets are legible and translatable by
Grantham University.

q Access Excel. Your data table will look similar to that found for Lab 2 below. The injection angle, will
go from 0 degrees to 90 degrees in steps of two (2) degrees. Once you have the range formula programmed

for      = 0°, use the “fill down” option in Excel to “distribute” the solutions to the other cells for the other
angles. Include your completed full Excel data table with your Lab Answer Sheet. Then graph the data in

order to construct a R vs.      graph. Denote on this graph, the maximum range, Rmax, and the angle,
 where this occurs. Be sure that your graph is properly labeled. For Lab 2 return with your Lab Answer Sheet:

(1) completed Excel spreadsheet, and (2) graph of R vs.          .
        °           Range, R
   (degrees )           (m)

To top