Setting up your Year Group - KS4 and KS5 Schools in England
Setting up your Year Group - KS4 and KS5 Schools in England
Step 1: Rolling Over Existing Student Data
If you have existing student data from the previous year, you can roll this over into your current year. You cannot roll-over Y13 or Y11 data, but please feel free to roll-over Y12 into Y13 and Y10 into Y11.
If you do not have existing data, then please skip this step and go to step 2.
This video will show you how to roll-over your existing student data into your current year from your previous year:
Step 2: Importing your Student Data
If you are new to Alps and don't have existing data in Connect Data, or if you do not wish to roll-over your existing data from last year, then you will need to import your student data manually from Excel.
Before importing the data from Excel, you will need to export your data out of your MIS first.
SIMS users can extract their data from SIMS to Excel by following the steps in this guide: Exporting Data from SIMS
Arbor users can extract their data from Arbor by following the steps in this guide: Exporting Data out of Arbor
For users of any of other MIS, unfortunately we do not have any resources to help you extract your data, but as long as you know of a method to easily extract the appropriate data from your MIS to Excel, then you should have no issues.
This video will show you how to import your student data:
Step 3: Calculating and Importing your Avg. GCSE Scores - KS5 Schools in England
Once you have imported your student data, you can then calculate and import your Avg. GCSE Scores.
The same method applies for both year 12 and year 13 students.
If you only use Connect for KS4, then you can skip this step.
This video will show you how to do this:
Step 4: Importing your CAT4 and KS2 Scores - KS4 Schools in England
You can now import CAT4 scores directly into Connect Data to use as your prior attainment scores without having to convert them to KS2 Scores.
If you only use Connect for KS5 then you can skip this step.
This video will show you how to do this:
Step 5: Importing your Teaching Data
Once the Student Data and Prior Attainment Data has been imported, you can then move onto importing your teaching data.
This video will show you how to do this:
Step 6: MEG report generation
Once the Student, Prior Attainment and Teaching Data has been imported, the MEG report will be generated for you automatically - you can download these reports from the MEG reports section that you can find on the homepage under 'Reports and Downloads'.
In Connect Data, we have now added a section underneath the Connect Data Settings that will allow you to edit and delete custom columns that you have imported via the student data import wizard. For guidance on importing custom columns, please click ...
Adding custom columns to your Student Information allows your colleagues to filter by categories that you define. As standard, Alps allows the import of Disadvantage, Ethnicity, SEND, EAL and Gender columns, with categories that we define and that ...
This article will show you how to make edits to the student data you have imported. You can make edits individually, using the Edit Student screen, or in bulk, using either merge or overwrite. Editing individual students Bulk updates – merge and ...
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 ...
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 existing data, you can roll-over the data for these ...