IT360 Spring 2014 Calendar

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

Week 1 
6

7

Class 1: Course Overview

Chapter 1 in Kroenke

Monday Schedule
8

Class 2: Relational Model

Chapter 3 in Kroenke
9 10 11
12

Week 2 
13

Class 3: SQL
data
queries
Chapter 2 in Kroenke
14

Lab 1: Access Lab
Access tutorial
15

Class 4: SQL Joins, group by
queries
16 17 18
19

Week 3 
20

ML King Jr Day

Lab 1 Due at 2359
21

Lab 2: SQL using MySQL

Madison Imports

Instructions to connect to MySQL using Workbench 5.x
Instructions to connect to MySQL using Workbench 6.x

Lab Solution

SQL Quiz at start of lab
22

Class 5: SQL GROUP BY, Subqueries
queries

Add Course Deadline
23 24 25
26

Week 4 
27

Class 6: More SQL

SQL Quiz at start of class

Lab 2 Due before 2359
28

Lab 3: More SQL

Movie Ratings

Lab Solution

Start Prereg
29

Class 7: SQL JOIN, Set Operations
queries
30 31

End Prereg
 

February 2014
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
            1
2

Week 5 
3

Class 8: SQL DDL, DML
queries

SQL Quiz at start of class

Lab 3 Due before 2359
4

Lab 4: SQL Joins, DDL, and DML Lab

Lab Solution
5

Class 9: Entity-Relationship Model
Chapter 5 in Kroenke
6 7 8
9

Week 6 

Academic Reserve Week
10

Class 10: More ER Model

SQL, ER model Quiz at start of class

Lab 4 Due before 2359
11

Lab 5: Entity-Relationship modeling

Lab Solution
12

6-week Exam
Review sheet

Feedback due
13 14 15
16

Week 7 
17

Washington's Birthday
18

Lab 6: ER to Relational lecture

Chapter 6, 7
ER to Relational Model lab

Lab Solution

Lab 5 Due before class
19

ER to relational model lab

Grades Due
20 21 22
23

Week 8 
24

Class 11: Normalization

Chapters 3,4 in Kroenke

ER to Relational Quiz

Lab 6 Due before 2359
25

Lab 7: Normalization lab

Lab Solution
26

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

Update CQPR trigger
Change Email trigger
27 28  

March 2014
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
            1
2

Week 9 
3

snow day
4

Lab 8: finish triggers, SPs
SQL Views lecture

SQL triggers, stored procedures, and views lab

Lab Solution

Normalization, SQL Triggers quiz

Lab 7 Due before class
5

Class 13: Project Start
6 7

Early Schedule
8
9

Spring Break
10

Spring Break
11

Spring Break
12

Spring Break
13

Spring Break
14

Spring Break
15

Spring Break
16

Week 10 
17

Class 14: show day - lecture next day
PHP Intro

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"
18

Lab 9: PHP Intro
Sample Order Form
Frequent PHP Errors


Lab Solution

Lab 8 Due before class
19

Class 15: PHP Arrays, Files, Functions lecture

arraysExamples.php
arrayFunctions.inc.php
ICE: student.inc.php
ICE: displayStudents.php

Chapters 3 and 4 in "PHP and MySQL"

Project part 0 (Project Responsibilities) Due before class
20 21 22
23

Week 11 
24

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

PHP quiz at start of class
25

Lab 10: song.inc.php
songPage.php

PHP and MySQL
Online Store Tables

Lab Solution

Lab 9 Due before class
26

Class 17: Sessions and Authentication
Session examples

Project part 1 (ER Model) Due before class
27 28 29
30

Week 12 

Academic Reserve Week
31

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

No quiz

Lab 10 Due before 2359
         

April 2014
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
    1

Lab 11: Shopping Cart
Online Store Tables
2

12-week Exam
Review sheet

Feedback due
3

Project parts 2, 3 (ER to Relational, Normalization) Due before 1530
4 5
6

Week 13 
7

Work on project

Lab 11 Due before 2359
8

Lab 12: DB Security lecture/lab

DB security lab
lab12.zip

Grades Due
9

Work on project

Project part 4 (Triggers) Due before class
10 11

Drop course deadline
12
13

Week 14 
14

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

Start Registration

Lab 12 Due before 2359
15

Lab 13: Transactions lab
16

Class 19: Data storage and indexing

Project part 5 milestone (login, send/receive messages, exchange) Due before class
17 18 19
20

Week 15 
21

Class 20: Finish Indexing
and
Ethics
Reading and Blackboard assignment: Ethics assignment

Blackboard assignment due at 0900

Lab 13 Due before 2359
22

Lab 14: Indexing lab
23

project work
24 25

End Registration
26
27

Week 16 
28

Final Project Presentations

Final Project Due

Lab 14 Due before 2359
29

SOFs

Course Wrap-up Review sheet

Last Day of Classes

Peer feedback due before lab
30

Reading Day
     

May 2014
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
        1

Start Finals
2 3
4 5 6 7 8

End Finals

Final exam at 0755 in MI223
9 10
11 12

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

Graduation Day
24
25 26 27 28 29 30 31