physicsponderer
- 74
- 10
I agree with your use of spreadsheets. I think it is a step that should not be omitted between the calculations and the graph when studying. Learning to make a table is a very useful thing. It can even be used outside of physics, and there is no need to go the whole way and plot a graph. I have used a table to work out how much electricity I was using doing different things by entering times and electricity meter reading into a table on paper (and how much it cost in money) which is sort of physics but also sort of business or just life.Dr. Courtney said:I kind of like Euler's method as a teaching tool and have used it to teach high school students to compute rocket trajectories as well as to compute forces from videos of experiments. For systems where the forces are changing slowly, it is not bad, and it can be implemented in a spreadsheet. Students can learn it even before they have a clue about calculus with the idea that for sufficiently short times, the assumption of constant acceleration is "good enough" for sufficiently short time steps. Then students can shorten the time step and see if their calculations change much. Sure, the spreadsheets might have 1000-10000 rows, but they are all cut and pasted from the first few, and this allows students to easily see how the motion is progressing.
I see use of Euler's method in a spreadsheet as a stepping stone for students to using numerical methods in black boxes. It gives some insight into what is going on inside those black boxes and allows solving a bunch more systems than the assumption of constant acceleration. There will always be a more efficient numerical method just around the corner. But computers today are pretty powerful - it may be a fine approach to sacrifice numerical efficiency for conceptual simplicity for certain parts of introductory training.
But having taught introductory college physics for lots and lots of years, making scientific programming part of the course or a prerequisite for it is going to be a hard sell for most intro courses (except majors courses). It will be a great way to make students hate the teacher. Students in introductory classes are open to spreadsheets, not so much to learning to program.
Hard to believe physics students would hate to learn a tiny easy bit of coding. They should love the teacher, not hate him or her.