Grading Documentation

Contents of this page

Updating Scantron Files

Scanning Scantrons

Installing & Setting up GMP 3.0

Grading Steps

Using GMP 3.0 to Create Summary Reports

Uploading Graded Data into Salesforce

GMP 3.0 Troubleshooting


 

Installing ScanTools

ScanTools is the software that allows the scanning machine to take an image of a scantron, create a file, and send it to our grading software (GMP 3.0) for grading. Upon hire, all new PMs (and any other staff that grade scantrons) should have a version of ScanTools already installed on their computer. If not, you will need to install the software using the ScanTools disk located in each region.  Follow up with your regional Office Manager, Programs Assistant, Operations Assistant, Programs Associate, or Programs Data Manager as to where the disk is located.

Once you have the disk, install and configure the software using the installation wizard.

Updating ScanTools Files for rSAT

Links for updating ScanTools for rSAT

Click here to access the folder with all of the ScanTools files for rSAT. Download all of the files in the folder (there are 5), including the two images (.tif files).

Installing the new ScanTools files

First, check the version of ScanTools on your computer. You can do this by clicking through on the help pull-down menu to find the “About” option.

1 Pull down - About

 

1 Software about

Follow the instructions below for the appropriate version of ScanTools.

For ScanTools v7.0 and Before

Move the files you downloaded in the first step as follows:

  • The default location to copy your .sds and tif files is C:\Program Files\Pearson NCS\ScanTools Plus\Applications
  • The default location to copy your profiles is C:\Program Files\Pearson NCS\ScanTools Plus\Profiles

For ScanTools 7.1 – 7.2

Move the files you downloaded in the first step as follows:

  • The default location to copy your .sds and tif files is C:\Program Files\Scantron\ScanTools Plus\Applications

4 Scantools

  • The default location to copy your profiles is C:\Program Files\Scantron\ScanToolsPlus\Profiles

For ScanTools Plus 8.0

Move the files you downloaded in the first step as follows:

  • The default location to copy your application file (.sds and .tif) is  C:\Scanner\ScanTools Plus\Applications
  • The default location to copy your optional profiles(.$cp and .$ep) is C:\Scanner\ScanTools Plus\Profiles

Updating to the “561 – Diagnostic Test Answer Sheet” Application

Depending on which disk is used to install the software (different regions may have older versions of the disk), you may need to configure the settings for the application and profile drop down menus in ScanTools.

1.On ScanTools, click Configure (top right hand corner).

2. Click Install Application.

3. Under Directories, click Applications.

4. Select the following three files and click okay.

  1. On ScanTools, click Configure.
  1. Select Install Applications.
  1. Under Directories, click Profiles.
  1. Click on the (2) files pictured below.
  1. Click okay.

Check the Applications drop down to ensure the 561 application shows up on the drop down menu.  The Profile and Conversion File drop downs should also contain a 561 option.

You are now ready to scan or install GMP 3.0 if you have not already done so.

Scanning Scantrons: Instructions for Scanning Scantrons using ScanTools

Scanning Scantrons

Pre-Scanning

You should have a stack of scantrons for one school site and one test version. If you have multiple sites and/or multiple test versions to grade, separate the scantrons by school site and test version.

1. On the front page of the scantron booklet, there are fields for student names, ID numbers, test ID number, and test date.

a. Most importantly: check to make sure that all of these are bubbled in correctly. Check student ID to make sure they it is a 6-digit CollegeSpring IDs. If it is not  (or are blank), you will need to go to Salesforce to find that students’ ID and fill it in with a number 2 pencil.

b. Make sure that the scantron has the correct test ID number bubbled in. If not, correct those that are incorrect using a number 2 pencil.

c. Finally, check to see if the test date is accurate and not, for instance, the student’s birthdate. If it is incorrect, change it using a number 2 pencil.

2. Check each scantron for stray pencil marks in places other than the bubbles. If there are any, erase them. This can cause problems with the scanning process.

3. Repeat this for the entire stack of scantrons for one site and one test.

