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

Using the Custom option
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

Note about this Tutorial

This tutorial has been updated. It was originally published using Excel 2003. The new images are screenshots from Excel 2013.

There may be very slight differences for those of you using Excel 2016 but, essentially, the layout is much the same as Excel 2013.

 

 

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

Excel icon

MSDATA.xls

 

 

 

ICT IN BIOLOGY

Custom Search

Using MS Excel 2013 as a Database

Preparing your database.

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

Remove any 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.

DB01

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

DB02

Go to Data and Filter

DB03

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 Smallest to Largest (Ascending)
Sort Largest to Smallest (Descending)
(last option)Number Filters
You also have the option to 'Select All' or any one or combination of the items in the list.

DB04

Go to A1 Volunteer, click on the arrow and select 3

DB05

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

DB06

Notice that the arrow in A1 has changed to a small filter icon. 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 filter icon (in this case in A1) and Select All.

DB07

 

Next: Using the Custom option

 

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 2017
Any questions or problems regarding this site should be addressed to the webmaster

Hosted By
Web Hosting by HostCentric


SiteLock