Step4 -KS2 Targets by 9V72Whf


                                                                                 Step 4

STEP 4 – Setting KS2 Targets – Autumn Term

STAGE A: Setting KS2 Targets after Y5 Targets have been entered

After the Y5 Target levels have been entered, the pupil contextual details can be
copied to the Targets KS2 sheet ready for the collection of KS2 targets at the
beginning of Yr 2.

The Targets KS2 sheet has data entry columns (red text/light blue background) for
KS2 target levels set at beginning of Year 5 and Year 6; points columns converting
target to point score & value added from Yr 4 to KS2 target (blue text/yellow
background); Yr4 levels and points & Yr 5 target columns carried forward to this
sheet (blue text/orange background); and Yr 5 test and TA columns (blue text/grey
background) which will eventually hold end of Yr5 levels and teacher assessments
and points for comparison with target.

To copy the pupil details into the KS2 Targets sheet:

Open the AspireMiddle2003 workbook as normal.

   1. Use <CTRL> & <H> to bring up the menu.

   2. Click on function ‘Yr 5 & KS2 Functions’

   3. Click on the function ‘Copy to KS2 Targets’
      The pupil details have now been carried forward to the KS2 Targets sheet
      with their Yr 4 levels & points and Year 5 targets carried forward.

   4. Make any changes to the pupil names now before any targets are entered –
      DELETE leavers and ADD new starters and/or SORT at this stage. You will
      need to Unprotect the book (from the CTRL-H menu) first before you attempt
      to delete or sort the names.

   5. Add class names and/or set names – this is important if you later want
      separate class or set lists for data collection or summary information.

   6. Save the file by selecting Save from the File menu

Produce KS2 Targets data collection sheet

To assist in the process of collecting targets, use the Print List KS2 Targets function
to produce a collection sheet in a new workbook for printing.

   7. Use <CTRL> & <H> to bring up the menu.

   8. Click on function ‘Yr5 & KS2 Functions’

   9. Click on the function ‘Print List KS2 Targets’

       A new workbook is created with pupil names and the KS2 target columns
       alongside Y5 test levels and TAs (the KS2 test/points columns should be left
       blank) on separate sheets for reading, Writing, Maths & Science.

       Adjust the format to suit your requirements if necessary and print list. You can

                   Information and Communications Technology Team
                                                                            Page 1 of 3
                                                                                   Step 4

       save the workbook for future printing or close the workbook without saving.
       This list can be produced again by simply running the function Print List KS2
       Targets’ again.

   10. Close the AspireMiddle2003 workbook until you are ready to enter the KS2

   When ALL the KS2 targets have been collected, open the AspireMiddle2003
   workbook as normal.

   12. Referring to the data collection sheet, enter the target levels into the
       appropriate target ‘set at Y5’ columns – click on a target cell and click on
       the pull-down list to select a level - the levels should be within the range
       specified in each cell note located at the top of these columns. As you cannot
       select from a pull-down list, you must check that levels are correctly entered!

       What happens when the target levels are entered?
       As the level is entered for each pupil, it is automatically converted to a point
       score and a value added from Yr 4 to KS2 target is calculated.

   13. Save the file each time after levels are entered for each subject.

To produce a hard copy of the targets entered, use the Print List KS2 Targets
function again to produce another new workbook, this time containing all the targets,
for printing.

   STAGE B: Produce KS2 Target Summary

   When all the target levels have been entered for each or all subjects, you can
   produce KS2 Target summaries for Reading, Writing, Maths & Science.

   This function can be run as many times as required BUT each summary
   produced must be SAVED AS your own specified filename so that the original
   summary template file (KS2TargetSummary.xls) is not overwritten. Each time this
   function is run, it will take account of any changes you have made to your Target
   KS2 data and recalculate accordingly.

   1. Use <CTRL> & <H> to bring up the menu.

   2. Click on function ‘Yr5 & KS2 Functions’

   3. Click on the function ‘KS2 Target Summary’

   4. Enter your 4 digit DfES number and click OK

   5. Leave blank and click OK

   6. Choose to summarise by Class, Set or Year – enter the appropriate letter and
       follow the prompt accordingly – note that if you wish to summarise by class,
       class names must be present in column D: to summarise by set, set names
       must be present in cols E,F & G [if class and set names were entered in Y5
       Targets sheet, they will have been copied to this KS2 sheet)

                   Information and Communications Technology Team
                                                                              Page 2 of 3
                                                                               Step 4

   A new workbook opens (filename KS2TargetSummary.xls) with separate
   sheets for Reading, Writing, Maths & Science showing calculations based on
   your targets data for KS2.

19. Select Save As from the File menu – select the folder you wish to save the
   file in (preferably AM2003) and enter an appropriate filename (eg:
   KS2TargetSummary2003]. Click OK.

   This file, subject to your printer settings, should not need adjusting for

When the Year 5 pupils move to Year 6, you will need to revisit the KS2
Targets in AspireMiddle2003 and review KS2 targets. This means either
copying and pasting the target levels from the ‘KS2 Targets set at Y1’
columns to the ‘KS2 Targets reviewed at Y2’ columns for each subject or
manually enter them.

               Information and Communications Technology Team
                                                                          Page 3 of 3

To top