MULTIPLE CHOICE EXAM SCANNING BY THE COMPUTER CENTER
(For the official reference see the "PROFESSOR TEST SCORING
MANUAL", available from Helen in the Psych Dept main office;
also from the Bureau of Educational Research and Service,
Gentry Rm. 119, and from the UConn Computer Center.)
(Of course, the official reference pamphlet doesn't include
my SAS program!)
* Bring bubble sheets and #2 pencils to the exam. Tell
students to:
a) bubble in name (top of form) and ID (col A-I)
b) leave column J blank
c) bubble in their exam version number in column K (not
necessary if there's only one version) and section
number in cols L-M (not necessary if there's only one
section)
d) bubble in their answers accurately
(my advice: draw cols J,K,L,M on the board for them with
examples, and write which exam version is white and
which is yellow, etc.; check to make sure they've bubbled in
col K correctly when they turn in the exam; make sure they've
filled in the bubbles and not just printed their ID, exam
version, etc.; later, you'll be glad you did.)
* The instructor submits THREE bubble sheets, which can all
be prepared before the exam:
SHEET ONE - exam information
a) in col J: bubble in "1" (col J says which instructor
sheet it is!)
b) in col K: bubble in number of exam versions
c) in cols A,B,C: bubble in course number
d) in cols D,E: bubble in section number (if multiple
sections, use "00")
e) in the "name" area: bubble in "PSYC", then a space, then
the course title (e.g. "PSYC GENERAL PSYCH")
f) in the "birthdate" area: bubble in the exam date
(optional)
SHEET TWO - the CMS USERID (mainframe address) you want the
scores sent to
a) in col J: bubble in "2"
b) in the "name" area: bubble in "CMS", then a space, then
your userid (e.g. "CMS ABC99001"); to bubble in numbers,
continue down the appropriate columns to the numbers at the
bottom of the page (cols A-I in the "identification number"
area)
SHEET THREE - instructor's answer key(s)
a) in col J: bubble in "3"
b) in col K: bubble in exam number of THIS answer sheet
(for multiple exam versions, submit additional copies of
sheet 3 with appropriate exam number in col K and
correct answers for that version -- but keeping the "3" in
column J for each)
c) in "name" area: bubble in instructor's name
d) in answer section: bubble in correct answers for exam
version identified in col K (up to 200, but only fill in
the number of answers you use, obviously)
* After the exam:
a) face all answer sheets the same way, with instructor
sheets on top
b) put them in a big manilla envelope
c) print on the front of the envelope...
instructor's name
course number
building
extension
U-Box
(...they used to also ask for the number of student
sheets, but they told me they don't care about that
anymore)
d) bring the exams to Room 049 in the Math Science Building
(the computer center), and ask them to rush if you need
it! (...you can get scores for finals sent to your
account within a few hours, but during the semester it's
overnight)
* What you get back:
a) your manilla envelope will be in your mailbox the next
day, with all the original bubble sheets and a bunch of
computer output -- including the exam scores and more
statistics than you could imagine using (which is good)
b) your mainframe account, more importantly, will have a
data file on your reader list, with a bunch of mysterious
letters and numbers for a name and no spaces between any of
the data; each student is represented by 4 lines of data
c) type "RL" to see your reader list; with the cursor next
to the new file (called "J2235S01 OUTPUT PUN A" or something
like that), hit the "PF9" key to receive it to your file list
* Now you have a file full of unspaced data called "J2235S01
OUTPUT A"...
* To copy the SAS program below to your mainframe account:
a) download the following SAS lines (below) to your hard
drive by going to Netscape's FILE menu to save this document
by choosing "SAVE AS..." and then "Format:TEXT"
b) open the new text document with Word or any text editor
so you can cut out all this instructional stuff, i.e.,
everything above "DATA PSYCxxx"; then save the remaining
SAS program as a text file called, say, "FINAL.SAS" or
whatever you like
c) upload that SAS program text file to your mainframe
account using the "rmac" command from a Mac (on the
mainframe, type "RMAC filename filetype filemode" -- whatever
you use as the three part name) or the analogous
PC command (just select "TRANSFER" from the menu, I think) --
call it "FINAL SAS A" for example
d) run it as is if you want to see the output for two
fictitious students included in the program; you can change
the very last line ("VAR...")to include whatever variables
you're interested in seeing; right now it gives the number
correct, percent of total, percentile rank, and z-score
corresponding to that score
e) umm... to run a SAS program, first type "use sascms" to
link to the SAS disc; then just type "SAS filename" (e.g.,
"SAS FINAL"); in your file list, the results will appear in
FINAL LISTING A and any errors will be (somewhat opaquely)
noted in FINAL SASLOG A
* To see your own data:
a) use XEDIT on the mainframe to delete the 8 lines of
fictitious data (but NOT the immediately following semicolon
sitting on its own line!) from the SAS program you uploaded
as "FINAL SAS A"
b) use the up and down commands ("U" and "D"!)to position
the SAS file so that "CARDS;" is on the line right above the
ruler in the middle of the XEDIT screen (and the lone
semicolon is on the line immediately below)
c) on the command line (next to the arrow at the bottom of
the screen) type GET and the name of the file you received
from the computer center (i.e., "GET J2235S01 OUTPUT A"), and
your data will appear inserted into the SAS program between
the line that says "CARDS;" and the line that's just a
semicolon
d) run the SAS program -- and maybe download the resulting
LISTING file as a text file, which you can edit and paste
into your grade sheet
* Here's that SAS program:
- you can change the PSYCxxx to your course number (e.g.
"PSYC132"), but you don't have to
- I forget what I was doing with the comments (e.g.,
/*(5-80)*/) but since they're comments, they contribute
nothing to the program, so they're harmless
- to see answers to individual items, add "ANS1 ANS2..."
etc. to the end of the "VAR..." line; or to see all 50
answers (or however many you had), add "ANS1-ANS50"
("VAR NAME ID TOTAL PERCENT PTILE STDEV ANS1-ANS50;")
DATA PSYCxxx;
INPUT
#1 SER1 1-4 BATCH 5-7 RUN 8 ID $ 9-17 NAME $ 18-37
INSTR $ 38-57 DEPT $ 58-61 COURSE 62-64 SEC 65-66 DATE 67-
72 CMSID $ 73-80
#2 SER2 1-4 WMIF 5 PT1 6-8 PT2 9-11 PT3 12-14 PT4 15-17
TOTAL 18-20 PERCENT 21-23 PTILE 24-25 STDEV 26-30 VERSION
31 (ANS1-ANS49) (1.) /*(32-80)*/
#3 SER3 1-4 (ANS50-ANS125) (1.) /*(5-80)*/
#4 SER4 1-4 (ANS126-ANS200) (1.) /*(5-79)*/ FILL 80
;
CARDS;
00020011999887777SIMPSON HOMER LUNDQUIST PSYC13101051099LUNDQUIS
0002 0190000000000190766700.4714432424241413214223444412
0002
0002
00030011999887777SMITHERS WAYLAND LUNDQUIST PSYC13101051099LUNDQUIS
0003 01700000000001706842-0.3414432422221213214223214312
0003
0003
;
PROC SORT;
BY SEC NAME;
PROC PRINT;
VAR NAME ID TOTAL PERCENT PTILE STDEV;