designing a questionnaire

The data we collected was from a sheet that had been handed around the classroom and was answered  with ticked boxes or simple sentences  and  both open and closed questions closed questions with a simple yes and no answer and open questions which are the sentences with more detail. but it could be changed, by the amount everyone could have wrote and this would be a closed question. and some questions didn't give enough options and some peoples answers were not on the sheet and this also made the questions longer. i recored the answers on excel and i then collected the data by recording the classes results.