Fa13 CEE-6110-001

Front Page

Hydroinformatics 

Quick Links:

Lecture Materials Page
Semester Project Results Page

USU CEE 6110, BYU CE En 594R, UofU CVEEN 7970

Class Time: Tuesday / Thursday 1:30 - 2:45 PM

Class Locations:

Utah State University:  Distance Education 105
University of Utah: OSH 275
Brigham Young University:  Clyde Building 234

Instructors:

Jeff Horsburgh

Utah State University

Offices: ENGR 223 / UWRL 201

Office Hours: T/TH 3:00 – 4:00 PM in ENGR 223, or by appointment

E-mail: jeff.horsburgh@usu.edu

Phone: 435-797-2946

  

Dan Ames

Brigham Young University

Office: 242J Clyde Building

Office Hours:  T/TH 9:30-11:30 in CB 242J, or by appointment

E-mail: dan.ames@byu.edu

Phone:  801-422-3620
 

Steven Burian

University of Utah

Offices:  MCE 2044

Office Hours: M 1:00 - 3:00 PM, or by appointment

E-mail: steve.burian@utah.edu

Phone: 801-585-5721

    

 

Course Offering

This course will be simultaneously offered across the CI-WATER (http://ci-water.org/ Links to an external site.) partner campuses (USU, UofU, and BYU). Additional support is being provided by the iUTAH Project (http://www.iutahepscor.org Links to an external site./). Each university has designated an instructor to manage things on their end, be present during class time, help deliver course content, and evaluate plus support work by students on their campus.  Support for development of this course was provided by National Science Foundation Grants No. EPS 1135482 Links to an external site., and EPS 1208732 Links to an external site.. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

 ciwater.png                 epscor_logo.png             iutah_eu_horz_sm.png       nsf_epscor_lg.jpg.gif                                   

Course Overview

Hydroinformatics is the study, design, development, and deployment of hardware and software systems for hydrologic data collection, distribution, interpretation, and analysis to aid in the understanding and management of water in the natural and built environment. This class will introduce students to fundamental and advanced hydroinformatics concepts and procedures including automated data collection networks, relational databases and data management software, metadata and semantics, data storage file formats and standards, data transformations and automation of data manipulation tasks to support modeling and analysis, web based data distribution and access using web services, and integrated networks of hydro-climate data.

The course has an open, project-type format where students will work individually or in a small group over the semester to discover, organize and manage data for a hydrology or water resources problem of their interest. Projects may include designing appropriate data models and automating data loading, manipulation, and transformations in support of data intensive analyses or modeling. Class time will include lectures focused on learning and developing data management, transformation, and task automation skills, class discussions, code writing exercises to solve data manipulation tasks, demonstration of software and data systems, and student presentations of their project work. The course will better prepare students to work in data-intensive research and project work environments and emphasize development of reproducible processes for managing and transforming data in ways that others can easily and completely reproduce on their own to support analyses and modeling.  Additionally, this course will better prepare students to work across multiple software platforms and systems used in data management.

Learning Objectives

Upon successfully completing this course, students will be able to:

 Data and the Data Life Cycle:

  1. Describe the data life cycle
  2. Determine the dimensionality of a dataset, including the scale triplet of support, spacing extent for both space and time
  3. Generate metadata and describe datasets to support data sharing
  4. Discover and access data from major data sources

Databases and Data Models:

  1. Store, retrieve, and use data from important data models used in Hydrology such as ArcHydro, NetCDF, and the Observations Data Model (ODM)
  2. Develop data models to represent, organize, and store data
  3. Design and use relational databases to organize, store, and manipulate data
  4. Query, aggregate, and pivot data using Structured Query Language (SQL), Excel, R, and other software systems

Visualization, Transformations, Analysis, and Modeling:

  1. Create reproducible data visualizations
  2. Write and execute computer code to automate difficult and repetitive data related tasks
  3. Manipulate data and transform it across file systems, flat files, databases, programming languages, etc.
  4. Retrieve and use data from Web services
  5. Organize data in a variety of platforms and systems common in hydrology and engineering
  6. Prepare data to support hydrologic, water resources, and/or water quality modeling

Prerequisites

Required:

  • Graduate student standing
  • Proficiency in Microsoft Excel and Geographic Information Systems (GIS)
  • Familiarity and ability to write simple programs in any programming language such as C, C++, C#, Fortran,Visual Basic, R, Matlab, Python, or Java.

Recommended:

  • Concurrent or prior enrollment in a course on programming or databases, hydrologic modeling, integrated river basins/watershed planning and management, GIS in water resources, groundwater modeling, or related.

Texts  

Required readings will be posted on this website or distributed in class.

 Some potential references, but not required:

Class Schedule

The class schedule is subject to change.  Please check the Lecture Materials page regularly for updates to the class schedule. Lecture materials and assigned readings are being posted to the Lecture Materials page.

Description of Required Course Work

Assignments

Students will complete a series individual assignments. Each assignment will pose a problem related to data organization, management, or transformation and will require use of software tools and/or computer programming/automation to solve.  The list of assignments follows, but is subject to change:

  • Assignment-1.     Metadata and the data lifecycle
  • Assignment-2.     Data model design
  • Assignment-3.     Database implementation and loading data 
  • Assignment-4.     Using Structured Query Language
  • Assignment-5.     Querying, visualizing, transformation, and analysis 
  • Assignment-6.     Automation of data management tasks
  • Assignment-7.     Accessing data using web services
  • Assignment-8.     Deploying an HIS HydroServer to share your data
  • Assignment-9.     Preparing data for input to a model

Students will submit the answer to each assignment in the format of a 1-page engineering report or briefing paper. Each report should be formatted with standard 12-point font, 1-inch margins, and be fully self-contained to include an introduction to the problem, methods used, and results obtained so that a technically-versed reader not familiar with the problem statement can understand the rationale for, methods used, and results of the work presented. The restriction to 1 page is to help develop clear and succinct writing skills.  Planners, managers, politicians, and decision makers rely on the work of engineers and hydroinformatics experts but are very busy people who rarely understand computer code or the underlying technologies. References, figures, tables, listing of code, and more detailed explanations can be included in appendices that do not count towards the 1-page limit. Students not satisfied with their performance on an assignment report may revise and resubmit it up to 1 week after the instructors evaluate and return the report.

Semester Project

Part of the course work will involve a semester-long project. Groups of up to 3-4 students will choose a hydrology or water resources data management problem to study for the semester. As part of the project, students will identify the data, data dimensionality, and lifecycle of the data required to solve the problem and develop metadata to describe and a data model to organize the data. Subsequently, students will implement the data model in a data management system and undertake querying, pivoting, and transformation activities to move the data into a model and/or analysis that uses the data. Students will report and make recommendations based on their results.  Details of the semester project are available via the Course Semester Project Information page.

Class Participation

We expect students to read assigned readings ahead of time and come to class and share their impressions of the reading(s) or ask questions on points they did not understand. At times, we may discuss readings in a seminar format. During lectures or discussions, the instructors will ask many questions, and, if needed, call on you individually to ensure everyone participates.

Grading of and Expectations for Submitted Work

Approximate Grading:        

Assignments

50%

Semester Project

40%

 

Final project report

20%

 

 

Peer review

5%

 

 

Final oral presentation

15%

 

Class Participation

10%

 

90 to 100% -- at least some sort of A
80 to 90% -- at least some sort of B
70 to 80% -- at least some sort of C
< 70% -- most probably some sort of F

 There is no curve. All submitted work (that meets grading rubric standards) will earn an “A”.

 All submitted work will be graded for technical correctness, organization, clarity, presentation, and other criteria according to the Grading Rubric available on the class website for the item. We will ask to meet with students who submit low quality work to discuss improvement strategies.

 Submitted work must be:

  • Original, typed with 1” margins in a standard 12-point font, printed, and stapled.
  • Have a title page with title, student name(s), date, email address(es), class, and instructor.
  • Handed in at the beginning of class on the due date listed on the class web page.
  • Turned in with the self-assessment portion of the Grading Rubric completed.
  • Turned in with the Group (and self) Rating Form completed (for group work items).
  • Turned in with duplicate electronic copy and the self-assessment via Canvas.
  • For group work, only one paper and Canvas copy need be submitted.
  • We do not accept late assignments. They will be graded as zero. In extenuating circumstances (birth/death in the immediate family; grave illness with doctor’s note), contact the instructors prior to the due date and make alternative arrangements.

Academic Integrity: We expect each student to uphold academic integrity.

Expectations for academic integrity at each institution participating in this course are given on the following web sites:

USU, BYU, U of U, and the instructors take plagiarism seriously, and we will hold offending parties to the full extent of the individual university policies. When in doubt, acknowledge sources, cite references, and properly quote material that is not your own.

Electronic Policies

  1. Class Webpage: We will post all class materials to the class webpage (this website in Canvas) including readings, lecture materials, and descriptions of and grading rubrics for all course work.
  2. Canvas: Submit electronic versions of all work and self evaluations to Canvas (for grading and archiving purposes).
  3. Project Reports: Please note that your project reports will be made publicly available on this Canvas website.
  4. Email: Include “Hydroinformatics” in the subject line of all email so that we can timely attend and respond to emails. Unless you request that we don’t, we may forward email questions and answers to the entire class.

Expectations of Students

  • Be on-time to class and ready to learn / participate when class starts.
  • Read assigned readings ahead of time and come to class prepared to share your impression(s) of the reading(s) and/or ask questions on points you do not understand.
  • Turn off or keep silent all electronic devices that may distract the instructors or other students. We will ask students using phones, pagers, PDAs, music players, etc. to leave class.
  • Contribute to class discussions while being respectful of and listening to others’ points of view.
  • Turn in all work on time in the required format.
  • Bring questions and concerns forward during class, office hours, or by chat or email.
  • Put in approximately 2 – 5 hours outside of class for each 1 hour of in-class time.

Expectations of the Instructors

  • Start class on time.
  • Respect the value of student’s time.
  • Call equally on all students for class participation.
  • Learn student names by some point through the semester.
  • Facilitate an environment of inclusivity and non-discrimination.
  • Respond to email within 30 hours when we are not traveling out of town.
  • Return graded work within 1 week from when work is submitted.

Disability/Special Accommodations

Please talk to one of the instructors immediately if you require disability or other special accommodations.

Additional Resources for Students

 Please direct further questions or concerns about the syllabus or the course to one of the instructors by email, in person, or phone.

CC Attribution This course content is offered under a CC Attribution Links to an external site. license. Content in this course can be considered under this license unless otherwise noted.