Scanning

  1. Plug in the scantron machine and connect it to your computer via the usb cord.
  2. Turn on the scantron machine (button is in the back of the machine) and wait for a green “1” to appear.
  3. Put scantrons into the paper feed. The scantrons should be face down with the cut edge pointed up, away from the feeder. There is a small icon on the scantron machine indicating the direction. Do not put more than 20-25 scantrons in at a time.
  4. Go to your computer and open the Scan Tools Plus software.
  5. Click on “Data File” then “New.”
  6. In the dialog window, name the file. The naming convention is: “school_cycle##_dt#_additionalinfo” For additional info, if you are scanning makeups, write “mup” after the last underscore.
  7. After you have named the data file, look for the drop-down menus. Change all to the “561” versions of the files for rSAT grading except for the edit profile. Leave the edit profile as “*None*”.
  8. OPTIONAL: If you want ScanTools to warn you when there is missing information on the Scantron (e.g., missing ID), change the edit profile to the 561 file. If you choose to do this, you will have to pencil in the missing information on the Scantron after it throws the error and then rescan that Scantron and any other Scantrons that were processed after it. 
    • 3 ScanTools
  9. Press the “Scan” button on the top left corner of the software.
  10. If it runs out of scantrons to scan, it will ask you whether you want to resume (you will need to add more scantrons to the machine) or stop. If you stop, the file will be created.
  11. Possible Issues
  • Error saying it cannot read the scantron – it will tell you the test ID of the last successfully scanned scantron. Look at the pile of scanned scantrons and find that test ID. For every scantron on top of that, check for pencil marks or for missing student IDs. Fix and rescan those that were unsuccessful.
  • Error saying the scantron is missing information (ID, name, date). You should grab the last scantron, fill in the missing information, and start the scan again from that scantron through the rest.
  • It could get stuck if you put too many scantrons in the machine at once. Unstick it and try again with fewer scantrons.

Saving the Files

  1. Once you stop scanning, the file created goes automatically into the software’s default folder. This will vary from computer to computer but should end with “/scantools plus/data files/” You can also search your computer to find the name of the file you created.
  2. Once you locate the folder, there should be 3 files in it. A .csv, a DAT file, and a TIF file. Move all three of these files into the DROPBOX/PROGRAMS/TESTING, DATA, & UPLOADING/GMP3.0/1. Raw ScanTools Files/Current Cycle/ folder.

Troubleshooting

A known issue is that ScanTools will create the correct file but it will be missing a header (the first row containing the names of each column). If this happens, a solution is to copy the header from another school’s/region’s scantron file (found in DROPBOX/PROGRAMS/TESTING, DATA, & UPLOADING/GMP3.0/2. Scantron Data/) and paste it into the first row of the file you’ve created that is missing a header.


Installing & Setting up GMP 3.0

Installation

When you initially set up the software on your computer, you need to do two things:

  1. Install the software
  2. Set the default directories
  3. Import the software files

Installation

There is only one installation file, but when you run it, it will need to install two pieces of software:

  • Grading Made Possible (GMP 3.0)
  • MATLAB Runtime Compiler (MRC) – GMP 3.0 was developed in MATLAB. This program makes it possible for GMP 3.0 to work without MATLAB. You will NEVER need to run the MRC; GMP 3.0 automatically runs it whenever you use it.

**If you are asked to deny the file download because it is potentially unsafe, bypass this denial by accepting the download**

Try this first…

1. Download the web installer:

  • Windows
  • Mac – download directly from our internal Dropbox at Programs/Testing, Data, and Uploading/GMP 3.0/!Installers!/Mac/for_redistribution

If that doesn’t work or if you have a Mac…

1. Download the full installer:

  • Windows
  • Mac – download the FULL installer from the same Dropbox folder as above.

2. Run the Installer and follow the onscreen Instructions. You will be given the option to check a box that will place a shortcut to the software on your desktop. For easy access, check this box.

3. Once the Installer is complete, you should be able to run the software by double-clicking on the GMP 3.0 shortcut.

**Note: it may be slow to start when you first open the software. Please be patient**

Setting the Default Directories

Once you’ve installed, run the software for the first time by double-clicking on the GMP 3.0 shortcut.

The first time you run the software, the software may not automatically detect the correct directory and/or it may not find all of the files it needs.

First, change the default directory. Click on the menu “Preferences” then “Default Directories.” You should then direct the software to the folder PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0 for the “Import Directory” and the folder PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/4. Graded Data for the “Output Directory.” See photo below.

 The next time you open the software, the default directories will be set up as you did the first time you opened the software.

Import the Software Files

