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
Exercises 1 and 2
Exercise 3

ICT in Biology Index

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

IB Biology Homepage

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

 

 

 

 

ICT IN BIOLOGY

Custom Search

Using MS Excel 2013 as a Database

Using the Custom option

This is very useful if you want to compare results, for example those of volunteer 3 and volunteer 7.

Return to the complete database that you saved to your desktop. The empty lines should have been removed!

Click on the arrow in A1 and select Number Filters and Equals option.

DB08

The following Custom AutoFilter pop-up box appears

DB09

Enter the information as shown below

DB10

And OK

You have now filtered the information from volunteers 3 and 7 only.

Now go to cell B1 and click on the arrow
Select day 8

DB11

You can now compare the results from day 8 from the two volunteers selected.

N.B. Notice that two arrows in line 1 are now showing the filter icon. This means that you have to click on both arrows, selecting ALL in each case, to return to the complete database.

 

Next: Exercises

 

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