This data set exports a complete summary of Student Course Evaluation results for each Student. The information is organized in CSV format, and to safeguard anonymity, the export will display a hashed user ID rather than a Student's university ID.
|
Column |
Details |
|---|---|
|
*Export file fields are listed in alphabetical order |
|
|
academic_year_code |
Second year of the academic year. For example, it will display 2024 for AY 2023/2024. |
|
campus_code |
Campus Code provided from the Student Information System from the nightly course data file. |
|
campus_description |
Campus Description provided from the Student Information System from the nightly course data file. |
|
clo_id |
ID for each CLO created in the platform |
|
college_code |
Code provided from Student Information System through nightly courses data files or when an Administrative Division is created via the platform’s UI. |
|
college_id |
ID automatically generated when the College or Administrative Division is created |
|
college_name |
Name provided from Student Information System through nightly courses data files or when an Administrative Division is created via the platform’s UI. |
|
comment |
Comments added to question responses. |
|
course_code |
Subject Code + Course Number |
|
course_id |
ID automatically generated when the Course is imported or when a Co-Curricular Activity is created |
|
course_name |
Course Name provided from the Student Information System from the nightly course data file or manually created in a Co-Curricular Activity |
|
course_registration_no |
Course Number |
|
course_schedule_code |
Schedule Code provided via nightly course section data file from campus Student Information System. If the field is blank then it is not being provided. |
|
course_schedule_description |
Schedule Description provided via nightly course section data file from campus Student Information System. If the field is blank then it is not being provided. |
|
course_section_code |
Course Section Subject Code |
|
course_section_id |
ID created when each course section is imported via the nightly course section data files or when a co-curricular section is created via the UI or nightly co-curricular section data file. |
|
course_section_name |
Name provided via the nightly course section data files or when a co-curricular section is created via the UI or nightly co-curricular section data file. |
|
course_section_no |
Course Section Number |
|
course_session |
Full Session name provided via nightly course section data file from campus Student Information System. If the field is blank then it is not being provided. |
|
course_session_code |
Schedule Code provided via nightly course section data file from campus Student Information System. If the field is blank then it is not being provided. |
|
course_subject_code |
Course Subject Code |
|
department_code |
Code provided from Student Information System through nightly courses data files or when an Administrative Unit is created via the platform’s UI. |
|
department_id |
ID automatically generated when the Department or Administrative Unit is created |
|
department_name |
Name provided from Student Information System through nightly courses data files or when an Administrative Unit is created via the platform’s UI. |
|
evaluated_instructor_email |
Instructor evaluated email address for either Instructor Multi-Choice or Instructor Text/Memo question types |
|
evaluated_instructor_first_name |
Instructor evaluated first name for either Instructor Multi-Choice or Instructor Text/Memo question types |
|
evaluated_instructor_last_name |
Instructor evaluated last name for either Instructor Multi-Choice or Instructor Text/Memo question types |
|
evaluated_instructor_role |
Displays one of the following, depending on the role that the user has in a section:
|
|
evaluated_instructor_university_id |
Instructor evaluated university ID for either Instructor Multi-Choice or Instructor Text/Memo question types |
|
evaluated_instructor_user_id |
Instructor evaluated user id for either Instructor Multi-Choice or Instructor Text/Memo question types. User ID is automatically generated either from Student Information System nightly data files or when the user is manually created in the platform. |
|
evaluated_instructor_username |
Instructor evaluated username for either Instructor Multi-Choice or Instructor Text/Memo question types. |
|
evaluation_criteria |
Designated whether the CLO Placeholder question was asked from the perspective of before and/or after taking the course section. |
|
evaluation_objective |
Full description of the course learning outcome |
|
evaluation_objective_label |
ID of the course learning outcome |
|
hashed_student_user_id |
Created for each submitted survey form. Allows linking of user data for reporting purporses. |
|
hierarchical_level |
Displays the type of business object the question is tied to (Survey Template, Institution, College/Administrative Division, Department/Administrative Unit, Course/Co-Curricular Activity, Course/Co-Curricular Section) |
|
hierarchical_level_object |
Displays the business object name that the question is tied to; an example would be “Arts and Sciences” for a College-aligned question in that college. |
|
institution_id |
ID generated during initial setup of your Assessment Platform |
|
institution_name |
Official Name of Insitution |
|
instructional_method_code |
Instructional Method Code provided via nightly course section data file from campus Student Information System. If the field is blank then it is not being provided. |
|
instructional_method_description |
Instructional Method Description provided via nightly course section data file from campus Student Information System. If the field is blank then it is not being provided. |
|
instructor_list |
List of instructors for the course section received via the nightly course section data file from campus Student Information System. |
|
instructor_only |
Displays T/F for true/false depending on if the question (row) is an instructor-only question. |
|
is_metric |
Question has been identified as a part of a metric. |
|
is_no_response_option |
Question has a no response/not applicable option |
|
is_required |
Displays T/F for true/false depending on if the question (row) is configured as required. |
|
metric_name |
Name identified for the metric created within the survey template |
|
metric_success_value |
Metric success threshold |
|
parent_course_section_id |
Unique identifier ID if the section is merged (cross-listed) with another |
|
partial_term_code |
Displays the code for the partial term, if applicable. |
|
question_description |
Full text of question |
|
question_id |
ID created for each question created |
|
question_option_id |
Question option ID created for each question response |
|
question_option_value |
Value tied to each multiple choice single answer, multiple choice multi choice and true/false question types. |
|
question_order |
Displays the sort order for a question (i.e., if a question is 3rd in the survey form students complete, a value of “3” will be displayed) |
|
question_type_code |
Short code for each question type |
|
question_type_id |
ID for each question type available in the platform |
|
question_type_name |
Full name for each question type |
|
question_response |
Response text for multiple choice single answer, multiple choice multi-answer and true/false question types. |
|
question_response_value |
Value tied to each multiple choice single answer, multiple choice multi choice and true/false question types. If this display different than the question_option_value, the survey template is set up then with ascending value instead of descending values. |
|
section_enrollment |
Number of students enrolled in the course section. If the course section is cross-listed or merged in Canvas it will include the enrollment of all sections |
|
survey_instance_form_id |
ID generated for each survey form created |
|
survey_instance_id |
ID created for each survey instance |
|
schedule_name |
Name created for each survey schedule by the survey administrator |
|
student_class_level |
Student Class Level provided via nightly student data file from campus Student Information System. If all fields are blank then it is not being provided. |
|
student_degree_code |
Student Degree Code provided via nightly student degrees data file from campus Student Information System. |
|
student_degree_name |
Student Degree Name provided via nightly student degrees data file from campus Student Information System. |
|
student_emphasis_code |
Emphasis Code (Concentration/Track) provided via nightly student degrees data file from campus Student Information System. |
|
student_emphasis_description |
Emphasis Description (Concentration/Track) provided via nightly student degrees data file from campus Student Information System. |
|
student_ethnicity |
Student Ethnicity provided via nightly student data file from campus Student Information System. If all fields are blank then it is not being provided. |
|
student_gender |
Student Gender provided via nightly student data file from campus Student Information System. If all fields are blank then it is not being provided. |
|
student_major_codes |
Major Code provided via nightly student degrees data file from campus Student Information System. |
|
student_major_names |
Major Name provided via nightly student degrees data file from campus Student Information System. |
|
survey_schedule_id |
ID generated for the Survey Schedule |
|
survey_template |
Name of Survey Template |
|
survey_template_id |
ID generated for the Survey Template |
|
survey_type_name |
Type of Survey, this will only display Student Course Evaluation all other survey types are not exportable in this Data Set. |
|
term_code |
Official code entered for each term; this matches the same term code provided in the nightly data files. |
|
term_id |
ID created when a term is created in the platform |
|
term_name |
Term name is either manually entered through the the platform’s UI or imported using the Term Template |
|
text_response |
Full text response for a Text/Memo |
📙 Additional Resources