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.
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:
SURVEY or TEST Answers or TEST ScoresSame as the "RUN TYPE" value on the original report
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:
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.