Likert question on excel
I made a survey for school using forms. I like the graphs provided after the surveys are done and I'm trying to use those graphs in excel, to be exact the likert graph but I cant seem to find out how to do it on excel. When ever I try to do the stacked bar graph it doesn't add up how it has it on forms. The title of the question is the only variable that comes on on everything like my x-axis, y-axis and key variables. Any way I can copy and paste the graphs already provided in forms onto excel? Or does anyone know the trick to use that specific formula in excel to do it?
Comment box based on rating
Apologies if this has already been asked, but I'm struggling to find an answer online. On MS forms, is there a way to have a comment text box appear based on the rating provided. E.g., if 1 star was given, a box pop up to ask for further information? I've tried the branching option, but can't see any 'logic' to apply. Thanks!
Drop Down Quiz Questions within a fill-in-the blank sentence structure
Is it possible to get a function in MS Forms for drop-down questions to show within the fill-in-the-blank question? It is helpful for students (especially younger students) to see their chosen answer within the actual question sentence. IE we would like to make it look like this: But we can only make it separate questions with drop down like this:
Input lag on Forms Quiz Feedback
Hi All, Teacher here. Physics & Computer Sci background so fine with tech. I've just run a form with 85 responses. It has 20 auto-marked multi-choice and then 4 text input fields that I am marking myself. The text is roughly 200-300 characters max. I wouldn't think it was a massive data file. The setup has worked great and I am mid way through grading the papers, however: When I am typing feedback using the comment field (the little speech bubble) on the "review answers" area. There is a huge input lagof between 2-5 seconds. Longer text = more lag. A similar, sorter lag occurs when inputting the scores. It's quite frustrating to work with. I have troubleshooted on my end including trying on multiple devices, my colleague tried it a their home; all have the same issue. Has anyone experienced this? Have any solutions? Can I feed this issue to MS somehow?
Excel export does not contain feedback comments
When the responses to a quiz are exported to an Excel file from Forms, the feedback comments are not copied across. Sometimes it will pick up comments that were added in to the quiz when it was designed, but any comments or feedback added when the quiz answers are reviewed and marked are not copied to the spreadsheet which makes the export pretty useless as a feedback tool. It is essential that comments madeafterthe quiz have been taken can be exported.
