My 5th grade kid's science experiment is "Calculating the Speed of the Perfect Knife Throw". Unfortunately, while I'm a whiz at reading and writing, my excel and math skills are woeful, so I turn to this forum hoping someone might tender assistance.
There are four (4) factors to depict, all of which I have recorded:
1. Distances at 10', 12.5' and 15'
2. Fractions of a second it takes from the release to target impact
3. Number of attempts thrown from each distance (20 each, so there are a total of 60 attempts)
4. Whether the blade stuck into the wood target ("hit") or dropped to the ground ("miss")
I envision that the horizontal axis should be labeled "Attempts" (1-20), and the vertical axis should be labeled "Fractions of a Second" (.05, .10, .15, .20, .25, .30, .35, .40). I envision a grid indicating different fractions of second dots corresponding to each attempt, where the "hits" are one color/shape and the "misses" are another color/shape.
The excel information that my kid typed is not formatted; it's just raw data, and is therefore unreadable for purposes of presentation.
Cheers to anyone willing to send me in the best direction!
Bookmarks