Density and Excel

We started off class by being told by Mr. Lieberman that we will be going to the math lab very quickly so he can show us how to make our graphs for post lab question one for the density of pennies lab. You are supposed to go on microsoft excel and then fill in the the A column with the calculated volume of the pennies. We just did the pre 1982 pennies for now. Then in the B column you type in the mass of the pennies. After we put in the numbers we made a graph of the numbers and printed it out and we have to staple it or glue it in our lab books. To make the graphs we first highlighted the data. Then you click on the insert tab and click charts and choose a type of graph. Next to make the x axis say volume you click on the chart itself then click the layout tab and choose labels. Then click axis titles and it will say x axis and y axis and click on those to be able to make a label for the axis. We left the math lab and came back to the classroom and started talking about density.

Mr. Lieberman showed us an experiment about density and in the experiment he set two beakers up with clear liquids in each and they had approximately the same volume, but Mr. Lieberman never said they were both the same liquid. Next he dropped an ice cube in each beaker and immediately one ice cube sunk and the other floated. The reason why it sunk was because the ice cube had a greater density than the liquid. The other ice cube floated because it had a smaller density than the liquid.

Here are some things you should know about density: it measures how much mass there is a an amount of space which is volume. The way to calculate density is mass divided by volume. Also be sure you know how to calculate volume if you were given mass and density and how to calculate mass if you were given volume and density. There is a special triangle to help those of you who are 'algebraically challenged' that will help you remember these formulas. Just another regular day in sixth period chem.

And the next scribe is....Becky N.