The Open Door Web Site

Biology
 

 

ICT IN BIOLOGY

USING EXCEL AS A DATA BASE

DATABASE OF FEMALE REPRODUCTIVE HORMONES

Data provided by Professor Paul Biscof Département de Gynécologie et d'Obstétrique Hôpital Universitaire de Genève

Use the database that contains the data from 20 healthy women volunteers aged 20 to 35 years old in Geneva Switzerland. These women had not been taking oral contraceptives for at least 3 months before the start of the study. Daily morning blood samples were taken on starting on the first day of their menstrual cycle (determined by the beginning of their menstrual bleed = menses) and continued to the first day of their next menstrual bleed.

Six hormones were measured in the blood samples:

  • FSH
  • LH
  • Prolactin
  • Oestradiol
  • Progesterone
  • Testostrone

UI = International Units
pg = picograms
ng = nanograms

The data was complemented by ultrasound scans of the volunteers’ ovaries to determine the stage of the follicles.

Using an Excel Database

Preparing your database

Open the file

and save it onto your computer's desktop. Open MSDATA.xls from your desktop.

Remove and empty dividing lines between volunteers (for example, line 29 and line 30)

Select the line(s), right click and select delete.
Repeat for other empty lines between the information for the twenty volunteers.

Return to line 1 of the database and highlight cells A to H

Go to Data, Filter, and then Auto filter

Small downward-pointing arrows will appear to the right in cells A to H in line 1
When you click on any one of the arrows you will obtain the following menu

Sort Ascending
Sort Descending
(All)
(Top 10….)
Custom

Followed by a list of items entered in the cells below the title cell.
Go to A1 Volunteer, click on the arrow and select 3

You have now filtered all of the information concerning volunteer number 3.

Notice that the arrow in A1 is now a different colour (in this case, blue). This indicates to you that a filter has been used in this column.

You should also notice that the number of filtered entries is indicated in the left had corner of the Excel window. In this example “33 of 579 records found”.

To return to the complete database, click on the coloured arrow (in this case in A1) and select ALL.

> ICT in Biology

ICT in Biology Index

© The Open Door Team
Any questions or problems regarding this site should be addressed to the webmaster

© Paul Billiet 2014