.png)
Scanning into Excel
To process a batch of practice SAT / ACT / PSAT / SubjSAT exams:
1.Start the BubbleScan OMR software.
2.Make sure the software is set to 44 Column Mode and we generally recommend Interactive Mode.
3.Open the Project and select the SAT, ACT, PSAT, or SubjSAT Scoring Spreadsheet.
It is important that the spreadsheet is opened from within the the BubbleScan OMR software.
4.If you need to make any changes to the spreadsheet (such as clearing out old data using the red CLEAR RECORDS button) this is the time to do it.
Select the Scan Source
5.Click Start Scanning to specify the folder where the scanned images are stored.
6.Review the data, load/modify the answer key, scale or names.
7.Generate the reports.
When the BubbleScan OMR Software processes a scanned image it extracts the bubbled-in data and temporarily stores this data in an internal database.
This process is called 'reading'. A counter for the number of forms 'read' is displayed in the BubbleScan OMR window.
2. 44 Column Mode & Interative Mode
By default BubbleScan OMR operates in Database Mode, where it stores all read data in its internal database and requires you to click 'Write DB to Excel' to write the data into the Excel spreadsheet. This is faster and the preferred method for most applications, particularly higher volume applications.
However, for processing practice SAT/ACT/PSAT/SubjSAT exams, the Interactive Mode is probably a better choice. Here, BubbleScan OMR automatically writes every processed form into the spreadsheet. This is more convenient and given low volumes of several dozen or so forms it might actually be faster than Database Mode. We recommend you change BubbleScan OMR to Interactive Mode.
3. Open the Project (i.e. the the Scoring Spreadsheet)
If you did not open the Scoring spreadsheet through the BubbleScan OMR software, then save your spreadsheet and exit Excel.
In order for the BubbleScan OMR software to interact with the Scoring spreadsheet, the spreadsheet must be opened from within the OMR software.
Start the BubbleScan OMR software, click on Open Project then select the desired Scoring spreadsheet. After the initial use, BubbleScan OMR adds the most recent spreadsheet to a 'recent' list.
.png)
Make sure the software found and selected your scanner by clicking on the 'Select a TWAIN Source' button.
.png)
.png)
Usually, scanners are installed with TWAIN and WIA drivers. You must select the TWAIN version, which unfortunately doesn't say TWAIN (usually), but can be identified because it is the one that doesn't say WIA.
----------------------------------------------------------------------------------------
This would also be the perfect time to clear out any old records - before new records get added to the spreadsheet.
Click on the button labeled 'Clear Records'. Then click Yes to confirm that you really do want to delete all records.
.png)
.png)
Click on Start Scanning. We recommend to uncheck 'Show Scan Screen'. It's completely optional, but eliminates one additional scan screen & button you need to push later.
.png)
If this is the first time you clicked Start Scanning during this session, the BubbleScan OMR software will prompt you for the image folder.
If you are scanning indirectly (i.e. you are scanning using the scanner manufacturer's software separate and outside of our OMR software) then you should browse to the directory where all the images are stored.
If you are scanning directly through our software, then either select an existing image directory or create a new one using the 'Create new Folder' icon in the top right hand corner.
Make sure to properly select the image folder so that the full path shows up in the Selected Path: field at the bottom of the window.
.png)
If you are scanning indirectly, select FOLDER. After you click OK, the BubbleScan OMR software is now actively monitoring the previously selected folder. Any new images (TIF or PDF) in the target folder will be processed and data written into the Excel spreadsheet (assuming you are running in INTERACTIVE MODE).
If you are scanning directly, select SCANNER. After you click OK, you will see the scanner manufacturer's scanning interface (see below).
.png)
In the example below we are using an Epson GT-S50.
.png)
Notice, that we are scanning Single-Sided, Letter, Black & White, 200dpi. We've selected Text Enhancement, which brings out marks a little more and Correct Document Skew, which helps if the forms go through the scanner a little crooked. We have not selected Remove Punch Holes. Avoid this setting!
Click Scan one more time and proceed to scan all your forms. The window will automatically close when all forms are scanned.
Notice that the counters in the BubbleScan OMR window will update as you scan and as the software processes (reads) images and writes them into Excel.
.png)
If you are running BubbleScan OMR in Interactive Mode, each page will be written into Excel as soon as it is read. Make sure not to edit any cells in Excel during this process.
If you are running in Database Mode, wait until all scanned forms are read (i.e. Scanned counter and Read counter are the same) then click on Write DB to Excel. Make sure not to write before all scanned forms are read!
The Scoring spreadsheet collects data into the Records worksheet.
.png){kind=small}
Each processed page will show up as a new line added to the Records worksheet
.png)