.png){kind=small}
Scoring Spreadsheets
The Scoring spreadsheet is where the raw data captured from the paper form via the BubbleScan OMR software is processed and graded.
We provide a separate scoring spreadsheet for SAT, ACT, PSAT and SubjectSAT.
The Scoring spreadsheets require Excel 2010 or newer to run. We utilize Excel Macros to handle the data processing and reporting as evidenced by the spreadsheets' extension '.xlsm' . It is quite common for Excel to post warning messages when opening macro-enabled spreadsheets. You should always answer these messages in the affirmative (i.e. 'enable') to ensure proper functioning.
.png)
Pitfall:
Customer who receive the Scoring spreadsheet via email at times open it directly from their email program and then save the opened spreadsheet to their computer's hard drive. This works if you remember to 'enable' in response to any messages that might be coming up, but causes havoc if you don't.
Recommendation:
Save/download the spreadsheet to your hard drive first and then open it. This ensures the downloaded copy will work properly.
We recommend placing the Scoring spreadsheet in a new folder with separate sub-folders for your answer keys, names lists, stored images, etc - rather than your PC's desktop.
Each spreadsheet scores student exams that use the same answer key. You can customize, export and re-import answer keys, but at any time the spreadsheet can only score exams that use the same answer key.
The spreadsheets generate detailed individual student reports.
The Scoring spreadsheet consists of several worksheets (tabs at the bottom of the screen). Clicking on any of these tabs only displays the underlying worksheet. It is completely safe as it does not execute any macro code and therefore does not change or 'hurt' anything.
Grey tabs are for worksheets that are used as temporary helper worksheets by the spreadsheet. As an end-user you should not modify these worksheets.
.png){kind=small}
Yellow tabs are the configuration worksheets. Configuration of these worksheet is explained in greater detail later.
.png){kind=small}
The blue tab is the Records worksheet. Here data from each scanned page is deposited and displayed.
.png){kind=small}
The red(-ish) tabs are the report worksheets. We quite often customize the summary reports for our customers. Let us know if you have unique requirements.
.png){kind=small}