Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • I have an Excel spreadsheet that contains flashcards which is split into 2 columns, Terms and Definitions. What I want to do is query GPT4 to convert them into multiple choice questions.

I have the excel reader and have imported the data, but I dont know how to split the columns and say something like:

 

(GPT4 Prompt)

I have a flashcard with the term {TERM} with the definition {DEFINITION}. I want to convert this flashcard into a multiple choice question. The definition will be the question and the terms with be the answers. You will generate the question and 4 answer choices. The correct answer choice will be prefixed with a '*' character and you will generate the other 3 incorrect answer choices. When generated the incorrect answer choices, make a selection to where the user will not be able to easily use process of elimination to conclude the correct answer. For example:

 

Uppers, stimulants. Legitimate and useful medical applications, but often abused. Example Ritalin for ADHD. Adderall for obesity, ADHD and narcolepsy are called what?

 

*Amphetamines

GPT generated incorrect answer choice

GPT generated incorrect answer choice

GPT generated incorrect answer choice

 

Thanks in advance

Hi @shatterstar6457​: Consider using the following syntax in place of the parameters you provided: @Value(Term) and @Value(Definition). You might also consider explicitly saying this as the example at the end of your prompt:

Term: <insert term name here>

Definition: <insert definition here>

Choices:

  1. <repeat definition/term here>
  2. <insert incorrect definition/term here>
  3. <insert incorrect definition/term here>

Reply


Community Stats

30,110
Posts
114,303
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.