This is Web Team Works' Student Grade Inquiry utility. Content of the "wtw" directory: readme.txt This file classlist.csv A sample data file. student.cgi The executable CGI script doing all the work template_front.html template_end.html Template files to customize your WEB page background.gif Background for WEB pages pixelred.gif pixelgreen.gif Needed for graphing System requirements: Windows 95/98/NT WEB server able to run CGI scripts. Xitami by iMatix (http://xitami.com/) is easy to install and free. Set up instructions: When the compressed file was unzipped, the 'wtw' directory was created. Copy this directory as a sub-directory to your cgi-bin directory, or whatever directory your WEB server likes for CGI scripts. For Xitami, your directory tree should normally look like this: "c:xitami/cgi-bin/wtw/", and the script should be at "c:xitami/cgi-bin/wtw/student.cgi". This is all you need to do. Testing: Start your WEB browser. Type "http://localhost/cgi-bin/wtw/student.cgi?classlist" to the "Location" line. You should see a page asking for your ID number. Respond by typing 1234, click on "GET GRADE", and view the result. If you do not see the pages described above, you either made a typo, or your WEB server is not able to run the script. You may try to put the "wtw" directory, with all of its content, to other locations on your hard disk, hoping to find the right cgi directory. As a last resort, you may have to read the instructions for your WEB server. Uninstalling: Delete the "wtw" directory, and this program will disapear. But why would you do that? Linking and customizing: To access the program, put "http://your.web.address.edu/cgi-bin/wtw/student.cgi?classlist" in your WEB page, where "your.web.address.edu" is (guessed?) your web address. Change the "background.gif" file to something you like better. Inspect the template files by a simple word processor, and edit them to include your name, address, E-mail as you wish. If you place %%date%% in these files, it will be updated with the current date when the WEB page is created for the students. Data file update: Use your favorite spreadsheet program to create a data file that has (at least) two columns: "ID Number" and "Total". These labels should be in the first row of the spreadsheet, spelled exactly as here (watch for upper and lower case letters). There may be many more columns in your spreadsheet, but the ones labeled with "ID Number", "Total" and "Name" are special. The "Name" column will never be printed (to prevent students from "guessing" ID Numbers). The last six digits of the "ID Number" is used to identify the student. The student's "Total" score will be used to graph his/her position in the class. The relevant data in all other columns will be reported back to the student. The "classlist.csv" file is an example. Once you are done with your own spreadsheet, it should be saved in the right format. Go to 'File' and 'Save as...' . In the window that opens select the CSV option. Save the file in the same "....../wtw/" directory where the student.cgi program is located. Use 'classlist.csv' for filename. Note on privacy: You may provide the full ID, but only the last six digits will be used. In fact, it is not necessary to have more than six digits in the ID Number column. These six digits should be really numbers, not letters. For a normal class size it is very unlikely that two of the IDs will coincide. If they do, change one of the numbers, and tell the student.