week

lecture dates

topics, exams, and special dates

optional readings

1

9/2, 9/4

Course overview and introduction

Database fundamentals

No lab meetings this week

K (Kroenke):

chap. 1

2

9/9, 9/11

The relational model

No lecture on 9/7 (Labor Day)

K: chap. 2, 3

3

9/14, 9/16, 9/18

SQL

Problem Set 1 due on 9/16

9/16: last day to add a class

K: chap. 2, 3

4

9/21, 9/23, 9/25

SQL (cont.)

Database modeling and design

Problem Set 2 due on 9/23

K: chap. 4, 5

5

9/28, 9/30, 10/2

Database modeling and design (cont.)

Problem Set 3 due on 9/30

Quiz 1 on 10/2

K: chap. 4, 5

6

10/5, 10/7, 10/9

Programming in Python: intro., working with numbers

Problem Set 4 due on 10/7

10/7: last day to drop without a 'W', and to change from credit to audit status

Z (Zelle):

chap. 1, 2, 3

7

10/13, 10/14, 10/16

Programming in Python: making decisions, working with strings and lists

Problem Set 5 due on 10/14

No lecture on 10/12 (Columbus Day)

Lecture on Tues. 10/13 (Mon. schedule)

Z: sect. 7.1-7.3,

sect. 4.1-4.5

8

10/19, 10/21, 10/23

Programming in Python: accessing a

database, working with files

Problem Set 6 due on 10/21

Z: sect. 4.6

9

10/26, 10/28, 10/30

Programming in Python: files (cont.)

Quiz 2 on 10/30

10

11/2, 11/4, 11/6

Data visualization & information design

Problem Set 7 due on 11/4

11

11/9, 11/13

Data mining: intro., classification learning

Problem Set 8 due on 11/13

No lecture on 11/11 (Veteran's Day)

No lab meetings this week

11/12: last day to drop a class with a 'W'

12

11/16, 11/18, 11/20

Classification learning, numeric estimation, preparing the data

Final-project proposal due on 11/18

13

11/23

Preparing the data, association learning

No lectures 11/25 or 27 (Fall recess)

No lab meetings this week

14

11/30, 12/2, 12/4

Association learning, case study

Problem Set 9 due on 12/2

Quiz 3 on 12/4

15

12/7, 12/9, 12/11

Case studies and/or project presentations

Final projects due on 12/11

Final exam: Mon., 12/21, 12:30-2:30 p.m.