Garr,
Here is a rough copy of the data output created from
Scanbook, the program used to read scantron forms and create a
simple text file. Each line of text represents a single scantron
form. Therefore, all responses in column 1 relate to question
1, column 2 to questions 2, etc. The application needs to be
able t o do the following -
In the example data below, questions 1-10 and 13-16 were marked but not questions 11 and 12. Questions 11 and 12 are not currently used but may be in the future at the discretion of the school or faculty.
AAAAAAAAAA AAAA BBBBBBBBBB DDDD CCCCCCCCCC GGGG DDDDDDDDDD IIII EEEEEEEEEE ADGI FFFFFFFFFF ADGI GGGGGGGGGG ADGI HHHHHHHHHH ADGI IIIIIIIIII ADGI JJJJJJJJJJ ADGI KKKKKKKKKK ADGIThe information needs to be converted from alphanumeric values to numeric values. The average and standard deviation need to be calculated for each question.
The following information shows the rating values
on the scantron (Form), the value recorded by scanbook (Data),
and the appropriate numeric value (Value)
Questions 1-12
Form Data Value A A 4.0 A- B 3.7 B+ C 3.3 B D 3.0 B- E 2.7 C+ F 2.3 C G 2.0 C- H 1.7 D I 1.0 F J 0.0 NA K value not calculatedQuestions 13
Form Data Value A A 4.0 B D 3.0 C G 2.0 D I 1.0 F J 0.0 NA K value not calculatedQuestion 14
Form Data Value
A lot A 4.0
Some D 3.0
A little G 2.0
Not discernable I 1.0
Questions 15-16
Form Data Value Very A 4.0 Adequately D 3.0 Somewhat G 2.0 Not at All I 1.0
Instructor
Course Title
Quarter Year