Consortium School Data

Consortium School Data

This article will define a consortium, and explain how to set up your student data to enable monitoring and end of year results analysis.

Are we a Consortium?

Consortia analysis is for schools/colleges who have enrolled students that are taught elsewhere and teach students that are not enrolled at their school/college.

At the start of the academic year students are tagged with the school/college that are enrolled at and each subject is tagged with where the student is taught.

This will enable Connect Interactive to show the progress of students both in terms of:

  • The whole cohort
  • Filtered based on
    • ‘EnrolledAt’
    • ‘TaughtAt’

At the end of the year the results pdf reports available are:

  • Consortium Overall
  • Consortium Provider
  • Consortium Subject

Please see this article for the best practise use of Consortia analysis in Connect interactive.

How do I submit Consortium data?

You will first need to turn on Consortium Settings, which can be done by clicking Consortium Schools in the Data Management tab of the homepage:



In the Consortium page, press the toggle to turn on the setting: 


Once this setting is enabled, you will then be able to add Taught At and Roll data into your student data. 

Note: Each school/college will need to do this in their Connect account. They will then be able to include the students' Roll organisation in the Year Group import, and for each subject in the Teaching Data import they can include the identifier of the organisation where they are taught.

 

Adding Roll Data

The Roll data should be imported at the same time as your Student Data. The Roll data is simply the site at which a student is enrolled.

Your Excel file that you import into the Student Data Import Wizard should look something like the example below:

roll_gab.PNG

Once this file is prepared, you will then be able to import your Roll data alongside your student data. 
 

Adding Taught At Data

The Taught At data should be imported at the same time as your teaching data. The Taught At data is simply the site at which a student is taught a particular subject.

Your Excel file that you import into the Teaching Data Import Wizard should look something like the example below:

taught_at.PNG

Even if the student is enrolled and taught at the same school, you should still populate their taught at data with the appropriate school.

Once this file is prepared you will then be able to import your Taught At data alongside your teaching data.

 

We recommend deciding on initials for each school/college and keeping these consistent when submitting data, whether through one central account or each individual school/college account. Once we have the data for each school/college within the consortium we will be able to run the reports.

For example, the Alps Example School/College names are below, with some suggestions for initials that could be used:

Green Abbey   GAB
Greenbeck School    GBS
High Spirits School   HSS


 

    • Related Articles

    • Producing consortium monitoring analysis in Connect

      This article provides guidance on how to view and analyse your consortium monitoring data if the Roll and Taught at columns have been populated in Connect Data.  Article relevant to:   Country England, Wales, Northern Ireland, International Schools ...

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

    • Manage Settings section - Creating Custom comparison groups

      You can now use multiple comparison categories to create groups in your subject, teaching set and student analysis, including any custom groups you have added. You will be able to create several of these comparison groups to view on one screen. You ...

    • Importing Student Data

      To set up a new year group in Connect, you can export your MIS data to excel and upload it into the Connect Data Management area. Please note the process for importing Student Data is the same for KS4 and KS5, the only difference being the Prior ...

    • Summit Strategic Analysis

      The Strategic Analysis zone in Summit allows you to analyse the contextual and overall value-added data for your LA/MAT/Group and at individual provider level. Step-by-step Guide Before you start your analysis, you first need to check you have ...