Fall 2013 CS2316 Calendar

References

Week 1: August 19th-23rd - Introduction, Python, Conditionals

Day	Readings/Assignments	Resources
Monday, August 19th	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.3.2) 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, August 21st	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, August 23rd	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: August 26th - 30th - Iteration, Strings, Lists & Recursion

Day	Readings/Assignments	Resources
Monday, August 26th	HW 0 Due Read ThinkCS Chapter 7 - Iteration	Reference: Python Reference Manual: For & While statements
Workshop	RA Coffee Watch Video: Fun with Pair Programming
Wednesday, August 28th	Read ThinkCS Chapter 8 - Strings HW 1 - 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, August 30th	Read ThinkCS Chapter 11 - Lists Read: ThinkCS Chapter 18 & 19 - Recursion & exceptions	lecture5_review.py Code: lecture6.py Code: calcListAvg.py

Week 3: September 2nd-6th - Dictionaries, File I/O, Modules

Day	Readings/Assignments	Resources
Monday, September 2nd	School Holiday - No Classes
Workshop	Practice Timed Lab 0
Wednesday, September 4th	Read: ThinkCS Chapter 20 - Dictionaries Read: ThinkCS Chapter 13 - Files HW 2 - Python Practice 2 Due	PIP3: Chapter 3 Code: get_int.py Introduction to the Fibonacci sequence by Tool (Lateralus) Reference: Dive Chapter 7: Classes & Iterators
Friday, September 6th	Read DMSI:CSV Files Read ThinkCS Chapter 12 - Modules	Reference: Dive Chapter 11 - Files Pickle Module documentation filterFile.py

Week 4: September 9th-13th - Timed Lab 1, Exam 1

Day	Readings/Assignments	Resources
Monday, September 9th	HW 3 - Due Exam Review	Python-Review1.pdf Python Review 2.pdf Exam 1 Vocabulary list 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 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
Workshop	Timed Lab 1
Wednesday, September 11th	EXAM 1	cs2316-exam1-fall2013.pdf cs2316-exam1-fall2013-answers.pdf
Friday, September 13th	Read: ThinkCS Chapter 15 - Classes and Objects - the Basics Read 7.1-7.4 (Classes & Iterators) from Dive into Python 3.	cashRegister,py

Week 5: September 16th - 20th - Basic Objects, Reading & Writing CSV files

Day	Readings/Assignments	Resources
Monday, September 16th	Read: ThinkCS Chapter 16 - Classes - Digging a little deeper	PIP3: Chapter 6 (pgs.233-245)
Workshop	list-RQ iteration-RA
Wednesday, September 18th	HW 4 - Due
Friday, September 20th	Read: ThinkCS Chapter 21 - Even more OOP	guiDemo.py parseMoney.py

Week 6: September 23rd-27th - GUI's

Day	Readings/Assignments	Resources
Monday, September 23rd	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
Wednesday, September 25th	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
Friday, September 27th	HW 5 - GUI File Reader Due Read sections 8 & 9 of An Introduction to Tkinter Progress reports for 1000 & 2000 level classes due!	EntryDemo.py radioButtonDemo.py

Week 7: September 30th- October 4th - Dynamic GUI's, Objects

Day	Readings/Assignments	Resources
Monday September 30th	Read about canvases. Read: ThinkCS Chaper 22 - Sets of Objects	Code: Radio Button Demo
Workshop
Wednesday October 2nd
Friday, October 4th		PIP3: Chapter 6 - Object Oriented Programming Simple TTT game GUI: ttt-simple.py Code: ttt-smart.py Code: windowDemo.py

Week 8: October 7th - 11th - URLLib & Regular Expressions

Day	Readings/Assignments	Resources
Monday October 7th	Read: DMSI: Web Scraping Read: DIVE Chapter 5 Regular Expressions	Code: canvas_demo.py HTTP Web Services from DIVE. Read PIP: Pages 225-226
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 October 9th	HW 6 Box Packer Due! Read: WSJ: 'Scrapers' Dig Deep for Data on Web Read: Legal Issues with Web Scraping Read: Screen-Scraping Ethics	RegexOne: Tutorial w/ interactive Examples RegExer practice site Debuggex Visual RegEx tool txt2re - RegEx Creater
Friday, October 11th	Read HOWTO: Fetch Internet Resources using the urllib Package Last day to Withdraw from an individual course.	Code: readWeb_wsbtv.py Code: readWSB_regex.py The WSBTV.com Visitor Agreement image_download.py An example table of data on the web An example of address data on the web

