P6 Templates

Document Sample
P6 Templates Powered By Docstoc
					     Using the
ToPP Tracking Grids




Produced by:                Lisa Steward
Technically reviewed by:    Dawn Mears
Team:                       Training
Date:                       11/9/2008
Version:                    1

www.ccceducation.net
Education Portal Resource   2630
ID number:
Introduction to ToPP Tracking Grids................................................................... 3
The Quick Start Guide to Using the Grids ........................................................ 6
  Importing the Grids ............................................................................................. 6
  Finding the Grids .................................................................................................. 6
  Using Termly Tracking Grids ............................................................................. 7
  Using Expectation Grids ..................................................................................... 8
  Using Yearly Tracking Grids.............................................................................. 11
  Using the Comparing Subjects Grid ................................................................12
  Saving Grids ..........................................................................................................13
Further techniques - Making even more of your grids ...................................14
  Filters .....................................................................................................................14
    Filter to show SEN pupils ..............................................................................15
    Create & Save a Filter for SEN girls..........................................................16
    Clearing Filters .................................................................................................16
    Mobility and Filtering by Academic Year of Admission..........................17
    Filtering by ‘Excluding’ ...................................................................................17
  Target Formulas ...................................................................................................18
  Summary Rows ......................................................................................................18
  Using Actions menu .............................................................................................19
  Printing ...................................................................................................................19




                                                     Page 2 of 19
Introduction to ToPP Tracking Grids

We have developed these grids to work hand in hand with the ToPP
marksheets. You must be recording regular assessments in these
marksheets to make best use of the grids. If you do not use ToPP
marksheets, but want to know more, then please contact the Education
ICT Helpline on: 0845 0450973.

There are four types of ToPP Grid Templates:

Termly tracking (1a. – 1f.) Y1 to Y6 grids show four assessments: the
summer of the previous year, December, Spring and Summer of the
current year. The grids can be used to analyse one group of pupils at a
time.




Expectation (2a.- 2f.) grids show progress over KS1 and KS2 and are
similar to the Nottinghamshire Tracking Grids which you may already be
using. The pink cells on the grids suggest what levels pupils are expected
to be at given their assessment at the start of the Key Stage.




                               Page 3 of 19
The Year Group tracking (3.) grid shows the most recent assessment for
Year 1 to Year 6 in one glance. It gives you a picture of attainment
across KS1 and KS2 in the subjects you choose to analyse.




Yearly tracking (4.) shows the end of year assessment for a group of
pupils from Y1 to Y6.




Comparing Subjects (5.) allows you to compare attainment in two
subjects for the group of your choice.




                              Page 4 of 19
Coloured Target Cells

On each of the grids you will see coloured cells with a ‘T’. These are the
equivalent of those plotted on the ‘Yellow Brick Road’. They indicate
levels that the majority of pupils would be expected to attain by the end
of the academic year and can be used for comparison. They are also used
as ‘target’ values for calculations and each of the grids can show you what
percentage or count of pupils below, at or above this target, or ‘on track’.

Year               Below Target        On Target          Above Target
Year 1             Lower   than 1a     1a, 2c             Higher than 2c
Year 2             Lower   than 2b     2b, 2a             Higher than 2a
Year 3             Lower   than 2a     2a, 3c             Higher than 3c
Year 4             Lower   than 3b     3b,3a              Higher than 3a
Year 5             Lower   than 3a     3a, 4c             Higher than 4c
Year 6             Lower   than 4b     4b, 4a             Higher than 4a




                               Page 5 of 19
The Quick Start Guide to Using the Grids
Importing the Grids

      Search for ToPP resources on the portal:Resource ID 2630
      Click on the link ‘Tracking Grids’ and click ‘File/Save As’ and save to
       a suitable location ready for import

In Sims

      Click Routines/Data In/Performance Analysis/Import
      Click on the ‘Browser’ to the right of the dialogue box
      Navigate to the file you have just downloaded and click ‘open’
      Click ‘Next’
      Click ‘Select All’ for tracking grids
      Click ‘Select All’ for group patterns
      Click ‘Finish’
      Click ‘Yes’
      Read the grey import log – only print if import failed
      Click ‘Close’

Finding the Grids

    Click Focus/Assessment/Tracking grids
You will see a screen similar to the one below:




Figure 1


This area lists any Grid Templates which have been imported

The panel on the right lists any grids which you have saved for future
reference. It will be empty to start with.

                                Page 6 of 19
Using Termly Tracking Grids

Make sure you can see the list of templates shown in Figure 1 (P6).

      Double click on the template ‘1a. ToPP Y1 Termly Tracking’.

