Peter Y. Chou CIS-50B-04 Instructor: Roberta Harvey(12/5/91)
Final Project Using 4 Applications: Basic, Filemaker Pro, Microsoft Excel & Word
ANALYSIS OF BIRTHDAYS OF 27 MUSICAL CONDUCTORS
ACCORDING TO THEIR DAYS OF THE WEEK (WEEKDAY),
ASTROLOGICAL SIGN (MONTH) & CHINESE ZODIAC SIGN (YEAR)

PETER Y. CHOU

BASIC PROGRAMMING:

Roberta Harvey's Basic program was adapted to calculate the Day of the Week from the
birthdate entry: (Name, Month, Day, Year). Two more Basic programs were written to compute
the Astrological Sign and the Chinese Zodiac Sign based on the birthdate. The three Basic
programs were merged to create one Birthday Program. The input file consists of 27
musical conductors and their birthdates from Musical Dictionaries. The output file
shows the Name, Birth date, Day of the Week, Astrological Sign, Chinese Zodiac Sign.
Sample Run:INPUT:NAME & DATE (MM,DD,YYYY)? Leonard Bernstein,8,25,1918

OUTPUT:Leonard Bernstein, 8-25-1918, Sunday, Virgo, Horse

FILEMAKER PRO:

The Filemaker Pro software was used to create 27 records containing 5 fields of information.
Sample File:
Name:Leonard Bernstein
Birthday:8-25-1918
Weekday:Sunday
Month:Virgo
Year:Horse

The Column Layout was used to sort the birthdays alphabetically according to Weekdays,
Astrological Signs, and Chinese Zodiac Years. Sample Layout File:

NameBirthdayWeekdayMonthYear
Leonard Bernstein8-25-1918SundayVirgoHorse
Seiji Ozawa9-1-1935SundayVirgoPig

MICROSOFT EXCEL & INTEGRATED SOFTWARE FOR BAR & PIE CHARTS:

The three sets of birthday data on the 27 conductors sorted by Weekdays, Astrological
Signs, and Chinese Zodiac Signs were entered into Microsoft Excel Spreadsheets. From
these data, Bar Charts and Pie Charts were created to give a visual presentation of the
birthday distribution according to Weekdays, Astrological Signs, & Chinese Zodiac Signs.

ANALYSIS & SUMMARY (TYPED USING MICROSOFT WORD):

This study is limited by the data sampling of 27 musical conductors, so that the statistical
significance may alter with additional data. Nevertheless, it is interesting to note the
preponderance of musical conductors been born on Sundays (33% vs. 14% average), in the
Astrological Sign of Aries (33% vs. 8% average), and the Chinese Zodiac Years of the Rat &
Horse (22% vs. 8%). What is most fascinating about this occurrence is that Sunday is the first
Day of the Week, Aries, the first Astrological Sign (Spring: March 20), and the Rat Year is the
first in the Chinese Zodiac Cycle of 12 Animal Years (because the Rat was the first animal to
bring a gift to the Buddha, followed by the Ox, the Tiger, etc.). The fact that a greater than
average (from double to quadruple) of musical conductors were born under these first signs
of the week, month, and year, shows their natural ability to lead and orchestrate a diverse
group of musicians to create a harmonious work of symphony.
Back to Roberta Harvey