1. Select Administration from the top of the left-hand task panel.
  2. Select Result Entry, followed by Bulk Upload.
  3. Select the Provider and Assessment Item. Then select the Calendar Year and Term in which the test was taken.
  4. Click Browse, then select the relevant Excel file.
    Note: The file type must be CSV.
  5. Choose the basis on which you wish to match the students in the spreadsheet to those in the Suite. TrackOne Studio recommends matching on Student ID if possible, though if the spreadsheet does not contain Student IDs, select Match on Name.
  6. Click Load Results.


  1. The spreadsheet will now have loaded. Match the column headings in the spreadsheet to the column headings in the drop-downs. For example:

    Family Name

    The spreadsheet column containing the student’s surname
    Given NameThe spreadsheet column containing the student’s first name
    Student IDThe spreadsheet column containing the student’s ID number
    Results: PAT-M Raw ScoreThe spreadsheet column containing the raw score
    Results: PAT-M Scale ScoreThe spreadsheet column containing the scale score
    Results: PAT-M StanineThe spreadsheet column containing the stanine
    Results: PAT-M PercentileThe spreadsheet column containing the percentile
    Metadata: PAT-M Test NumberThe spreadsheet column containing the test number
    Metadata: PAT-M Normative Reference YearThe spreadsheet column containing the normative reference year

  2. If there are any blank rows/rows to be ignored, tick Ignore using the far left-hand column. For instance, as shown in the example above, the row containing the headings (Unique ID, Family Name, Given Name, etc.) can be ignored. This is because these headings have already been selected from the drop-downs, which will see that they are included in the upload.
  3. Click Validate and Save Results.



  1. If the spreadsheet has uploaded successfully, a green tick icon will appear (underneath the Validate and Save Results button).


  2. If the spreadsheet has not uploaded successfully, a red error message will appear under the Validate and Save Results button. This often occurs where the Suite has failed to recognise a student (often because of an error in the student ID number).
  3. Scroll down to find the student (the same red error icon will appear next to their name).


  4. The Suite will require the user to enter the correct student ID. In the blank field provided, enter the ID, then click the Manual Student ID option.

    HINT: It can be useful to keep a separate tab open to search for correct student ID numbers. Open a new tab and click Analytics at the top of the left-hand task bar. Then click Student ResultsSchool Results.

    From here, use the search area to locate the student (shown below).


  5. Click Validate and Save Results. The green tick should now appear to indicate that the spreadsheet has been uploaded successfully.