Course Evaluations & Surveys requires information about courses and users for each Project, and receives this information via a Course and User upload process within the Project functionality.
These upload files are Microsoft Excel formatted files containing the below fields. One row per course and one row per course enrollment.
NOTE
The top row of the file contains a header row with each column name as indicated below, use these exactly as specified below. And, don't include the optional fields in your files unless you choose to use these fields, and if not used, do not include the header for an optional field.
When uploading an Excel or text file (.xlsx or .txt), columns or rows with a text value longer then 255 characters must go to the top of the file and within the first 15 rows, however, the long text string does not need to be in all 15 rows. The first 15 rows of the file defines the column type and size, which is a known feature in Excel.
Course File
These fields are optional and can be omitted from the upload file if not being used. When omitting fields from the file do not include the field name in the Header Row and omit data from contents rows. Date format is MM/DD/YYYY HH:MM.
Title: The course title (Max. 1024 characters).
Code: The course code as displayed to users (Max. 440 characters).
CourseUniqueID: The unique identifier for the course and what is used in the User File to associate users to a course (Max. 440 characters, and this field needs to be unique over time and projects).
SurveyStart: The defined start date for Survey Access for this course.
SurveyEnd: The defined end date for Survey Access for this course.
AdminLevelStart: The defined start date for administrator reporting access to Administrator Reports for this course.
AdminLevelEnd: The defined end date for administrator reporting access to Administrator Reports for this course.
AdminCourseLevelStart: The defined start date for administrator reporting access to Course Reports for this course.
AdminCourseLevelEnd: The defined end date for administrator reporting access to Course Reports for this course.
InstructorCourseLevelStart: The defined start date for instructor reporting access to Course Reports for this course.
InstructorCourseLevelEnd: The defined end date for instructor reporting access to Course Reports for this course.
NodePath: Where course resides in the Account Hierarchy (e.g., mycollege.department.program). This is an optional field, the same result can be achieved by using the Hierarchy Mapper feature to train the system to automate the course - department pairings.
Remove: An optional field, and if included and field value is set to "1" then the specific course would be removed/deleted from the project. If the project was deployed and there are survey responses already submitted in the course, if removed, all survey responses for the course would also be deleted. 1 = Remove.
CrossListUniqueID: An optional field and provides support for cross-listed courses. Where one course is selected as the "parent" course where all survey responses would be available for the parent and all "children" courses, children courses would not display in reporting. To make a course a child course, simply insert the parent's course unique id into this field, which makes the course a child and crosslists with the specified parent.
User File
These fields are optional and can be omitted from the upload file if not being used.
UserTypeID: The code for user type:
Instructor Code = 3
Student Code = 4
Teaching Assistant = 6
CourseUniqueID: The unique identifier for the course and matches up with the Course File to associate users to a course (Max. 440 characters)
FirstName: The user's first name (Max. 128 characters)
LastName: The user's last name (Max. 128 characters)
Email: The user's email address (Max. 256 characters)
Username: The user's Course Evaluations & Surveys username. Note: For LMS/Portal customers, this is also the LMS/Portal Username (Max. 64 characters)
Password: The user's Course Evaluations & Surveys password (Max. 16 characters, Optional field if using LMS or Single Sign On)*
Unenroll: An optional field, and if included and field value is set to "1" then the specific user (student or instructor) would be removed/dropped from the specific course. If the project was deployed and there survey responses already submitted in the course from the student, the unenrolled/dropped student's survey responses for the course would also be deleted. 1 = Remove*
DisableReporting: An optional field, and if included and field value is set to "1" then reporting for the specific instructor for the specific course would be disabled and not available even when the CES Administrator has enabled reporting within the project. 1 = Disable*
DisableCustomQuestion: An optional field for instructor users, and if included and field value is set to "1" then access to the Custom Question functionality for the specific course is disabled (if this feature is turned on for instructors). When this field is blank, Custom Question access for instructors is enabled, but still requires the feature to be turned on within the project settings (Note: the field setting of 0 also enables this setting). 1 = Disable*
OptOut: An optional field, and if included and field value is set to "1" then the user's response will be set to Opted Out for the course and the user will no longer have an active evaluation for the course, but still requires the feature to be turned on within the project properties. 1 = Disable*