Spring 2011 CS1803 Calendar

References

Week 1: January 14th-21st - Introduction, Python

Day	Readings/Assignments	Resources
Friday, January 14th	Course Syllabus Read: ThinkCS Chapters 1 & 2 Read: WhatIsAllowed.pdf	GIMP for windows GIMP for MacOSX CS1803 - Where it fits.pdf CS 1803 - Fall 2010 course website
Workshop		Python (version 3.1.3) http://www.python.org
Wednesday, January 19th	Read: ThinkCS Chapter 3 - Functions Read: Differences Between Python 2 and Python 3 HW 0 - Due before 6pm	Reference: Python Language Reference: Function Definitions VariablesTypesMath.ppt Functions.ppt PIP3: Chapter 1
Friday, January 21st	Read ThinkCS Chapter 4 - Conditionals Read: ThinkCS Chapter 5 - Fruitful Functions	Reference: Python Language Manual: IF statement Python is #5 in the world!

Week 2: January 24th-28th - Iteration, Strings & Lists

Day	Readings/Assignments	Resources
Monday, January 24th	Read ThinkCS Chapter 6 - Iteration	Reference: Python Reference Manual: For & While statements
Workshop	Watch Video: Fun with Pair Programming Coffee RA
Wednesday, January 26th	Read ThinkCS Chapter 7 - Strings Read ThinkCS Chapter 9 - Lists HW1 Due before 6pm!	String Methods String Formatting Reference:Python 3 String Documentation PIP3: Chapter 2 Reference: Dive Chapter 2: Native Datatypes Reference: Dive Chapter 4: Strings lecture4_python.py
Friday, Jan 28th	Python Review 1	Python-Review1.pdf lecture5_review.py PIP3: Chapter 3

Week 3: January 31st - February 4th- Recursion, Exceptions, & Dictionaries

Day	Readings/Assignments	Resources
Monday, January 31st	Read: ThinkCS Chapter 11 - Recursion & exceptions	Code: get_int.py Introduction to the Fibonacci sequence by Tool (Lateralus) Reference: Dive Chapter 7: Classes & Iterators Code: lecture6.py
Workshop	cs1803-itteration-RA.pdf
Wednesday, Febuary 2nd	Read: ThinkCS Chapter 12 - Dictionaries HW2 Due before 6pm	lecture7.py
Friday, February 4th	Read: ThinkCS Chapter 10 - Modules & files	Reference: Dive Chapter 11 - Files

Week 4: February 7th-11th - File I/O & Basic Python Objects

Day	Readings/Assignments	Resources
Monday, February 7th	Read: ThinkCS Chapter 13 - Classes and Objects Read 7.1-7.4 (Classes & Iterators) from Dive into Python 3.	PIP3: Chapter 6 (pgs.233-245) filterFile.py feb_7th-lecture.py
Workshop	RQ-list.pdf
Wednesday, February 9th	Read: ThinkCS Chapter 14 - Classes and Functions Read: ThinkCS Chapter 15 - Classes and Methods	feb9_lecture.py Point.py
Friday, February 11th	HW 3 Due before 6pm Exam Review	feb11_lecture.py Python Review 2.pdf Fall 2010 Exam 1.pdf Fall 2010 Exam 1 - Answers

TA Led Exam Review: Saturday Feb 12th, 2pm, D.M. Smith Building, Room 105

Week 5: February 14th-18th - Reading & Writing CSV files

Day	Readings/Assignments	Resources
Monday, February 14th	Exam 1	cs1803-spring2011-exam1.pdf cs1803-spring2011-exam1-key.pdf
Workshop
Wednesday, February 16th	Read DMSI:CSV Files	lecture_feb16.txt
Friday, February 18th	Midterm Grade Reports	parseMoney.py feb18_lecture.py

Week 6: February 21st - 25th - GUI's

Day	Readings/Assignments	Resources
Monday, February 21st	Read DMSI: Graphical User Interfaces Read PIP3: Chapter 15 - Introduction to GUI Programming Read sections 1-5 of An Introduction to Tkinter	feb21_lecture.py
Workshop
Wednesday, Feburary 23rd	HW 4 - Greedy Scheduler due before 6pm Read sections 6-7 of An Introduction to Tkinter	feb23_lecture.py Code:tic-tac-toe GUI More Info: The game of Tic-Tac-Toe
Friday, Feburary 25th	Read sections 8 & 9 of An Introduction to Tkinter

Week 7: February 28th - March 4th - Dynamic GUI's & Objects

