Semester 2 Project (version 1.85)

Rubric is Here

Sample Site Map is HERE

Our second semester project is designed to give you a great deal of practice with the four main features of a modern website:

  • Designing Web pages
  • Designing a Database "Back End"
  • Writing Code to manage database connections and web objects
  • Production Graphics

Although you are working individually, the result of each of your work will combine to model a basic online high school grading application.

You must complete components related to each of the "Big Four" topic areas above.

Additionally, you must choose one of those topic areas as an area of interest/ specialization that you put double-extra-effort into research, design and implementation.

═══════════════════════════

WEBSITE DESIGN REQUIREMENTS

1) WEB PAGE COMPONENTS (20 pts):

Your website must include:

An impressive home page with appropriate, intriguing, eye-catching graphics as described in "Production Graphics" (section 4) below

At least 3 webpages in your root directory to include:

  • a homepage named "index.html"
  • a data page
  • an html page of your own

That root directory should also contain

  • An images subfolder
  • A documents subfolder
  • A data subfolder
    • The data folder should contain a data query page
    • The data folder should contain a data results page

A consistent "look and feel" where each page on each level uses the same font sizes, font colors, navigation menus/buttons and/or similar parts.

Each page should be clear and easy to read with no portions that run off the screen (Dealing with various screen sizes can be a pain-- be prepared)

A database 'homepage' where your users will go to view & query data

Extended Option Suggestions:

  • Use CSS to maintain look and feel throughout your system

══════════════════

2) DATABASE COMPONENTS (20 pts):

Your database 'homepage' must include:

A link to a seperate query Page:

The query page should allow your user to do basic queries such as finding a particular student or teach and display the results back to the user.

The query page should allow your user to view the results of main table queries in rows.

The query page should allow your user to view the results of main table queries in single records.

Extended Option Suggestions:

Including a one-to-many relationship between two or more tables and allowing querying on those.

Use SQL queries to make a fully functional password (add/edit/change) system

══════════════════

3) CODING COMPONENTS (20 pts):

Your website must include:

Javascript (including Jquery) and/or PHP code that accurately and efficiently connects your webpage to our classroom Mysql Server

Javascript (or other language code) that somehow manipulates images or object on your main page to make your page more dynamic.

You will be graded on our usual classroom coding conventions:

  • variables and functions have appropriate names
  • code is clear, concise and easy to read
  • repetitive sections are placed in functions
  • commenting is appropriately detailed

NOTE: you *can* incorporate outside code here if you:

  • Clear it with me first
  • Include proper citing and documentation as required by the owner of that code.
  • Failing to provide proper and appropriate citation/copy write notice or other documentation here will FAIL your entire project.

══════════════════

4) PRODUCTION GRAPHICS COMPONENTS (15 pts):

Your website must include:

An *impressive* eye-catching graphic on your home page (background images can be tricky)

A page 'banner' or similar quality production graphic that is the same on every other page on your site.

Graphics should:

  • Fit clearly and evenly on the screen for 'conventional' screen resolutions (we'll decide what that means)
  • Employ multiple layers
  • Complement the 'look & feel' of your site in terms of style and color choice

 

5) Scheduling & Code Review (15 pts):

A) Beginning Thursday, May 23 participate in code review.

B) At the end of the first week AFTER the AP Test, you must present to me a link to your first draft calendar/schedule of your anticipated work for the rest of the semester. That work MUST be signed off on by our class IP.

C) At the end of the second week AFTER the AP Test, you must present to me a link to your FINAL draft calendar/schedule of your anticipated work for the rest of the semester. That work MUST:

  • Be signed off on by our class IP.
  • Be periodically adjusted as your work progresses (I need to have editing privileges and I will check your update history unannounced to see that you have made periodic updates to your schedule)

Our IP will be our project manager. It is his job to keep things going and to encourage you to stay on task and make periodic reports on your individual progress back to me..

That's a GOOD thing.

Being non-gracious and non-humble to him in that regard is ill-advised

6) Extended Work (10 pts)

Did you take one of the four main components beyond the basics?

Did you achieve some level of 'mastery' in that?

═══════════════════════════