Spring 2013 CS2316 Calendar

References

Week 1: January 7th-11th - Introduction, Python, Conditionals

Day	Readings/Assignments	Resources
Monday, January 7th	Course Syllabus Read: ThinkCS Chapters 1 & 2 Read WhatIsAllowed.pdf	GIMP for windows GIMP for MacOSX CS 2316 - Workload.pdf CS 2316 - Where it fits.pdf CS 2316 - Spring 2012 course website CS 2316 - Fall 2011 course website CS 2316 - Summer 2011 course website
Workshop	Read: ThinkCS Chapter 3 - Hello, little turtles!	Python (version 3.2.3) http://www.python.org If you have a Mac, read this: IDLE and tkinter with Tcl/Tk on Mac OS X and install the appropriate version of ActiveTcl for your Mac OS X version. A list of TK color "names"
Wednesday, January 9th	Read ThinkCS Chapter 4 - Functions Read: Differences Between Python 2 and Python 3	Reference: Python Language Reference: Function Definitions VariablesTypesMath.ppt Functions.ppt keywords vs. identifiers PIP3: Chapter 1
Friday, January 11th	Read: ThinkCS Chapter 5 - Conditionals Read: ThinkCS Chapter 6 - Fruitful Functions	Reference: Python Language Manual: IF statement Python is #8 in the world!

Week 2: January 14th-18th - Iteration, Strings, Lists & Recursion

Day	Readings/Assignments	Resources
Monday, January 14th	Read ThinkCS Chapter 7 - Iteration Read Section 5.8 - Unit Testing with Doctest HW0 - Introduction Due!	Reference: Python Reference Manual: For & While statements code: doctest example.py
Workshop	RA Coffee Watch Video: Fun with Pair Programming
Wednesday, January 16th	Read ThinkCS Chapter 8 - Strings HW1 - Python Practice 1 Due	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, January 18th	Read ThinkCS Chapter 11 - Lists	lecture5_review.py Code: lecture6.py Code: calcListAvg.py

Week 3: January 21st-25th - Lists, Recursion & Dictionaries

Day	Readings/Assignments	Resources
Monday, January 21st	M.L.K. Jr Holiday - No Classes
Workshop	string-RQ iteration-RA
Wednesday, January 23rd	Read: ThinkCS Chapter 18 & 19 - Recursion & exceptions HW2 - Python Practice 2 Due	lecture7.py Python-Review1.pdf PIP3: Chapter 3 Code: get_int.py Introduction to the Fibonacci sequence by Tool (Lateralus) Reference: Dive Chapter 7: Classes & Iterators
Friday, January 25th	Read: ThinkCS Chapter 20 - Dictionaries	Reference: Dive Chapter 11 - Files

Week 4: January 28th - February 1st - Modules & File I/O

Day	Readings/Assignments	Resources
Monday, January 28th	Exam Review Read: Thinks CS Chapter 9 - Tuples	Exam 1 Vocabulary list feb11_lecture.py Python Review 2.pdf cs2316-exam1-fall2011.pdf cs2316-exam1-fall2011-answers.pdf cs2316-exam1-spring2012.pdf cs2316-exam1-spring2012-answers.pdf cs2316-exam1-fall2012.pdf cs2316-exam1-fall2012-answers.pdf
Workshop (Jan 29th)	HW3 - Calculator Fun Due Practice Timed Lab 0
Wednesday, January 30th	EXAM1	cs2316-exam1-spring2013.pdf cs2316-exam1-spring2013-answers.pdf
Friday, February 1st		filterFile.py feb_7th-lecture.py

Week 5: February 4th-8th Basic Objects, Reading & Writing CSV files

Day	Readings/Assignments	Resources
Monday, February 4th	Read DMSI:CSV Files	Pickle Module documentation
Workshop	Timed Lab 1	Summer 2011 Timed Lab 1 cs2316-fall2011-tl1-string-stats.pdf CS 2316 Fall 2012 Timed Lab 1 - Library Helper CS 2316 Spring 2012 TL1 - Python Fundamentals CS 2316 Spring 2013 TL1 - List Filtering
Wednesday, February 6th	HW4 - Lifeguard Ranker Due Read: ThinkCS Chapter 15 - Classes and Objects - the Basics Read 7.1-7.4 (Classes & Iterators) from Dive into Python 3.	PIP3: Chapter 6 (pgs.233-245) lecture_feb16.txt
Friday, February 8th	Read: ThinkCS Chapter 16 - Classes - Digging a little deeper Read: ThinkCS Chapter 21 - Even more OOP	guiDemo.py parseMoney.py feb18_lecture.py

