I was working with a teacher on Monday who had created a Google Form that could be used to collect responses for any in-class question (ie. math problem of the day). There was one problem with the form and that was that the students usernames are a combination of letters and numbers, making the students for each answer difficult to identify.
Here is a simple way to solve this problem using the vlookup function and the copyDown add-on. This is a very basic Example Form to show the data entry and an Example Response Sheet which has the instructions to setup the vlookup and copyDown features.
Enjoy your your everyday Form,