DBM Content

 

Week Monday Wednesday Ancillary Material
8/29/2015 Introductions/Course Description/ Data Types/Excel Basics Excel Functions cont’d / Pivot Tables. 

Review Info

Lecture#01


Excel Functions

Sample Data

Lecture#2

 

9/5/2015 Labor Day – No Class

Database Design: Table Design, Relationships; Intro to SQL Server Management Studio

ASSIGN Homework #1

 

Lecture#3


HW_#1

9/12/2015 Database Creation: Importing Data, Creating Metadata

Queries/Writing SQL

Homework #1 DUE!!

Lecture#4
9/19/2015 Queries/Writing SQL

Introduction to Spatial SQL

 


 

 

9/26/2015

Spatial SQL cont’d

Data Sharing (SQL Server/ODBC) / Understanding Digital Networks Lecture#5
10/3/2015

Introduction to R

ASSIGN HW2

Introduction to R cont'd

HW#2
10/10/2015 Introduction to R cont’d

Manipulating data with R 

Homework #2 DUE!!

R References
10/17/2015 Manipulating data with R cont’d Integrate Data in R (maybe ArcGIS)  
10/24/2015 No Class Creating Workflows – Using R to script  R_Workflow
10/31/2015

Creating Workflows – Using R to script 

ASSIGN HW#3

Creating Workflows – Using R to script 

 

HW#3
11/7/2015

Creating Workflows – Using R to script cont’d: 

HW#3 DUE!!

Creating Workflows – Using R to script cont’d

For Loops

Nice R Resource

11/14/2015 TBD:  Assign Final Project  
11/21/2015 TBD Thanksgiving Break  
11/28/2015 GitHub in AG316 Work on Own Data GitHub Lecture
12/5/2015 Work on Own Data    
12/14/2015 Scheduled Final...