ODWS icon

The Open Door Web Site
HOMEPAGE BIOLOGY HOMEPAGE CHEMISTRY PHYSICS ELECTRONICS HISTORY HISTORY OF SCI & TECH MATH STUDIES LEARNING FRENCH STUDY GUIDE  PHOTO GALLERY
IB BIOLOGY HOMEPAGE TOPIC CHAPTERS SCIENTIFIC INVESTIGATIONS DRAWING IN BIOLOGY DRAWING TABLES ERROR ANALYSIS IN BIOLOGY ALL ABOUT GRAPHS STATISTICS SCIENTIFIC POSTERS MOLECULAR IMAGES
WS

 

Using MS Excel as a Database

Preparing your database
Using the Custom option
Exercise 3

ICT in Biology Index

Using MS Excel as a Calculator
Using MS Excel : Going Further with Graphs

IB Biology Homepage

Exercise 2

Investigation 1

The follicle ruptures about 36 hours after the LH peak.

Sample the database and plot the levels of LH against time.

Inspect the graphs and determine the lowest concentration that LH rises to in the peaks.

Select LH, Number Filters, "greater or equal to" and enter your figure. Press Enter.

You should now have a list of the volunteers whose level of LH went above your selected value.

If you have two or more values from the same volunteer you will need to raise the value that you are using. You will probably find that some of the volunteers are missing after filtering. Why should this be? It might be worth looking at them.

The peaks for LH will occur on a particular day in the menstrual cycle. Ovulation occurs 36h later.

Cut the Days from mensis data and paste it under the data base.

Add 1.5 to the days column to determine the point of ovulation.

Establish the mean and standard deviation for the day of ovulation for this set of volunteers.

Establish the mean and standard deviation for the day of ovulation for this set of volunteers.

MS Excel: Using it as a Calculator: Creating your own Functions
MS Excel: Using it as a Calculator: Using Preset Functions

The rhythm method is a method of contraception which relies on calculating the "safe period". This is the period when there is no viable oocyte in the fallopian tube. Oocytes are receptive to sperms for about 24h after ovulation and then die after 3 days. Authorities vary in their estimations of how long sperm cells remain viable in the uterus. Figures for sperm viability vary from as little as 1 day to as long as 7 days inside the woman after ejaculation.

From the evidence from this data base evaluate this method of contraception.

 

Investigation 2

There are a number of interactions between hormones in the cycle:

  • Negative feedback controls FSH levels after they stimulate oestradiol secretion.

  • There is a positive feedback between LH levels and oestradiol levels

  • Testosterone is a precursor of oestradiol (testosterone is made by cells in the ovary then converted to oestradiol).

  • Prolactin is a hormone that milk secreting which inhibits progesterone secretion.

Chose one of these interactions and sample the data base to see what evidence there is for them

If one hormone stimulates another there should be a positive correlation between their levels.

To create a random sample you may use

Random Integer Generator

 

 

 

 

ICT IN BIOLOGY

Custom Search

Using MS Excel 2013 as a Database

Exercise 1

Start with the complete database that you saved to your desktop. The empty lines should have been removed!
Filter day 8 from B1

 

DB01

Now click on the arrow in line E1 and select Number Filters and Greater Than or Equal To

DB02

When the "is greater than or equal to" pop-up box appears, enter "10"

DB03

12 records are filtered

Now click on the arrow in column F1 and select Sort Largest to Smallest (Descending)

DB04

This allows you to compare the oestradiol levels (pg/ml) with high prolactin levels (≥ 10 ng/ml) during day 8 of the menstrual cycle from the 20 volunteers.

 

Questions

How many volunteers show progesterone levels greater than 1ng/ml on day 9 of menses?

Which volunteer shows FSH levels over 10UI/L during 5 days? Are these days consecutive?

Try first and then look at method on the next page

 

Next: Method to Exercise 1 and Exercise 3

 

The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.

Donate to the Open Door Web Site using PayPal

SITE MAP
WHAT'S NEW?
ABOUT

PRIVACY

COPYRIGHT

SPONSORSHIP

DONATIONS

ADVERTISING

© Paul Billiet 2018
Any questions or problems regarding this site should be addressed to the webmaster

Hosted By
Web Hosting by HostCentric


SiteLock