Question

I have a project I don't know how to set up.

Answer 1

In this project, you will be gathering data from two online databases, then using graphs and math to look for trends in the data. Although you could theoretically do this all by hand, it is far easier to use a spreadsheet program such as Open Office spreadsheet. (Open Office is a wonderful free program that can be downloaded from the internet if you do not already have another spreadsheet program such as Excel.)

You will be going to the Cell Size Database to find the Nucleus Area, then getting the C-value for that animal from the Animal Genome Size Database. Both measurements are not available for every animal so you will need to go back and forth between the two databases to find animals that you can get both numbers for. Also you will want to be sure you get the full range of sizes in each category so that you don’t bias the data. So in each category (we will use amphibians, fish, and birds) get the largest Nucleus Area number that also has a C-value and the smallest nucleus area number that also has a C-value. Then you will select from the range in between. You will need to get 10 animals’ Nucleus Area and C-value for each category--10 amphibians, 10 birds, and 10 fish. This will take a long time to do.

1. Set up your spreadsheet with these labels in the first row

category
(amphibian, bird, fish) scientific name common name C-value Nucleus Area

Answer 2

3. Click on Amphibian to view the table of Amphibian species.

4. Various measurements are provided but we will only use the Nucleus Area (NA) measurement. The sizes are measured in millionths of a square meter (µm). This NA number is not available for every animal. Select a species for which there is an NA measurement available. Copy the scientific name.

5. Open this link http://www.genomesize.com/search.php At the left of the page, click the search database link. Enter the scientific name you copied in step 4 into top right field in the search and leave all of the other fields the same.

6. If there is no C-value data, forget about that animal and go back to the Cell Size Database and find another animal with a NA number.

7. If there IS C-value data, fill out all the fields in your table for this animal using the two databases. When more than one value for Nucleus Area or C-value is given, average the numbers and use that average number to put in your table.

8. Repeat the process until you have filled out your table with 10 amphibians, 10 birds, and 10 fish.

9. Create a scatter graph of the data with C-value on the X axis and Nucleus Area on the Y axis. Click the link here for a video tutorial on how to do this in Open Office

10. Add a trend line through the graph as instructed in the above tutorial.

11. The program will calculate the value of R2 , the "coefficient of determination" for the trend line. This is a calculation of how far from the line the actual data points fall. For the trend line through the data to have any real meaning, R2 must equal 0.5 or above.

Answer 3

My biology teacher does a really poor job. He just hands you a lesson and questions and wont help you with any of it or help you understand anything. I need help.

Answer 4

My goodness. Do you need this urgently? I can help you this weekend (30,31st)
You must be in AP bio. Your teacher would have to had done an example in class or at least had you familiarized with the experimentation process so that you where comfortable with this.
I am just to busy today and tomorrow but I can after that. I should be able to help because my father is an active research PI of a medical Laboratory. This is a big project with all the work of proper college level research and absolutely none of the fun.
i really feel sorry about that