Blog

How to instruct AI to create a multiple choice CSV import files for you

Fri 11th Apr 2025< Back to Blogs and Tutorials

Creating exams in ClassMarker.com CSV import format is easy with AI tools like ChatGPT, Google Gemini, and DeepAI. Just copy and paste the instructions below, then customize the number of questions and subject matter to your needs.

You just need to choose how many questions to create for your test and select the subject matter (update them in the in prewritten AI instructions below).

Use the below instructions with AI to create an online test

---- START AI INSTRUCTIONS ----

Create a CSV file ready for download in ClassMarker.com format for a multiple-choice quiz, with '5' questions on the subject 'Cyber security'. Follow these steps:

1. Create the Columns: Use the exact following column names in the first row:

  • Question Type: multiplechoice". # Rename the first column df = df.rename(columns={'Question Type': 'Question Type: multiplechoice'})
  • Parent Category
  • Category
  • Random Answers
  • Correct Feedback
  • Incorrect Feedback
  • Points
  • Question
  • Correct
  • Answer A
  • Answer B
  • Answer C
  • Answer D
  • Answer E
  • Answer F
  • Answer G
  • Answer H
  • Answer I
  • Answer J

2. Populate the questionsrows, 1 row per question, for each row, use these guidelines:

  • Question Type: Enter "multiplechoice" for all rows.
  • Parent Category: Use "Generic Parent" as a broad category for the question.
  • Category: Use "Generic" as a specific subcategory for the question.
  • Random Answers: Indicate whether the answers should be randomized (Yes or No).
  • Correct Feedback: Write feedback for correct answers. Provide a variety of alternatives like: "Well done!" "Correct! Great job." "Excellent work!" "You got it! Good job."
  • Incorrect Feedback: Write feedback for incorrect answers. Provide a variety of alternatives like: "Sorry, that is not correct.", "Not quite, try again.", "That's incorrect. Keep practicing.", "Incorrect, don't give up!".
  • Points: Assign a numerical value to each question. Use whole numbers or include 1 decimal place (e.g., 1.5).
  • Question: Write the text of the question.
  • Correct: Indicate the correct answer using its letter (e.g: C).
  • Answer A to Answer J: Fill in the answer options. If fewer than 10 options are provided, leave the remaining fields blank.

3. Formatting Guidelines:

  • Ensure all columns are present in the CSV file, even if some cells remain empty (e.g., unused answer slots like Answer H).
  • The Correct Answer column should correspond to one of the answer options provided (e.g., A, B, C).
  • Use consistent phrasing for feedback to maintain clarity across all questions.

4. Optional Enhancements:

  • Add more answer options (Answer F to Answer J) as required.
  • Adjust the Points column to reflect question difficulty.

---- END AI INSTRUCTIONS ----

More instructions and sample import CSV files: How to create import files for ClassMarker.com

Register Here and see how easy it is, to begin online Testing!

Happy Testing!

Review Related Online Testing Blogs and Tutorials

How Do I Give online exams?
How do I create quizzes with Random Questions?
How to Create Online Tests with Timers?
Create online surveys and forms.

< Back to Blogs and Tutorials

Forgot password? / Register free