What if you could create multiple choice questions inside ChatGPT and then export into Gimkit? Quizizz? Other apps? Why yes you can! In this post, I will demonstrate how I helped our science teacher create some questions in ChatGPT. Then, how we exported them and pulled them into Gimkit!
This can work for any tool that is CSV. To keep it simple, I'm using Google sheets but you can use Excel. Also note that I'm on a Mac but I'll include PC instructions.
Table of Contents
Step 1: Determine the type of CSV format that your tool needs.
So, first we created a ten question multiple choice with an answer key. But then, Jessica, our middle school science teacher, asked this question, “Can I take this into Gimkit?”
And I realized that ChatGPT does do CSV exports.
So, I went to Gimkit to determine the format it needed for the CSV Input. Quizizz is a separate format, so I'll do that one separately.
So, first I went into Gimkit and downloaded and opened their template into Google Sheets by opening it and clicking “New Kit” –> Import from Spreadsheet and then I downloaded the spreadsheet.
Step 2: Generate Questions Relating to Your Topic
In my experience, it is easier to get good questions if you have already been “talking” to ChatGPT about your topic. I would make sure that it understands what you're teaching, the objectives and such. In this case, Jessica and I had been generating ideas, and project ideas, and had a multi-prompt “conversation” about her lessons around this topic.
Don't for one second think that ChatGPT is doing the work of teaching. As I've said multiple times, human intelligence can be multiplied by ChatGPT. However, when you do not have knowledge of a topic, you do not know how to prompt for that work.
So, after we found the questions we wanted, we used this prompt. If you are prompting without conversation, you'll have to have much more information than this. (I'll do a separate post for science teachers on another day!)
Notice that the format is the names of the columns.
Step 3: Save the CSV onto your computer as a CSV File.
So, when you copy the CSV code, then it needs a place to go.
I opened text edit on my Mac. (Tip: You have to go into preferences and tell it to open in plain text.) On a PC I would use the free Notepad++.
Then, I just go in and paste. Then, I click File and save and save it as gimkit-space.csv. You can name it anything but it must, I mean MUST, end in csv.
Then, after I saved it, it ended in CSV and I saved it on my computer.
Step 4: Go Back to Your Google Sheet and Import the CSV
Now, all you have to do is go back to the Google Sheet and go to File –> Import.
When you import it, import it as a NEW SHEET inside the Google Sheet Template. It is OK, this is the best way to do it!
Step 5: Copy the Questions and Answers from the New Sheet into the Template Sheet
This is important. Make sure the import sheet headings look exactly as the template that was downloaded. This way it will import properly. In this example you can see my second sheet. I'm just copying the questions and answers as I've highlighted.
Now I will paste into the first sheet.
Step 7: Check and Edit Your Data
Now, we had already checked our questions and answers before we had created the CSV but I have to emphasize this.
ALWAYS CHECK THE QUESTIONS AND ANSWERS.
ChatGPT is a Large Language Model. It studies humans. Humans make mistakes. ChatGPT can make mistakes too. In this case you just have to check the question and the first column which is the correct answer.
Just fix the mistake by typing in the spreadsheet, and when you're happy, go to the next step.
Step 8: Delete the Second Spreadsheet
Truthfully, you probably don't HAVE to do this. However, I just wanted to keep it simple and understandable.
Step 8: File and Download as a CSV
Step 9. Upload your CSV into Gimkit
Import from Spreadsheet and then upload the file in Gimkit. Then, you're done!
Never miss an episode
Get the 10-minute Teacher Show delivered to your inbox.