Difference between revisions of "CSC220 Schedule 2010"

From dftwiki3
Jump to: navigation, search
(Weekly Schedule)
(Weekly Schedule)
 
(57 intermediate revisions by the same user not shown)
Line 5: Line 5:
 
=<font color="Magenta">Main Project</font>=
 
=<font color="Magenta">Main Project</font>=
  
* [http://cs.smith.edu/classwiki/index.php/CSC220_Project_2010 Main Page] for the Project
+
* [http://cs.smith.edu/classwiki/index.php/CSC220_Page_(2010) Main Page] for the Project
  
 
=Weekly Schedule=
 
=Weekly Schedule=
Line 262: Line 262:
  
 
----
 
----
* [[CSC220 Homework 7 2010| Homework 7]]
+
* [[CSC220 Homework 7 2010| Homework 7]] and [[CSC220 Homework 7 Solutions | a solution]]
  
 
||  
 
||  
Line 271: Line 271:
 
||
 
||
 
; Monday 11/08
 
; Monday 11/08
* Presentation on GIS file formats by Jon Caris
+
* Presentation on GIS file formats by Jon Caris.  Main reference is [http://smithgisclasses.pbworks.com/w/page/32286115/CSC220 here]
 
* File uploads:
 
* File uploads:
 
** [[CSC220 uploadFile1.htm| uploadFile1.htm]] and [[CSC220_uploadFile1.htm#FileUpload1.php | uploadFile1.php]]
 
** [[CSC220 uploadFile1.htm| uploadFile1.htm]] and [[CSC220_uploadFile1.htm#FileUpload1.php | uploadFile1.php]]
Line 277: Line 277:
 
** [[CSC220 uploadFile3.htm| uploadFile3.htm]] and [[CSC220_uploadFile3.htm#FileUpload3.php | uploadFile3.php]]
 
** [[CSC220 uploadFile3.htm| uploadFile3.htm]] and [[CSC220_uploadFile3.htm#FileUpload3.php | uploadFile3.php]]
 
** [http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html  Blobs]: storage for binary data  
 
** [http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html  Blobs]: storage for binary data  
** Random subdirectories, [http://en.wikipedia.org/wiki/MD5 md5] hashing, in general, and with [http://php.net/manual/en/function.md5.php md5].
+
 
* [http://php.net/manual/en/reserved.variables.session.php Php $_SESSION], and [http://www.tizag.com/phpT/phpsessions.php Php examples]
 
  
 
; Wednesday 11/10
 
; Wednesday 11/10
 
:[[Image:FlightPatternsInProcessing.jpg|right|300px|link=http://www.aaronkoblin.com/work/flightpatterns/]]
 
:[[Image:FlightPatternsInProcessing.jpg|right|300px|link=http://www.aaronkoblin.com/work/flightpatterns/]]
 
* Presentation on '''Processing''' and data visualization by '''Eitan Mendelowitz'''
 
* Presentation on '''Processing''' and data visualization by '''Eitan Mendelowitz'''
 +
** [[CSC220 Processing Sketch Examples | Eitan's sketches]]
 
* Some examples with potential usefulness for our project:
 
* Some examples with potential usefulness for our project:
 
** [http://processing.org/learning/topics/pattern.html patterns...]
 
** [http://processing.org/learning/topics/pattern.html patterns...]
Line 290: Line 290:
 
** [http://processing.org/learning/topics/puff.html puff...]
 
** [http://processing.org/learning/topics/puff.html puff...]
 
** [http://processing.org/learning/topics/reflection2.html reflection...]
 
** [http://processing.org/learning/topics/reflection2.html reflection...]
* [[CSC220 Processing and Web Access Examples | Web Access from a Processing Script]]
+
* [[CSC220 Processing and Web Access Examples | Web Access from a Processing Sketch]]
 
+
----
 +
* Additional Information from Jon:
 +
** Jon's wiki: http://smithgisclasses.pbworks.com/w/page/32286115/CSC220
 +
** Example of GoogleMap Animations
 +
*** GPX to Google Maps animation (very, very cool!) : http://www.chrislacy.net/map/current/index.html
 +
*** uTrack- online GPX track report generator (very cool):  http://utrack.crempa.net/
 +
*** Mike Williams - Google Maps API Tutorial: http://econym.org.uk/gmap/example_cartrip.htm
 +
*** London Tube (looks promising) Website: http://traintimes.org.uk:81/map/tube/?from=map;to=tube
 +
*** Code at github: https://github.com/dracos/underground-live-map
 +
*** Christchurch Earthquake Map: http://www.christchurchquakemap.co.nz/
 
----
 
----
*
+
* [[CSC220 Homework 8 2010 | Homework 8]] <--- due 11/19
  
 
||  
 
||  
 
* [http://processing.org/ Processing.org]: the main reference and point of entry!
 
* [http://processing.org/ Processing.org]: the main reference and point of entry!
*
+
 
 
    
 
    
 
|- valign="top"
 
|- valign="top"
Line 303: Line 312:
 
||
 
||
 
; Monday 11/15
 
; Monday 11/15
 +
* Food for thought:
 +
<br />
 +
<center><videoflash type="vimeo">14200191</videoflash></center>
 +
<br />
 +
Visualization of Wikileaks '''in Processing''' 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. <br /><br />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?  
 
* Storing uploaded files on server: in database or in subdirectories?  
 
** Random subdirectories, [http://en.wikipedia.org/wiki/MD5 md5] hashing, in general, and with [http://php.net/manual/en/function.md5.php md5].
 
** Random subdirectories, [http://en.wikipedia.org/wiki/MD5 md5] hashing, in general, and with [http://php.net/manual/en/function.md5.php md5].
 
* [http://php.net/manual/en/reserved.variables.session.php Php $_SESSION], and [http://www.tizag.com/phpT/phpsessions.php Php examples]
 
* [http://php.net/manual/en/reserved.variables.session.php Php $_SESSION], and [http://www.tizag.com/phpT/phpsessions.php Php examples]
; Wednesday 11/17
+
* [[CSC220 Cookie Example | Cookie Example]] and [http://maven.smith.edu/~220a/cookie.php link]
 +
* [http://www.cafeaulait.org/course/week5/16.html Passing parameters to applets]
 +
* [[CSC220 Project Time Diagram | Snapshots from Today's Class]]
 +
; Wednesday 11/17  
 +
* '''Team work + contract'''
 +
# Name of individual team partners (does your team have a name?)
 +
# Description of the tasks you want to work on for the final project
 +
# Your plan of attack:
 +
## Where are you starting from?
 +
## What do you want to have accomplished by the time of the presentation on the last day of class?
 +
## What do you want to have accomplished by the last day of exams, which is when the project is due?
 +
## What is missing for you to accomplish your goal(s)?
 +
## Do you have all the data?  Part of the data?
 +
## Do you have all the programs?  Some of the programs?  Is there anybody else in class who is generating something you need?  Which team is it?
 +
## How do you plan on addressing Items 5 and 6?
 +
# If your plan of attack fails for some reason, is there an easy way to change direction?
 +
 
 +
* More food for thought (from http://www.digitalurban.org/2010/11/swinglet-cam-diy-drone-aerial.html)
 +
<videoflash>B-xVy2E1sT4</videoflash>
 +
 
 
----
 
----
*
+
* No homework this week; Work on your project!
  
 
||  
 
||  
*
+
* [http://php.net/manual/en/function.setcookie.php  setcookie()] function
 +
* [http://www.tizag.com/phpT/phpcookies.php Tutorial] on cookies
  
 
|- style="background:#eeeeff" valign="top"
 
|- style="background:#eeeeff" valign="top"
Line 317: Line 352:
 
||
 
||
 
;  Monday 11/22
 
;  Monday 11/22
; Wednesday 11/24 -- '''Thanksgiving Break'''
+
* <font color="magenta">'''Lab 8'''</font> on mail redirection
 
+
* <font color="magenta">'''Lab 9'''</font> on backing up mysql databases
 +
; Wednesday 11/24  
 +
<tanbox>
 +
<!--[[Image:DancingTurkey.gif | 150px| right]]-->
 +
[[Image:TurkeyCarcass.jpg | 200px | right]]
 +
<center>'''Thanksgiving<br />Break'''</center>
 +
</tanbox>
 
----
 
----
*
+
* No homework this week; Work on your project!
 +
*  [[CSC220 Lab 8: Redirecting Email to Database | Lab 8]]
 +
* [[CSC220 Lab 9: Automatic MySql Database Backup | Lab 9]]
 
||  
 
||  
 
*
 
*
Line 329: Line 372:
 
||
 
||
 
; Monday 11/29
 
; Monday 11/29
 +
* [http://cs.smith.edu/~thiebaut/classes/220/CppCrashCourse_220_2010.pdf  C++ Crash Course].  There are no solutions to the labs/exercises in the presentation: you have to work them out on your own to learn C++!!!
 
; Wednesday 12/1
 
; Wednesday 12/1
 +
* Group work on project ([http://www.facebook.com/album.php?aid=259348&id=264041891883 photos])
 +
<br />
 +
[[Image:CSC220Board_1_1201.jpg |200px]]
 +
[[Image:CSC220Board_2_1201.jpg|200px]] <br />
 +
<br />
 +
[[Image:CSC220Board_3_1201.jpg|200px]]
 +
[[Image:CSC220Board_4_1201.jpg|200px]]
 +
<br />
 +
* Food for thought:
 +
<videoflash>4cEQZreQ2zQ</videoflash>
 +
<br />
 +
* New development for processing: processing/javascript: program in Processing, save as a javascript library.  No java involved!
 +
<center>[[Image:ProcessingJS_org.png|300px|link=http://processingjs.org/]]<br />http://processingjs.org/</center>
 +
 
----
 
----
*
+
* No homework this week; Work on your project!
 
||
 
||
*
+
* [http://cplusplus.com/doc/tutorial/ C++ Tutorial]: Very good coverage of C++!
  
 
|- style="background:#eeeeff" valign="top"
 
|- style="background:#eeeeff" valign="top"
Line 339: Line 397:
 
||
 
||
 
; Monday 12/06
 
; Monday 12/06
 +
* [[CSC220 C++Qt Crash Course | C++ Crash Course: GUI Programming with Qt]]
 
; Wednesday 12/08
 
; Wednesday 12/08
 +
* [http://cs.smith.edu/classwiki/index.php/CSC220_Assignments_2010 Assignments from last meeting on 12/1]
 +
* Group work
 +
* Board Capture:
 +
[[Image:CSC220ProjectPresPrepa1.jpg|140px]]
 +
[[Image:CSC220ProjectPresPrepa2.jpg|140px]] 
 +
[[Image:CSC220ProjectPresPrepa3.jpg|140px]]
 +
<br />
 +
[[Image:CSC220ProjectPresPrepa4.jpg|140px]]
 +
[[Image:CSC220ProjectPresPrepa5.jpg|140px]]
 +
[[Image:CSC220ProjectPresPrepa6.jpg|140px]]
 
----
 
----
*
+
* No homework this week; Work on your project!
 
||  
 
||  
 
*
 
*
Line 349: Line 418:
 
| Week 15 <br /> 12/13  
 
| Week 15 <br /> 12/13  
 
||
 
||
; '''Monday''' -- '''Last Class'''
+
; '''Monday''' -- '''Project Presentation'''
 +
<center>
 +
[[Image:ProjectPresentation1.gif]]
 +
</center>
 +
;Food for thought
 +
* Below, Facebook friendship graph, from http://chartporn.org/2010/12/14/facebook-friends/
 +
<center>[[Image:FacebookFriendships.png|450px]]</center>
 +
 
 
----
 
----
*
+
* [[CSC220 Final Assignment 2010 | Final Assignment]] regarding project with details of submission.
 
||  
 
||  
 
*
 
*
Line 387: Line 463:
 
=List of Programs=
 
=List of Programs=
 
   
 
   
*
+
* [[:Category:Php| Php]] programs
 
+
* [[:Category:MySql |MySql]] programs
=Miscellaneous Information=
+
* [[:Category:Bash | Bash ]] programs
 
+
* [[:Category:Processing |Processing]] programs
* [[Image:amsterdam.png|10px|right]]
 
 
 
  
  
Line 408: Line 482:
  
 
<br />
 
<br />
[[Category:CSC220]]
+
[[Category:CSC220]][[Category:Processing]][[Category:Php]][[Category:MySql]][[Category:Bash]]

Latest revision as of 15:38, 14 December 2010

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 in Processing 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.

Wednesday 11/17
  • Team work + contract
  1. Name of individual team partners (does your team have a name?)
  2. Description of the tasks you want to work on for the final project
  3. Your plan of attack:
    1. Where are you starting from?
    2. What do you want to have accomplished by the time of the presentation on the last day of class?
    3. What do you want to have accomplished by the last day of exams, which is when the project is due?
    4. What is missing for you to accomplish your goal(s)?
    5. Do you have all the data? Part of the data?
    6. Do you have all the programs? Some of the programs? Is there anybody else in class who is generating something you need? Which team is it?
    7. How do you plan on addressing Items 5 and 6?
  4. If your plan of attack fails for some reason, is there an easy way to change direction?


  • No homework this week; Work on your project!
Week 12
11/22
Monday 11/22
  • Lab 8 on mail redirection
  • Lab 9 on backing up mysql databases
Wednesday 11/24
TurkeyCarcass.jpg
Thanksgiving
Break


Week 13
11/29
Monday 11/29
  • C++ Crash Course. There are no solutions to the labs/exercises in the presentation: you have to work them out on your own to learn C++!!!
Wednesday 12/1
  • Group work on project (photos)


CSC220Board 1 1201.jpg CSC220Board 2 1201.jpg

CSC220Board 3 1201.jpg CSC220Board 4 1201.jpg

  • Food for thought:


  • New development for processing: processing/javascript: program in Processing, save as a javascript library. No java involved!
ProcessingJS org.png
http://processingjs.org/

  • No homework this week; Work on your project!
Week 14
12/06
Monday 12/06
Wednesday 12/08

CSC220ProjectPresPrepa1.jpg CSC220ProjectPresPrepa2.jpg CSC220ProjectPresPrepa3.jpg
CSC220ProjectPresPrepa4.jpg CSC220ProjectPresPrepa5.jpg CSC220ProjectPresPrepa6.jpg


  • No homework this week; Work on your project!


Week 15
12/13
Monday -- Project Presentation

ProjectPresentation1.gif

Food for thought
FacebookFriendships.png



Links and Resources

Bash Shell

Linux Utilities

MySQL

Maps/GIS

Tips & Tricks

List of Programs












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