Proving Kepler's Third Law Activity Worksheet and Spreadsheet

An activity to guide students through the analysis of real planetary data (orbit radius and period) to see if it is consistent with Kepler’s Third Law.

Includes:

1. A worksheet (PDF) for students with complete instructions. This can be issued to students as independent work in class or at home. Space is provided for working out and writing answers to the questions.
2. A Numbers¹ spreadsheet with solutions. There is an Incomplete tab, which can be projected whilst introducing the activity if desired. The Complete tab has all the solutions to aid the teacher as they work through it with the class. Solutions include results computed directly from the data using spreadsheet formulae and a separate table in which results from a hand drawn graph can be inputted and computed. The Printable tab has the solutions in a printable format if needed.
3. The Incomplete and Printable tabs from the spreadsheet are also included as separate PDFs for anyone unable to use the Numbers app.

¹ This is a Numbers spreadsheet. It is possible to convert Numbers spreadsheets to Excel files but I cannot guarantee an easy to use output since the tables may be converted to separate worksheets in the Excel file.