Since my company built and manage the national driver offender retraining scheme (nDORS) platform for NPIA I can give you a bit of insight.
Those that have stated it varies from police force to police force are quite right and there are ACPO guidelines to abide by too as has been mentioned. The one thing I don't think has been mentioned is that there is also an eligibility check. If you've been on a course in the past three years IIRC then you will not be eligible to attend another and will have to take the points/fine.
I recently had to attend a course myself and actually thougyht it was really very interesting. Perhaps it was just the provider (AA) or the instructor, but I gained a lot from it. Some points were obvious but I never really considered. For example my excess speed tends to manifest itself on single carriageway twisty A roads. Turns out this is where there is the highest liklehood of death because the speeds are higher than urban areas and the relative impact speed is significantly higher than motorways because you're going to have a head on crash rather than everyone travelling in the same direction. Obvious, but not something I gave that much thought to. I was also amazed that only me and one other person in the room out of 30 could accurately answer what the national speed limit is on a single carriageway!
To the OP, whilst not unheard of, I doubt very much they'll be offered a speed awareness course. It's not something you can "ask" for either.