Week 9: October 14th - 18th - Databases

Day	Readings/Assignments	Resources
Monday October 14th	Fall Break - No classes!	scrapeAddressData.py
Workshop	Fall Break - No Workshop!
Wednesday October 16th	Read: DMSI: Database Connectivity
Friday, October 18th	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: October 21st - 25th - Databases & SQL

Day	Readings/Assignments	Resources
Monday October 21st	Read about the SQL Like statement and wildcards. Read about the SQL Count function.	Read PIP3: Pgs 480-488 Exam 2 Vocabulary list Practice Exam 2.pdf Practice Exam 2 - Answers.pdf cs2316-exam2-fall2011.pdf cs2316-exam2-fall2011-answers.pdf cs2316-fall2011-tl2-element-finder.pdf tl2-test-file.csv cs2316-exam2-spring2012.pdf cs2316-exam2-spring2012-answers.pdf cs2316-exam2-fall2012.pdf cs2316-exam2-fall2012-answers.pdf 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 cs2316-fall2011-tl3-class-finder.pdf tl3.html tl3a.html 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 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
Workshop	Timed Lab 2 RA_webscraping.pdf pair_programming_partner_review.pdf
Wednesday October 23rd	EXAM 2	cs2316-exam2-fall2013.pdf cs2316-exam2-fall2013-answers.pdf
Friday, October 25th	Read about the SQL Sum and Avg functions, and the GROUP BY statement.	contacts_pymysql.py contacts_sqlite.py

Week 11: October 28th - November 1st - Advanced SQL & Functional Programming

Day	Readings/Assignments	Resources
Monday October 28th
Workshop
Wednesday October 30th	Read this webpage on functional programming in Python.	PIP3: Pgs 182-183 - Lambda Functions PIP3: Pgs 395-398 - Functional-Style Programming
Friday, November 1st	HW 8 - Data Merge Due

Week 12: November 4th-8th - Parsing XML, Software Engineering Practices

Day	Readings/Assignments	Resources
Monday November 4th	Read DMSI: XML Read Chapter 12. XML from Dive Into Python 3.	Read PIP3: Pgs 312-316. xml_weather.py weather_download.py
Workshop	SQL Practice
Wednesday November 6th	HW 9a - GT Pizza Login Due	Code Sample: writeSimpleXML.py xml_demo.py
Friday, November 8th	Read Section 5.2 and 5.8 (Program Development & Doctest) from ThinkCSpy.	Code sample: example_xml_writer.py Data sample:exampleOUT.xml Code Sample: example_xml_reader.py

Week 13: November 11th-15th - Case Studies

Day	Readings/Assignments	Resources
Monday November 11th		delFromList.py Code Sample:xml_write.py Code Sample: weatherWebpage.py
Workshop	RA: Message getter.pdf
Wednesday November 13th	HW9b - GT Pizza Due	Code Sample: sql2xml.py
Friday, November 15th		DOTdisplay.py

Week 14: November 18th-22nd - Exam 3 & Deployment

Day	Readings/Assignments	Resources
Monday November 18th	Exam 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
Workshop	Timed Lab 3
Wednesday November 20th	EXAM 3	cs2316-exam3-fall2013.pdf cs2316-exam3-fall2013-answers.pdf
Friday, November 22nd		Read: How To Use cx_Freeze and the main cx_Freeze website w/ downloads CX Freeze on the Mac instructions cx_Freeze demo files: canvasDemo.py hello.py setup.py nullsoft scriptable install system

Week 15: November 25th- 29th - Thanksgiving

Day	Readings/Assignments	Resources
Monday November 25th
Workshop
Wednesday November 27th	HW 10 - IBM-XML Due!
Friday, November 29th	No Class - School Holiday!

Week 16: December 2nd - 8th - Dead Week Review

Day	Readings/Assignments	Resources
Monday December 2nd		List of 32,000 common words Cheating_Hangman.py
Workshop
Wednesday December 4th
Friday, December 5th

Final Exam - Friday December 13th, 11:30am-2:20pm