Item analysis: Field descriptions

student_username

The student's username; if there is no username, this field is blank.

student_unique_user_id

The student's unique Schoology user ID.

student_first_name

The student's first name.

student_last_name

The student's last name.

assessment_name

Assessment title.

assessment_major_version

The version of the assessment that this student took for the submission.

submission_date

The date and time the student submitted the assessment.

submission_id

Schoology's ID for the submission.

course_name

Course name of section in which the assessment was taken.

course_code

Course code of section in which the assessment was taken.

section_name

Name of the section in which the assessment was taken.

section_code

Section code of the of section in which the assessment was taken.

section_name

Name of the section in which the assessment was taken.

section_code

Section code of the of section in which the assessment was taken.

section_school_code

Section school code of the of section in which the assessment was taken.

school_name

Building in which the assessment was taken.

section_administrator

Names of the section instructors.

section_administrator_unique_ids

Unique user IDs of the section instructors.

question_id

The ID used to identify the question; this value is included in all four reports.

question_version_id

The ID used to identify the version of the question; this value is included in all four reports.

Every time a member of your AMP team edits a question in an assessment, Schoology saves the update as a new version and keeps all previous versions. As a result, one question in AMP may have multiple distinct versions. Each of these will have the same question_id, but distinct question_version_id values.

points

The number of points the student received on the question.

max_points

The number of points available on the question.

attempted

True or false is displayed in this field:

• True indicates the student answered the question in the assessment.

• False indicates provided no response.

question_id

ID used to identify the question; this value is included in all four reports.

question_version_id

ID used to identify the version of the question; this value is included in all four reports.

question_type

Type of question.

question_text

Text of the question, with HTML removed; question text is truncated at 256 characters.

Math equations built using the math editor display in LaTeX format in the question_text field.

learning_objectives

Titles of all aligned learning objectives; if multiple objectives are aligned to a question, they are separated by commas.

average_score

Expressed as a ratio of the sum of student’s points and max points; rounded to two digits after the decimal.

standard_deviation

Standard deviation of points or max points expressed as a ratio and rounded to two digits after the decimal.

p-value

Ratio of students who provided the correct answer to total students who received the question in the assessment; p-value will not account for partial credit, so students must receive full credit on the question to count toward this metric.

students_assessed

Total number of students whose submission contained the question, including omissions.

omits

Number of students who did not attempt the question.

rpb

Point biserial correlation coefficient of each assessment item.

• Items with a point biserial correlation below 0.1 should be reviewed.

• Questions with a maximum point value of zero are not included in this report.

question_id

ID used to identify the question; this same value is included in all four reports.

question_version_id

ID used to identify the version of the question; this value is included in all four reports.

response_value

One possible answer for the question.

response_text

Text included in the response area for the question; for true or false questions, both the value and the text can be the same.

student_response_count

Displays the number of students whose response included the answer.

• If a student gives multiple answers, all count for that individual student. For example, if a student answers both A and B for a question, both display on their own rows in the report.

• For this reason, the number of response counts on all answers can exceed the number of students who took the assessment.

submission_id

ID used to identify the student submission.

question_id

ID used to identify the version of the question; this value is included in all four reports.

question_version_id

Student's unique Schoology user ID; if there is no unique user ID, this field is blank. This value is included in all four reports.

response_value

Student's selected answer for the question.