Breadcrumbs

Program Assessment Results by Student

This data set easily exports a complete summary of Program Assessment results for each student. The information is neatly organized in CSV format, and each student's entry in this report is labeled with their University ID, along with any other student attributes that may be provided from the Institution's Student Information System Import File. To view the assessment results via this data set, the data set must be created based on the owner Department and College of the course section assigned to the assessment.

Field

Details

*Export file fields are listed in alphabetical order

college_administrative

  • 0 - Not an Administrative Division

  • 1 - Administrative Division

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.

course_campus

Campus 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_campus_code

Campus 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_catalog_no

Course Number

course_code

Subject Code + Course Number

course_description

Description provided from the Student Information System from the nightly course data file or manually created with a Co-Curricular Activity

course_id

ID automatically generated when the Course is imported or when a Co-Curricular Activity is created

course_instructional_method

Full name for the instructional method provided via nightly course section data file from campus Student Information System. If the field is blank then it is not being provided.

course_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.

course_learning_objective_code

Code is automatically created for each course learning outcome.

course_learning_objective_description

Full description of the course learning outcome.

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_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

  • 0 - the row is a Co-Curricular Section

  • 1 - the row is a Course Section

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_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_session_description

Session 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_subject_code

Course Subject Code

course_version_uuid

ID created with every new version of the course through the course revision process and ties together the correct version of the Course with its respective Course Sections

department_administrative

  • 0 - the row is is not an Administrative Unit

  • 1 - the row is an Administrative Unit

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.

expected_level

Proficiency scale level the student should be achieving when assessed

expected_percentage

The expected percentage is associated with the expected level and is the threshold that the student has to active to meet the performance goal.

institution_code

Code or Shortname created during initial setup of your Assessment Platform

institution_id

ID generated during initial setup of your Assessment Platform

institution_name

Official Name of Insitution

mapping_code

Relationship between Outcome Sets and Courses. Eg. Course <> Outcome, Course <> Performance Indicator, CLO <> Outcome, CLO <> Performance Indicator

program_id

ID created when a new program is imported via the initial program import during implementation or manually created via the the platform’s UI

program_name

Name created by the institution

program_rubric_id

ID automatically create for each programs proficiency scale

program_rubric_level

Proficiency Scale Level

program_rubric_name

Proficiency Scale Level Name

rubric_level

Rubric level is the proficiency scale level the student achieved.

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_email

Student Email provided via nightly student data file from campus Student Information System or manually via the platform’s UI.

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_first_name

Student First Name provided via nightly student data file from campus Student Information System or manually via the platform’s UI.

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_last_name

Student Last Name provided via nightly student data file from campus Student Information System or manually via the platform’s UI.

student_majors

Student Major provided via nightly student degrees data file from campus Student Information System.

  • If all fields are blank then it is not being provided.

  • If the student has more than one major, each major will be comma-separated.

student_outcome_code

Code created for each outcome: Institution, College, Department, External, or Program Outcomes

student_outcome_description

Full description for each outcome: Institution, College, Department, External or Program Outcomes

student_outcome_name

Name created for each outcome: Institution, College, Department, External, or Program Outcomes

student_university_id

Student University ID provided via nightly student data file from campus Student Information System or manually via the platform’s UI.

student_user_id

Student Username provided via nightly student data file from campus Student Information System or manually via the platform’s UI.

success

  • 0 - the student did not meet the expected percentage/expected level.

  • 1 - the student did meet the expected percentage/expected level.

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

📙 Additional Resources

Data Sets