I am a teacher and I am trying to incorporate more technology when it comes to exams. Here is the scenario.
Students take an exam online using google forms. The data is put into a spreadsheet. Unfortunately the student does not get a printout of their exam and which ones they got right or wrong. I want to take the data and create a separate sheet in excel or google spreadsheet whatever is easier.
I want that sheet to have the question, their response to that question, a yes if they got it right, no if they got it wrong, and the correct answer. Being that I have over 160 students I am thinking there is a way to do this using a macro. The macro needs to be able to select the next row and create another page so that I can print them out and hand them back to the kid.
Is there any way of doing this? If so, how do I do it.
Students take an exam online using google forms. The data is put into a spreadsheet. Unfortunately the student does not get a printout of their exam and which ones they got right or wrong. I want to take the data and create a separate sheet in excel or google spreadsheet whatever is easier.
I want that sheet to have the question, their response to that question, a yes if they got it right, no if they got it wrong, and the correct answer. Being that I have over 160 students I am thinking there is a way to do this using a macro. The macro needs to be able to select the next row and create another page so that I can print them out and hand them back to the kid.
Is there any way of doing this? If so, how do I do it.
