Edinboro University


CSCI 323 Web Development
Fall 2015

Special Note - We need to keep this schedule very flexible, I want you to get the most out of the course.  To make that possible we may need to move/add/delete some topics depending on our pace and how the class is doing.  I will continually tweak this web site, so check it often to see what's going on.

 

Week
Starting

    
8/24

Introduction to the course

  • Go over syllabus
  • What you'll learn
  • What you need
  • Assignments
  • Grading
  • Expectations
  • Lab time
  • Edinboro Network
  • Take roll
  • Make sure all of us can run the Adobe software

Your Homework Website:

Implement the following today:

  • Figure out how to access the cs server area for your web site

Web Site Work flow:

  1. Define scope of project, objectives, target audience, schedule & available resources
  2. Develop Design strategy and establish the look and feel of the web pages
  3. Develop Prototype (This will be our actual site)
  4. Present to client
  5. Assemble & create the web site.
  6. We'll have a csci323 domain for this course.
  7. Location of files:
    /home/cs/d123456t/public_html
  8. Your Web area (sample)
    http://csci323.cs.edinboro.edu/~d123456t

Chapter 1 - Setting the Scene

 
8/31

Chapter 2 -Establishing a Web Presence

  • Chapter 2 Notes
  • This includes some screen shots of FileZilla and PuTTY
  • Download:
  • Work on our initial web pages. We can save to a flash drive if you don't have an account or public_html directory yet.
  • Make a page for our assignments.

Chapter 3 - HTML for Content Structure

  • Chapter 3 Notes → We look at a trimmed version of these notes, we cover this material via demo.  Most sould be a quick review from the 1st web course.
  • Initial Pages
    • Add DIVs
    • hyperlinks
    • CSS
    • Buttons ?
    • Look at competors web sites, steal ideas
  • Intro to Photoshop
    • Text as image
      • Create a heading for your project
      • text effects
    • Colors
    • Cropping
    • Backgrounds
      • getting from web
      • Centering on page
    • Save for Web
    • Transparancy
    • File types
  • Looks like SSI is not working
9/7

Chapter 3- HTML for Content Structure

  • Continue on the table & hyper links exercise
  • Start Chapter 4
  • Some CSS examples
  • Good web site for colors
    colourlovers.com

 

Chapter 4 - CSS for Content Presentation

  • Chapter 4 Notes
  • Create a simple CSS file for our site.
  • Make a class
  • Make use of an ID to style one particular item on your page.
  • Let's make a div style parameters and see what is available.
  • Look at Navigation

9/14

Chapter 4 - CSS for Content Presentation

  • Continue on the CSS style sheet exercise

Chapter 5 - HTML Forms for Data Collection and Submission
9/21

Chapter 6

  • Chapter 6 Notes (covered this already)
  • Discuss Regular expressions
    • sequence of characters that forms a search pattern
    • we are using these to validate the users input
    • we are "searching" for a pattern of characters
    • use in the javascript search() function
    • https://regex101.com/
  • Work on Validating our feedback
  • Add the products page

 

Chatper 7

  • Chapter 7 Notes
  • Java Script
  • Work on rotating image div on your home page.
9/28

Review

Exam 1

  • HTML 5
  • CSS w/sheet
  • Write JavaScript
  • Small Application
  • Make it live on the internet
  • Add Link to your homework page
10/5

Chapter 7

Review of Exam1:
go over example of making in-line block type of menu for our site.

Chapter 7

  • Continue with the CSS
  • Rest of time Work day
  • I'd like to see each student's progress
10/12

 

  • Reading Day

Chapter 8

  • Start Chapter 8
  • Make a simple php web page and test it
10/19

Chapter 8

  • Finish Notes
  • Make a simple PHP page to create a text file on the server

Chapter 9

  • Review basic concepts of database
  • Propose a simple E-R diagram
  • Lab time to work on PHP E-mail and collection of data for your project.
  • Chapter 9 Notes

 
10/26

Chapter 9

A good site with examples of using PHP to connect -> examples

 

Chapter 9 or 10

 

  • Email - should be working, Let's test it
  • Database - Discuss our design
  • phpMyAdmin - Login & create a table
  • Connect - Write the PHP to connect
11/2

Review for the Exam

  • Closed book
  • Short answer questions
  • Maybe write some code
    • Simiar to what we did in class for connecting to a database and printing data out.
    • Understand how a form works
      • move the data to the next page and display it. ($_POST)
      • start a session
      • $_SESSION
    • Write the SQL to display the data
    • Write some generic SQL
      • Display data sorted
      • Display only certian data
      • Add a record
    • Add data from form to database
    • Some short answer database questions
      • relations ?
      • referential integrity
      • E-R diagram
      • Primary Key
      • Foreign Key
  • Review the questions in the book at the end of the chapers.

Exam 2 - Chapters 5 through 9

 
11/9

Chapter 10

  • Go over exam
  • Start Ch 10
  • Notes
  • Connect to our database

