The first big milestone of your move to Arbor is the migration of data from your existing MIS. Your Project Manager will give you details of our migration process during your Discovery meeting.
To make sure the migration is accurate, we give secondary schools two dummy data runs - we’ll take a backup of your data, migrate it to Arbor, and you can log in to your Arbor system to see how it looks.
Once you’re into your Arbor dummy site, you’ll need to thoroughly check the data that has migrated and cleanse the data in your existing system ahead of the second dummy run.
This guide will show you how to check data in Arbor, and highlight a few common migration problems.
Top Tip: You should record your data checks in your Implementation Workbook, to make it easy to keep track of the work still to be done.
Using the Data Migration Report
After each migration, you can view a summary of the migrated data by downloading your Data Migration Report. This interactive report can help you quickly identify discrepancies in the migrated data.
To access the Data Migration Report, you will need the permission Student Profile: Admin: Administer All Students.
A lot of the summaries in your Data Migration Report are linked to your Arbor system, so will take you to the relevant tables to look more closely at the data. For example, you can click the summary of migrated Pupil Premium students to go straight to the demographic report that shows Pupil Premium eligibility.
You can use the pre-migration data counts in your Implementation Workbook to quickly compare the data in Arbor with your old system.
Migration Data Counts
Your Implementation Workbook has a list of recommended data counts to perform in Arbor. This is a great way to identify discrepancies between the two datasets. You should make any changes in your existing system ahead of your second dummy data run or final migration.
In these videos, we'll show you how to find the data needed for these counts in Arbor.
Migration Data Checks
After each migration, it is important to thoroughly check your student and staff data to make sure it has migrated correctly. As well as checking student and staff profiles, we recommend undertaking detailed checks of migrated attendance, behaviour, exams, timetable, and enrolment data.
We recommend checking a sample of students from different year groups, with a range of demographic indicators (e.g. FSM, EAL, SEN Status, Dual Registered). You should check a minimum of 20 students.
We recommend checking a sample of staff, with a range of job roles and start dates. You should check a minimum of 10 staff.
We recommend checking a sample of attendance certificates to ensure that all attendance marks and absence notes have migrated correctly. You should also use the Attendance Statistics screen to check that the number and percentage of present, absent, and late marks match your previous MIS.
You should carefully check that statutory behaviour data - fixed-term and permanent exclusions - have migrated. Depending on your previous system, we may be able to migrate historic behaviour incidents - in this case, you should check a range of students to confirm that these have all migrated.
Your exams officer should carefully check candidates, entries, and results. Check out our Top Tips for Exams Officers for more information about getting started with Exams.
You should check a sample of student and staff timetables, and review any timetable clashes.
Carefully check the enrolment figures for the whole school, year groups, registration forms and courses.
If you have a Sixth Form, check that your Programmes of Study (e.g.A Level English Literature 2yr) and Programme Instances (e.g. A Level English Literature 2yr, 2019 - 2021) have migrated. Check that students are enrolled into the correct programme instances.