Schedule
Mastery learning
Traditional classes are time-based learning. You spend a specific amount of time on a topic and then you move on to the next topic. For example, in 220 you might cover while and for loops in week 5, take a quiz on them, and then move on to ArrayLists in week 6. Suppose you got a 75% on that quiz in week 5. That means that you did not learn 25% of the material. In week 10 you take a test on inheritance and get an 80% (you did not master 20% of the material). These gaps in your mastery start adding up, and eventually, in some future class you will hit a wall.
In contrast, in Mastery Learning you stay on the topic until you master it. You work at your own pace. The bulk of this class centers on this approach. You stay on a topic until you master it. The lectures are a set of videos (mostly screencasts) that you can watch at anytime.
Some class elements are traditional time-based ones and they are indicated on the schedule below.
Actual scheduled events are listed in bold.
Suggested schedule of videos is indicated in green.
Suggested dates to finish projects is indicated in brown.
General topics to be working on are indicated in gray.
week 1
- Wednesday 18 January – intro
- videos – 3 hrs.
- Vagrant – 25m
- Getting started with Cloud9 – 21m
- Introduction to Git – 34m
- Introduction to Google Cloud – 35m
- Introduction to Flask – 10m
- Basic Flask Templates – 20m
- Flask variables, Conditionals and Loops – 20m
- Basic Flask running on c9.
- Basic Flask templates
week 2
- Wednesday 25 January- RAT 1 hfSQL ch1&2
- rudiment: Basic Flask Templates – goal to get done with this by Friday!
- Videos – 1.5 hours
- postgresql on Cloud9 – 16m
- Postgres and Principle of Least Privilege – 13m
- Flask and HTML Forms – 21m
- PostgreSQL and Flask – 20m
- Flask PostgreSQL Tips – 20m
- Pretty Good Practices – 18m
- Simple Forms
- Postgres on c9
week 3
- Monday 30 January – Lightning Round 0 (lightning round prep)
- Videos – 25 minutes
- Session Variables 25m
- Python and Postgres
- rudiment: Flask/PostgreSQL
week 4
- Monday 6 February – RAT 2 hfSQL ch3, 4, 5 & 12
- optional rudiment: Where in the World
week 5
- Monday 13 February – Lightning Round 1 (helpful to bring textbook)
- tomato.sql
- world.sql (drop your old world db and install this one)
- Videos < 1 hr.
- SocketIO part 1: 34m
- SocketIO part 2: 17m
- rudiment: Session Task
week 6
- Monday 20 February– RAT 3 hfSQL ch 6, 7
- rudiment: SocketIO task 1
- Digital Ocean Quest
week 7
- Monday 27 February – Lightning Round 2
- world.sql (you already have)
- umw.sql
- tomatoes2p.sql (new version)
- NOTE: these databases are not in 3NF in order for you to work on simple queries before we work on those involving joins. In Real Life we would not design databases in this way.
- videos: 1.5 hr.
- Normal Form: 21m
- More on Normalization: 35m
- Random Friday: 34m
week 8
- Monday 6 March – Spring Break
- rudiment: SocketIO task 2 – the major refactor
week 9
- Monday 13 March – RAT hfSQL ch 8, 9, 10
- rudiment: SocketIO task 2 – the major refactor
- Wednesday
- Project Sprint 1 demo
- talk to me to sign up
week 10
- Monday 20 March
- Lightning Round 3
- additional join info
- World7.sql
- Chinook (NOTE: This does not create a database)
- Movies
- Videos
- Acid and Base Semantics 32m
week 11
- Monday 27 March
week 12
- Monday 3 April
- demo: Samantha and Kevin
- noSQL lab1
week 13
- noSQL map reduce
week 15
- noSQL project demo
- Developer Blog Signup
- Department Data Science Survey