CS 2316 - Summer 2018 GTL

Lecture: 4 days per week from 10:30 - 11:30

Lecture Schedule

Topics link to slides, where available.

ITCS means Interactive Think CS Textbook

TP means Think Python, 2nd Edition, by Allen B. Downey, O'Reilly Media, December 2015. Available free at http://greenteapress.com/wp/think-python-2e/ and from O'Reilly at http://shop.oreilly.com/product/0636920045267.do

Date	Topics	Reading and Resources	Reminders
Python Review
Week 1
2018-05-14	Dorm Check-in
2018-05-15	Orientations
2018-05-16	Intro to DME	Syllabus Schedule Meet the Teacher Video: Getting Started Exercise: CS 2316 Pre-test	HW0 Released 2018-05-16
2018-05-17	Intro to Python	ITCS - Introduction TP 1 Video: Intro to Python
2018-05-18	Values and Variables	ITCS - Simple Data TP 2 Video: Values and Variables
Week 2
2018-05-21	No Class
2018-05-22	Functions	ITCS - Functions ITCS - Turtles TP 3
2018-05-23	Modules and Programs	ITCS - Modules TP 1,14 hanglib Exercise: BMI Module Exercise: Hangman	HW0 Due 2018-05-23
2018-05-24	Data Structures	ITCS - Lists ITCS - Dictionaries TP 10,11,12 Video: Data Structures Exercise: Data Utilities
2018-05-25	Data Structures	ITCS - Lists ITCS - Dictionaries TP 10,11,12 Video: Data Structures Exercise: Data Utilities	HW1 Released 2018-05-25
Week 3
2018-05-28	strings
2018-05-29	iPython
2018-05-30	Control Structures	ITCS - Selection ITCS - Iteration TP 5, 7 Exercise: Grades Module
2018-05-31	Control Structures	ITCS - Selection ITCS - Iteration TP 5, 7 Exercise: Grades Module
2018-06-01	No Class
Week 4
2018-06-04	Functional programming	TP 19
2018-06-05	Functional programming	TP 19
2018-06-06	Classes and Objects	ITCS - Classes and Objects OOP Code TP 15 - 18 Exercise: Treating People as Objects
2018-06-07	Classes and Objects	ITCS - Classes and Objects OOP Code TP 15 - 18 Exercise: Treating People as Objects	HW1 Due 2018-06-07 HW2 Released 2018-06-07
2018-06-08	No Class
Data Formats, Retrieval, and Storage
Week 5
2018-06-11	Classes and Objects	ITCS - Classes and Objects OOP Code TP 15 - 18 Exercise: Treating People as Objects
2018-06-12	File IO CSV Files	IP 8 Exercise: Tree IP 8 Exercise: Student Emails (Sample Answer) Exercise: Tides Exercise: Calculate Grades
2018-06-13	Review 1	dme-exam1-practice.pdf cs2316-exam1-practice-answers.pdf Exam 1 Practice Problems
2018-06-14	Exam 1	cs2316-exam1-practice.pdf cs2316-exam1-practice-answers.pdf
2018-06-15	No Class
Week 6
2018-06-18	File IO CSV Files	IP 8 Exercise: Tree IP 8 Exercise: Student Emails (Sample Answer) Exercise: Tides Exercise: Calculate Grades
2018-06-19	File IO CSV Files	IP 8 Exercise: Tree IP 8 Exercise: Student Emails (Sample Answer) Exercise: Tides Exercise: Calculate Grades
2018-06-20	CSV Files	IP 8 Exercise: Student Emails (Sample Answer) Exercise: Tides Exercise: Calculate Grades
2018-06-21	CSV Files	IP 8 Exercise: Student Emails (Sample Answer) Exercise: Tides Exercise: Calculate Grades
2018-06-22	Data Exchange Formats	IP 8 XML Details Python XML and Database APIs JSON Spec people.xml Exercise: Books
Week 7
2018-06-25	No Class
2018-06-26	No Class
2018-06-27	No Class
2018-06-28	Relational Model
2018-06-29	Basic Relational Design		HW2 Due 2018-06-29
Week 8
2018-07-02	MySQL Install Fest
2018-07-03	Field Trip
2018-07-04	SQL DDL SQL CRUD	MySQL Guide Exercise: Registration Database Exercise: Pubs Queries MySQL Guide - on databases course web site Exercise: Registration Database Exercise: Pubs Queries
2018-07-05	SQL Queries	MySQL Guide - on databases course web site Exercise: Registration Database Exercise: Exercise: Dorms Queries
2018-07-06	No CS 2316 Lecture
Week 9
2018-07-09	No Class
2018-07-10	SQL Queries	MySQL Guide - on databases course web site Exercise: Registration Database Exercise: Exercise: Dorms Queries
2018-07-11	SQL Queries	MySQL Guide - on databases course web site Exercise: Registration Database Exercise: Exercise: Dorms Queries
2018-07-12	Regular Expressions HTML web-mining (None of this on Exam 2)	IP 7 Python RE Module Python Regex HowTo IP 8
2018-07-13	Exam 2	cs2316-exam2-practice.pdf cs2316-exam2-practice-answers.pdf
Data Analytics
Week 10
2018-07-16	Guest lecture: data manipulation in research
2018-07-17	Python GUIs	GUI Example Code
2018-07-18	Python GUIs	GUI Example Code	HW3 Released 2018-07-18
2018-07-19	Python GUIs	GUI Example Code	HW4 Released 2018-07-19
2018-07-20	No Class
Week 11
2018-07-23	Python Database API Python GUIs	Python XML and Database APIs Python DB-API Python SQLite API PyMySQL GUI Example Code
2018-07-24	NumPy	Numpy Manual
2018-07-25	Pandas	Pandas.PyData.org	HW3 Due 2018-07-25 HW4 Due 2018-07-25
2018-07-26	Pandas	Pandas.PyData.org	Final Instructional Day
2018-07-27	Reading Day - No Class
Finals Week
2018-07-30
2018-07-31
2018-08-01
2018-08-02
2018-08-03	Dorm Check-out