 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 Preparing your
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) Select the
line(s), right click and select
delete.
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 Sort
Ascending Followed by a
list of items entered in the cells below the title
cell.
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 and Shirley Burchill 2007 |
|||||||||
