.png){kind=small}
Excel Grading/Scoring/Tabulation Spreadsheets
The Excel spreadsheet is where the raw data captured from the paper form via the BubbleScan OMR software is processed, graded, scored or tabulated.
The spreadsheets are customized to handle one or more unique forms and to generate one or more unique reports.
Generally there is a different spreadsheet for each unique form.
Our 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 Excel spreadsheet in a new folder with separate sub-folders for your answer keys, names lists, stored images, etc - rather than your PC's desktop.
The DEMO spreadsheets will only display and review the captured data. Any code to process data further (i.e. to generate custom reports) has been removed.