IT360 Spring 2013 Calendar

January 2013
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
    1 2 3 4 5
6

Week 1 
7

8

Class 1: Course Overview

Chapter 1 in Kroenke

Monday Schedule
9

Class 2: Relational Model

Chapter 3 in Kroenke
10 11

Lab 1: Access Lab
Access tutorial
12
13

Week 2 
14

Class 3: SQL
data
queries
Chapter 2 in Kroenke
15 16

Class 4: SQL Joins, Aggregation
queries

Class Exercises Solutions
17

Lab 1 Due at 2359
18

Lab 2: Basic SQL
Madison Imports
Instructions to connect to MySQL

Lab Solution
19
20

Week 3 
21

ML King Jr Day
22

Add Course Deadline
23

Class 5: SQL GROUP BY, Subqueries
queries

SQL Quiz at start of class
24

Lab 2 Due before 2359
25

Lab 3: More SQL
Movie Ratings

Lab Solution
26
27

Week 4 
28

Class 6: SQL JOIN, Set Operations
queries
29

Start Prereg
30

Class 7: SQL DDL, DML

queries

SQL Quiz at start of class
31

Lab 3 Due before 2359
   

February 2013
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
          1

Lab 4: SQL Joins, DDL, and DML Lab

Lab Solution

End Prereg
2
3

Week 5 
4

Class 8: Entity-Relationship Model
Chapter 5 in Kroenke

SQL Quiz at start of class
5 6

Class 9: More ER Model
7

Lab 4 Due before 2359
8

Lab 5: Entity-Relationship modeling

Lab Solution
9
10

Week 6 

X-week
11

Class 10: ER to Relational
ER to Relational Exercises

Chapter 6, 7

Feedback due

Entity-Relationship Model Quiz
12 13

6-week Exam
Review sheet
14

Lab 5 Due before 2359
15

Lab 6: ER to Relational Model

Lab Solution

End X-week
16
17

Week 7 
18

Washington's Birthday
19 20

Class 11: Normalization
Normalization Exercises

Chapters 3,4 in Kroenke

Grades Due

ER to Relational Quiz
21

Lab 6 Due before 2359
22

Lab 7: Normalization lab

Lab Solution
23
24

Week 8 
25

Class 12: PHP Intro
PHP Intro Handout

page.inc.php
person.inc.php
getPersonInfo.php
processPersonInfo.php
readPersonsInfo.php

Chapter 1 and Chapter 6 (up to page 183) in "PHP and MySQL Web Development"

Normalization quiz at start of class
26 27

Class 13: PHP Arrays, Files, Functions
PHP Arrays, Files, Functions Handout
arraysExamples.php
arrayFunctions.inc.php
ICE: student.inc.php
ICE: displayStudents.php

Chapters 3 and 4 in "PHP and MySQL"
28

Lab 7 Due before 2359
   

March 2013
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
          1

Lab 8: PHP Intro
Sample Order Form
Frequent PHP Errors


Lab Solution
2
3

Week 9 
4

Class 14: PHP and MySQL
song.inc.php
songPage.php
Songs table
myConnectDB.inc.php

PHP quiz at start of class
5 6

Class 15: More PHP and MySQL
song.inc.php
songPage.php
7

Lab 8 Due before 2359
8

Lab 9: PHP and MySQL
Online Store Tables

Lab Solution

Early Schedule
9
10

Week 10 
11

Spring Break
12

Spring Break
13

Spring Break
14

Spring Break
15

Spring Break
16

Spring Break
17

Week 11 
18

Class 16: Sessions and Authentication
Session examples

No quiz
19 20

Creating a Shopping cart
Shopping Songs Provided Code
ICE: song.inc.php
ICE: songPage.php
21

Lab 9 Due before 2359
22

Lab 10: Shopping Cart
Online Store Tables

Lab Solution
23
24

Week 12 
25

Class 17: Project Start
26 27

Work on project
28

Lab 10 Due before 2359
29

Project work
30
31

Week 13 
           

April 2013
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
  1

Class 18: Ethics Reading (quiz at start of class): Data misuse
The Code of Professional Responsibility

Start X-week

Project part 1 (ER Model) Due before class

Feedback due
2 3

12-week Exam
Review sheet
4 5

Lab 11: DB Security lecture
DB security lab
lab11.zip

Lab Solution

End X-week
6
7

Week 14 
8

Class 19: SQL Triggers, Stored Procedures
Chapter 7, 10b in Kroenke, Chapter 13 p 316 in "PHP and MySQL Web Development"

Project parts 2, 3 (ER to Relational, Normalization) Due before class
9

Grades Due
10

Class 20: finish triggers, SPs
SQL Views

LimitStudents trigger
FixEmail trigger
InsertStudents stored procedure
11

Lab 11 Due before 2359
12

Lab 12: SQL triggers, stored procedures, and views

Lab Solution

Drop course deadline
13
14

Week 15 
15

TBA

Start Registration

Project milestone - partial web interface Due before class
16 17

Class 21: Transactions and Concurrency Control
Chapter 9, pg 321-335 in Kroenke
18

Lab 12 Due before 2359
19

Lab 13: finish lecture
Transactions lab

Lab Solution

Project Description (Part 5) and Hints updated (April 19)
20
21

Week 16 
22

Project work in lab
23 24

Final Project Presentations

Final Project Due
25 26

Lab 14: Data storage and indexing lecture
Indexing lab

Lab Solution

End Registration

Lab 13 Due before lab

Peer feedback due before lab
27
28 29

Class 22: SOFs
Course Wrap-up Review sheet

in lab
30

Last Day of Classes
       

May 2013
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
      1

Reading Day
2

Start Finals

Lab 14 Due before 1200
3

Final Exam at 1330 in MI223
4
5 6

Final Exam Alternate 0755 in MI223
7 8 9

End Finals
10 11
12 13

Grades Due
14 15 16 17 18
19 20 21 22 23 24

Graduation Day
25
26 27 28 29 30 31