Converting Marks to PointsThe conversion from marks isn't terribly straight forward, unfortunately.
I'll use your previous Unit 7 mark of 23/50 as an example. You took that in January 2023, so we look up the grade boundaries for that exam series
here. Within that document you'll find "BTEC Level 3 Nationals in Applied Science" on page 6, where is shows that for Unit 7 you'd need 16/50 for a Pass and 25/50 for a Merit. That's a 9 mark difference. You'll also see that is a 120 GLH unit.
On page 3 you'll see that a Pass in a 120 GLH unit earns you 12 points and that a Merit earns you 20 points. An 8 point difference. Below that table it says, "Points are awarded on a sliding scale between the grade boundaries based on the number of raw marks achieved by each learner." This "sliding scale" means that if you were half-way between a Pass and Merit in terms of marks, then you'll be awarded the points half-way between a Pass and a Merit.
Or, to put in another way, each 1 mark between a Pass and a Merit in Unit 7 for January 2023 earns you 8/9 of a point above that which you would have got for a "minimal" Pass of 16/50. So you'd have got 12 points for the Pass, plus 8/9 x 7 - because you were 7 marks over the Pass boundary of 16/50. That's 12 (the points for a 16/50 pass) plus 6.22 points from the "sliding scale" part, or 18 points (rounding down). That's why in the spreadsheet I had this unit down as 18 points.
I did tell you is wasn't very straight forward!
January 2022 vs. January 2023Earlier I said, "I've used the January 2023 boundaries below as the January 2022 boundaries were slightly lower and the June 2022 boundaries were slightly higher - so they're a reasonable approximation of a mid-point."
For Unit 1 you got 44/90. The January 2023 boundaries (which I'd used) were 41 for a Merit and 59 for a Distinction, whilst the January 2022 boundaries were 40 for a Merit and 58 for a Distinction.
Using the January 2023 boundaries, I did:
15 + ((24 - 15) / (59 - 41)) x 3 = 15 + (9 / 18) x 3 = 16.5 (which I rounded down to 16, as I assume that's what they'd do)
Using the January 2022 boundaries, I get:
15 + ((24 - 15) / (58 - 40)) x 4 = 15 + (9 / 18) x 4 = 17.0
For Unit 3 you got 34/60. The January 2023 Merit boundaries were 26 for a Merit and 38 for a Distinction, whilst the January 2022 boundaries were 27 for a Merit and 39 for a Distinction.
Using the January 2023 boundaries, I did:
20 + ((32 - 20) / (38 - 26)) x 8 = 20 + (12 / 12) x 8 = 28
Using the January 2022 boundaries, I get:
20 + ((32 - 20) / (39 - 27)) x 7 = 20 + (12 / 12) x 7 = 27
So the change in grade boundaries moves your points for Unit 1 up by 1 and for Unit 3 down by 1. So you'd still be on 192 points (DMM) if Unit 10 and Unit 19 are a Pass and Unit 21 stays at a Merit.