Projects for CST-111

NOTE::

Submit the spreadsheet project as a shared Google document (as described below).
The HTML and Javascript projects may be combined, and submitted as web page filess that are uploaded to your folder (at "http://suffolk.li/" )

Spreadsheet

Create a spreadsheet document on "Google Documents" and share it (with edit permission) with "tripodics@gmail.com" .

From chapter 12 of the textbook, on page 420, create a spreadsheet for any one of the following problems: 50, 51, 52, or 53
or a do a spreadsheet project of your own choosing, with equivalent complexity.

Your spreadsheet must include:

Formulas with relative cell references.
Formulas with absolute cell references.
The use of at least two different functions (not necessarily in the same formula).
Conditional formatting.
+++
Your name at the bottom of the spreadsheet.

Also include an example of a circular reference, and make the background red for the cell(s) that contain it.

HTML

In your folder at "http://suffolk.li/" create web pages that include the following:

Text markup tags: -- "illustrate" at least a dozen different text markups.
For each one, state the tag name, say what it does, and show an example.
Include at least one example of properly-nested markup tags.
Images: -- Include a few images, some from local image files and some that come from elsewhere on the internet ("http://.../..."). Align some of these images on the left, some on the right, and some centered.
List tags: -- ordered and unordered lists.
Illustrate a few different types of list, including at least one nested list..

Create a link that says "Click to go here" and takes the user to another page ("here.html"). On this new page, there should be a differently-colored background and a link that says "Click to go there". On that page ("there.html"), include links to go back to "here" or to go "home" (to the original web page).

HTML + JavaScript

Modify your HTML pages to illustrate as many of the following as you can:

Rollover effects. (i.e. changing an image when the mouse is hovering above it, then changing it back to what it was when the mouse moves away).
Changing the background color, when a link is clicked.
Changing the width or height of an image,
Using the "alert()" method, to pop up a subwindow. when a link is clicked.

For extra credit, add a "form" with at least two tags to input text from the user, another tag to display a result (this may be a third input tag), and a few buttons to perform operations ( such as addition, multiplication, etc.) on the input values, and display the results.