Numerical Calculation in Open Office

I created another screen cast showing how to get started with a numerical calculation for one of my classes. In this case, the students are attempting to model the motion of an object falling with air resistance. The following example doesn't show the steps including the air resistance, but maybe it is enough to get someone started.

More like this

You know I like the Mythbusters, right? Well, I have been meaning to look at the shooting bullets in the air myth for quite some time. Now is that time. If you didn't catch that particular episode, the MythBusters wanted to see how dangerous it was to shoot a bullet straight up in the air. I am…
There is no air resistance in line rider. Sorry to spoil the suspense. To test for the presence of an air resistance force, a track was created that let the rider fall. ![linerider air 1](http://scienceblogs.com/dotphysics/wp-content/uploads/2008/09/linerider…) (note the markers on the side.…
On MythBusters this week, Adam and Jamie tested the bullet-proofness of various objects. The one that sticks in my mind is the ipod. The said there was a report of a solider being shot by an AK-47, but he was saved because the bullet hit his ipod. To test this, Adam shot an AK-47 at an ipod and…
In part I of this post, I talked about the basics of projectile motion with no air resistance. Also in that post, I showed that (without air resistance) the angle to throw a ball for maximum range is 45 degrees. When throwing a football, there is some air resistance this means that 45 degree is…

I did that in Excel and posted the results on the Mythbusters fan site. Their data on terminal velocity and the altitude needed to achieve it were incorrect, at least by my model. Considering how frequently they use those parameters (explosion stops guy falling out of airplane, bullet terminal velocity, others) I'd say it's certainly worth their while to consider.

Of course, they didn't.