Monday, September 19, 2011

Parts of a Lab Report

Today (or tomorrow for G period) we learned about the parts of a lab report.  The first PowerPoint below details the parts of a lab report.  The second PowerPoint shows you how to make an x y scatter plot in Excel.  Lastly, there is an image of the rubric that you will need to turn in when you submit your lab report.  You can not turn in a lab report without the rubric.  If you don't have the rubric and self-evaluation completed, your lab report will be late.
Tips for working in Excel: Remember that your graph should display the average for the five beans in each group (0.0g salt, 0.5g salt etc).

Insert a blank row, below the data for bean 1e.  To do this, highlight row 7 (bean 2a), go to "Insert" and select "row."  A new row should appear directly below 1e.  The row in the screen shot is yellow, because I added the color to make it easier to see.

You can click on any of the images below to make them larger.

Directly below 0.41, type =average (as you start to do this a menu will appear and you can select AVERAGE.
 Now the cell (square) below 0.41 should look like the picture below.
 Highlight the data for which you want to take the average.  Once you have highlighted these numbers, press Enter (Return).

You should now have an 0.38 in the box where you originally typed =AVERAGE . Place the cursor so that it touches the lower right corner of the highlighted blue box.  A black plus sign (+) should appear.  Drag this symbol directly across the row and this will give you the averages for the rest of the data for group 1.

Once you have all of the averages completed, you are ready almost to make an X Y scatter plot.  You will want to open either a new spreadsheet or a new tab in Excel.  Make a data table that contains the averages (see below).
Now you are ready to click through the PowerPoint below and make an X Y scatter plot.
Making an xy scatter plot
View more presentations from ilanasaxe

And just in case you 'misplaced' the rubric, you can see it (and print it) from the image below. 

No comments: