Checking your data in Arbor

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.

How to download and use the Data Migration Report


How to use the Data Migration Report

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. 

Counting Student Data

Counting Staff Data


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. 

Checking Student 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.  

Checking Staff Data 

We recommend checking a sample of staff, with a range of job roles and start dates. You should check a minimum of 10 staff. 

Checking Attendance Data 

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.

Checking Behaviour Data

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.

Checking Exams Data 

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. 

Checking Timetables 

You should check a sample of student and staff timetables, and review any timetable clashes.

Checking Student Enrolments

Carefully check the enrolment figures for the whole school, year groups, registration forms and courses.

Checking Programmes of Study

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. 

Was this article helpful?
0 out of 0 found this helpful
I'm still stuck!



Article is closed for comments.