Lecture Materials

The calendar events for the course are not available to the public, so we have created this page for posting lecture materials.

Key to course reading material:
Assigned readings: Read and come to class prepared to discuss the details of these readings.
Suggested readings: Read to get more insight and background on the lecture topic.

Date	Topic	Lecturer
Aug. 28	Data and data problems in the information age PowerPoint Slides: Lecture1_DataintheInformationAge.pptx Download Lecture1_DataintheInformationAge.pptx Video Recording: UEN Server Links to an external site.	Horsburgh
Aug. 30	Data management and the data life cycle PowerPoint Slides: Lecture2_DataLifeCycleDataManagement.pptx Download Lecture2_DataLifeCycleDataManagement.pptx Assigned Readings: Borer, E.T., E.W. Seabloom, M.B. Jones, and M. Schildhauer (2009). Some simple guidelines for effective data management, ESA Bulletin, 90(2):205-214, http://dx.doi.org/10.1890/0012-9623-90.2.205 Links to an external site.. Suggested Readings: CI-WATER DMP Download CI-WATER DMP , iUTAH DMP Download iUTAH DMP , WSC DMP Download WSC DMP Video Recording: UEN Server Links to an external site.	Horsburgh

Sep. 4	Metadata PowerPoint Slides: Lecture3_Metadata.pptx Download Lecture3_Metadata.pptx Suggested readings: Michener, W.K., J.W. Brunt, J.J. Helly, T.B. Kirchner, and S.G. Stafford (1997). Nongeospatial metadata for the ecological sciences, Ecological Applications, 7(1), 330-342, http://dx.doi.org/10.1890/1051-0761(1997)007[0330:NMFTES]2.0.CO;2 Links to an external site.. Michener, W.K. (2006). Meta-information concepts for ecological data management, Ecological Informatics, 1(1), 3-7, http://dx.doi.org/10.1016/j.ecoinf.2005.08.004 Links to an external site.. Video Recording: UEN Server Links to an external site.	Horsburgh
Sep. 6	CI-WATER Symposium (No Class)

Sep. 11	Data Models PowerPoint Slides: Lecture4_DataModels.pptx Download Lecture4_DataModels.pptx Video Recording: UEN Server Links to an external site.	Horsburgh
Sep. 13	Data Model Design PowerPoint Slides: Lecture5_DataModelDesign.pptx Download Lecture5_DataModelDesign.pptx Video Recording: UEN Server Links to an external site.	Horsburgh

Sep. 18	Storing and Manipulating Data Using Google Fusion Tables No PowerPoint slides presented YouTube video clips watched include: 16 minute introduction to Google Fusion Tables by the developer: http://youtu.be/5tcpUh7myJ0 Links to an external site. 60 minute Google IO Conference presentation. We didn't use this in class, but it is a really good supplement. This includes an introduction to programming using the API! http://youtu.be/Z2o0mtnF1Bg Links to an external site. 4 minute demo accessing Google Fusion Tables and uploading data from a Mac.http://youtu.be/pLL2EDXfaXQ Links to an external site. We also did a live demo in class. Key things to remember: 1. you need to have a Google Account to use this service, 2. remember that it's an experimental service so I wouldn't make it an integral part of your research program till it becomes more permanent, 3. enjoy! Video Recording: UEN Server Links to an external site.	Ames
Sep. 20	Data Visualization and Mapping in Microsoft Excel PowerPoint Slides: Lecture7_EsriMapsforOffice.pptx Download Lecture7_EsriMapsforOffice.pptx Project Home Page: http://www.esri.com/software/esri-maps-for-office Links to an external site. 4 minute demo on YouTube (we didn't watch this one, but it's good): http://youtu.be/9kI9Hi_jTFk Links to an external site. 5:39 minute demo on YouTube (this is the one with the groovy music that we watched in class in the middle of the lecture): http://youtu.be/4tVC0QCCse8 Links to an external site. Video Recording: UEN Server Links to an external site.	Ames

Sep. 25	Database Implementation PowerPoint Slides: Lecture8_DatabaseImplementation.pptx Download Lecture8_DatabaseImplementation.pptx Suggested Readings: Horsburgh, J. S., D. G. Tarboton, D. R. Maidment, and I. Zaslavsky (2008), A relational model for environmental and water resources data, Water Resources Research, 44, W05406, http://dx.doi.org/10.1029/2007WR006392. Links to an external site. Horsburgh, J.S., D.G. Tarboton (2012). CUAHSI Community Observations Data Model (ODM) Version 1.1.1 Design Specifications, Consortium of Universities for the Advancement of Hydrologic Science, Inc., Washington, D.C., http://www.codeplex.com/Download?ProjectName=HydroServer&DownloadId=349176. Links to an external site. Video Recording: UEN Server Links to an external site.	Horsburgh
Sep. 27	Using SQL to Query a Relational Database PowerPoint Slides: Lecture9_UsingSQL.pptx Download Lecture9_UsingSQL.pptx Video Recording: UEN Server Links to an external site.	Horsburgh

Oct. 2	Aggregating and pivoting data – SQL and Excel PowerPoint Slides: Lecture10-AggPivotData.ppt Download Lecture10-AggPivotData.ppt Example Excel File: Lecture10-LBR-PivotExample.xlsx Download Lecture10-LBR-PivotExample.xlsx Video Recording: UEN Server Links to an external site.	Rosenberg
Oct. 4	Moving data across platforms – database to R and analyzing data PowerPoint Slides: Lecture11_DatabasetoR.pptx Download Lecture11_DatabasetoR.pptx Suggested Readings: Venables, W.N., D.M. Smith, and the R Core Team (2012). An Introduction to R, Version 2.15.1, http://cran.r-project.org/doc/manuals/R-intro.pdf Links to an external site.. Video Recording: UEN Server Links to an external site.	Horsburgh

Oct. 9	Programming for automation of common data management tasks, part 1 PowerPoint Slides: Lecture12_IntroToPythonAndArcpy.pdf Download Lecture12_IntroToPythonAndArcpy.pdf Video Recording: UEN Server Links to an external site.	Ames
Oct. 11	Programming for automation of common data management tasks, part 2 PowerPoint Slides: LECTURE13_INTROTOPYTHONANDARCPY.pdf Download LECTURE13_INTROTOPYTHONANDARCPY.pdf Video Recording: UEN Server Links to an external site.	Ames

Oct. 16	Student project interim oral presentations Video Recording of USU Presentations: UEN Server Links to an external site.	Students
Oct. 18	Friday Class Schedule (Fall Break – No Class)

Oct. 23	Service Oriented Architecture for Sharing Hydrologic Data: The CUAHSI HIS PowerPoint Slides: Lecture14_HydroDesktop_and_HIS.pptx Download Lecture14_HydroDesktop_and_HIS.pptx Download HydroDesktop here: http://hydrodesktop.codeplex.com Links to an external site. Video Recording: UEN Server Links to an external site.	Ames
Oct. 25	Using HydroDesktop to search, discover, view, and analyze data in the HIS network No formal PPT lecture today, rather this will be a demo of HydroDesktop and several of the key features. Please come to class with HydroDesktop installed on your computer. Download HydroDesktop here: http://hydrodesktop.codeplex.com Links to an external site. We will do a live exercise in class based on a HydroDesktop exercise by Jiri Kadlec for computing interpolated precipitation maps for the Czech Republic. You can find both documents on this page: http://hydrodesktop.codeplex.com/documentation?referringTitle=Presentations%20and%20Publications Links to an external site. Your ILO-7 is based on a HydroDesktop exercise by Tim Whiteaker for studying the Hydrology of Jacob's Well. Video Recording: UEN Server Links to an external site.	Ames

Oct. 30	HydroServer Lite: A quick way to get data online and join the CUAHSI HIS PowerPoint Slides: Lecture16_HydroServer_and_HydroServerLite.pptx Download Lecture16_HydroServer_and_HydroServerLite.pptx Video Recording: UEN Server Links to an external site.	Ames
Nov. 1	Customizing HydroServer Lite to meet the needs of your organization Live demonstration and follow-along activity building and deploying a live HydroServer Lite instance. Links to all relevant material from today's presentation are given in the ILO-8 assignment. Video Recording: UEN Server Links to an external site.	Ames

Nov. 6	Water Resources modeling example using the Water Evaluation and Planning (WEAP) tool. PowerPoint Slides: Lecture18-cee6930-ReservoirSimulationWEAP.ppt Download Lecture18-cee6930-ReservoirSimulationWEAP.ppt Other Materials: Lecture18_WEAPPrimer-LowerBearRiver.pdf Download Lecture18_WEAPPrimer-LowerBearRiver.pdf Lecture18_LowerBearRiver-Hydroinformatics.zip Download Lecture18_LowerBearRiver-Hydroinformatics.zip Video Recording: UEN Server Links to an external site.	Rosenberg
Nov. 8	Automating the data preparation and entry to WEAP PowerPoint Slides: Lecture19-cee6930-AutomateDataPreparationEntryWEAP.ppt Download Lecture19-cee6930-AutomateDataPreparationEntryWEAP.ppt Other Materials: Lecture19_WaterYearCalendarYear.xlsm Download Lecture19_WaterYearCalendarYear.xlsm Video Recording: UEN Server Links to an external site.	Rosenberg

Nov. 13	Introduction to the OpenMI Modeling Environmnent in HydroDesktop PowerPoint Slides: Lecture20_OpenMI.pdf Video Recording: UEN Server Links to an external site.	Ames
Nov. 15	Using OpenMI and HIS data to perform hydrologic modeling Assigned Reading: Gregerson, J.B., P.J.A. Gijsbers, and S.J.P. Westen (2007), OpenMI: Open modeling interface, Journal of Hydroinformatics, 9(3), 175-191, http://dx.doi.org/10.2166/hydro.2007.023 Links to an external site. Video Recording: UEN Server Links to an external site.	Ames

Nov. 20	Visualizing high-dimensional data PowerPoint Slides: Lecture22-cee6930-VisualizeHighDimensionsalData.ppt Download Lecture22-cee6930-VisualizeHighDimensionsalData.ppt Additional Materials: Matlab example parallel coordinates code Download Matlab example parallel coordinates code. Assigned Reading: Wegman, E. J. (1990), Hyperdimensional data analysis using parallel coordinates, Journal of the American Statistical Association, 85(411), 664-675, http://www.jstor.org/stable/2290001 Links to an external site. Video Recording: UEN Server Links to an external site.	Rosenberg
Nov. 22	Thanksgiving Holiday (No Class)

Nov. 27	Course wrap-up and review PowerPoint Slides: Lecture23_CourseWrapUp.pptx Download Lecture23_CourseWrapUp.pptx Video Recording: UEN Server Links to an external site.	Horsburgh
Nov. 29	Final Project Oral Presentations (USU) Video Recording: UEN Server Links to an external site.	Students

Dec. 4	Final Project Oral Presentations (UofU) Video Recording: UEN Server Links to an external site.	Students
Dec. 6	Final Project Oral Presentations (BYU) Video Recording: UEN Server Links to an external site.	Students

Dec. 13	1:30 PM Final Oral Presentations Continued	Students