Week 6: February 11th-15th - GUI's

Day	Readings/Assignments	Resources
Monday, February 11th	Read DMSI: Graphical User Interfaces Read sections 1-5 of An Introduction to Tkinter	PIP3: Chapter 15 - Introduction to GUI Programming feb21_lecture.py Point.py
Workshop	RA-FindMax sample_numbers.txt
Wednesday, February 13th	Read sections 6-7 of An Introduction to Tkinter	labels_colors.py Code:tic-tac-toe GUI More Info: The game of Tic-Tac-Toe
Thursday Feb 14th	HW 5 - GUI File Reader (Factory) Due
Friday, February 15th	Read sections 8 & 9 of An Introduction to Tkinter Progress reports for 1000 & 2000 level classes due!	EntryDemo.py radioButtonDemo.py

Week 7: February 18th-22nd - Dynamic GUI's, & Objects

Day	Readings/Assignments	Resources
Monday February 18th	Read about canvases. Read: ThinkCS Chaper 22 - Sets of Objects	Code: Radio Button Demo
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 February 20th	Read: DMSI: Web Scraping Read: Legal Issues with Web Scraping Read: Screen-Scraping Ethics Read: WSJ: 'Scrapers' Dig Deep for Data on Web	PIP3: Chapter 6 - Object Oriented Programming Simple TTT game GUI: ttt-simple.py Code: ttt-smart.py Code: windowDemo.py
Friday, February 22nd	Read HOWTO: Fetch Internet Resources using the urllib Package	Code: readWeb_wsbtv.py Code: readWSB_regex.py The WSBTV.com Visitor Agreement

Week 8: February 25th - March 1st - URLLib & Regular Expressions

Day	Readings/Assignments	Resources
Monday February 25th	HW6 Box Packer Due! Read: DIVE Chapter 5 Regular Expressions	Code: canvas_demo.py HTTP Web Services from DIVE. RegEx Practice Test RegExer practice site Debuggex visual RegEx tool Read PIP: Pages 225-226 Exam 2 Vocabulary list cs2316-exam2-fall2011.pdf cs2316-exam2-fall2011-answers.pdf cs2316-exam2-spring2012.pdf cs2316-exam2-spring2012-answers.pdf cs2316-exam2-fall2012.pdf cs2316-exam2-fall2012-answers.pdf
Workshop	Timed Lab 2	TimedLabExam2Question7.pdf TimedLabExam2Question7-gradingKey.pdf Summer 2011 TL1 (equivalent to Spring/Fall TL2) Supply Chain Analysis cs-2316-timed-lab-1-string-stats.pdf fall2011-tl2-element-finder.zip Spring 2012 TL 2 - Access Analysis Fall 2012 TL2 - Stock Data Analysis
Wednesday February 27th	EXAM2	cs2316-exam2-spring2013.pdf cs2316-exam2-spring2013-answers.pdf
Friday, March 1st		Code: image_download.py An example table of data on the web Last day to Withdraw from an individual course.

Week 9: March 4th - 8th - Databases

Day	Readings/Assignments	Resources
Monday March 4th	Read: DMSI: Database Connectivity	scrapeAddressData.py
Workshop	RA_webscraping.pdf
Wednesday March 6th
Friday, March 8th	Mini-HW7 Simple Web Scraper Due 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

Week 10: March 11th - 15th - Databases & SQL

Day	Readings/Assignments	Resources
Monday March 11th	Read about the SQL Like statement and wildcards. Read about the SQL Count function.	Read PIP3: Pgs 480-488 cs2316-fall2011-tl3-class-finder.pdf tl3.html tl3a.html
Workshop	RA-SQL-practice.pdf
Wednesday March 13th	Read: XKCD number 327
Friday, March 15th	HW8 - Data Merge Due Read about the SQL Sum and Avg functions, and the GROUP BY statement.	contacts_pymysql.py contacts_sqlite.py

