Placement Test Results File

Downloaded placement test results are saved as a comma-separated text file with a header row identifying the data columns.

This file format can be opened in any spreadsheet application to be viewed as tabular data.

Each student take is represented as a row in the file, so students who have retaken the placement test are listed more than once.

Student identification data are provided by the learning management system (LMS).

Data Columns

Column Description
StudentID Student ID.
First Name Student's given name.
Last Name Student's family name.
Email Student's email address.
Score Number of questions answered correctly.
Total Questions Number of questions on the test.
Start Time When the student began the test.
Submission Time When the student ended the test.
Total Time The duration—specified as hours:minutes:seconds—between the Start Time and Submission Time.
1,2,3... Score for each question on the test.

Times are reported in the time zone set for your school.

Example File

StudentID,First Name,Last Name,Email,Score,Total Questions,Start Time,Submission Time,Total Time,1,2,3,4,5
250708,Daniel,White,dmwhite@example.org,1,5,3/11/2016 18:25:53 EDT,3/11/2016 18:26:30 EDT,0:00:36,0,1,0,0,0
306586,Patricia,Garcia,pgarcia@example.org,1,5,1/13/2016 19:49:11 EDT,2/18/2016 4:30:03 EDT,848:40:52,0,1,0,0,0
306586,Patricia,Garcia,pgarcia@example.org,4,5,1/12/2016 3:34:28 EDT,1/12/2016 3:35:58 EDT,0:01:29,1,1,1,1,0
250708,Daniel,White,dmwhite@example.org,3,5,1/11/2016 15:09:03 EDT,1/11/2016 15:20:00 EDT,0:10:57,1,1,0,1,0
242052,Mary,Allen,mrallen@example.org,5,5,12/10/2015 2:43:14 EDT,12/10/2015 4:13:14 EDT,1:30:00,1,1,1,1,1
340067,John,Rodriguez,jrod@example.org,3,5,12/10/2015 1:10:25 EDT,12/10/2015 1:14:54 EDT,0:04:29,1,0,1,1,0
326098,Betty,Nguyen,nguyenb@example.org,1.5,5,12/2/2015 14:54:19 EDT,12/2/2015 14:54:56 EDT,0:00:37,0,0,0.5,1,0