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.
Open Microsoft Excel.
In column A, enter the title of each question.
In column B, enter the corresponding correct answer.
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.
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.
From the Save As type drop-down menu, select CSV or comma separated or delimited as the file type.
Click Save.
A warning message will notify you that the selected file type does not support workbooks that contain multiple sheets. Select OK.
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.
From the Accessories program folder (located in the Start menu), open Notepad.
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.
Select Save As and name the file questionlist.csv.
From the Save as type menu option, select All Files.
Click Save.