|The Open Door Web Site|
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:
UI = International Units
The data was complemented by ultrasound scans of the volunteers’ ovaries to determine the stage of the follicles.
Using an Excel Database
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)
line(s), right click and select
Return to line 1 of the database and highlight cells A to H
Go to Data, Filter, and then Auto filter
downward-pointing arrows will appear to the right in
cells A to H in line 1
Followed by a
list of items entered in the cells below the title
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.
© Paul Billiet 2016