Remove Duplicates

Remove Duplicates

When importing Teaching Data from your MIS, sometimes you will see the Remove Duplicates step. If you have no duplicates in your data, it will automatically skip past this step. If you do have duplicates you will need to resolve these before continuing with the import. Duplicates are students with multiple subject entries for the same subject, usually caused by the student having multiple teaching sets for the same subject.

To resolve this error, press the red Remove All Unresolved Rows button, which will allow you to delete the duplicates and keep one entry:


If you would like to keep multiple sets or teachers for one subject entry, you will need to enter the multiple sets or teachers names within one cell in your spreadsheet e.g. '13AB/13CD', 'Mr AB/Mrs CD'

    • Related Articles

    • Importing Teaching Data

      Once the Student Data and Prior Attainment Data has been imported, you can then move onto importing your Teaching Data. This includes the subjects your students are studying, the teaching sets and teachers. You can only import one teaching set and ...

    • Editing Teaching Data

      If you need to make changes to your teaching data, such as subjects or sets, you can do this on an individual student basis or in bulk using Overwrite & Replace or Update & Merge. Edit Individual Students To edit an individual student's subject ...

    • Editing Student Data

      If you need to edit your existing Student Data, you can do so by either editing individual students or uploading data in bulk. For example, you may wish to edit individual data if a student has left your college/school, or you could do a bulk upload ...

    • Individual Subject Pages

      In the Subject Analysis zone, the individual subject pages allow you to take an in depth look at a subject's performance. Please see our video and step-by-step guides below: <br> You can access the subject pages in two ways. The first ...

    • Roll Over Student Data

      Before a new academic year begins, you can save time by rolling-over your existing student data from the current year into the next academic year. In Connect, the new academic year is typically launched at the start of July for you to populate with ...