Update information for students in bulk - UCIs, funded hours, YSSA

There are a few fields in Arbor you can fill in in bulk for students. You can find them by going to Students > All Students > Bulk Update or in School > Data > Data Quality Dashboard > Students.

Permissions

• 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.

Contact Details

This section includes three pages for updating and resolving errors in student email addresses, telephone numbers and postal addresses.

Need to ignore a few errors in bulk? Just select the boxes next to the rows, then click the Bulk action button to select Bulk Ignore.

You can also click on the error to resolve it by updating the information or choosing to ignore the error.

Bulk Update Student Contact Details

There is another page where you can update student phone numbers, emails and addresses for all students this academic year. Go to Students > All Students > Bulk Update > Student Contact Details.

You can change the date range using the filters at the top of the page, and sort the columns to find missing details. To update the phone number or email address, click the field to type into it.

Identity

Assign UPNs

This page shows all students that don't have a UPN assigned. Use the bulk actions, or click into a blank UCI field to update it. You can see more details here: Assigning UPNs in bulk

Assign ULNs

You can see more details here: Bulk adding ULNs

Bulk assign UCIs

This page shows all students whether or not they need a UCI. Use the bulk actions, or click into a blank UCI field to update it. You can see more details here: Adding and editing exam candidate Unique Candidate Identifiers (UCIs)

Demographics

Basic Student Details

This section 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 click the Bulk action button to select Bulk Edit Ethnicity source to choose the source. You can see more information about the available options here.

Student Funding Records and School Led Tutoring Hours

These pages are for school to update which students are eligible for funding, and the hours taken of School Led Funding:

• You need to record which funding students are eligible for, if any. For example, you may need to report on some student's top-up funding indicator for the census. You can see more details here: Adding top up funding to a student
• If you have recorded a student as being in receipt of School led tutoring funding, you must add their number of tuition hours: Record the number of tuition hours

Core Learning Aims, Learning and EEP Hours and GCSE Attainment for Funding

These pages are for schools with Post-16 students to:

• record learning aims for Programmes of Study: Programmes of Study and Core Learning Aims for Post-16
• record the time spent on different activities for the census: Planned learning and EEP hours
• record past GCSE attainment in English and Maths: Adding prior attainment for English and Maths

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. 

Top Tip: You can upload a spreadsheet of these details in bulk: Entity Importer for setting up your site from scratch or adding new data

You can update an individual student’s hours by clicking on their name.

• 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’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 YSSA

For students who are 11+ you'll need to record who's information you are sharing with Connexions. You can see more information on this on the DfE's website here. Top Tip: This information is not required in the Census for Primary Schools.

Tick the students then click the Bulk action button to update the value. If you’re not requesting this information, you can mark your students as Unsought.