CSCI-146 Lab: Working Outline

• Week 1 : 13th January

  Setting up Accounts

  • Introduction
  • Students should fill out the background survery doc pdf
  • Basic Php
  • Important info for transferring/creating files on cobweb

• Week 2 : 20th January - No Class

• Week 3 : 27th January

  • Multi-tier development using PhP
  • Setting up MySQL, Connecting to MySQL, Creating tables
  • Create/edit/populate tables. Simple selects
  • Constrains and keys
  • Programming assignment 1 - Online Store Due Feb 8th, 11.59pm via Blackboard.

• Week 4 : 3rd February

  • MySQL: MySQL Examples, queries without groupby constructs
  • More sql
  • Create tables
  • Populate tables
  • Programming assignment 2 - Simple queries Due Feb 15th, 11.59pm via Blackboard.

• Week 5 : 10th February

  • More MySQL groupby construct, in class exercies
  • More php if needed
  • In Class Exercises
  • Programming assignment 3 - group by queries Due Feb 22nd, 11.59pm via Blackboard.

• Week 6 : 17th February

  • Review of MySQL, discussion of ethics paper
  • Handout Term Project: Phase 1 due March 1st

• Week 7 : 24th February

  • In-class SQL Programming exercises
  • Review MySQL, PhP
  • Handout Term Project: Phase 2 (Teams) due April 13th

• Week 8 : 3rd March

  • JDBC
  • Programming assignment 4 (JDBC) Due March 28th, 11:59pm via Blackboard

• Week 9 : 10th March

  • Project discussion with teams
  • Planning Phase 2
  Project Phase 2 Due April 9th

• Week 10 : 17th March - SPRING BREAK

• Week 11 : 24th March

  • Review of JDBC
  • Check-in with teams and Project Phase 2 - demo current project status
  • Introduction to Oracle and SQL-Plus
  • How to connect to oracle

• Week 12 : 31st March

  • Check-in with teams and Project Phase 2 - demo current project status
  • Sophmore review

• Week 13 : 7th April

  • Ethics discussions

• Week 14 : 14th April

  • SVN
  • Term Project: Phase 3 (Teams) due final date

• Week 15 : 21st April

  • Project Phase 3: DUE - a complete integration of the three sections (database and user interface)

• Week 16 : 28th April

  • Project Phase 3: DUE - corrections to the phase 3 implementations and a cohesive user interface design

• Week 17 : GW Final Exam Date - TUESDAY MAY 5TH 3-5PM

  • Final Project Demos