March 18th-22nd - Spring Break!

Week 11: March 25th - 29th - Functional Programming

Day	Readings/Assignments	Resources
Monday March 25th	Read this webpage on functional programming in Python.
Workshop	Timed Lab 3	Spring 2012 - Timed Lab 3 - email collector cs2316-summer2011-tl2.zip (equivalent to Fall/Spring TL3) Fall 2011 TL3 Class Finder tl3.html tl3a.html cs-2316-timed-lab-3-address-verifier.pdf Fall 2012 cs2316-spring2013-tl3-grade-cutoffs.pdf cs2316-tl3-syllabus_1.html cs2316-tl3-syllabus_1.html cs2316-tl3-syllabus_1.html
Wednesday March 27th	EXAM3	Exam 3 Vocab List cs2316-exam3-spring2012.pdf cs2316-exam3-spring2012-answers.pdf cs2316-exam3-fall2011.pdf cs2316-exam3-fall2011-answers.pdf cs2316-exam3-fall2012.pdf cs2316-exam3-fall2012-answers.pdf cs2316-exam3-spring2013.pdf CS2316-exam3-spring0213-answers.pdf
Friday, March 29th	Read Section 5.2 and 5.8 (Program Development & Doctest) from ThinkCSpy (2nd edition). Read Chapter 12. XML from Dive Into Python 3.	PIP3: Pgs 182-183 - Lambda Functions PIP3: Pgs 395-398 - Functional-Style Programming

Week 12: April 1st-5th - Parsing XML, Software Engineering Practices

Day	Readings/Assignments	Resources
Monday April 1st	HW9 - GT Pizza Login Read DMSI: XML	Read PIP3: Pgs 312-316. xml_weather.py weather_download.py
Workshop
Wednesday April 3rd		Code Sample: writeSimpleXML.py xml_demo.py
Friday, April 5th		Code sample: example_xml_writer.py Data sample:exampleOUT.xml Code Sample: example_xml_reader.py

Week 13: April 8th-12th - Case Studies

Day	Readings/Assignments	Resources
Monday April 8th	HW9b-GT Pizza Due	delFromList.py SimWorld.py Code Sample:xml_write.py
Workshop
Wednesday April 10th		Code Sample: weatherWebpage.py
Friday, April 12th		DOTdisplay.py

Week 14: April 15th-19th - Exam 4

Day	Readings/Assignments	Resources
Monday April 15th	HW 10 - IBM-XML Due!	Read: CX Freeze Documentation CX Freeze demo files: canvasDemo.py hello.py setup.py
Workshop	Timed Lab 4
Wednesday April 17th	Review	cs2316-exam4-vocab.pdf cs2316-exam2-summer2011.pdf cs2316-exam2-summer2011-answers.pdf Exam4Review-SQL-pymysql-basicXML.pdf PracticeExam3.pdf PracticeExam3-Key.pdf cs2316-exam4-fall2011.pdf cs2316-exam4-fall2011-answers.pdf cs2316-exam5-fall2011.pdf cs2316-exam5-fall2011-answers.pdf cs2316-exam4-spring2012.pdf cs2316-exam4-spring2012-answers.pdf cs2316-fall2011-tl5-xml-processing.pdf gamesdata.xml cs2316-fall2011-tl4-sql-manipulation.pdf fall2011-TL4-sql-manipulation.zip fall2011-tl5-xml.zip Spring 2012 Timed Lab 4 - SQL Backup (to XML) cs2316-exam4-fall2012.pdf cs2316-exam4-fall2012-answers.pdf
Friday, April 19th	EXAM4	cs2316-exam4-spring2013.pdf cs2316-exam4-spring2013-answers.pdf

Week 15: April 22nd-26th - Review

Day	Readings/Assignments	Resources
Monday April 22nd		Code Sample: sql2xml.py
Workshop
Wednesday April 24th
Friday, April 26th

Final Exam - Monday April 29th 2:50pm-5:40pm