how to let students enter private exam results into a spreadsheet without others seeing

[palaeontology]

I apologise if this is an obvious one, but I can't seem to get my head around how to do this ...

I'd like about 400 students to enter their own exam results into a spreadsheet but in a way that no one else can see other student's results.

So there are a couple of important considerations in this ...

* students need to be able to enter results that are unseen by others (however, I should be able to see all results, of course)
* multiple students need to be able to access the spreadsheet at the same time

I'm thinking it might have to be a userform that they use, but as that's attached to a spreadsheet file which can only be used by one user at a time, I get lost at this point as to where to go from here.

Can someone think of a way to achieve this ... am I missing something really obvious ?

Kind regards,

Chris

 

[palaeontology]

Strike that query ... I've just realised I can get the data from the students privately using a Google Form as a survey.

Thankyou for looking into it for me anyway,

Kind regards,

Chris