schedule.md

layout	title
page	Data Carpentry for Biologists Schedule

Week 1: Introduction, Creating Databases, Adding Data

Material:

• Video Introduction
• Introduction
• Quality Assurance & Control

Week 2: Selecting, Filtering, Sorting, and Aggregating Data

Material:

The reading and videos cover the same material. You can either choose one or have a look at both.

Reading:

• Basic Queries
• Aggregation

Videos:

• Selecting
• Filtering
• Sorting
• Aggregation
• Nulls

[Assignment 1]({{ site.baseurl }}/assignments/sql-1)

Week 3: Tidy Data, Joins, Nested Queries

Material:

For Joins and Nested Queries you can watch the video or do the reading, you don't need both.

• Tidy Data, Sections 1-3
• Data Organization
• Joins [Video]
• Joins [Reading]
• Nested Queries [Video]
• [Nested Queries]({{ site.baseurl }}/lectures/sql_nested_queries/) [Reading]

[Assignment 2]({{ site.baseurl }}/assignments/sql-2)

Week 4: Introduction to R and RStudio

Topics

• R & RStudio
• Expressions & Variables
• Types
• Errors
• Vectors

Reading:

• Getting Started
• Introduction to R

[Assignment 3]({{ site.baseurl }}/assignments/r-1)

Week 5: Working with Data

Topics

• Matrices & data frames
• Importing data
• Basic subsetting
• Readable code

Reading

• Starting with data
• Introduction to data frames
• Vector Reference[Read links at bottom]
• Data Frame Reference [Read links at bottom]

[Assignment 4]({{ site.baseurl }}/assignments/r-2)

Week 6: Working with Tabular Data

Topics

• dplyr

Reading:

• Aggregating and analyzing data with dplyr
• optional Introduction to dplyr vignette

[Assignment 5]({{ site.baseurl }}/assignments/r-3)

Week 7: Data Visualization

Reading

• Graphics with ggplot2 using ggplot
• Graphics with ggplot2 using qplot [optional]

[Assignment 6]({{ site.baseurl }}/assignments/r-4)

Week 8: Programming Fundamentals 1

Topics

• Functions
• Loops

Reading

• Creating functions
• Software Carpentry loops lesson

Assignment 7

Week 9: Programming Fundamentals 2

Topics

• Conditionals
• Problem decomposition

Reading

• Software Carpentry lesson on making choices

Assignment 8

Week 10: Version Control

Reading

• Git basics in RStudio

Assignment 9

Week 11: Combining R and SQL databases

Reading

• SQL databases and R

Assignment 10

Week 12: Putting it all together

Topics

• Style
• Debugging

Reading

• Hadley Wickham's R style guide

Assignment 11

Weeks 13-16: Projects