biotechnology lab day 3

TODAY IN SCIENCEYOU WILL NEED:

Pencil, Calculator, Log #1 Biotechnology Lab – 1 sheet- 2 sides Bookshelf – Staple to yesterday’s papers

Cornell Notes – Biotech Virtual Lab – We will be adding to them

Please sit in your normal seats for taking roll.

ASSIGNMENT LOG #1

9/3 9/5 Tools of the Trade 145 

9/5 9/11 BioTechnology Virtual Lab

165/10   

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

 Low

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

g3

ORGANIZING THE DATACorn Type No

InfestationLow Infestation

High Infestation

BT 123

Super

BT 456

Golden Crop

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

Column A Column B Column C Column D

BT 123

Super

BT 456

Golden Crop

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 Docs

1) 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

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 Docs

1) 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) Make Graph on Excel or Google Docs5) Extra Credit – Cover PageTitle, Picture, Name, Date, Period

6) Questions 1-3 Bullet format; Question 4 is extra credit

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

2)No Homework, if you completed everything else.

3)Virtual Lab due at the beginning of class on Wednesday.