Part C: Spreadsheet Usage for Teaching and Learning

Science Lesson Plan: Force (Newton's Second Law)
Objective: To know how to create a spreadsheet and scatter graph for use within a science experiment.

Question: How does the mass of an object (in g) affect how much force is needed (in N) to move it?

The First column should be weight in g, 100g increasing by 100g increments to 1kg. Next, the
Second column would be force needed to move it in N.

g=gram
kg=kilogram
N=Newton

In cell A1 type Mass of the object in g. In cell B1 type Force needed to move it in N. In cells A2 through A11, respectively, type 100, 200, 300, 400, 500, 600, 700, 800, 900 and 1000. In cells B2 through B11, respectively, type the results recorded from the experiment. The results (the amount of force needed to move the object) should correlate with the appropriate mass of the object.

The students would do the experiment on the floor in the classroom. The students will use balls made of paper. The surface at my school is tile. Also, after the information has been recorded on the spreadsheet, the students will use the Chart Wizard in Microsoft Excel to create a scatter graph to interpret the results of the experiment. To create the graph highlight column headings and all the data in those two columns to make the graph.