CSC 370: Week of 4/5/10

CSC 370: The Week beginning Apr. 5

Homework:

Make a page that uses JQuery tabs.
Make a page that has an external CSS with separate styles for screen and print (your CSS should include comments that clearly indicate the differences between the styles for the different media).
The above could be the same page or two separate HTML pages.

Due: Apr. 15

Reminder: we will have a test Tuesday April 13th.
Tuesday:

Questions about next week's test!

HangmanPart.htm

Holbein1a.htm Another example of having both print and screen CSS, this time in a separate file
Horsefeathers.htm Uses JQuery to scroll a set of div's vertically, use ready, each, index, this, and size
FadeAway.htm Uses JQuery fadeIn and fadeOut
Select (Drop-down list) Inputs (PowerPoint includes a switch statement creates these files (zipped) or as an alternative a key-valued array creates these files (zipped))
Thursday:

Try MySQL Again Use your MySQL account on the gamma to create a database called YourLastName_Northwind (with, of course, YourLastName replaced with your last name). Then design a Customers table based on the Customers table your find in the Northwind Access database. Export the data from Access and import the data into your MySQL table. Write and run a basic query on the table. Make a screen capture showing the results of your query in the phpMyAdmin interface. Send me a document with that screen capture.

Download the necessary files and follow the directions at http://tablesorter.com/docs/ to turn your earlier table assignment into a sortable table. (I took my first two rows of the Sixers table which were not part of what got sorted and placed them in a separate table. Then I switched the row striping from static to dynamic, i.e. I used JQuery's $('tr:even') and $('tr:even'). Finally to make sure the table was re-styled after it got sorted I wrote a few lines of code based on http://tablesorter.com/docs/example-triggers.html, their example with a trigger.) Post your files and send me the link.