Day	Readings/Assignments	Resources
Monday February 28th	Read about canvases.	Code: canvas_demo.py Simple TTT code, demonstrating exhaustive search of all possible game outcomes: ttt-simple.py Code: ttt-smart.py
Workshop
Wednesday March 2nd	HW5 - Factory due before 6pm Read: PIP3: Chapter 6 - Object Oriented Programming Read: ThinkCS Chaper 16 - Sets of Objects Read: ThinkCS Chapter 17 - Inheritance
Friday, March 4th	Last day to drop an individual course with a W grade	Code: SimpleSimWorld.py

Week 8: March 7th- March 11th - Objects, Review, Exam

Day	Readings/Assignments	Resources
Monday March 7th	Read HOWTO: Fetch Internet Resources using the urllib Package Read PIP: Pages 225-226	Code: SimpleSimWorld2.py HTTP Web Services from DIVE.
Workshop	Timed Lab
Wednesday March 9th	Review	Practice Exam 2.pdf Practice Exam 2 - Answers.pdf cs1803-exam2-fall2010.pdf cs1803-exam2-fall2010-answers.pdf TimedLabExam2Question7.pdf TimedLabExam2Question7-gradingKey.pdf
Friday, March 11th	Exam 2	cs1803-spring2011-exam2.pdf cs1803-spring2011-exam2-answers.pdf

Week 9: March 14th-18th - Reading the Web

Day	Readings/Assignments	Resources
Monday March 14th	Read: Legal Issues with Web Scraping Read: Screen-Scraping Ethics Read: WSJ: 'Scrapers' Dig Deep for Data on Web
Workshop	HW 6 Due! (Tuesday March 16th!) pair_programming_partner_review.pdf
Wednesday March 16th		Code: readWeb_ajc.py The AJC's Terms of Service / Visitor Agreement An example table of data on the web
Friday, March 18th	Read: DMSI: Web Scraping Mini-HW 7 Due before 6pm!

Spring Break: March 21-25th

Week 10: March 28th - April 1st - Databases & SQL

Day	Readings/Assignments	Resources
Monday March 28th	Read: DMSI: Database Connectivity Read all of SQL Basic from the W3Schools SQL Tutorial Read about the Connection and Cursor objects from PEP 249 - Python Database API Spec v2.0
Workshop
Wednesday March 30th	Read PIP3: Pgs 480-488 Read about the SQL Like statement and wildcards.
Friday, April 1st	Read about the SQL Count function.	contacts_sqlite.py

Week 11: April 4th - 8th - More SQL & Remote SQL Servers

Day	Readings/Assignments	Resources
Monday April 4th	HW 8 - Web Table Reader Due before 6pm Read about the SQL Sum and Avg functions, and the GROUP BY statement.
Workshop	Install pymysql3: HOWTO_install_pymysql_windows.pdf. pymysql3-Mac-instructions.pdf. Zip file can be downloaded from here. How to access the database from off campus.
Wednesday April 6th		contacts_pymysql.py
Friday, April 8th	Read this webpage on functional programming in Python. Read PIP3: Pgs 182-183 - Lambda Functions Read PIP3: Pgs 395-398 - Functional-Style Programming HW 9 - SQL Practice

Week 12: April 11th-15th - Parsing XML, Software Engineering Practices

Day	Readings/Assignments	Resources
Monday April 11th	Re-Read Section 5.2 and 5.8 (Program Development & Doctest) from ThinkCSpy. Read Chapter 12. XML from Dive Into Python 3. Read PIP3: Pgs 312-316.	xml_weather.py weather_download.py
Workshop
Wednesday April 13th	HW 10 - NewsVender	Code Sample:xml_write.py Code Sample: weatherWebpage.py Code Sample: sql2xml.py
Friday, April 15th

Week 13: April 18th-April 22nd - Object Oriented Programming , Review & Exam

Day	Readings/Assignments	Resources
Monday April 18th	Read 7.1-7.4 (Classes & Iterators) from Dive into Python 3.	SimWorld.py
Workshop	Timed Lab
Wednesday April 20th	HW 11 - Using XML Review	PracticeExam3.pdf PracticeExam3-Key.pdf cs1803-exam3-fall2010.pdf cs1803-exam3-fall2010-answers.pdf xml_demo.py
Friday, April 22nd	Exam 3	cs1803-spring2011-exam3.pdf cs1803-spring2011-exam3-key.pdf

Week 14: April 25th - 29th - Packaging Programs & Review

Day	Readings/Assignments	Resources
Monday April 25th		List of 32,000 common words Cheating_Hangman1.py
Workshop
Wednesday April 27th		Code sample: example_xml_writer.py Data sample:exampleOUT.xml Code Sample: example_xml_reader.py
Friday, April 28th	HW 12 - Your Program Read: Py2EXE tutorial Review	Py2EXE demo files: canvasDemo24.py hello.py setup.py

Final Review: Wednesday May 4th, 6-9pm, TA Lab (CCB 107-A)

Final Exam date/time: Period 15 - Friday May 6th 2:50-5:40pm