Filter
Top Products
Section Seven -Pre-Assigning Question Titles and Correct
Answers: Questionlist.csv
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 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.
Tip: i-clicker can only identify and utilize one questionlist.csv file at a time. If you want to create
multiple files at once (i.e. one for each lecture), or if you want to save these files for later use, create
the files and save them using different file names that provide you with more information (e.g.
questionlist0716.csv, or Week 1 Lecture.csv). Do not save these files within your i-clicker folder.
When you are ready to use a file for your lecture, copy the file to your i-clicker course folder and
rename it to questionlist.csv. When you are finished with the lecture you can delete the copy in your
course folder.
The file must be in the format “question title, answer” with one question on each line. In the example
below, the questions are titled Question 1, Question 2, and Question 3, and the correct answers are
A, B, and B:
Question 1, A
Question 2, B
Question 3, B
Creating a questionlist.csv in
Microsoft 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, locate/select “Save As” and
name your document questionlist in the
Save As:” field.
5. In the “Format:” field/pull-down, locate
“CSV” or comma delimited as the file
type from the drop-down menu and
select that option.
6. Before clicking “Save,” make sure you are saving the questionlist file in your course folder (i.e. the
folder in which your i-clicker and i-grader applications reside).
7. If a previous questionlist file exists, you will be asked if you wish to replace it. Select “Replace.”
Tip:
Do not name your questionlist 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.
46
Questions? Contact us at support@iclicker.com or call toll-free at 1-866-209-5698.