Remove duplicates

Remove duplicates

Connect Data uses Student IDs to match information imported using the different wizards. Therefore, in some areas it is very important that there are no duplicate values.

In each Academic Year, each Student ID can only appear once, and each student can only have one entry for any subject in any given grades or teaching data import.

We advise to try and remove the duplicates you can within Excel before import, this can be done by using the Remove Duplicates tool:



Each wizard also contains a Remove duplicates step to ensure there are no import errors:


In the above, there is a duplicated subject for a student within the Teaching Data.

To remove duplicates, simply use the bin icon to the left-hand side of the entry you wish to remove from the import. The other entry will then go green, showing that this is now a valid entry.





    • Related Articles

    • How do I disable a user?

      If a user leaves, Connect Administrators can remove users from the account. Log into Connect and go to Manage Users. In the list of users click Edit next to appropriate User. Tick Disable and then Save.
    • Add Teaching Data

      If you do not wish to analyse your data by teaching set, then you do not need to import this data. If you are subscribing to Connect Interactive however, we encourage you to submit your teaching sets to get as much as you can from your analysis. The ...
    • Add Personalised Targets

      Once you have imported your Year Group, teaching data and prior attainment scores, you will be able to import your own Personalised Targets, if you wish to do so. The Personalised Targets wizard can be launched from the quick actions toolbar in the ...
    • Import your Monitoring Grades

      Before creating a monitoring point, you first need to create a student cohort in Connect Data for 19/20. Click here to see how to create a student cohort.  You will know if you haven’t created a student cohort for 20/21 if the Year Group summary bar ...
    • Setting up your Year Group

      The Cohorts page gives an overview of the data currently in the system. Until you have imported your basic student data using the + Year Group wizard, you will not be able to add prior attainment, and you will only be able to add teaching sets and ...