When you run GMP 3.0 for the first time, you need to import the software files. These files are all in Dropbox (PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/!Software Files/).

To import a file, click on the “Import” pull-down menu and select the file you want to import. You will see in the Session Log confirmation that the file was imported.

  • Import the Master Scoring Key –> KEY_MASTER.xlsx (this file may take a bit to import; be patient)
  • Import the Salesforce Variable Map –> SALESFORCE_VARIABLE_MAP.xlsx
  • Import the Summary Report Template –> TEMPLATE_ScoreReport.xlsx

Note: You will import the Salesforce Report when you grade (see below).


Grading Steps

General Grading Process

*Note: Please make sure you have completed all installation steps on your computer above before grading. You only have to complete installation steps once on your computer.

Pre-Grading: Updating the Salesforce File

  1. Scantron File: Creation & Selection
  2. Essay File: Creation & Selection
  3. Check for Flags
  4. Run Grading

If you want to see these steps numbered in GMP 3.0, click on “Preferences,” “Display Options,” then check the “Show Step Numbering on Buttons” option.

Please note: it is very important that you name your files correctly and save them in the correct place! Please follow instructions carefully.

Pre-Grading: Updating the Salesforce File

In order to grade, you need to update the Salesforce file so that GMP 3.0 can pull information from Salesforce for error checking and adding information onto the final graded file. You should always update this file when grading so the software has the most up-to-date information.

There are two steps for you to follow:

  1. Downloading the file from Salesforce
  2. Importing it into GMP 3.0

Downloading from Salesforce

Log in to Salesforce and click on the “Reports” tab. Pick the “Grading” folder from the “All Folders” list on the left. In that folder, there are three reports. Click on the GMP 3.0 report specific to your region (e.g., “GMP 3.0 (NY)” for New York). See photo below.

 

Once you click on the report, it should update in your web browser. Once it does, click the button that says “Printable View” to download the report. See photo below.

 

The file will download to your computer as an .xls file, but it will be corrupted. You need to open the file and re-save it as a .xlsx file for the file to be saved and processed properly. If you skip this step, you will run into errors when grading.

When you open the file, it will give you an error. Press OK to pass the error and open the file. Click “File” then “Save As”. Navigate to the folder PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/!Software Files/.

  • Change the “Save as type” field to .xlsx
  • Name the file “Salesforce_Grading_Software_Report_MM_DD_YYYY_Region”
  • Save.
  • See photo below.

Saving Salesforce File4

Importing Salesforce File

You next need to import the file you just saved into GMP 3.0. Open GMP 3.0 and click on the “Import” pull-down menu. Then, click on “Salesforce Report”. See photo below.

Navigate to the location where you saved the file (PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/!Software Files/) and open the file. If you see old versions of the Salesforce file in that folder, delete them.

In the Session Log, you should see confirmation that it imported the correct file.

Note: You can check to see if the file imported correctly by clicking the “Open” pull-down menu, then selecting “Salesforce Report”.

Step 1. Scantron File: Creation & Selection

Terminology

Ordinal Test Number (OT): The number corresponding to the ORDER in which the test was taken. The first test students took is OT1, the second test students took is OT2, etc.

Diagnostic Test Number (DT): The number corresponding to the VERSION of the test that was taken. The test that is labeled “Test 1” is DT1, regardless of the order in which students took the test. The test that is labeled “Test 2” is DT2, regardless of the order in which students took the test. Etc.

Guidelines for File Naming

  1. Only alter the parts in all caps in the template.
  2. Case does not matter. Upper or lower case, or some mix of the two, is all fine.
  3. Do not leave the hashtag (#) in the file name for scantrons. This should be replaced with an actual number.

Scantron File

The next thing you should do is to create, name, and select your scantron file. The template for the scantron file is in Dropbox (PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/!Templates). See photo below.

The Scantron file used by GMP 3.0 is the UNALTERED file that you created using ScanTools and then saved into the PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/1. Raw ScanTools Files/ folder.

  1. Open the file you are grading from the “1. Raw ScanTools Files” folder.
  2. Save the file as a .csv named with the template convention: “Scantron_SCHOOL_DT#_OT#_CYCLEYY.csv”. For example, if you are grading Inglewood DT 4 which was taken as the last test during AYP 2015-2016, you would save the file as “Scantron_Inglewood_DT4_OT4_AYP15.csv”. If you wanted to add some info to that file to indicate that these are makeup tests, you would save it as “Scantron_Inglewood_DT4_OT4_Summer14_Makeups.csv”.
  3. Save the file in PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/2. Scantron Data/) in the appropriate cycle and year folder.
  4. Finally, import the Scantron file into GMP 3.0 by clicking the “Scantron” button under “Select Files” on the main pane of the software. Navigate to the Scantron file and open it. Once you do, the software will confirm that the file has been opened. See photo below.

