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 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: 
Download Class3_DataLifeCycleDataManagement.pptx


Assigned Readings: 
GAMUT Paper:  Download Class3_iUTAH_GAMUT_Workflow_Final_Online.pdf
Simple Data Management Methods Paper:  Download Class3_ESAdatamng09.pdf

 

Datalogger Programming and Data Collection

Sept. 7 -Datalogger Programming and Data Collection - Horsburgh
PowerPoint Slides:   Download Class4_DataCollection.pptx

 

Sept. 12 - Datalogger Programming Using Arduino Part 1 - Horsburgh
PowerPoint Slides Download Class5_DataloggerProgrammingArduino.pptx


Example Code:  Class5_ExampleSketches.zip Download Class5_ExampleSketches.zip
Assigned Reading Download Class5_Kirchner_et_al-2004-Hydrological_Processes.pdf

Sept. 14 -  Datalogger Programming Using Arduino Part 2 - Horsburgh
PowerPoint Slides:   Download Class6_DataloggerProgrammingArduino.pptx


Example Code:  Class6_ExampleSketches.zip Download Class6_ExampleSketches.zip
Assigned Reading:   Download Class6_HYDRO-D-14-00092.pdf

 

Sept. 19 -  Datalogger Programming Using Arduino Part 3 - Horsburgh
PowerPoint Slides Download Class7_Arduino_Bringing_it_Together.pptx

 

Databases and Data Models

Sept. 21 -  Data Models and Data Model Design - Horsburgh
PowerPoint Slides:   Download Class8_DataModels.pptx

 

Sept. 26 - Database Implementation Part 1 - Horsburgh
PowerPoint Slides:   Download Class9_DataModelImplementation.pptx


Instructions for installing MySQL for Mac Download Class9_Install_MySQL_and_MySQL_Workbench_on_Mac_OSX.pdf
Instructions for installing MySQL for Windows Download Class9_Install_MySQL_and_MySQL_Workbench_on_Windows.pdf

Sept. 28 - Database Implementation Part 2 - Horsburgh
PowerPoint Slides:   Download Class10_DataModelImplementation.pptx


Suggested Reading:   Download Class10_Horsburghetal_2007_ODM_WRR.pdf
Suggested Reading:   Download Class10_ODM1.1.1DesignSpecifications.pdf

 

Oct. 3 -  Using SQL to Query a Relational Database Part 1 - Horsburgh
PowerPoint Slides:   Download Class11_UsingSQL.pptx

Oct. 5 -  Using SQL to Query a Relational Database Part 2 - Horsburgh 
PowerPoint Slides:   Download Class12_UsingSQL.pptx

 

Visualization, Transformation, and Analysis

Oct. 10 - UofU Fall Break -  Introduction to Python Programming - Part 1 - Horsburgh
PowerPoint Presentation:   Download Class13_Intro_to_Python_Part1.pptx


Video Recordinghttp://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:   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 Download Class14.5_Python_Coding_Challenge.pptx

 
Python Code for Solution 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 Download Class15_UsingPython.pptx


Example Code
Download Class15_Example.py
Example Code Download Class15_Example_Final.py
Suggested Reading:   Download Class15_TheReturnOfProgramming.pdf 
Suggested Reading:   Download Class15_CodingBestPractices.pdf

Oct. 26 - Using Python to Retrieve and Visualize Data - Part 2 - Horsburgh
PowerPoint Presentation:   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 Download Class17_WaterUseAnalysisPython_Part1.pptx


Example CodeClass17_Code_Examples.zip Download Class17_Code_Examples.zip
DataClass17_Data.zip Download Class17_Data.zip

Nov. 2 - Exploring Residential Water Use Data Using Python - Part 2 - Horsburgh
PowerPoint Presentation Download Class18_WaterUseAnalysisPython_Part2.pptx

 

Nov. 7 - R Intro - Burian
Pre-Class Required Activity
Download PreClass Exercise R.pdf


PowerPoint Presentation Download Class19_Intro_to_R-1.pptx
GoogleDoc: http://bit.ly/IntroRTeamExercises Links to an external site.
Exercise 2 Files Download Class19_Sample_WQ_Files.zip
Sample Code for Group Exercise 1 Download Class19_TeamExercise1.R
Sample Code for Group Exercises 2-4 Download Class19_TeamExercises2_3_4.R

Nov. 9 - Using R Packages - Part 1 - Burian
PowerPoint Presentation Download Class20_R_Packages_Data_Retrieval.pptx


Sample Code for USGS dataRetrieval Exercises:  Download Class20_USGSdataRetrievalChallenges.R
Sample Code for WaterML Exercises Download Class20_WaterMLDemo.R 

 

Nov. 14 - Using R Packages - Part 2 - Burian
PowerPoint Presentation Download Class21_R_Packages_RMySQL.pptx


Sample Code for RMySQL Exercise:  Download Class21_RMySQL_Example.R

Nov. 16 - R Packages for Mapping + Projects and Version Control - Burian
PowerPoint Presentation Download Class22_R_Packages_Projects_VersionControl.pptx


Data for Leaflet Exercise Download UtahLakeWQStations.csv

 

Nov. 21 -  Creating R Shiny Apps - Part 1 - Burian
Pre-Class Assignment Download Class23_PreClassInstructions.docx

 
PowerPoint Presentation:  Download Class23_R_Applications.pptx

Data for Shiny Exercise:  Download YellowstoneVisitorData.csv

In-Class Demo Solution:  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:  Download Class24_SharingAndPublishingInstructions.docx

PowerPoint Presentation:  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 Download Class25_CourseWrapup.pptx

 

Dec. 11 - 15 - Finals Week