CSC220 Schedule 2010

From dftwiki3
Revision as of 09:28, 11 November 2010 by Thiebaut (talk | contribs)
Jump to: navigation, search

Back to Main Page


Main Project

Weekly Schedule

Week Topics Reading
Week 1
9/08
Wednesday 9/08
  • Introduction and syllabus
  • Overview of the project
  • What we'll use this semester
  • Sources of information
  • Linux shells
    • what is a shell (see wikipedia)?
    • different choices: Bourne shell, C shell, Z shell, Korn shell, Bash (Bourne Again) shell
  • The Bash shell
    • default shell for Mac, GNU operation system, and many Linux variants
    • has been ported to MS-DOS
    • configuration files: .bash_profile, .bashrc
    • important commands:
      • ls
      • rm
      • cat
      • cd
      • pwd
      • grep, -i, -l, -v, -A, -B
      • wc
      • chmod
      • chown
      • head & tail
      • tail -f
      • history
      • watch

  •  
Week 2
9/13
LearningTheBashShell.gif
Mon 9/13
  • Lab 1: playing with bash
  • pipes and redirection, stdout, stderr
    • sort
Wed 9/15

Week 3
9/20
Monday 9/20
Wednesday 9/22
  • phpinfo() test
  • using Php as interpreter (on hadoop110)
  • Arrays in php: sample programs
  • Lab 3

Week 4
9/27
Monday 9/27

  • Lab #4 on Forms
  • Mini assignment for Wed 9/29: create an organizational chart for the project. What needs to happen? What tools will be needed? How/where is the data stored? How is the data observed?
  • Homework #3 and Solution programs
Week 5
10/04
Monday 10/04
  • Project overview. See pictures here.
  • Below, a video created by Jon for the class. Thanks Jon!

Wednesday 10/06



Week 6
10/11
Monday

Fall Break

Wednesday
Lab 5
Food for thought...


Week 7
10/18
Monday 10/18
MysqlLogo.png
Wednesday
  • Difference between joins (inner and outer)
  • Views
  • Indexes
  • Feedback on Homework #4


Thursday -- Take-home Midterm Exam, available here!

Week 8
10/25
Monday 10/25
  • A word about the Solution for Homework 5
  • Indexes
    • B-Trees
    • PRIMARY INDEX
    • INDEX
    • UNIQUE
    • FULL TEXT
  • Lab 6
Wednesday 10/27

Week 9
11/01
SQLInjection XKCD.png
Monday 11/01
CSC220ProjectDiagram2.jpg
Wednesday 11/03
  • GPS demo by Jon Caris

Week 10
11/08
Monday 11/08


Wednesday 11/10
FlightPatternsInProcessing.jpg


Week 11
11/15
Monday 11/15
  • Food for thought:



Visualization of Wikileaks by Mike Dewar. Mike says This is a visualisation of activity in Afghanistan from 2004 to 2009 based on the Wikileaks data set. Here we’re thinking of activity as the number of events logged in a small region of the map over a 1 month window. These events consist of all the different types of activity going on in Afghanistan.

The intensity of the heatmap represents the number of events logged. The colour range is from 0 to 60+ events over a one month window. We cap the colour range at 60 events so that low intensity activity involving just a handful of events can be seen – in lots of cases there are many more than 60 events in one particular region. The heatmap is constructed for every day in the period from 2004-2009, and the movie runs at 10 days per second.

  • Storing uploaded files on server: in database or in subdirectories?
    • Random subdirectories, md5 hashing, in general, and with md5.
  • Php $_SESSION, and Php examples
Wednesday 11/17

Week 12
11/22
Monday 11/22
Wednesday 11/24 -- Thanksgiving Break


Week 13
11/29
Monday 11/29
Wednesday 12/1

Week 14
12/06
Monday 12/06
Wednesday 12/08


Week 15
12/13
Monday -- Last Class



Links and Resources

Bash Shell

Linux Utilities

MySQL

Maps/GIS

Tips & Tricks

List of Programs

Miscellaneous Information

  • Amsterdam.png












(c) D. Thiebaut 2010, Dept. Computer Science, Smith College.