The Office of the University Registrar (OUR) provides scanning services for the post-processing of data sheets. The service is limited to Cornell faculty and teaching staff who require scanning for course-related materials only (i.e. exams and course evaluations).
Only raw data files are returned to clients. Clients are responsible for their own post-processing and printing of data results.
Email your request for scanning to email@example.com and include the following information: course department and course number, contact information, professor of the course, and approximate drop-off and pick-up date.
- Please take the time to arrange the bubble sheets in the same direction. You may notice that some sheets have a tapered cut in the upper right corner to facilitate this process.
- Use the blue answer sheets (Form 4521) when giving an exam that has five or less possible answers for each question. If your exam has more than five possible answers for each question, then you should use the green answer sheet (Form 6703).
- Complete and submit the online Opscan Request Form.
- Deliver forms to the Office of the University Registrar, B07 Day Hall.
If you have problems submitting the Opscan form, send an email to firstname.lastname@example.org.
Forms are available at the Cornell Store or can be ordered directly from NCS.
All Opscan processing will be ready within five to seven business days. The Office of the University Registrar will make every effort to return your final exam requests within 24 hours to support compliance with the faculty legislative recommendation that final grades be submitted within 72 hours of the exam. To be eligible for this expedited service you must schedule your request no later than the last day of classes.
Other Scanning Sources
The following companies provide a comprehensive scanning and post-process service:
Survey Intelligence Research Services
Contact: Betty Liu
NCS Regional Processing Center (RPC)
Contact: Tony Tossona
(800) 735-2566 ext. 1388
In order to process raw data from test/survey results, you need to pass the data through one of two methods:
- Excel or another spreadsheet program. Using spreadsheets requires importing the data to a spreadsheet file, then creating equations and/or functions that process the data.
- SAS (a statistical software package). Using SAS requires having the SAS software either on a desktop machine, or using it through an Instruct/Research account. It is also necessary to use a program specifically written to process the data. We have already created a number of SAS programs which will process the majority of raw data files/formats used by Opscan customers.
Cornell has a site license for SAS software which is handled by CU Software Licensing Services at CIT. Please visit the software licensing website for more information (pricing, system requirements, order form, etc.).
A number of SAS programs are already available for public use and can be used with the desktop version of SAS.
Any Cornell academic user can register for an Instruct account in order to use SAS. To request an account on the Instruct server, contact the Academic Technology Center's support staff at email@example.com.
You can use a Research account if you have research-oriented tasks. For more information and the form for requesting a Research account, go to: www.cit.cornell.edu.
Using SAS on Instruct and Research:
In general, once you login to your Instruct/Research account to run an SAS program, type SAS followed by the program name. For example: sas stdeval (where "stdeval.sas" is the name of the SAS program).
Uploading SAS programs and data to your Instruct/Research account:
To upload an SAS program or data file you must use FTP. Use FTP to connect to your Instruct (instruct1.cit.cornell.edu) or Research (rsrch1.cit.cornell.edu) account with your NetID and password. You will then upload your program from your computer to your directory space on your account (transfer the program in ASCII [text] mode).
CISER consultants can help SAS users with data access, data manipulation, program logic, program syntax, and de-bugging, as well as database conversions and file transfers across computing platforms. More information is available at the CISER website.
At the present time, the Office of the University Registrar does not create customized, printed forms (bubble-sheets). However, you may contact National Computing Systems (NCS) at 1-800-735-2566. Ask to speak with the Cornell representative about creating forms.
Additional questions regarding the Opscan scanning service may be directed to firstname.lastname@example.org.