Summer 2013 CS2316 Calendar

References

Week 1: - Introduction, Python, Conditionals, Iteration, Functions, Strings, Lists

Day	Readings/Assignments	Resources
Tuesday May 14th	Course Syllabus Read: ThinkCS Chapters 1 & 2 Read WhatIsAllowed.pdf Read ThinkCS Chapter 4 - Functions Read: Differences Between Python 2 and Python 3	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 CS 2316 - Spring 2013 course website Reference: Python Language Reference: Function Definitions VariablesTypesMath.ppt Functions.ppt keywords vs. identifiers PIP3: Chapter 1
Recitation	Read: ThinkCS Chapter 3 - Hello, little turtles!	Python (version 3.3.1) 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"
Thursday May 16th	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: Nested Lists, Recursion, Dictionaries

Day	Readings/Assignments	Resources
Tuesday May 21st	HW0 - Introduction Due! Read ThinkCS Chapter 7 - Iteration Read ThinkCS Chapter 8 - Strings Read ThinkCS Chapter 11 - Lists	PIP3: Chapter 2 Reference: Python Reference Manual: For & While statements code: doctest example.py String Methods String Formatting Reference:Python 3 String Documentation Reference: Dive Chapter 2: Native Datatypes Reference: Dive Chapter 4: Strings parseMoney.py
Recitation	RA Coffee
Thursday May 23rd	HW1 - Python Practice 1 Due Read: ThinkCS Chapter 18 & 19 - Recursion & exceptions Read: ThinkCS Chapter 20 - Dictionaries	PIP3: Chapter 3 Code: calcListAvg.py Code: get_int.py Introduction to the Fibonacci sequence by Tool (Lateralus) Reference: Dive Chapter 7: Classes & Iterators Reference: Dive Chapter 11 - Files

Week 3: May 27-31st - Modules, File I/O, & CSV Files

Day	Readings/Assignments	Resources
Tuesday, May 28th	HW2 - Python Practice 2 Due Read: ThinkCS Chapter 9 - Tuples Read: ThinkCS Chapter 13 - Files Read DMSI:CSV Files	filterFile.py
Recitation	Seperate Numbers
Thursday May 30th	HW3 - Enigma Fun Due Read: ThinkCS Chapter 15 - Classes and Objects - the Basics Read: ThinkCS Chapter 16 - Classes - Digging a little deeper	Point.py PIP3: Chapter 6 (pgs.233-245) Pickle Module documentation

Week 4: June 3rd-7th- GUI's & Basic Objects

Day	Readings/Assignments	Resources
Tuesday June 4th	Read DMSI: Graphical User Interfaces Read sections 1-5 of An Introduction to Tkinter Read 7.1-7.4 (Classes & Iterators) from Dive into Python 3. Read: ThinkCS Chapter 21 - Even more OOP	PIP3: Chapter 15 - Introduction to GUI Programming guiDemo.py labels_colors.py
Recitation	RA-FindMax sample_numbers.txt
Thursday June 6th	HW4 - Lifeguard Ranker Due Read sections 6-7 of An Introduction to Tkinter Read sections 8 & 9 of An Introduction to Tkinter	EntryDemo.py radioButtonDemo.py

Week 5: June 10th-14th Dynamic GUI's, & Objects

Day	Readings/Assignments	Resources
Tuesday June 11th	Read: ThinkCS Chaper 22 - Sets of Objects	Code: Radio Button Demo
Recitation	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.
Thursday June 13th	HW 5 GUI File Reader (Factory) due Read: DMSI: Web Scraping Read: Legal Issues with Web Scraping Read: Screen-Scraping Ethics Read: WSJ: 'Scrapers' Dig Deep for Data on Web Read HOWTO: Fetch Internet Resources using the urllib Package	PIP3: Chapter 6 - Object Oriented Programming HTTP Web Services from DIVE. Simple TTT game GUI: ttt-simple.py Code: ttt-smart.py Code: windowDemo.py Code: canvas_demo.py
Friday June 14th	Optional Review Session: CULC 152 3pm

