assignments

getting started

• Describe your previous programming and internet experience.
• As a programming warmup, write a program that translates text into pig latin. All the details (language, interface, complexity, ...) are up to you. Submit your code and enough documentation, tests, and/or screenshots to show what you did and that it works.
• As an internet warmup, create a static web page on a topic of your choice using html5 and css. It should include at least one image and at least link. You can deploy it anywhere you like, including just as attached files in your work submission.
• Finally, give some feedback. Were those two tasks hard? Easy? Fun?

HTTP and CGI

• Browse through the Sep 11 & Sep 18 from last year
• Pick some part of that which looks interesting , implement, and come to class Tuesday ready to share and discuss.

relational databases

• Read about SQL syntax and databases. (See the sources on the resources for some starting places.)
• Practice your SQL chops with the databases and exercises at http://en.wikibooks.org/wiki/SQL_Exercises .
  • Look at three databases: "warehouse", "pieces and providers", and "planet express".
  • For the first two, browse the exercises, trying least three from each. (Warning: there will be more than one 'correct' answer.)
  • Using sqlite, load at least one of these databases and test your answers explicitly.
  • Invent at least three similar exercises for the planet express database, and again test explicitly with sqlite.
• Coming: a related SqlAlchemy task.

flask take 1

• Start reading and exploring the Flask web app framework
• Put together a first version of site using it (or part of it)

midterm project

• Finish a Flask web app including a SQL database and ORM object layer.
• Details all up to you ... but do include docs and trimmings.

final project

• Submit whatever you worked on as the 2nd project.