Assessment reports: Exporting student results by item (AMP)

After you create and distribute Managed Assessments, you can evaluate student performance with several types of reports:

Item-level results
Overall results
Mastery results
Auto-export aged assessment reports

Reports are available for current, inactive, and archived courses and sections.

Export an item analysis report

The Item Analysis Report shows results by individual question. It helps you evaluate learning trends, compare results across question types, and identify students who may need additional support.

Select AMP and choose Assessment Reports.
Locate and select the managed assessment.
From the Assessment Summary, click View Item Performance.
Click Export Report.
Select the Managed Assessment and Report Type to export.
- Choose Single Reports to export a ZIP file containing four CSV spreadsheets:
  - The item_results_by_student.csv file contains information on student performance by questions in the assessment. There is a row for every combination of student and question from the assessment. For example, if 10 students each responded to 10 questions in an assessment, there would be 100 rows in the file; one each for every question answered by each student.
  - The assessment_questions.csv file contains additional information about the questions themselves, including average score, p-value, standard deviation of score, total number of students assessed on the question, number of omits, and point biserial correlation on each question.
  - The assessment_answers.csv file contains the text of all multiple choice and true/false questions and possible answers in the assessment, including the frequency/count of students response on each multiple choice answer. There is a row for every combination of multiple choice and true/false question and possible answer choice from the assessment. For example, if there are 20 total multiple choice and true/false questions, and each of them have 5 possible answers, there would be 100 rows in the file: one each for every question answer combination.
  - The assessment_student_responses.csv file contains student answers for all multiple choice and true/false questions in the assessment. If the student gave multiple responses (answered both A and C on a single question, for example), there are multiple rows for that question.
- Choose Merged Report to export a CSV spreadsheet with all columns included in the four spreadsheets listed above.
Select the schools to include and click Next.
Select the sections and instructors to include and click Next.
Confirm your selections and click Export Report. This sends an email to the email address with which your Schoology account is associated. The email includes a link that directs you back into Schoology. From there, Schoology automatically initiates a download of the CSV report to your device. If you selected Single Reports, you'll need to unzip the file on your computer to review the multiple CSV files.

You can also export Item Analysis Reports from the Overall or Mastery results table.

Item analysis report information

Performance by student and question report field descriptions

Field	Description
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.

Additional assessment question information report field descriptions

Field	Description
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.

Multiple choice and true or false answer text report field descriptions

Field	Description
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.

Multiple choice and true or false student answer report field descriptions

Field	Description
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.

The merged item analysis report contains the data from all four CSV files.