Spring 2014 CS2316 Calendar

References

Week 1: January 6th-10th - Introduction, Python, Conditionals

Day	Readings/Assignments	Resources
Monday, Jan 6th	Course Syllabus Read: ThinkCS Chapters 1 & 2 Read:WhatIsAllowed.pdf	GIMP download 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.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. Video: How to install on a Mac A list of TK color "names"
Wednesday, Jan 8th	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, Jan 10th	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 13th-17th - Iteration, Strings, Lists & Recursion

Day	Readings/Assignments	Resources
Monday, Jan 13th	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, Jan 15th	Read ThinkCS Chapter 8 - Strings Read ThinkCS Chapter 9 - Tuples 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, Jan 17th	Read ThinkCS Chapter 11 - Lists Read: ThinkCS Chapter 18 & 19 - Recursion & exceptions	lecture5_review.py Code: lecture6.py Code: calcListAvg.py

Week 3: January 20-24th - Dictionaries, File I/O, CSV Files

Day	Readings/Assignments	Resources
Monday, Jan 20th	School Holiday - No Classes
Workshop	Practice Timed Lab 0
Wednesday, Jan 22nd	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, Jan 23rd	Read DMSI:CSV Files Read ThinkCS Chapter 12 - Modules	List of Python 3 Modules Reference: Dive Chapter 11 - Files Pickle Module documentation filterFile.py

Week 4: January 27th-31st - Modules, Timed Lab 1, Exam 1

Day	Readings/Assignments	Resources
Monday, Jan 27th	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 cs2316-exam1-fall2013.pdf cs2316-exam1-fall2013-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 CS 2316 Fall 2013 TL1 - cs2316-tl1-fall2013-multitap.pdf cs2316-tl1-spring2014-contactbook.pdf
Workshop	Timed Lab 1
Wednesday, Jan 29th	EXAM 1	cs2316-exam1-spring2014.pdf cs2316-exam1-spring2014-answers.pdf
Friday, Jan 31st,	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: Feburary 3rd-7th - Basic Objects

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

Week 6: Feburary 10th-14th - GUI's

Day	Readings/Assignments	Resources
Monday, Feb 10th	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, Feb 12th	HW 5 - GUI Monty Hall Due 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, Feb 14th	Read sections 8 & 9 of An Introduction to Tkinter Progress reports for 1000 & 2000 level classes avaliable next week!	EntryDemo.py radioButtonDemo.py

Week 7: Feburary 17th-21st - Dynamic GUI's, Objects

Day	Readings/Assignments	Resources
Monday Feb 17th	Read about canvases. Read: ThinkCS Chaper 22 - Sets of Objects	Code: Radio Button Demo
Workshop
Wednesday Feb 19th
Friday, Feb 21st		PIP3: Chapter 6 - Object Oriented Programming Simple TTT game GUI: ttt-simple.py Code: ttt-smart.py Code: windowDemo.py Code: canvas_demo.py
Sat Feb 22nd	TA Led Review Session - CULC 152 - 1pm

Week 8: Feburary 24th-28th - URLLib & Regular Expressions

Day	Readings/Assignments	Resources
Monday Feb 24th	HW 6 Due! Read: WSJ: 'Scrapers' Dig Deep for Data on Web Read: Legal Issues with Web Scraping Read: Screen-Scraping Ethics Read: DMSI: Web Scraping	HTTP Web Services from DIVE. Read PIP: Pages 225-226
Workshop	Timed Lab 2
Wednesday Feb 26th	EXAM 2	Exam 2 Vocabulary list 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 cs2316-exam2-fall2013.pdf cs2316-exam2-fall2013-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-exam2-spring2014.pdf cs2316-exam2-spring2014-answers.pdf
Friday, Feb 28th	Read: DIVE Chapter 5 Regular Expressions Last day to Withdraw from an individual course.	RegexOne: Tutorial w/ interactive Examples RegExer practice site Debuggex Visual RegEx tool txt2re - RegEx Creater

Week 9: March 3rd-7th - Databases

Day	Readings/Assignments	Resources
Monday March 3rd	Read HOWTO: Fetch Internet Resources using the urllib Package	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 scrapeAddressData.py
Workshop	Direct download of setuptools-2.2.zip (Setuptools Homepage) Windows Instructions Mac OSX instructions How to access the database from off campus.
Wednesday March 5th	Mini-HW7 Simple Web Scraper Due Read: DMSI: Database Connectivity
Friday, March 7th	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 10th-14th - Databases & SQL

Day	Readings/Assignments	Resources
Monday March 10th	Read about the SQL Like statement and wildcards. Read about the SQL Count function.	Read PIP3: Pgs 480-488
Workshop	RA_webscraping.pdf
Wednesday March 12th
Friday, March 14th	Read about the SQL Sum and Avg functions, and the GROUP BY statement.	contacts_pymysql.py contacts_sqlite.py

Spring Break: March 17th-21st

Week 11: March 24th-38th - Advanced SQL & Functional Programming

Day	Readings/Assignments	Resources
Monday March 24th	Exam Review Read this webpage on functional programming in Python.	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-fall2013.pdf cs2316-exam3-fall2013-answers.pdf cs2316-fall2011-tl3-class-finder.pdf tl3.html tl3a.html 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 Spring 2012 - Timed Lab 3 - email collector cs2316-tl3-spring2014-taFinder.pdf [ TL3_TA_Sample_Data.html ]
Mon March 24th: 9:30pm	TA Led Review Session: CULC 152
Workshop	Timed Lab 3
Wednesday March 26th	EXAM 3	cs2316-exam3-spring2014.pdf cs2316-exam3-spring2014-answers.pdf
Friday, March 28th	HW 8 - Data Merge Due	PIP3: Pgs 182-183 - Lambda Functions PIP3: Pgs 395-398 - Functional-Style Programming

Week 12: March 31st-April 4th - Parsing XML, Software Engineering Practices

Day	Readings/Assignments	Resources
Monday March 31st	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 April 2nd	HW 9a - GTBrokers Login Due	Code Sample: writeSimpleXML.py xml_demo.py
Friday, April 4th	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: April 7th-11th - Case Studies

Day	Readings/Assignments	Resources
Monday April 7th		delFromList.py Code Sample:xml_write.py Code Sample: weatherWebpage.py
Workshop
Wednesday April 9th	HW9b - Due	Code Sample: sql2xml.py
Friday, April 11th		DOTdisplay.py

Week 14: April 14th-18th - Exam 4 & Deployment

Day	Readings/Assignments	Resources
Monday April 14th	Exam Review	cs2316-exam4-vocab.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 4
Wednesday April 16th	EXAM 4	cs2316-exam4-spring2014.pdf cs2316-exam4-spring2014-answers.pdf
Friday, April 17th		scrollbarExample.py 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: April 21st-24th - Dead Week

Day	Readings/Assignments	Resources
Monday April 21st
Workshop
Wednesday April 23rd	HW 10 - MLB-XML Due!
Friday, April 24th

Final Exam - Monday April 28th, 11:30am-2:20pm (Period 2)