Saving the Data

  1. Next, you need to save the data in two formats. This first save will be File/Save As

    2. Image depicting the file menu in OMR

    and will bring up this window:

    Image depicting the save file as requester

  2. Navigate to the appropriate file location, which is the same as the file name that you copied earlier. As soon as you have navigated there, go to the filename input, and right-click with your mouse. You should see a menu as shown below…

    3. Image depicting pasting the file name into the save as requester

  3. After you select Paste from the menu, the ‘Save Data’ window should appear as below

    4. Image depicting the save as requester ready to save an OMR format file

    The reason for saving data in the native format is in case we need to go back to the base data format to re-export a file that got messed up for whatever reason. Redundancy is a beautiful thing, and any good, fault tolerant system has it built in.

  4. Next, go to File/Save As again, and this time, choose a different file type in the ‘Save as type:’ drop down box at the bottom of the ‘Save Data’ window. Note in the graphic below, that we are are going to choose the Excel 97/2000 format. Note the red box on the scroll bar of the drop down list… if after you drop down the list, and click in the red box zone twice, it will put the ‘Excel 97/2000 (*.XLS)’ choice right at the bottom of the list ready for you to click on it to choose it.

    5. Image depicting the save as requester in excel format

  5. Once you click on it, it will cause a change in the ‘Save Data’ window, adding a third entry region so that you can enter a worksheet name (note that this software uses the term ‘Table Name’). In this case, we want the file name and the worksheet name to be identical with one exception. The worksheet name needs to be preceded by the underscore character… ‘_’. This is because if we don’t explicitly put it there, the software will put it there anyway, so lets just account for it. As such, all following scripts that operate in the analysis will expect it as well.

    6. Image depicting the save as excel requester ready to take the file name

  6. Right click in the file name, and paste in the name again, and then left click in the Table name and press the _ key, then right click in it and paste the name yet again. By pasting, we avoid any spelling errors. Once the entries are completed correctly, you should see a screen similar to that below…

    7. Image depicting the save as excel requester ready to save

  7. At this point, the export to excel is completed. That completes the initial course scan process for a single course. The good news is that you get to do this about 100 more times, or for every single course taught and evaluated this semester. Enjoy!