+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, Average Points Score and Best 8 Capped in Technical; Hello, Does anyone know how the DofE works out average point score and best 8 (capped) point score for pupils? ...
  1. #1

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Average Points Score and Best 8 Capped

    Hello,

    Does anyone know how the DofE works out average point score and best 8 (capped) point score for pupils?

    This is the explanation document from the DofE website (TECHNICAL ANNEX) but the figures I get using this method don't make sense and apparently the document is years out of date (point scores for GCSE grades are old - i.e. A*=4; A=3.5; B=3...)

    Does anyone know how its done?

    Thanks in advance,

    Ben

  2. #2

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0
    OK - the above is a live link on the DofE website to an out of date document.

    The present method of calculation can be found here (Value added technical information)

    Ben

  3. #3
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    Are you trying to do this for yourself? I was asked to do this based off of my school's targets/estimated grades, so I exported the year 11 marksheet (which held the data) to Excel - I gave point values to A*, A, B, etc. (using find/replace - for A* that's "A~*") I then made the targeted columns a named range, and the estimated columns a named range. Inserted a column at the end of the sheet, and put in a formula that was like:

    =AVERAGE(LARGE(Estimated 2:2, {1,2,3,4,5,6,7,8})) - replacing "Estimated" with "Target" for the target column, and changing the amounts for students that aren't taking 8, after running it, I used the Ready Reckoners sheet that was passed to me via an email and checked our estimated VA against last years actual VA, and they were pretty close, so I feel like this is what was requested of me (may not be what you are trying to do though)

  4. 2 Thanks to tombry:

    park_bench (2nd March 2012), tmcd35 (4th December 2012)

  5. #4

    Join Date
    Feb 2012
    Location
    Glossop
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I am trying to do the same calculation, without having to put 200-odd students individually into Raiseonline's Ready Reckoner. The method described here: education.gov.uk/schools/performance/secondary_11/KS2-4_General_VA_Guide_2011_FINAL_AMENDED.pdf - pages 15-16 - seems considerably more complicated than the method described in the link posted by tombry above. I'm a bit confused about which method to use now!
    Thanks
    John

  6. #5
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    I haven't messed with the individual student one yet - only the whole school one.

  7. #6

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by tombry View Post
    Are you trying to do this for yourself? I was asked to do this based off of my school's targets/estimated grades, so I exported the year 11 marksheet (which held the data) to Excel - I gave point values to A*, A, B, etc. (using find/replace - for A* that's "A~*") I then made the targeted columns a named range, and the estimated columns a named range. Inserted a column at the end of the sheet, and put in a formula that was like:

    =AVERAGE(LARGE(Estimated 2:2, {1,2,3,4,5,6,7,8})) - replacing "Estimated" with "Target" for the target column, and changing the amounts for students that aren't taking 8, after running it, I used the Ready Reckoners sheet that was passed to me via an email and checked our estimated VA against last years actual VA, and they were pretty close, so I feel like this is what was requested of me (may not be what you are trying to do though)
    Hi I am trying to do this for myself but it is complex. The method you describe is good but it doesn't take into account the fact that different courses have different GCSE equivalences (Depending on how your data is set up I guess) and that short courses are only worth 0.5 of a GCSE although they could be one of the top results.

    It is tricky... I'm working on it though.

  8. #7
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30
    Challenge accepted!

    Lawks, it looks like a tough one though.

  9. #8
    tombry's Avatar
    Join Date
    Jan 2012
    Location
    Bassingbourn
    Posts
    194
    Thank Post
    45
    Thanked 37 Times in 29 Posts
    Rep Power
    22
    Quote Originally Posted by park_bench View Post
    Hi I am trying to do this for myself but it is complex. The method you describe is good but it doesn't take into account the fact that different courses have different GCSE equivalences (Depending on how your data is set up I guess) and that short courses are only worth 0.5 of a GCSE although they could be one of the top results.

    It is tricky... I'm working on it though.
    Yeah I was asked to do it and told the weights didn't matter for what I was doing - I think it was a reduced list of students though.

    I'll have to work on the proper one eventually, but I have a whole ton of stuff to focus on first.

  10. #9

    Join Date
    Mar 2012
    Posts
    17
    Thank Post
    3
    Thanked 6 Times in 4 Posts
    Rep Power
    7
    Hey

    I was tasked with doing this earlier this in the year and set up an Excel sheet to do this for me. If you want a copy PM me and I'll email it to you.

  11. #10

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,686
    Thank Post
    850
    Thanked 899 Times in 744 Posts
    Blog Entries
    9
    Rep Power
    329
    Quote Originally Posted by tombry View Post

    =AVERAGE(LARGE(Estimated 2:2, {1,2,3,4,5,6,7,8}))
    This looks like what I'm looking for, but I have an additional complication I wonder if an Excel expert could help me out on.

    I am using VLOOKUP to bring the point scores for each GCSE subject into 1 table. Now no pupil does every GCSE subject, so for the subject they are not taking excel puts a '#N/A' in that column. The above formula is not taking this in to account and always returns '#N/A'.

    Anyone got any ideas. Maybe I can alter the VLOOKUP to return '0' instead of #N/A if the pupil can't be found in the referenced subject table?

  12. #11

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,686
    Thank Post
    850
    Thanked 899 Times in 744 Posts
    Blog Entries
    9
    Rep Power
    329
    Scrap that! Answered my own quetion:

    <code>
    =IFERROR (VLOOKUP(a1,target!a1:z99,4,FALSE),0)
    </code>

  13. #12
    skunk's Avatar
    Join Date
    Mar 2006
    Location
    North West
    Posts
    311
    Thank Post
    88
    Thanked 40 Times in 33 Posts
    Rep Power
    30
    I tend to use the following:

    <code>
    =if(a1="","",VLOOKUP(a1,target!a1:z99,4,FALSE))
    </code>

    as this shows any errors that are not related to having a blank cell a1.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 9th December 2011, 10:05 AM
  2. Replies: 2
    Last Post: 29th October 2011, 04:59 PM
  3. Rep points scores
    By FN-GM in forum General Chat
    Replies: 14
    Last Post: 6th May 2009, 09:44 AM
  4. Sophos EC and best practice
    By FatBoy in forum Windows
    Replies: 8
    Last Post: 17th November 2007, 09:37 AM
  5. Implementing best practice ICT management and support
    By FITS in forum Courses and Training
    Replies: 16
    Last Post: 8th September 2005, 02:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •