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.
Course Introduction
Aug. 21 - University of Utah Only (USU no class) - Burian
Aug. 23 - University of Utah Only (USU no class) - Burian
Aug. 29 - Course Introduction - Horsburgh, Burian
Course introduction, review of syllabus, introductions of instructors and students
PowerPoint Slides: Class1_Intro_to_Hydroinformatics.pptx
Download Class1_Intro_to_Hydroinformatics.pptx
Aug. 31 - Field Trip: iUTAH GAMUT Monitoring Site (Offline at Local Site)
Sept. 5 -Data Management and the Data Life Cycle - Horsburgh
PowerPoint Slides: Class3_DataLifeCycleDataManagement.pptx
Download Class3_DataLifeCycleDataManagement.pptx
Assigned Readings:
GAMUT Paper: Class3_iUTAH_GAMUT_Workflow_Final_Online.pdf
Download Class3_iUTAH_GAMUT_Workflow_Final_Online.pdf
Simple Data Management Methods Paper: Class3_ESAdatamng09.pdf
Download Class3_ESAdatamng09.pdf
Datalogger Programming and Data Collection
Sept. 7 -Datalogger Programming and Data Collection - Horsburgh
PowerPoint Slides: Class4_DataCollection.pptx
Download Class4_DataCollection.pptx
Sept. 12 - Datalogger Programming Using Arduino Part 1 - Horsburgh
PowerPoint Slides: Class5_DataloggerProgrammingArduino.pptx
Download Class5_DataloggerProgrammingArduino.pptx
Example Code: Class5_ExampleSketches.zip
Download Class5_ExampleSketches.zip
Assigned Reading: Class5_Kirchner_et_al-2004-Hydrological_Processes.pdf
Download Class5_Kirchner_et_al-2004-Hydrological_Processes.pdf
Sept. 14 - Datalogger Programming Using Arduino Part 2 - Horsburgh
PowerPoint Slides: Class6_DataloggerProgrammingArduino.pptx
Download Class6_DataloggerProgrammingArduino.pptx
Example Code: Class6_ExampleSketches.zip
Download Class6_ExampleSketches.zip
Assigned Reading: Class6_HYDRO-D-14-00092.pdf
Download Class6_HYDRO-D-14-00092.pdf
Sept. 19 - Datalogger Programming Using Arduino Part 3 - Horsburgh
PowerPoint Slides: Class7_Arduino_Bringing_it_Together.pptx
Download Class7_Arduino_Bringing_it_Together.pptx
Databases and Data Models
Sept. 21 - Data Models and Data Model Design - Horsburgh
PowerPoint Slides: Class8_DataModels.pptx
Download Class8_DataModels.pptx
Sept. 26 - Database Implementation Part 1 - Horsburgh
PowerPoint Slides: Class9_DataModelImplementation.pptx
Download Class9_DataModelImplementation.pptx
Instructions for installing MySQL for Mac: Class9_Install_MySQL_and_MySQL_Workbench_on_Mac_OSX.pdf
Download Class9_Install_MySQL_and_MySQL_Workbench_on_Mac_OSX.pdf
Instructions for installing MySQL for Windows: Class9_Install_MySQL_and_MySQL_Workbench_on_Windows.pdf
Download Class9_Install_MySQL_and_MySQL_Workbench_on_Windows.pdf
Sept. 28 - Database Implementation Part 2 - Horsburgh
PowerPoint Slides: Class10_DataModelImplementation.pptx
Download Class10_DataModelImplementation.pptx
Suggested Reading: Class10_Horsburghetal_2007_ODM_WRR.pdf
Download Class10_Horsburghetal_2007_ODM_WRR.pdf
Suggested Reading: Class10_ODM1.1.1DesignSpecifications.pdf
Download Class10_ODM1.1.1DesignSpecifications.pdf
Oct. 3 - Using SQL to Query a Relational Database Part 1 - Horsburgh
PowerPoint Slides: Class11_UsingSQL.pptx
Download Class11_UsingSQL.pptx
Oct. 5 - Using SQL to Query a Relational Database Part 2 - Horsburgh
PowerPoint Slides: Class12_UsingSQL.pptx
Download Class12_UsingSQL.pptx
Visualization, Transformation, and Analysis
Oct. 10 - UofU Fall Break - Introduction to Python Programming - Part 1 - Horsburgh
PowerPoint Presentation: Class13_Intro_to_Python_Part1.pptx
Download Class13_Intro_to_Python_Part1.pptx
Video Recording: http://205.127.238.49/tcs/?id=6abb90d7-7cba-464f-9fd9-1d0289b50264
Links to an external site.
Oct. 12 - UofU Fall Break - Introduction to Python Programming - Part 2 - Horsburgh
PowerPoint Presentation: Class14_Intro_to_Python_Part2.pptx
Download Class14_Intro_to_Python_Part2.pptx
Video Recording: http://205.127.238.49/tcs/?id=07529cba-a81e-4245-9d38-2c0ed79721ce
Links to an external site.
Oct. 17 - UofU watches Python Lecture 1, Offline Programming Challenge at USU - Horsburgh
PowerPoint Presentation: Class14.5_Python_Coding_Challenge.pptx
Download Class14.5_Python_Coding_Challenge.pptx
Python Code for Solution: USGS_python_challenge.py
Download USGS_python_challenge.py
Oct. 19 - UofU watches Python Lecture 2, USU Fall Break
Oct. 24 - Using Python to Retrieve and Visualize Data - Part 1 - Horsburgh
PowerPoint Presentation: Class15_UsingPython.pptx
Download Class15_UsingPython.pptx
Example Code: Class15_Example.py
Download Class15_Example.py
Example Code: Class15_Example_Final.py
Download Class15_Example_Final.py
Suggested Reading: Class15_TheReturnOfProgramming.pdf
Download Class15_TheReturnOfProgramming.pdf
Suggested Reading: Class15_CodingBestPractices.pdf
Download Class15_CodingBestPractices.pdf
Oct. 26 - Using Python to Retrieve and Visualize Data - Part 2 - Horsburgh
PowerPoint Presentation: Class16_UsingPython.pptx
Download Class16_UsingPython.pptx
Example Code: Class_16_ExampleScripts.zip
Download Class_16_ExampleScripts.zip
Oct. 31 - Exploring Residential Water Use Data Using Python - Part 1 - Horsburgh
PowerPoint Presentation: Class17_WaterUseAnalysisPython_Part1.pptx
Download Class17_WaterUseAnalysisPython_Part1.pptx
Example Code: Class17_Code_Examples.zip
Download Class17_Code_Examples.zip
Data: Class17_Data.zip
Download Class17_Data.zip
Nov. 2 - Exploring Residential Water Use Data Using Python - Part 2 - Horsburgh
PowerPoint Presentation: Class18_WaterUseAnalysisPython_Part2.pptx
Download Class18_WaterUseAnalysisPython_Part2.pptx
Nov. 7 - R Intro - Burian
Pre-Class Required Activity: PreClass Exercise R.pdf
Download PreClass Exercise R.pdf
PowerPoint Presentation: Class19_Intro_to_R-1.pptx
Download Class19_Intro_to_R-1.pptx
GoogleDoc: http://bit.ly/IntroRTeamExercises
Links to an external site.
Exercise 2 Files: Class19_Sample_WQ_Files.zip
Download Class19_Sample_WQ_Files.zip
Sample Code for Group Exercise 1: Class19_TeamExercise1.R
Download Class19_TeamExercise1.R
Sample Code for Group Exercises 2-4: Class19_TeamExercises2_3_4.R
Download Class19_TeamExercises2_3_4.R
Nov. 9 - Using R Packages - Part 1 - Burian
PowerPoint Presentation: Class20_R_Packages_Data_Retrieval.pptx
Download Class20_R_Packages_Data_Retrieval.pptx
Sample Code for USGS dataRetrieval Exercises: Class20_USGSdataRetrievalChallenges.R
Download Class20_USGSdataRetrievalChallenges.R
Sample Code for WaterML Exercises: Class20_WaterMLDemo.R
Download Class20_WaterMLDemo.R
Nov. 14 - Using R Packages - Part 2 - Burian
PowerPoint Presentation: Class21_R_Packages_RMySQL.pptx
Download Class21_R_Packages_RMySQL.pptx
Sample Code for RMySQL Exercise: Class21_RMySQL_Example.R
Download Class21_RMySQL_Example.R
Nov. 16 - R Packages for Mapping + Projects and Version Control - Burian
PowerPoint Presentation: Class22_R_Packages_Projects_VersionControl.pptx
Download Class22_R_Packages_Projects_VersionControl.pptx
Data for Leaflet Exercise: UtahLakeWQStations.csv
Download UtahLakeWQStations.csv
Nov. 21 - Creating R Shiny Apps - Part 1 - Burian
Pre-Class Assignment: Class23_PreClassInstructions.docx
Download Class23_PreClassInstructions.docx
PowerPoint Presentation: Class23_R_Applications.pptx
Download Class23_R_Applications.pptx
Data for Shiny Exercise: YellowstoneVisitorData.csv Download YellowstoneVisitorData.csv
In-Class Demo Solution: MyFirstApp.zip Download MyFirstApp.zip
Options for Homework Assignment: ClimateAppOption.zip Download ClimateAppOption.zip or WaterQualityAppOption.zip Download WaterQualityAppOption.zip
Nov. 23 - Thanksgiving (No Class!!)
Nov. 28 - Creating R Shiny Apps - Part 2 - Burian
Directions for Uploading Apps: Class24_SharingAndPublishingInstructions.docx
Download Class24_SharingAndPublishingInstructions.docx
PowerPoint Presentation: Class24_R_ApplicationsReview.pptx Download Class24_R_ApplicationsReview.pptx
Nov. 30 - Student Shiny App Demos - Burian
Dec. 5 - Final Project Presentations - Students
Dec. 7 - Student Lightning Talks and Course Wrap-up - All
PowerPoint Presentation: Class25_CourseWrapup.pptx
Download Class25_CourseWrapup.pptx
Dec. 11 - 15 - Finals Week