CS 105
Fall 2018

Schedule

week

lecture dates

topics, exams, due dates, and other special dates

0

9/5, 9/7

  • Course overview and introduction
  • Database fundamentals
  • No labs this week

1

9/10, 9/12, 9/14

  • The relational model: How is data organized in a typical database?
  • SQL: a language for creating, modifying, and extracting data from a database

2

9/17, 9/19, 9/21

  • SQL (cont.)
  • 9/17: last day to add a class
  • Problem Set 1 due on 9/20

3

9/24, 9/26, 9/28

  • SQL (cont.)
  • Problem Set 2 due on 9/27

4

10/1, 10/3, 10/5

  • SQL practice
  • Programming in Python: fundamentals, loops
  • Problem Set 3 due on 10/4

5

10/9, 10/10, 10/12

  • Python: working with numbers, making decisions
  • No lecture on 10/8 (Columbus Day)
  • Lecture on 10/9 (Mon. schedule)
  • 10/9: last day to drop without a ‘W’
  • Quiz 1 on 10/10
  • Problem Set 4 due on 10/12 (Friday)

6

10/15, 10/17, 10/19

  • Python: working with strings/text and lists; accessing a database
  • Problem Set 5 due on 10/18

7

10/22, 10/24, 10/26

  • Python: working with data in a text file
  • Problem Set 6 due on 10/25

8

10/29, 10/31, 11/2

  • Data visualization: how to create compelling and useful data graphics
  • Problem Set 7 due on 11/1

9

11/5, 11/7, 11/9

  • Data mining: what is it? How can a computer learn to categorize things?
  • 11/9: last day to drop with a ‘W’
  • Quiz 2 on 11/7

10

11/12, 11/14, 11/16

  • Data mining: categorizing things (cont.), finding patterns in numeric data
  • Problem Set 8 due on 11/15
  • Final-project proposal due on 11/18

11

11/19

  • Data mining: discovering arbitrary relationships
  • No lectures on 11/21, 11/23 (Fall break)
  • No labs this week

12

11/26, 11/28,

  • Data mining: preparing data for mining; case study
  • Problem Set 9 due on 11/29

13

12/3, 12/5, 12/7

  • Case studies and/or project sessions
  • Quiz 3 on 12/5
  • Work on final project

14

12/10, 12/12

  • Case studies and/or project sessions
  • Final projects due on 12/12
  • 12/13-12/16: Study period

15

  • Final exam: Fri, 12/21, 12:30-2:30 pm
    The exam must be taken at this time, so please plan your travel accordingly!