WFM 5201: Data Management and Statistical Analysis

Semester: October 2011

1. Instructor:

Akm Saiful Islam
Associate Professor, IWFM, BUET
Email: akmsaifulislam@iwfm.buet.ac.bd
Phone: 880-2-9664640~44 Ext 7923

2. Class Hours:

  Sunday (subject to change)  4:00p.m. - 5:15p.m.  (Ground Floor, IWFM)

3. Office Hours:

  Sunday (subject to change)  5:15p.m. - 5:30p.m.  (Room 306-2,  IWFM)

4. Grading Policy (subject to change):

Mid Term  = 25%  Final Exam = 40%  Database Project =20% 
Assignment =10% Attendance =   5%

5. Course Content:

Data requirement for water resources development; Types and sources of data; Time series data; Database management; Exploratory data analysis; Homogeneity and stationarity of data; Descriptive statistics; Statistical interval, inference and hypothesis testing; Statistical sampling; Analysis of variance; Correlation and regression; Frequency analysis; Statistical software.

6. Syllabus of this part:

• Descriptive statistics

• Exploratory data analysis

• Frequency analysis

• Correlation and regression

• Analysis of variance

• Database management
   

7. Lecture Topics (subject to frequent update):

• Introduction and Syllabus

• Lecture-1: Descriptive Statistics: Measures of Central Tendency

• Lecture-2: Descriptive Statistics: Measures of Location

• Lecture-3: Descriptive Statistics: Measures of Dispersion

• Lecture-4: Descriptive Statistics: Measures of Symmetry and Peakedness

• Lecture-5: Exploratory Data Analysis through Graphical Means

• Lecture-6: Correlation and Regression

• Lecture-7: Concepts of Database Management System

• Lecture-8: Hands on Exercise on Microsoft Access Database (Lab-1)

• Lecture-9: Hands on Exercise on Microsoft Access Database (Lab-2) 

• Lecture-10: Hands on Exercise on Microsoft Access Database  (Lab-3)

• Lecture-11: Frequency Analysis (Plotting Position, Normal Distribution)

• Lecture-12: Frequency Analysis (Log-Normal, Log Pearson's Type III, Gumbel EV1Distribution)

8. Mini Project:

-  Guideline: Topics related to database design will be announced in the class.
-  Report: 10 page report written in Microsoft Word, due on Last week.
-  Report should contain - introduction to the problem, methodology, results, conclusion.
-  Presentation: Each student will present their study at the end of the semester

10. Software: Microsoft Excel, Microsoft Access, SPSS

9. Books:

i. Haan C.T. (1977) Statistical Methods in Hydrology, The Iowa State University Press, Ames.

ii. Warren Viessman and Gary Lewis (2003) Introduction to Hydrology, Prentice Hall.

iii. Shahjahan Mondal (2005) Lecture Notes on Statistics and Probability for Master in Risk Analysis and Management  

iv. In addition, papers in different relevant journals (e.g. Water Resources Research, Journal of Hydrologic Engineering, Hydrological Science Journal etc.) would be required.

  Last updated on 16 October 2011 (c) Bangladesh University of Engineering and Technology