TODAY IN SCIENCEYOU WILL NEED:

Pencil, Calculator, Log #4 Biotechnology Lab – Picked up last week on Wed-You should have 3 pages 6 sides

Please sit in your normal seats for taking roll.

Reminders Signed and Corrected Test #3 –

Due tomorrow Check grades on-line for accuracy Progress Notice to be sent home

next week- Signature will be required

TODAY’S TASK LIST1) Continue working with a partner

from your table OR working individually.

2) Pick up your Assigned Computer.3)You will be held responsible for its

well-being.4) Complete all 8 experiments5) Organize your AVERAGES on Analysis Pg 5

6) Make Graph on Excel or Google Docs7) Extra Credit – Cover PageTitle, Picture, Name, Date, Period

GRAPHS Directions on this PPT MUST be done on the computer What if the printer doesn’t work?

1.Save to drive, print at home2.E-mail doc to yourself and print

at home3.Save spreadsheet on USB and

print at home

AnalysisGraphing Results can be visually quantified by using the averages for each corn crop type. You will be constructing a bar(column) graph that shows the comparison yield for crops with no, low and high ECB infestation.

Chart Title (y vs x)

Name(s), Period #

__________________ vs _____________________

y axis x axis

X axis label Types of Corn

Y axis label Yield in kernel Mass (g)

ORGANIZING THE DATACorn Type No

InfestationLow Infestation

High Infestation

BT 123

Super

BT 456

Golden Crop

Find your AVERAGES from all the experiments to complete this chart.

BIOTECHNOLOGY VIRTUAL LABCOLLECT YOUR DATA

ECB Level Mass of 1st ear Mass of 2nd ear Mass of 3rd ear Average (show work)

 None

128.6  132.9 154.4

 

3 

Low       

• There are 8 different data collection tests.• Continue until all Data is Collected.

g

This average number must be moved to the Organizing Data table for graph making.

BT123

ORGANIZING THE DATACorn Type No

InfestationLow Infestation

High Infestation

BT 123

Super

BT 456

Golden Crop

Record all the AVERAGE numbers in this chart for each corn….paying close attention to the infestation level.

Creating your graph (Visuals follow directions)

1)Make sure ALL your averages are filled in to the organization chart

2)Open up Excel or Google Docs spreadsheet1)The directions for each of these is a

little different but easy to figure out.3) Input the data from your organization

chart into columns A,B, C and D on your each spreadsheet. (see next slide)

ORGANIZING THE DATACorn Type No

InfestationLow Infestation

High Infestation

Column A Column B Column C Column D

BT 123

Super

BT 456

Golden Crop

3)Highlight all information (A1- D5)4)Insert “chart” COLUMN GRAPH5)Make sure to have a Title, subtitle

(put both partners names on the graph and print 2), X axis label, Y axis label

6)Save Graph (should look like next slide if done correctly…with your labels included)

Creating your graph (Visuals follow directions)

Your graph should

look like this

however, your

labels should be

completed.

GRAPHING ON GOOGLE & EXCELChoose: Google Docs OR Excel

Graphing in Excel – PC1)Input Data

2)Highlight

3)Insert – Column Graph

4)Use layout tabs at the top to customize graph

5)When complete; move to a New Sheet and Print

Graphing in Google Docs1) Sign up for account

2) Select “Documents”

3) Click on “Create” – “Spreadsheet”

4) Input data –Col. A = Names of Corn

B = NONE Results

C = LOW Infes.

D= HIGH Infes.

5) Highlight Data

6) Click on Chart – Insert Chart Icon

7) Select – “Column Style Graph”

8) Customize – Name & Axis labels

This graph only and 3 column bars….Your graph should have 4 columns…one for each type of corn

GRAPHING ON GOOGLE & EXCELChoose: Google Docs OR Excel

Graphing in Excel – PC1)Input Data

2)Highlight

3)Insert – Column Graph

4)Use layout tabs at the top to customize graph

5)When complete; move to a New Sheet and Print

Graphing in Google Docs1) Sign up for account

2) Select “Documents”

3) Click on “Create” – “Spreadsheet”

4) Input data –Col. A = Name of Corn

B = NONE Results

C = Low Infes.

D= High Infes.

5) Highlight Data

6) Click on Chart – Insert Chart Icon

7) Select – “Column Style Graph”

8) Customize – Name & Axis labels

TODAY’S TASK LIST1) Continue working with a partner

from your table OR working individually.

2) Pick up your Assigned Computer.3)You will be held responsible for its

well-being.4) Complete all 8 experiments5) Organize your AVERAGES on Analysis Pg 5

6) Make Graph on Excel or Google Docs7) Extra Credit – Cover PageTitle, Picture, Name, Date, Period

HOMEWORK1)We will be working in class tomorrow on our Conclusion Rough Draft

2)Test #3 – Corrected and Signed- Due Tomorrow.