I have heard some users of Microsoft 365 that they wish there was a way to have something like Google Forms to collect formative assessment or survey data from students and parents
In OneDrive, click on “New.” The last document option is “Excel survey.”
Add a Title
Enter a Question
Click where it says “Enter your first question here.” This will open the settings for the question. Delete the default text of “Enter your first question here” and replace it with your first question. The “Question Subtitle” allows you to provide additional context or directions for your question.
For a multiple choice question choose “Choice.” Delete out the default text of “Choice A”, “Choice B”, etc… Hint: use the keyboard shortcut “Control A” to select all of the default text. Each answer choice A, B, C, D, etc… is entered on it’s own line. Type your answer choices and press enter between choices.
If you want to have a default answer that the students can accept, for example if the question is “What assignment is this?” you may want a default answer to pre-slug that field on the survey form. Click done.
Add Another Question
Use “Control C” to copy the link to the survey. Share this link with your students, or whoever you need to take the survey.
If you need to get back to the survey form to edit or share it, locate the “Survey” icon in the toolbar. Click on this for the options to “View Survey,” “Edit Survey,” “Delete Survey,” Or “Share Survey.”