Consortium Schools - submitting your data

Consortium Schools - submitting your 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 within the 'Manage Data' section. 

Step 1: Click into 'Manage Data' from the homepage of Connect:


Step 2: Select 'Consortium Schools' from the sidebar on the left-hand side:

settings.png

Step 3: Use the toggle to enable consortium headers:

enable_.png

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. 

Click here to see our article on importing student data, to assist you whilst you import this 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.

Click here to see our article on importing teaching data, to assist you whilst you import this data.

 

Once your TaughtAt and Roll data has been added, you can then begin to analyse your data in Connect Interactive.

 

Recommended naming conventions:

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

If you have any questions about best practice for your consortium then please get in touch with us on 01484 887 600, or email reports@alps.education. We can advise upon the best way for you to submit your data on a case by case basis.

 

    • 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 ...
    • Consortium best practice for monitoring

      This article provides guidance on how best to manage your in-year Consortium monitoring data to allow you to analyse your ‘on roll’ and ‘taught at’ groups separately.  We also have an article on how you can analyse your Consortium data using Connect ...
    • 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 ...
    • Roll-over Student Details

      This article will give details of how you can use our Auto Roll-over tool to move your Year Groups from one to the next, saving you time when creating your Cohorts. What is roll-over? If you have 2019/20 data, you can roll-over the data for these ...
    • Exporting data from SIMS

      This article give step by step instructions for SIMS schools using our report definitions to extract their Student Information, Teaching Sets and Exam Results. Importing the report definitions Running the reports Adding extra data – Student ...