1. Open Excel
2. File > Open > Browse for File
3. Click OK at all prompts

Select the DOB filter dropdown.

Untick all

Tick any dates after 31/8/2022

Note down the children with these DOB

Checking DOB

If you do need to assess these children in Target Tracker please follow these instructions to edit the DOB of these children in the file.

NB: As you are having to amend the DOB for Target Tracker to accept the file, the DOB of the children will be wrong in Target Tracker so only do this if you accept this and make staff aware. You will also need to Year Group Modify these children when they are initially imported to ensure that they are assessed in the correct year group (Pre2 for children born 1/9/22-31/8/23) – see below.

To Edit:

1. Go to where the CTF is saved
2. Right click and ‘Open with……notepad or wordpad’
3. Select Edit > Find
4. Look for the first name eg Jones
5. Edit the child’s DOB to 2022-08-31;

Eg
<DateOfBirth>2022-09-12T00:00:00+01:00</DateOfBirth>

To

<DateOfBirth>2022-08-31T00:00:00+01:00</DateOfBirth>

Repeat with the rest of the children from your list.

   6. File > Save

Reset the filter from the DOB check

Home > Editing

Clearing the filter

Select the Ethnicity filter dropdown – sometimes labelled group_code            (codes will all be 4 letters eg WBRI)

Can you see any of these codes;

        ABRI, BBRI, ORAB and AWEL?

If not. no need to do any editing of ethnicity codes.

If any or all are in the file, note down which ones – you will need to edit these in the CTF for the file to be valid,

To Edit:

1. Go to where the CTF is saved
2. Right click and ‘Open with……notepad or wordpad’
3. Select Edit > Find
4. Look for each code in turn eg ABRI (NB if these letters are in a name this will show, just ‘Find next’) It will look like this in the file;

Identifying and editing ethnicity code errors

<Ethnicity>ABRI</Ethnicity>

Edit this to;

<Ethnicity>AOTH</Ethnicity>

<Ethnicity>BBRI</Ethnicity>

Edit this to;

<Ethnicity>BOTH</Ethnicity>

<Ethnicity>ORAB</Ethnicity>

Edit this to;

<Ethnicity>OARA</Ethnicity>

<Ethnicity>AWEL</Ethnicity>

Edit this to;

<Ethnicity>AOTH</Ethnicity>

File > Save

In Target Tracker;

1. Select Year group children have been placed in (if DOB edited to 31/08/2022 this will be Pre3)
2. Home > Other > Contextual
3. Select a child whose DOB you have edited to 31/8/2022
4. Edit Pupil
5. Year Group Modify -1
6. Agree at message re data as children new so no data to lose.

You will not need to do this for these children next time, just new ones.

Year Group Modifying in Target Tracker