You will see the layout of the grid as shown below:




To begin to use any of the ‘Termly Tracking Grids’ there are three things
you must do:

1 Choose the subject you want to analyse
   Click on the arrow next to ‘Assessment’ and choose ToPP Maths

2 Choose the group of pupils you want to focus on
   Click on the ‘browser’ next to ‘Source Group’/expand Year
     Group/click on Y1/Apply

3 Populate the grid with names
   Click on Populate

You now have a very useful grid which shows the names of Year 1 pupils
plotted into the the grid according to their teacher assessments which
have been recorded in December, Spring and Summer.

There are 7 Tracking grids available (1a, 1b, 1c, 1d, 1e, 1f, 1g).




                                 Page 7 of 19
Using Expectation Grids
Make sure you can see the list of templates shown in Figure 1 (P6).

      Double click on ‘2b ToPP Y1-Y2 Expectations’ Grid Template

You will see the grid layout similar to the one below:




To begin to use any of the ‘Expectation’ grids there are five things you
must do:

1 Choose the subject you want to analyse
   Click on the arrow next to ‘Assessment’ and choose ToPP Maths

2 Choose the group of pupils you want to focus on
   Click on the ‘browser’ next to ‘Source Group’/expand Year
     Group/click on Y2/Apply

3 Choose the correct result set for the columns
   Right click on a column heading

You will see the following menu:



      Click ‘Select Result Set for
       Columns’
      Click on ‘Y2 Summer’ (vital for
       this particular grid)
      Click ‘Select’


                                Page 8 of 19
4 Choose the correct result set for the rows

      Right click on the row headings.

You will see the following menu:

      Click ‘Select Result Set for Rows’
      Click on ‘Y1 December’ (vital for this Y1-Y2
       grid)

5 Populate the grid with names
   Click on Populate


There are 6 ‘Expectation’ grids available (2a, 2b, 2c, 2d, 2e, 2f).



It is vital that the correct Result Sets are chosen according to the grid
you wish to work on. Follow the table below and all will be well!



Grid Template           Result Set Rows            Result Set Columns
2a: Y1-Y1               Y1 December                Y1 Summer
2b: Y1-Y2               Y1 December                Y2 Summer
2c: Y2-Y3               Y2 Summer                  Y3 Summer
2d: Y2-Y4               Y2 Summer                  Y4 Summer
2e: Y2-Y5               Y2 Summer                  Y5 Summer
2f: Y2–Y6               Y2 Summer                  Y6 Summer




                                Page 9 of 19
Using Year Group Tracking Grids
Make sure you can see the list of templates shown in Figure 1 (P6).

      Double click on ‘3. ToPP Y1-Y6 Year Group Tracking’ Grid Template

You will see the grid layout shown below:




To begin to use the ‘Year Group Tracking Grids’ there are two things you
must do:

1 Choose the subject you want to analyse
   Click on the arrow next to ‘Assessment’ and choose ToPP Maths

2 Populate the grid with names
   Click on Populate

The position of the pupils is determined by the most recent teacher
assessment the system can find. It is therefore very important that all
assessments are up to date in the ToPP marksheets before this grid is
used.

If you want to save the grid, take care to give it a useful name and then
click ‘Save’.

There is only one ‘Year Group Tracking’ Grid Template since this shows
attainment of current Y1 to Y6 on one grid.


                              Page 10 of 19
Using Yearly Tracking Grids
Make sure you can see the list of templates shown in Figure 1 above.

      Double click on ‘4. ToPP Y1-Y6 Yearly Tracking’ Grid Template

You will see the grid layout shown below (colours may be different!):




To begin to use the ‘Yearly Tracking Grids’ there are three things you
must do:

1 Choose the subject you want to analyse
   Click on the arrow next to ‘Assessment’ and choose ToPP Maths

2 Choose the group you want to analyse
   Click on the browser next to Source Group and choose Y3

3 Populate the grid with names
   Click on Populate



There is only one ‘Yearly Group Tracking’ Grid Template since the layout
is the same for all year groups.




                               Page 11 of 19
Using the Comparing Subjects Grid

Make sure you can see the list of templates shown in Figure 1 above.

      Double click on 5. Comparing Subjects




To begin to use the ‘Comparing subject’ grid there are 6 things you must
do:
1 Choose the subject you want for the columns
     Click on the arrow next to ‘Assessment’ and choose ToPP Maths

2 Choose the subject you want for your rows
   Right click on the row heading
   Choose ‘Select assessment for rows; and choose ToPP Writing

