Excellent input! Is it possible to add feedback for both correct and incorrect answers in the same CSV file that contains the questions? If so, what would the new structure of the CSV file be?
@luweezla9 ай бұрын
Thank you so much! I did it 😁 and I’m not computer savvy😁 This gives me the ability to personalize class quizzes based on lecture topics.
@HowToCanvas9 ай бұрын
I'm glad this could help you out! "Not computer savvy" people are my people.
@greese86915 ай бұрын
This is fantastic, thanks so much Sean and Phillip! I just tried it with Copilot, and it generates an .xlsx file, so no need to copy/paste the table.
@philipcallil53693 ай бұрын
Fantastic, all went well in doing this. Sean, thank you for a really clear and concise way for teachers to save a lot of time and use a valuable tool for formative assessment. Low stakes quizzes will be part of the response to check student reading for understanding with ChatGPT starting to impact on student learning. The multiple response questions did not generate the comma required to incorporate multiple responses but otherwise all good with accuracy. That was easily changed in the csv file. Would love to know how to incorporate into the table the generated positive comments and explanations when students get the answers wrong.
@philipcallil53693 ай бұрын
Interesting, I've generated several quizzes for the same article and the correct response seem to change. While easily fixed, it's something to be wary of.
@hiroenglishteacher8 ай бұрын
I'm a little late, but... If you're from Brazil, you probably work with the Brazilian version of the Microsoft Office Software (like I do). In this case, the CSV values are exported and the commas are saved as semicolons. There's a workaround: open the CSV and substitute every semicolon for a comma, then the process works just fine. Maybe it could help someone... BTW, great video! It made my quiz creation process much faster! Thanks a lot
@HowToCanvas8 ай бұрын
Thank you for this! I’m not familiar with the Brazilian office e nao fala Portuguese bem mas eu quero fazer todos meus videos por as pesoas no Brazil 🇧🇷
@hiroenglishteacher8 ай бұрын
@@HowToCanvas Oh, it's such an underrated LMS here! People should use it more.
@gcoelho20009 ай бұрын
Congratulations on the teaching and thank you very much!
@HowToCanvas9 ай бұрын
You're very welcome!
@briangabert299616 күн бұрын
You show how to add explanations at 8:20. How do you add the explanations to the Excel table so that it gets into Canvas? Is there a separate column that needs to be added? Same goes for positive feedback at 8:40. How do you get the feedback from ChatGPT to Canvas? Thank you!
@user-zy2ni9wi2d9 ай бұрын
This is amazing! Could I possibly copy a word document with an exam I already have an have chatgpt convert it into this, so I can use it on Canvas?
@lenoreporter53334 ай бұрын
Thanks for the video! Do you know if there is any way to include feedback by answer choice within the CSV to convert into the QTI? I know you can do it with the '@' after each option in Respondus 4.0, but I am a mac user at work. I am also not too comfortable with QTI to know the ins and outs of formatting possibilities!
@user-fn1iy4vy7t11 ай бұрын
Do you know if there is a way to convert the files in a way that the questions can import into New Quizzes on Canvas instead of classic quizzes?
@HowToCanvas9 ай бұрын
This may help. community.canvaslms.com/t5/Instructor-Guide/How-do-I-import-a-quiz-from-a-QTI-package-in-New-Quizzes/ta-p/880
@gildaekhtiar92936 ай бұрын
I tried your way and worked for my ESL class. can you show me how to do fill-in-the-blank questions?
@ccderik7 ай бұрын
I'm getting this error on all questions when converting the CSV to QTI: "Missing columns needed for question type "MC;;1;". The columns look fine in Excel (I have included the empty B column, btw). Do you have any clue to what's up? 🤔
7 ай бұрын
Me too !
@greese86915 ай бұрын
I ran into this issue then realized that saving the file as a CSV (Comma delimited)(*.csv) (not the other CSV formats) resolves the issue.
@ccderik5 ай бұрын
@@greese8691 I'm saving it as that but still get the error (on every question), saying that it's missing columns for the question type.
@hodajahanshahloo87518 ай бұрын
Wow, It was amazing
@HowToCanvas8 ай бұрын
Thank you!
@capsonlinehomeschool9 ай бұрын
Which Chatgpt did you use because following your instructions my CHATGPT's tables were a complete mess.
@HowToCanvas9 ай бұрын
I find interesting tips on Reddit sometimes. www.reddit.com/r/ChatGPT/comments/108iavw/pretty_simple_prompt_to_have_chatgpt_format/ There's usually someone who knows a good prompt. I haven't really been making many tables in ChatGPT lately.
@marksimpson445911 ай бұрын
I wonder if you could take an Excel sheet and manually enter your own quiz questions like the format chatGPT created, and then go through the other steps to import that quiz into Canvas. Is there any example somewhere of what the columns would need to be and the options (like MC, MT, TF), e.g., a short essay.
@HowToCanvas11 ай бұрын
You can absolutely do that. Follow my template with the question type in the first column, a blank second column, point value in the third column, etc. etc. I personally don't know if short answer or essay would be a question type in that format. Perhaps.
@scotthannah482511 ай бұрын
Love this, thank you. Is there a way to add the incorrect/correct feedback into the table so that it can be imported to Canvas?
@HowToCanvas11 ай бұрын
As far as I've researched, I don't think this is possible. I'll make a video next week talking through the Excel spreadsheet more precisely.
@geoffreymiller80654 ай бұрын
Careful, the answers I got were often wrong, very wrong.