IT360 Spring 2012

January 2012
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
1	2	3	4	5	6	7
8 Week 1	9	10 Class 1: Course Overview Read Chapter 1 in Kroenke Monday Schedule	11	12 Lab 1: Access Lab Access tutorial	13 Class 2: SQL data queries Chapter 2 in Kroenke	14
15 Week 2	16 ML King Jr Day	17	18 Lab 1 Due at 2359	19 Lab 2: Basic SQL Madison Imports Instructions to connect to MySQL Lab Solution SQL Quiz at start of lab	20 Class 3: More SQL queries	21
22 Week 3	23 Class 4: More SQL queries	24 Add Course Deadline	25	26 Lab 3: More SQL Movie Ratings Lab Solution Lab 2 Due BEFORE start of Lab SQL Quiz at start of lab	27 Class 5: Relational Model Chapter 3 in Kroenke	28
29 Week 4	30 Class 6: Normalization Chapters 3,4 in Kroenke	31 Start Prereg

February 2012
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
			1	2 Lab 4: Normalization lab Lab Solution Lab 3 Due before lab Relational Model and Normalization Quiz	3 Class 7: Entity-Relationship Model ER Model Exercises Chapter 5 End Prereg	4
5 Week 5	6 Class 8: More ER Model	7	8	9 Lab 5: Entity-Relationship modeling Lab Solution Lab 4 Due before lab Entity-Relationship Model Quiz	10 Class 9: ER to Relational ER to Relational Exercises Chapter 6, 7	11
12 Week 6	13 Class 10: Review Start X-week	14	15	16 Lab 6: ER to Relational Model Lab Solution Lab 5 Due before lab	17 6-week Exam End X-week	18
19 Week 7	20 Washington's Birthday	21	22 Grades Due	23 Lab 7: SQL lecture queries More SQL Lab Lab Solution Lab 6 Due before lab	24 Class 11: PHP Intro page.inc person.inc getPersonInfo processPersonInfo readPersonsInfo Chapter 1 and Chapter 6 (up to page 183) in "PHP and MySQL Web Development"	25
26 Week 8	27 Class 12: PHP Arrays, Files, Functions arraysExamples arrayFunctions.inc ICE: student.inc ICE: displayStudents Chapters 3 and 4 in "PHP and MySQL"	28	29

March 2012
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
				1 Lab 8: PHP Intro Sample Order Form Frequent PHP Errors Lab 7 Due before lab PHP quiz at start of lab	2 Class 13: PHP and MySQL Song Class Song Page Songs table myConnectDB.inc.php	3
4 Week 9	5 Class 14: More PHP and MySQL, lab work	6	7	8 Lab 9: PHP and MySQL Lab Solution	9 Class 15: lab work Early Schedule Lab 8 Due before class	10
11 Spring Break	12 Spring Break	13 Spring Break	14 Spring Break	15 Spring Break	16 Spring Break	17
18 Week 10	19 Class 16: Project Start	20	21	22 Project work Lab 9 Due before lab Project responsibilities email and hardcopy due at noon	23 Class 17: Sessions and Authentication Session examples	24
25 Week 11	26 Class 18: Creating a Shopping cart Shopping Songs Provided Code ICE: song.inc ICE: songPage	27	28	29 Lab 10: Shopping Cart Online Store Tables Project Parts 1-4 (ER model, ER to Relational, Normalization, Load Data) Due before lab	30 Project work	31

April 2012
Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
1 Week 12	2 Class 19: SQL Stored Procedures, Triggers Chapter 7, 10b in Kroenke, Chapter 13 p 316 in "PHP and MySQL Web Development" Start X-week	3	4	5 Lab 11: SQL Views Lecture SQL stored procedures, triggers and views lab Lab Solution Lab 10 Due before lab Feedback due	6 12-week Exam Review sheet End X-week	7
8 Week 13	9 Project work	10 Grades Due	11	12 Lab 12: DB Security lecture DB security lab lab12.zip Lab Solution Lab 11 Due before lab Project milestone - upload/view photo due before lab (demo during lab)	13 Class 20: Transactions and Concurrency Control Chapter 9, pg 321-335 in Kroenke Drop course deadline	14
15 Week 14	16 Guest lecture Start Registration	17	18	19 Lab 13: finish lecture Transactions lab Lab Solution Lab 12 Due before lab Project milestone - add/view friends due before lab (demo during lab)	20 Class 21: Ethics Reading (quiz at start of class): Data misuse The Code of Professional Responsibility	21
22 Week 15	23 Class 22: Data storage and indexing	24	25	26 Lab 14: Indexing Lab Solution Lab 13 Due before lab	27 Final Project Presentations End Registration Final Project Due	28
29 Week 16	30 SOFs, Course Wrap-up Review sheet