[Classclimate-users] importing cdv files into Class Climate

[Grenert, Joseph]

Thanks for sharing, Tom. I'm sure this will help someone.

_____________________________________________________________

Jody Grenert
Communication Director
Ohio University College of Health Sciences and Professions
W361 Grover Center
Athens, OH 45701
740.593.1433
grenert at ohio.edu

-----Original Message-----
From: classclimate-users-bounces at listserv.ohio.edu [mailto:classclimate-users-bounces at listserv.ohio.edu] On Behalf Of Scanlan, Thomas
Sent: Thursday, April 11, 2013 11:31 AM
To: Users of the Scantron ClassClimate survey tool
Subject: [Classclimate-users] importing cdv files into Class Climate

The College of Arts and Sciences is in the process of sending out an advising survey for all of its undergraduate students.  With the help of Jody Grenert and Jill Bateman (thanks to both of you for your help!!) I managed to import 3534 email addresses into the survey.  I had tried to do this yesterday without success.  But this morning Jill told me that a csv file generated on a Mac would not work.  I then opened that file on a PC, and in a few minutes, I was done.  Jody's directions for this (attached below) were perfect-- except that I didn't include any column titles or "headers".  In the lefthand column, I put the unique "Course ID" (which was the same for all entries); in the righthand column, I put the student email address.  

One cool feature of this import function was that it automatically got rid of duplicate email addresses.  (We had a few hundred of these because I generated the csv file from the College advising list which lists double majors twice.)

If anyone wants to do something similar, I would be happy to share my (very limited) wisdom on this operation.

Best,

Thomas Scanlan, Ph D.
Associate Dean
College of Arts and Sciences
Ohio University