1. Create three folders at the root directory on a floppy disk with the following names: db, your last name followed by the letters "simple", and your your last name.  All files you create for this project should go in one of these three folders.  All database files should go in the db folder.  Putting anything in the "simple" folder is optional but this is where the non-database files for a simplified version of the project (see below) would go.

2. Create in Access a database and save it with a name that uses your last name in some way.  Put this database in a db folder on your floppy.  In this database, create a table with at least 3 multiple choice quiz questions pertaining to the subject matter of IST227.

3. Enter into this database correct answers and incorrect answers for each question.  Your database should accommodate the possibility of different numbers of answers to different questions without using fields such as answer1, answer2, etc.  One way to do this would be to create two: one for questions and one for answers.

4. Name your initial file (the one the user begins with) index.html, index.asp, or some other suitable name that indicates which is the beginning file of your application.

5. Create one or more Active Server Pages pages which read(s) the database and displays the question, followed by the possible answers with each answer preceded by a radio button.  The ASP page should reference the database in a way that is portable from one platform to another, e.g. by using the MapPath() method of the Server object.  The page should display a button for the user to submit their answer.

6. If the user's answer is correct, an appropriate message should be displayed and there should be a way for the user to go to the next question.  If incorrect, an appropriate message should be displayed and there should be a way which takes the user back to the question so that the user may try again.

7. When the user is finished, the application should tell the user what percent of questions the user got right on the first try.

Simplifications

You may want to code a simplified version of the project and once that is working, save the working simplified version for possible submission to me should the full scale version of the project not be attainable.  Create another copy of everything and modify this copy to remove some or all of the simplifications.  What simplifications you use are up to you, but some that come to mind are the following:

1) All questions have the same number of answers.
2) Use a single table rather than two tables.
3) Hard code the questions and answers in server-side JavaScript rather than using a database.
4) Hard code the questions and answers in client-side JavaScript rather than putting the questions and answers on the server.
5) Rather than dynamically writing the questions and the answers, create a separate .html page for each question.

Enhancements:

You can get an "A" on the project without doing anything more.  However, if you feel so inclined, you can include enhancements.  Some enhancements that come to mind are the following:

1. In step 5, the Active Server Page should ascertain from the database whether there is only one possible answer to each question.  If more than one answer is possible to a given question, checkboxes should be displayed rather than radio buttons.

Submission

Submit your project on a floppy disk to me.  Let me know at that time whether you will post it on your own webspace such as brinkster.com or whether you would like me to post it on my brinkster.com site.  Either way you can link to it from your schedule page.

If you make extensive use of code which is not your own, indicate the source of it in comments.  Do not use Dreamweaver  behaviors (JavaScript functions)..