Note: You can check to see if the file imported correctly by clicking the “Open” pull-down menu, then selecting “Scantron File.”

You will have one Scantron file for every set of tests you grade.

 

Step 2. Essay File: Creation & Selection

Terminology

Ordinal Test Number (OT): The number corresponding to the ORDER in which the test was taken. The first test students took is OT1, the second test students took is OT2, etc.

Diagnostic Test Number (DT): The number corresponding to the VERSION of the test that was taken. The test that is labeled “Test 1” is DT1, regardless of the order in which students took the test. The test that is labeled “Test 2” is DT2, regardless of the order in which students took the test. Etc.

Guidelines for File Naming

  1. Only alter the parts in all caps in the template.
  2. Case does not matter. Upper or lower case, or some mix of the two, is all fine.
  3. Do not leave the hashtag (#) in the file name for scantrons. This should be replaced with an actual number.

Essay File

  1. First, you will need to make sure you have all essays graded for the tests you are scoring.

Before you start grading, you should have all of the essays graded that you would like to include in the grading process. You must two sets of essay scores in the file – Reading (1-4), Writing (1-4), Analysis (1-4) – for a total of 6 scores. Check to make sure you are not missing scores before grading. See photo below.

Essay Scoring

NOTE: If a student did not complete an essay, they should have a blank for their essay scores – not 0s.

2. Then, if you haven’t done so already, you will create an Essay file for that school/cycle.

The template for the essay file is in Dropbox (PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/!Templates). You only need ONE essay file per school per cycle. For example, if Inglewood is being served in AYP 2015-2016, you will only need to create an essay file for them once. For subsequent tests, you will add essay scores to that file.

When you grade your first set of tests, open up the template file and then save it with the school and cycle you are grading. For example, if you are grading Inglewood tests during AYP 2015-2016, you would save the file as “Essay_Grading_Inglewood_AYP15.xls”. You should save the file in Dropbox (PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/3. Essay Data/) in the appropriate cycle and year folder.

3. Then, you will need to add your scores to the existing Essay file for that school/cycle.

Locate and open the Essay file you created in the prior step. You may have created the file when you graded at an earlier time. This file should be in PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/3. Essay Data/ in the appropriate cycle and year folder.

There is a separate tab in the Essay file for each DT. Remember that the tab corresponds to the DT, NOT to the OT (see terminology above). If you are inputting essay grades for test version 1 (DT 1) but it was taken as the last test in the cycle (OT4), those scores should go into the tab that says “DT1.” Copy and paste your score information into this file.

Make sure that columns A – L in the document have COMPLETE information for every student. 

When you are done inputting all of the essay grades you are using to grade in that session, save the file.

In the future, if you need to grade more tests from that school in that cycle, all you have to do is add those essay scores to that same file. You do NOT need to create a new essay file. You can use the same essay file for the same school in one cycle. Just add the new students and essay scores to the appropriate tab by following the instructions above.

4. Finally, import the Essay file into GMP 3.0 by clicking the “Essay” button under “Select Files” on the main pane of the software. Navigate to the Essay file and open it. Once you do, the software will confirm that the file has been opened. See photo below.

Note: You can check to see if the file imported correctly by clicking the “Open” pull-down menu, then selecting “Essay File.”

Step 3: Check for Flags

Diagnostic Run

Once your Salesforce file, Scantron file, and Essay file are organized, named, updated, and saved, and imported, you can start a diagnostic run. You can check to see if all files are appropriately imported by clicking the “Open” pull-down menu and checking to see that each file can be opened and is correct.

Optional: Questions Left Blank Check

GMP has a setting to show you the students who left 50%+ of the test blank. This may be useful for flagging those students to schools. If you want the software to show you these students, click on the “Preferences” pull-down menu and check the “Show Percent Unanswered Flags” option. This option is OFF by default. See photo below.

Check for Flags

Now that you have imported your files, the two buttons in the “Grade” pane of the software should be active. First click the “Check for Flags” button to do a diagnostic run of the software. This will run the grading process without creating a file to allow you to find and correct issues before doing the final grading. See photo below.

 

Any error flags and/or automatic corrections will show up in the Session Log. You can save this log at anytime by clicking “SAVE LOG.” You can also clear the log at anytime by clicking “CLEAR LOG.”  You can also copy information from the log by selecting text and right-clicking on the Session Log window.

Automatic Corrections

The software will also show you any automatic corrections it made to names and/or IDs using the Salesforce file. It is critical this file is updated for these corrections to work.

You should scan these to ensure that they were done correctly. The easiest way to do this is to go down the list and make sure names seem to match.

For example, below you can see a set of students whose IDs were autocorrected by the software. A scan of the names indicates that these students seem to have been corrected correctly.

Error Correction

Error Flags

The possible errors or flags that the software could identify are as follows:

  • STARTUP ERRORS REGARDING FINDING SOFTWARE DATA FILES
    • ERROR => Cannot find Master Scoring Key. Please select in Import menu. (you need to import the Master Scoring Key through the “Import” pull-down menu; the Master Scoring Key is in the !Software Files folder)
    • ERROR => Cannot find Salesforce Variable Map. Please select in Import menu. (you need to import the Salesforce Variable Map through the “Import” pull-down menu; the Salesforce Variable Map is in the !Software Files folder)
    • ERROR => Cannot find Salesforce Report. Please select in Import menu. (you need to import the Salesforce Report file through the “Import” pull-down menu; see grading instructions above)
  • WHEN READING/IMPORTING FILES
    • ERROR => Missing variable(s) in Scantron file: <Missing variables will be listed here> (you are missing columns in the Scantron file)
    • ERROR => Missing variable(s) in Essay file: <Missing variables will be listed here> (you are missing columns in the essay file)
    • ERROR => Missing variable(s) in Salesforce file: <Missing variables will be listed here> (you are missing columns in the Salesforce report file)
  • WHEN CHECKING/SCORING TESTS
    • ERROR => Missing test item(s) in Scantron file: <Missing items will be listed here>
    • ERROR => File <essay file with multiple worksheets> does not contain worksheet with any of these valid names: <valid names> (the tabs in the essay file are named incorrectly)
    • ERROR => Invalid essay score of <essay score> for ID <Student ID>. Check essay file. (the essay score is invalid for that student)
    • ERROR => ESSAY FILE ERROR – Duplicate IDs:  <IDs will be listed here> (the essay file has duplicate student IDs)
    • UNDEFINED ERROR => Non-scalar in Uniform output, at index 1, output 1. Set ‘UniformOutput’ to false. (Note: there may be text in the essay score column. Make sure the essay score column only consists of numbers) 
  • MISCELLANEOUS
    • ERROR => Could not open: http://collegespring.org/grading [or whatever the help website is]
    • UNDEFINED ERROR =>  [System Error Message] When these errors occur, error information will printed to the screen, and a log file that might contain additional information will be saved in the application folder.
  • FLAG LIST – these are issues with specific students’ scores that the software will flag
    • Duplicate Student in Scantron file (the same student is listed twice in the Scantron file)
    • No score in essay file (student has no score in the essay file)
    • No match in essay file (student’s scantron does not match anyone in the essay file)
    • Multiple matches in essay file (student’s scantron matches multiple students in the essay file)
    • Found matching ID in Essay File, but names do not match (student’s scantron matches an ID in the essay file but not the name)
    • No match in Salesforce file (student’s ID was not found in the Salesforce file)
    • Multiple matches in Salesforce file (student’s ID matched multiple records in Salesforce)

You should correct any errors or flags before the final grading. You can do this easily by opening the files directly in the software (“Open” pull-down menu), making corrections, then resaving the files.

You can run a diagnostic run as many times as you want before doing the final grading (i.e., producing output files). It is a good idea to do it multiple times until you are sure that all errors are fixed.

Step 4: Run Grading

Final Grading

Once you have corrected any errors identified in the diagnostic run(s), you can click the “Run Grading” button. See photo below.

The software will ask you where you want to save output files. In your initial setup (see above), you should have set the software to open to the “Graded Data” folder (PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/4. Graded Data/). Within that folder, select the appropriate cycle folder.

The software will save a file that starts with “Salesforce_Report.” The rest of the file name indicates the school, DT number, and date and timestamp for the file. This is the file you will upload to Salesforce.

Graded Salesforce File Upload

If you do not open this file before uploading, you do not need to change anything – you can just upload it using Data Loader.

If you do open this file to double-check anything, you will need to change the Test ID Number column (AK) to text and replace as follows: 1 = 01, 2 = 02, 3 = 03, 4 = 04. Do this by first right-clicking on the Test ID Number column (AK) and selecting “Format Cells…” Then in the “Format Cells” window, select “Text” and click OK. Then change the first number in column H to “01” and drag the number all the way down to the last row. Make sure it copies the number and does not add a sequence. See photo below.

Test ID

You will also need to change the date format to YYYY-MM-DD. Do this by first right-clicking on the Test Date column (AJ) and selecting “Format Cells…” Then in the “Format Cells” window, select “Custom” and type “YYYY-MM-DD” in the Type: text box. Click OK. See photo below.

Test Date

You can then save the file as a .csv and upload to Salesforce.


Using GMP 3.0 to Create Summary Reports

What is a Summary Report?

After grading, GMP 3.0 can create Summary Reports that contain the following information:

  1. Group Summary: a list of every students’ total scores, section scores, test scores, and essay scores.
  2. Differentiation: the % of students who got questions correct/incorrect/blank by difficulty level of questions, across the whole test and within reading, writing & language, and math.
  3. Top Incorrect Questions: a list of the questions that x% or more of students got incorrect with corresponding explanations of the correct answer.

This report can be filtered by the Mentors, Teachers, Mentor Groups, or Teacher Classrooms.

How should I use a Summary Report?

Generally speaking, you can use the Summary Report to give instructors and mentors more information about how to differentiate instruction to their particular students’ needs.

Here are some specific recommendations for how to use the Summary Report to offer support that will work well for both instructors and mentors:

For Instructors

  • All Top incorrect Qs tabs — Identify trends in the difficulty levels of top questions missed, ideally all top incorrect answer choices should be mostly hard problems. Track concepts commonly answered incorrectly and suggest that instructors review those concepts in class or provide students with Khan Academy practice based on those concepts.
  • Top incorrect Qs (math) — Assess if there are trends in incorrect answers between calculator and no calculator tests and provide information to teachers on whether students need more support in calculator or no calculator problems (really will only be helpful to schools with access to calculators).
  • Instructors should not review listed individual DT questions with students. Mentors will review all DT problems with students.
For Mentors
  • Refer to the Top incorrect Qs for each content area when preparing for sessions. Spend extra time going over those problems when they are reviewed during the Lesson and Activity portion of MHB lessons.

Creating a Summary Report

Once you have graded, the buttons under the “Create Reports” section of the main pane of the software will be active. See photo below.

 

Settings

Reports Settings

The first setting to choose is the filter you want for the report. You can filter by Mentors, Teachers, Mentor Groups, or Teacher Classrooms. You can only pick one type of filter. Whichever filter you choose means that the report generated will only be for the specific mentors/teachers/groups/classrooms you chose. If you want a report for every student in the file, you can leave the default choice, “No Filter”.

Next, you may want to adjust the % missed cutoff. This cutoff tells GMP 3.0 the minimum % of students who need to miss a question before it shows up in the report. For example, if you leave the default (25%), only questions where at least 25% of students missed the question will show up in the report.

Finally, you can choose whether or not to save the Full Scoring File. This file contains the individual responses to every question for every student in the filtered file. The default is that the software will not create the Full Scoring File.

Create Report

Once you have chosen your settings (you can also skip the settings step to ride the defaults), you can click “Create Report.” GMP 3.0 will ask you where you want to save the report. You can save a copy in PROGRAMS/TESTING, DATA, & UPLOADING/GMP 3.0/5. Reports/.


 Uploading Graded Data into Salesforce

Salesforce Upload

  1. Open Data Loader (Lexiloader for Mac users).
  2. Choose “Upsert.”
  3. Log in using your email and Salesforce password + security token
  4. Under “Select Salesforce object”, choose “SAT Performance”
  5. Click browse to find and select your .csv file that contains the data you want to upload.
  6. Click next.
  7. In the pop-up window, click OK.
  8. In “Step 2a: Choose your field to use for matching”, click next.
  9. In “Step 2b: Choose your related objects”, select “Student_ID_Number_c”, then click next.
  10. In “Step 3: Mapping”, click “Choose an Existing Map.” Open the map found here: (PROGRAMS/TESTING, DATA, & UPLOADING/Salesforce Data Uploading/Data Loader Maps/”SAT Score Map GMP 3.0″)
  11. In the “Current Field Mapping” section, each File Column Header should have a corresponding Name in the Name column, with the exception of First and Last name and Program Year. Scroll down to verify. If other names are missing, contact the system administrator to troubleshoot.
  12. In “Step 4: Finish” choose the directory (only needs to be selected once): (PROGRAMS/TESTING, DATA, & UPLOADING/Salesforce Data Uploading/Data Loader Uploads/[your region]/[sub-folder as appropriate])
  13. Click finish.
  14. If there were no errors, click OK.
  15. If there were errors, view the output file; scroll right for error messages.
  16. If you do not know how to correct the error, send the output file to the system administrator for troubleshooting.

For more detailed instructions, please refer to “Chapter 3: Data Loader Instructions” under the Salesforce Instructions Document (PROGRAMS/ TESTING, DATA, & UPLOADING/ Salesforce Data Uploading/ Salesforce Instructions) 


 GMP 3.0 Troubleshooting

Grading Made Possible (GMP) 3.0: Software Description

Menus

  • GMP: From this menu, you can find this help page, restart the software (clearing any session logs or files),exit the software, or learn more about its creator.
  • Import: From this menu, you can load or reload the files the software uses to grade.
  • Open: From this menu, you can open any of the files you are grading directly. You can then make changes and re-save them.
  • Preferences: From this menu, you can select the default directories used by the software. You can select whether the software shows step numbers on the buttons and the font size. You can also select whether or not the software shows the students who left 50%+ of the items on the test blank.

Select Files

  • The two buttons in this pane allow you to select the Scantron and Essay files you will use in the grading.

Grade

  • The two buttons in this pane are only active when you have all the files for grading imported. The “Check for Flags” button allows you to do a diagnostic run of the software with no file produced – only flags and corrections logged. The “Run Grading” button allows you to do grading, which will produce an output file for you to save.

Create Reports

  • The Settings button allows you to set the settings for the Summary Report.
  • The Create Report button allows you to generate a Summary Report by the established settings.

Session Log

  • The session log will contain all of the information for files loaded, actions taken, and flags produced during your session. You can clear this log using the “CLEAR LOG” button. You can save this log using the “SAVE LOG” button.

Troubleshooting Process

If you have a problem, please do the following in the following order:

  • First, make sure that you are using the most current version of GMP (currently that is GMP 3.0). Make sure that all of the software’s files are up to date (see installation steps).
  • Next, make sure that you fixed any flags that came up during the diagnostic run. Flags must be fixed prior to grading.
  • Then, check the following Common Issues.
    • File Format Issues
      • The names or formats of your Scantron or Essay files are incorrect.
      • Essay file does not have the tabs named for the DT (see template).
      • Scantron file was changed in some way. Do not edit the Scantron file when you get it from ScanTools – if you change something, it may not run.
    • Scantron Content Issues
      • Student ID is incorrectly formatted in the Scantron – it has special characters or spaces.
      • Scantron file has no test ID for any student. If no student has a test ID, just add it to one student’s row in the Scantron file (this is an exception to the recommendation above).
      • Scantron file has strange characters in the name/name severely misspelled.
    • Essay Content Issues
      • Essay file is missing students who are present in the Scantron file.
      • Essay file doesn’t have an ID assigned to every student.
      • Essay file contains essay scores that are impossible (i.e., not a blank or within the 0-4 range).
    • Salesforce File Issues
      • Students in the Scantron file are missing from Salesforce. All students must be present in Salesforce to grade. There is a known limitation to the Salesforce report where if there are too many students in the report, random students can be left out of the report. Use the Salesforce report for your region only to try to avoid this issue.
      • Students in the Scantron file do not have a school assigned to them in Salesforce. If at least 1 student does not have a school name in Salesforce, it cannot give the file a school name in that field and will create the undefined error message. Update the school name to the students in Salesforce, re-download the file, and then try grading again
  • If all this is checked and you still have a problem, email the GMP administrator.