SaneTron

A tool to remove the unnecessary formatting from the output of Brock University's Scantron™ system and convert it into a file that can be imported into Excel, SPSS and other modern tools.

Enter Data:

Please copy and paste the contents of the .RPT file you received into this box.

For best results only paste in the part of the report containing the table you want to convert:

Examples of the kind of information this tool can convert

The following are real results with random student numbers
Survey results:
   --------------------------------------------------------------------------
  |  Q  |  A  |  B  |  C  |  D  |  E  |  M  |  I  | Mean 1 | Mean 2 | S.Dev. |
   -----+-----+-----+-----+-----+-----+-----+-----+--------+--------+--------
  |   1 |   0 |   0 |   0 |   0 |   0 |   0 |  10 |  0.00  |  0.00  |  0.00  |
   -----+-----+-----+-----+-----+-----+-----+-----+--------+--------+--------
  |   2 |   2 |   2 |   2 |   2 |   2 |   0 |   0 |  3.00  |  3.00  |  1.41  |
   -----+-----+-----+-----+-----+-----+-----+-----+--------+--------+--------
  |   3 |   2 |   2 |   2 |   2 |   2 |   0 |   0 |  3.00  |  3.00  |  1.41  |
   -----+-----+-----+-----+-----+-----+-----+-----+--------+--------+--------
  |   4 |   2 |   2 |   2 |   2 |   2 |   0 |   0 |  3.00  |  3.00  |  1.41  |
   -----+-----+-----+-----+-----+-----+-----+-----+--------+--------+--------
  |   5 |   2 |   2 |   2 |   2 |   2 |   0 |   0 |  3.00  |  3.00  |  1.41  |
   -----+-----+-----+-----+-----+-----+-----+-----+--------+--------+--------
  |   6 |   2 |   2 |   2 |   2 |   2 |   0 |   0 |  3.00  |  3.00  |  1.41  |


Test responses/answers:
              1     6     11    16    21    26    31    36    41    46 
Student #                                                                     S#
              -----+-----+-----+-----+-----+-----+-----+-----+-----+----- 
9234981      |CEACD|DBC..|D.C.C|E..DE|ACDBB|DBD.E|CAD.C|A.A.C|     |     |  0001
( 10.0)       +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
9435653      |.A...|..C..|..EBA|ED.C.|A.C.B|.BC..|EE..D|CAA..|     |     |  0002
( 21.0)       +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
9932432      |EEAE.|..C..|D...C|EC..E|.EC.E|...DD|...AC|..B..|     |     |  0003
( 22.0)       +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
9234238      |BE...|..C..|.....|E...B|..C.A|.B.B.|.....|..B..|     |     |  0004

Test scores (but results are still parallel):

  Student #   Grade/ 40   % Grade            Student #   Grade/ 40   % Grade
 
   2345233      20.00       50.0              9654321      16.00       40.0
   9134548      25.00       62.5              9654327      25.00       62.5
   9748672      19.00       47.5              9631432      21.00       52.5
   9233971      25.00       62.5              9654320      13.00       32.5
   9485195      21.00       52.5              9654326      16.00       40.0
   9912344      16.00       40.0              9654321      12.00       30.0
   9912345      14.00       35.0              9654327       5.00       12.5

This website also accepts full survey or test score reports.

Examples:

  1. Survey .RPT file
  2. Exam .RPT file

Please respect the privacy of student information.

This web site and the information you submit to it, and the information it in-turn sends to you, is secure. No record of any information submitted to this web site is stored.

Please send feedback about this tool to Matt Clare in the CTLET. Please send feedback about Brock University's Scantron™ system to ITS.