Chapter 10

  • Notes
  • Let's add functioniality to Update a record in the database.
11/16

Chapter 11

Project Day

  • I'd like to see the status of your last project
11/23 & 11/30

Extra

Project day

Chapter 12


Final Exam: Tuesday at 10:15


Subject to change Assignments
Due Date Description

8/28

HW-1

Exercise 1.12 & 2.10 - Idea for your parallel project; save it to index.html
** Let's tweek this a bit and make it a HTML page and post it to our web directory
* Make a directory for this assignment Call it

9/4

HW-2

Modified version of Exercise 3.16 - (refer to page 61, top for a sample of what it could look like.  Save this as Index.html in a folder called HW-2 on the web server.

What you need:

  • One page, your initial page for your product
  • Good layout like we did in class,
    • header, nav, main footer DIVs
    • centered
    • Approprite and good color selection
  • Heading graphic that we made in Photoshop
  • Menu where the links go to dummy pages (a href="#")
  • Some text about your company (borrow/steal from another site)
  • footer put your copyright note there for now

Notes:

  • Simlar to the one we started in class. http://csci323.cs.edinboro.edu/~dtucker/HW-2
  • I wanted to have you use Server Side Includes but it looks like the ability to use them is not enabled on our apache server.
  • Make sure you test your page!! - have a friend look at it or look at it off campus.

9/11

HW-3

Add much more CSS HW-2

Parallel project from Chapter 4

  • Use a seperate CSS style sheet
  • CSS styled menu
  • Box style menu - yes, have color, maybe underline change on hover
  • consider borders on the divs
  • Centered, width that fits most screens (900px) But you can have a top banner all the way accross if you want.

 

 

9/18

HW-4

Parallel Project for Chapter 5

  • Feedback Form
  • Products selection Form
  • Read the parallel project requirments carefully from the book.
  • The CD rom had good examples for this assignment
  • And the stuff we did in class

9/25

HW-5

Chapter 6 - 6.15 Exercises on the Parallel Project

Validate all that makes sense to do so. 

On my example I would validate

  • Quantity
  • First Name
  • Last Name
  • E-Mail
10/14
HW-6

Parallel Project Exercise p. 255

  1. Gather some images that relate to the product that you are selling
  2. Add the rotating image functioinality talked about in this chapter
  3. Add the drop down menu functionality to your home page.
    1. I know there are other options but use javascript for this
    2. Modify your other pages accordingly

Sample:

Chapter 7 Sample

11/6

HW-7

Chapter 8 Parallel Project: p. 302

  • Welcome Message on Home page that changes every time the page is accessed
  • Server-Side PHP processing for your feedback form
    • You recieve an e-mail message
    • The user gets an e-mail confirmation message
    • New web page confirming the feedback submission
    • Save teh feedback to a text file on the server like in class
  • Server-Side PHP processing for an order
    • Same features as above when the user submits an order

11/13

HW-8

Chatper 9 Parallel Project: p. 362

Answers questions 1 through 6. Remember not to make it to big, no way near as big as the author's. I'm thinking 3 or 4 tables max.

Make me a simple web page with a screen shot of your E-R diagram from PhP MyAdmin.

12/1

HW-9

"The Big Project - Putting it all together"   

My Sample Project

Link to the sample page I've been making in class

If you want to see the admin and non-admin stuff:

Admin Login:

  • dtucker@edinboro.edu
  • password

Non Admin Login

  • msimko@edinboro.edu
  • password

Grading Rubric

Chapter 10 Parallel Project: p. 439 - (Final Project)

incorporate all of your previous work, but make it its own link.

More specifically: "When I run your web site"

  • Overall good design
    • Tabs/block style links
    • Consider colors
    • Wrapper that is centered
  • "Today's Date" on the home page or some sort of updating.
  • Survey / Feedback page with PhP e-mailing
    • User gets a confirmation
    • Send to your edinboro account the actual question
    • Append to a text file.
  • I'd like to be able to add a customer (using your previous form; maintain your previous validation)
  • Add some dummy data to your tables - customers, products and transatctions
  • Run a query to display all the customers
  • Simple page to add a product, make simple admin link, you don't need to log in. Put near bottom of home page near copyright.
  • Validation on all forms
    • Doesn't have to be perfect at a minimum make sure the fields are not blank.
    • But use the regular expressioin check for the e-mail
  • Run a query to display all products (like your are shopping)
    • 10 Bonus points if you include an image of the products
    • Customer can Purchase a product
    • Its ok if you can only purchase one or more of a single product at a time.
    • Provide the total cost (quantity * cost + tax)
  • Query to see all purchases
    • Customer and product
    • Quantity

Tables (for example only, yours will probably differ):

  • Each table should have its own ID as primary key
  • Customer Table:
    • Customer ID
    • First Name
    • Last Name
    • e-mail
    • Address
  • Products Table
    • Product ID
    • Price
    • Quantity In Stock
    • Description (memo)
  • Transaction Table
    • Transaction ID
    • Customer ID
    • Product ID
    • Quantity