Week 6: June 17th-21st - URLLib & Regular Expressions

Day	Readings/Assignments	Resources
Tuesday June 18th	Read: DIVE Chapter 5 Regular Expressions Read: DMSI: Database Connectivity	Code: readWeb_wsbtv.py Code: readWSB_regex.py The WSBTV.com Visitor Agreement scrapeAddressData.py image_download.py RegEx Practice Test RegExer practice site Debuggex visual RegEx tool Read PIP: Pages 225-226 An example table of data on the web
Recitation	RA_webscraping.pdf
Thursday June 20th	HW 6 Box Packer 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

Exam Study Material

Exam 1 (Spring/fall)		Exam 1 Vocabulary list Python-Review1.pdf 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 cs2316-exam1-spring2013.pdf cs2316-exam1-spring2013-answers.pdf
Exam 2 (Spring/Fall)		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 cs2316-exam2-spring2013.pdf cs2316-exam2-spring2013-answers.pdf
Exam 3 (Spring/Fall)		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
Timed Labs (Spring/Fall)		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 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 cs2316-fall2011-tl3-class-finder.pdf tl3.html tl3a.html

Week 7: June 24th-28th - Review & Midterm

Day	Readings/Assignments	Resources
Tuesday June 25th	Mini-HW7 Simple Web Scraper Due Read about the SQL Like statement and wildcards. Read about the SQL Count function. Read about the SQL Sum and Avg functions, and the GROUP BY statement.	Read PIP3: Pgs 480-488 contacts_pymysql.py contacts_sqlite.py
Recitation	Exam Review	Read: XKCD number 327
Thursday June 27th	Midterm Exam	cs2316-midterm-summer2013.pdf codesamples/cs2316-midterm-summer2013-answers.pdf

Week 8 July 1st - 5th - Databases & SQL Functional Programming

Day	Readings/Assignments	Resources
Tuesday July 1st	Read this webpage on functional programming in Python.	PIP3: Pgs 182-183 - Lambda Functions PIP3: Pgs 395-398 - Functional-Style Programming
Recitation	RA-SQL-practice.pdf
Thursday July 4th	School Holiday: No Class!

Week 9: July 8-12th - XML

HW8 - Data Merge Due Wed July 10th

Day	Readings/Assignments	Resources
Tuesday July 9th	Read Chapter 12. XML from Dive Into Python 3. Read DMSI: XML	Read PIP3: Pgs 312-316. Code Sample:xml_write.py xml_weather.py weather_download.py
Recitation	cs2316-recitation-assignment-message-getter.pdf	delFromList.py
Thursday July 11th		Code Sample: writeSimpleXML.py xml_demo.py Code sample: example_xml_writer.py Data sample:exampleOUT.xml Code Sample: example_xml_reader.py

Week 10: July 15-19th - Case Studies

Day	Readings/Assignments	Resources
Monday July 15th	HW9a due
Tuesday July 16th		DOTdisplay.py Code Sample: sql2xml.py Code Sample: weatherWebpage.py SimWorld.py
Recitation	RA-SQL-practice-2.pdf
Thursday July 18th	HW 9b Due	Read: CX Freeze Documentation CX Freeze demo files: canvasDemo.py hello.py setup.py

Week 11: July 22nd-26th - Review

Day	Readings/Assignments	Resources
Tuesday July 23rd	HW 10 - IBM-XML Due!
Recitation	Optional Mini-EC homework Modules Due before recitation!
Thursday July 25nd		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 cs2316-exam4-spring2013.pdf cs2316-exam4-spring2013-answers.pdf

TA Led Review: Friday July 26th, 3pm Skiles Room 202

Final Exam: Thursday Aug 1st 8:00am-10:50am - CULC 102