Preparing for the school census

For links to other useful guides, webinars and bookable support slots with our Support Team, click here

Changes to the census this academic year

For guidance from the DfE on changes to the census, click here, or for further information detailing what data your school must return in the census, click here.

Alternative Provision details

Schools have two new areas to record details for students they’ve sent to Alternative Provision placements, and students they are providing Alternative Provision placements to. See how to record this here: Recording Alternative Provision placement details

The data from the Autumn term is being collected in the Spring school census. Please note that these areas are optional.

Learner funding and monitoring (FAM)

Schools can add funding to Student Profiles to report they are in receipt of catch-up funding.

For the Spring census, schools also need to return the cumulative total number of hours (year to date) that students eligible for funding have received school-led tutoring.

You can see how to add this to students here: Managing School led tutoring funding and teaching hours


The DfE refers to Fixed Period Exclusions as 'suspensions'. Censuses will display 'suspensions' in data tables so you can make sure you’re submitting the correct data.

For Permanent Exclusions that are still going through the review process, tick the Do not return in school census box to prevent errors.

Post-16 Programmes

For the Autumn Census only, programme aims will be collected for both on and off roll pupils. You’ll also need to specify a Programme Aim Type for each student on each Programme. We’ve made this 16 to 19 Study Programme by default, but you can change this to T level if needed. Take a look at our central guidance: Programmes of Study and Core Learning Aims for Post-16.


Preparing your data

Before the Dry Run facility opens, you can start preparing for Census using these three key areas:

  1. Check your recorded School Details by going to School > School Details.
  2. Check for duplicate student profiles in the Suspected Duplicates section
  3. Add and update basic details in the Students > Identity and Students > Demographics sections. Just click a cell to add the data!


  • School: General Admin: Administer - Access and edit the data in the Data Quality Dashboard for students
  • Student: Consents: Administer - Update YSSA for students

If you don't have the permission, you'll need to ask your admin team to give you permission using these instructions.

Preparing your school and childcare data

Check your recorded School Details by going to School > School Details. Ensure that your LA is filled in, Establishment Number, School telephone number and email address, Intake Gender, School phase, School type, Governance type, Intake type and URN all have information present (especially important to check if you have recently become an Academy).



Add childcare provision details

In the Spring Census, your school is required to provide information on the number and type of childcare places your school provides. This is required even if you do not provide childcare.

There are four types of childcare that you have to provide information on:

  • B - Before school
  • A - After school
  • H - Holiday provision
  • U - Nursery for ages 0-4 (for more than 9 hours/day, not a provision that is only available during school hours or where children can only attend for a morning or afternoon session).

For each type of childcare, you will need to add the type to the Child Care Places section by clicking +Add.


Please note that certain information is not required, and may flag an error if you add it:

  • Closing Time is not required for Before School Childcare
  • Opening Time is not required for After School Childcare
  • Weeks Open is not required for either Before or After School Childcare

If you do not offer this type of childcare, set the Childcare signposting and Childcare for other schools fields to No, leaving the others blank. 



If you do offer this type of childcare, add the details specific to your school's situation.



If your school offers childcare for under 5s, and it is for more than 9 hours, add your Under 5s childcare to reflect the start and end times.



If your school offers childcare for under 5s but it is less than 9 hours, you do not need to report this, so set your childcare as shown below.


Merge or delete any duplicate students

You can see a list of potential duplicate students in School > Data > Data Quality Dashboard >Suspected Duplicates > Students.

You can then merge or delete these. Take a look at this article to see how to do this.

Top Tip: If you know that two students are duplicates but they aren't flagging as such, make sure their names are identical.


Check data for students

To check that all students have information entered for key Census fields, go to School > Data > Data Quality Dashboard > Students.

Religion, country of birth and nationality are not reported in the census, so these fields are not required.



Assign UPN - Make sure all students have a UPN. If a student has no UPN against their profile they will show up in the list here. To generate a UPN for a student, use the bulk actions. 



To assign a known UPN to a student, add this from the Identity section of their student profile.



Update Basic Details - This allows you to quickly check that you have filled in some key information regarding students. To add or change any of the information, just click on the cell you wish to edit and a slide over will appear where you can add or update the correct information. For example, to add an Ethnicity source, select the students then select Bulk Set Ethnicity to choose the source. 



For Nursery years: Update Funded Hours - Clicking on this will take you to a table that contains hours and funding information required in the School Census for Early Years and Nursery students. This data is not reported for 4-years-olds in Reception, so Reception students are not included in the table. For each individual student the number of funded hours allowed depends on the student's age and NC year.

Please note, for students that are not entitled to extended hours paid for by the government, do not enter anything into the Extended hours field. Hours paid for by the child’s parents or the school should only contribute to the Hours at setting total.

You can update an individual student’s hours by clicking on their name. You’ll need to ask the parents if you do not know a child’s code.



You can also add some information in bulk, but you will still need to add the codes in by clicking on the students. 



If a student is 2 and has funded hours, you'll need to add a funding basis. Click the student's name to add a funding basis (this cannot be updated in bulk).


Update School Led Tutoring Hours - If you have recorded a student as being in receipt of School led tutoring funding, you must add their number of tuition hours.

Click into the filters to select your date range and student group - by default this will show the current term and the lowest NC year group at your school. We recommend setting the date range from the start of the academic year to census day so you can easily see the hours that will be reported in the census.

The page will then show you a list of students in that group who have been logged as having School led tutoring funding. To add hours, tick the boxes next to the students you wish to log hours for, then select the blue pencil icon to click Update School Led Tutoring Hours.



In the slide over, select how many hours should be input into each week's column, and set the date range these hours should be applied for.



If you've set your date range to be from the start of the year until census day, the number in the Total Hours column will be what is output in the census. Please note that because this is a week view, your census will include any hours that take place on the Friday after the census.



For students 11+: Update YSSA - If you have students whose information you are sharing with Connexions etc make sure that this is noted in the Youth Support Services Agreement section.



If you’re not requesting this information, you can mark your students as Unsaught.



What to do next

Once you've checked your site and filled in any missing data using the instructions above, you can get started on your census. 

Once the census dry run is open, you can run your dry run census and get it ready for submission. See here for when the dry run opens and to access your full census guide: School Census help and guidance

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



Please sign in to leave a comment.