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:

remove_dups.png

remove_duplicates.gif

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

Remove_dups.PNG

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.

remove_dups_1.PNG

 

 

 

    • 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 ...

    • Isolate the performance of one subject in the Student section

      In the Student Analysis section of Connect you can isolate students who are studying a specific subject. This is achieved by using the drop-down box called 'Focus on'. To remove the subject, simply click on the 'x' next to the subject.  

    • Removal of the Curriculum Balance Factor from the 2016 BTEC suite

      Historically, the overall Quality Indicator score for BTECs has had a Curriculum Balance Factor applied to it to take into account the variation in subject value-added scores of the BTEC courses.  The way in which we now construct our benchmarks for ...