Assignment for Mid-term on Monday the 25 March, 2002

The breakdown of points for mid-term.

Multiple Choices20%

Solutions directly related to home assignments20%

ASP (including database connectivity) and JavaScript60%

You can not get more than 50% of the points allocated in any of the above components if you do not submit printed solutions to your home assignments with your mid-term exam. You must follow the instructions below.

You can use your home assignment solutions, as a reference, during the mid-term. Only one stapled bundle will be allowed. Any other unstapled pages must not be on the table during mid-term.

Home Assignment (20%)

The Task:

  • You will need to write complete functional code for solving each of the questions included in the following practice problems posted on this subject’s web page (same as the assignment used during previous quiz):

Practice problems on ASP and JavaScript
Practice on session variables, cookies and hidden text box.

In addition to the above you also need to include to your assignment the solution to question no 2 of your immediate past assignment (before the last quiz) on database connectivity. The text of question 2 was as below.

Problems on Data Base Connectivity

Write ASP code segments to display on the screen the following information (use tabular output where applicable).

a. The number of fields in the data table called ‘Customer’ from the database called ‘Sqlpractice’. The number should have a ‘*’ before and after it and centered on the screen.

b. The names of all fields in the data table called ‘Customer’ from the database called ‘SqlPractice’. Each name should appear on a separate line.

c. The value of the 3rd field in the 5th record of the data table called ‘Customer’ from the database called ‘SqlPractice’.

You have the choice to decide on the user interface, whenever necessary, to get the answer to each question in your assignment. It must be as user friendly as possible.

  • Upload all your codes to csl server by creating your sub-folder in an already created folder named “463assignments”. The “463assignments” folder is at the same level as your individual and group folders on the csl server. In this folder you should create a subfolder. The name of the folder should contain your first and last name (e.g. if your name is “Joe Binh” then the name of the folder should be “JoeBinh”). All your codes should be in this one folder and you should avoid creating any further sub-folders within your subfolder.

(Note: You must immediately create your sub-folder in the “463assignments” folder to test that your access permission to the folder is OK. The transfer of your codes may occur later to your convenience before the due time. If you have any problem creating your sub-folder you must contact your class teacher before 12:30PM on Friday (22nd March).

Note that you can only transfer your codes to this folder and may not read, delete or execute.)

  • You must create and upload in the folder an HTML file named “midassgn.html” containing all links to each of the solutions of the assignment i.e. clicking on each link should guide through the solution of a given problem.
  • All codes must be uploadedbefore 8:00 AM on Monday (25 March 2002).

You must strictly follow the instructions below for use of assignment solutions during the mid-term. This must also be submitted with your mid-term.

  • Print each question followed by your fully functional code that you wrote to solve the problems. Each page should have page numbers and your name. Note that in the mid-term questions references to assignment questions will be made without repeating the question itself. Include also the screen outputs.
  • All pages MUST be stapled in one bundle and sequentially numbered. Bring it to the class for mid-term on Monday (25 March 2002). Staple EXTRA 3 blank pages to answer your questions in the class. You will not be allowed to use any pages not stapled in one bundle.
  • You MUST NOT include any materials, which are not solutions to the assignments, in the single stapled bundle.
  • Any student not having the printed copy ready before start of the class will have late penalty of 25% and points may also be deducted from the class activity.
  • You will be tested in the class on your code on paper to evaluate your understanding of the codes that you have written to solve the assignment problems. This will determine your points for this assignment part of your activity.
  • You MUST submit your home assignment along with your mid-term.

1