Title Post date
Using spreadsheets Keywords: absolute and relative cell references, chi-squared, Excel, formulas, graphing, model, OpenOffice Calc, simulating data, Solver, spreadsheets, trend line, uncertainties

Want a quick way to do calculations, simulate data and draw graphs? Here are some quck tips on using spreadsheets to do this!

In this activity, we will use an accepted physical model, that of an object falling in a vacuum, to create simulated data that could result from an experiment. We will then graph this data and fit a trend line to it.

7 years 19 weeks ago
Bicycle Power Keywords: bicycle, chi-squared, power, spreadsheets

How can you measure the mechanical power required to pedal a bicycle by observing how it slows down when you stop pedalling?

The forces acting on a bicycle can be estimated by observing the rate at which it slows down when you stop pedalling. This technique can, in principle, be used for any transportation vehicle.

5 years 35 weeks ago
Syndicate content

a place of mind, The University of British Columbia

C21: Physics Teaching for the 21st Century
UBC Department of Physics & Astronomy
6224 Agricultural Road
Vancouver, BC V6T 1Z1
Tel 604.822.3675
Fax 604.822.5324

Emergency Procedures | Accessibility | Contact UBC | © Copyright The University of British Columbia