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