Alphabetizing your responses from Google Forms
If you have ever used google forms for a test/quiz, and have exported the results to a google form, you may have noticed that the form created will include the students email address. This makes it more time consuming to capture your students' marks because you cannot alphabetize based on last name.
Step 2: Copy the data from your Google sheet that contains the form data.
Be sure that the first column selected is the student email address.
Step 3: Paste this data into the 'Alphabetize' Google sheet.
NOTE: The mytoools2go email addresses need to be in column A.
Step 4: Press the big green button.
The script will run and convert the email addresses and sort your sheet.
When using the sheet again, all you have to do is paste in the new data and press the button again.
No comments:
Post a Comment