3 Choose the ‘Result set for the rows
   Right click on the row heading
   Choose ‘Select Result Set for Rows’
   Choose ‘Year 5 Summer’

4 Choose the Result Set for the columns
   Right click on the column heading
   Choose ‘Select Result Set for Columns’
   Choose the same result set as before ‘Year 5 Summer’

5 Choose the group you want to analyse
   Click on the browser next to Source Group
   Choose Year 5

6 Populate the grid with names
   Click on Populate




                              Page 12 of 19
Saving Grids

You may want to save the grid you have been working on – it will save you
choosing result sets, subjects etc next time you want to look at it.

To do this:
    Adjust the name to something
      meaningful (adding subject would
      be useful)
    Click ‘Save’



The grid you have saved will be listed in the ‘My saved grids’ panel on the
right next time you go to use the tracking grids.

      Focus/Assessment/Tracking grids:




                               Page 13 of 19
Further techniques - Making even more of your grids

This section explains other areas to explore on your grids:
      Filters
      Formulas
      Colouring

Filters

It is possible to filter the group of pupils on your grid, for example filter
Year 6 so that you just see SEN pupils. It is also possible to combine
filters, for example, you could just see girls with SEN. You can use the
filters as a ‘one off’ but you can also save filters which you think will be
of future use on any grid or marksheet.

All of the techniques explained below can also be used in Assessment
Manager marksheets using the same ‘Group Filter’ options.

The screen shot below shows a typical ToPP grid – it shows the whole of
Y6. The ‘Group Filter’ option is here:




                                Page 14 of 19
In this example you will first of all filter for all of our SEN pupils. You
will then filter for our SEN girls. You will then save the filter for future
use on any grid or marksheet. Finally you will clear the filter

Filter to show SEN pupils
      Click on the browser next to the Group Filter




      Click on the + next to SEN status
      Tick the boxes shown below

The choices you have made will turn blue

      Click Apply

You will now see just the SEN pupils on
your grid.




                               Page 15 of 19
Create & Save a Filter for
SEN girls

      Click on the Group
       Filter browser again
      Click New
      Expand ‘Gender’
      Tick Female
      Enter a name in the
       ‘Filter name’ box
      Take the tick out of
       ‘Private’ if you wish
       others to use this
       filter
      Click Save

The filter will now appear in
the list at the top as shown
right.

Click ‘Apply’

You will now see SEN girls on
your grid.


Clearing Filters

If a filter has been applied to a marksheet
or a grid, you will see either the name of the
saved filter or ‘Filter applied’ as shown
right. To clear the filter:

      Click on the ‘Group Filter’ browser
      Click on ‘Clear Selection’

You will be back to the whole of the ‘Source
Group’ (in this case, Year 6)




                                Page 16 of 19
Mobility and Filtering by
Academic Year of Admission

It is possible to filter according to
when the pupils joined the school.
It will be difficult to do this for
pupils who joined you before
Sims.net existed, however for
other pupils it is straightforward.

      Click on the ‘Group Filter’
       browser
      Click on + next to Academic
       Year of Admission
      Tick Relevant Year
      Click Apply



It is possible to narrow it down by term. To do this:

As before but also
    Click also on + next to the Academic
      Year you have chosen
    Tick term/s as appropriate
    Click ‘Apply’




Filtering by ‘Excluding’

Using a filter to exclude pupils can
sometimes be effective e.g not SEN or not
White British. See the choices below for
not White British filter:

      Click ‘Exclude’
      Click those to be excluded from the
       grid



                                Page 17 of 19
Target Formulas

In grids where targets cells (T) are present, you can decide to show a
percentage or count of those below, on and above target.




To do this on a grid:

      Click on ‘Summary Columns’
      Tick either Count or Percentage

The results will be displayed at the far
right of the grid.


Summary Rows

A summary row showing the count of pupils at each level can be shown.
You can also show the count by gender.




To do this:

      Click ‘Summary Rows’
      Tick either or both ‘Show Summary Rows’ and ‘Split results by
       Gender’




                               Page 18 of 19
Using Actions menu

Try out the Actions menu. Larger font is particularly useful, so too is the
options to paint cells with colour and show or hide empty columns.




Printing

Do try printing straight from the grid, however you may find it useful to
export it to Excel and then delete any unwanted rows and use Print
Preview to get exactly what you’re after. I’d definitely recommend using
the ‘Larger font’ options, shown above, a couple of times before
exporting.




                              Page 19 of 19

				
DOCUMENT INFO
Description: P6 Templates document sample