Pre-Assigning Question Titles and Correct Answers

If you’d like to assign titles to your questions (and the correct answer) before your lecture (instead of the default Q1, Q2 assignments given by i>clicker), you may create a questionlist.csv file and save it in your course folder. If you are teaching multiple sections or courses, you will need to include a questionlist.csv file in each course folder.

To create a questionlist.csv file in Excel:

  1. Open Microsoft Excel.

  2. In column A, enter the title of each question.

  3. In column B, enter the corresponding correct answer.

  4. Go to File > Save As and select your course folder from the folder list (e.g., iclicker Win/Classes/PSYCH-400-001).name your file questionlist in the File name field.

Note: Do not name your questionlist file as questionlist.csv in the File name field. If you do this and save the file as a CSV file, it will not work properly with your i>clicker application.

  1. In the File name field, name your file questionlist.

Note: Do not name your questionlist file as questionlist.csv in the File name field. If you do this and save the file as a CSV file, it will not work properly with your i>clicker application.

  1. From the Save As type drop-down menu, select CSV or comma separated or delimited as the file type.

  2. Click Save.

  3. A warning message will notify you that the selected file type does not support workbooks that contain multiple sheets. Select OK.

  4. An information window will notify you that questionslist.csv may contain features that are not compatible with CSV (comma delimited) and will ask, “Do you want to keep the workbook in this format?” Select Yes.

To create a Questionlist file in Notepad:

  1. From the Accessories program folder (located in the Start menu), open Notepad.

  2. Enter the title of the question followed by a comma and then the correct answer. Do not add a space between the comma and the correct answer.

  3. Select Save As and name the file questionlist.csv.

  4. From the Save as type menu option, select All Files.

  5. Click Save.