Hi Jethro,

I assume that you would like to keep this relatively simple. My thoughts are
as follows:-

Create an Excel worksheet with only one worksheet.
Unlock only those cells where the students enter data.
Password protect the worksheet allowing only 'Select unlocked cells'
Save the worksheet in a folder that the students can access and then set
security on the file to read only and also that the students cannot delete
it. (Your Computer Systems Administrator should be able to help you with
this.)
Students could then load the workbook and enter their details and would have
to save it to a new filename (say Student Id.)
You could then have a macro that picks up all workbooks in a specific folder
and copy the required data to a master worksheet.

Now you need to consider how to address any privacy issues. Talk to your
Computer Systems Administrator on this issue to find the best option to suit
you. My preferred method is one whereby the saved files can only be viewed
and accessed by the owner (the person who saved them) but other people like
youself can have full access to all the files in the folder.

Regards,

OssieMac

See also http://gregmaxey.mvps.org/Extract_Form_Data.htm