Apple Mouse manual Creating a questionlist.csv Microsoft Excel

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-clickercan 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-clickerfolder. When you are ready to use a file for your lecture, copy the file to your i-clickercourse 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.