BTEC Business Extended Diploma Grade Calculator

I was wondering if anyone could help me calculate my grades for Btec Business Level 3 Extended Diploma.I am aiming for DDD.
These are my grades so far:
Unit 1 Exploring Business- M
Unit 2 Developing a marketing campaign- P
Unit 3 Personal and business finance - N|P
Unit 8 Recruitment and Selection - P
Unit 14 Investigating Customer Service - M
Unit 16 Visual Merchandising- D
Unit 24 Employment Law- D
Unit 4 Managing an Event- D
Unit 19 Pitching an event- Predicting: D
Unit 7 Business decision making Predicting: M

What does N|P mean for Unit 3? Was it a Pass or Near Pass?

I haven't checked, but I'm fairly sure that the BTEC Nationals Level 3 Extended Diploma in Business contains 13 units. So do you have a prediction for your remaining units? Or are you try to establish what you need to get in them for DDD overall?

Unit 5- D Predicted
Unit 6- M Predicted
Unit 9-D Predicted
For unit 3 I got a near pass
I want to know What would I get overall with all of my grades?

I was wondering if anyone could help me calculate my grades for Btec Business Level 3 Extended Diploma.I am aiming for DDD.
These are my grades so far:
Unit 1 Exploring Business- M
Unit 2 Developing a marketing campaign- P
Unit 3 Personal and business finance - N|P
Unit 8 Recruitment and Selection - P
Unit 14 Investigating Customer Service - M
Unit 16 Visual Merchandising- D
Unit 24 Employment Law- D
Unit 4 Managing an Event- D
Unit 19 Pitching an event- Predicting: D
Unit 7 Business decision making Predicting: M

I’m thinking to retake unit 3 anyways to get my near pass up but essentially my other Distinctions make up for it. But thank you very much!

If your predictions are accurate, you have a minimum of DDM overall and a maximum of DDD overall.
I realise that's a tad vague, but it's because of the way external units are handled in BTECs. Every grade gives you a certain number of points (depending on the grade and the size of the unit, in guided learning hours - GLH). However, for external units (the ones with exams) they adjust the points based upon your mark (not just your grade). For example, a 120 GLH external unit (like Unit 6 or Unit 7) earns you 20 points for a Merit and 32 points for a Distinction. However, if your mark was half-way between the M and D grade boundaries, you get 26 points (i.e. have way between the M points and the D points). So unless you happen to know you mark per exam, all I can give you are minimums and maximums.
You can see these minimum and maximum overall grades below (note that the Unit Grade for each unit is identical in both calculations - it's the Unit Points for the external units which are different):


(Do feel free to check I've entered your unit grade correctly!)
You will note that you overall points range from 200 to 230. For a DDD you need 216. So it's 50/50 whether you get DDM or DDD.

Hi, can I ask where you found this spreadsheet and how to use it please

for all my units, unit 1,4,5,8,10,13,14,18,27 and for the exam i got pass for unit 2 and 3. for unit 6 and 7 i got a near pass. what overall grade will i get? because i need a DDM

i got 48 marks on unit 2 exam

distinction on unit 3 exam

51 on unit 7 exam

48 on unit 6 exam

n distinctions on all assignments
what will my final overall grade be for btec business level 3 extended diploma

Your most likely grade is D*D*D. It's impossible to be entirely sure as the grade boundaries move about and you haven't mentioned when you took each of those exams. I calculate you as having 269 BTEC points from those grades, where 252 are needed for a D*D*D and 270 are need for a D*D*D*. So it's possible you'll actually just scrape a D*D*D*.
See mock-up below (using random optional units):

what would it be if I had got a pass (39/42 on unit 2), merit in unit 3, merit in unit 6 and pass in unit 7, then distinction in all coursework units.

For what BTEC subject? (Applied Science, Business, Engineering, etc.)
For what BTEC size? (Extended Certificate, Foundation Diploma, Extended Diploma, etc.)

what would it be if I had got a pass (39/42 on unit 2), merit in unit 3, merit in unit 6 and pass in unit 7, then distinction in all coursework units.

Business level 3 extended diploma

Your most likely grade is D*D*D. It's impossible to be entirely sure as the grade boundaries move about and you haven't mentioned when you took each of those exams. I calculate you as having 269 BTEC points from those grades, where 252 are needed for a D*D*D and 270 are need for a D*D*D*. So it's possible you'll actually just scrape a D*D*D*.
See mock-up below (using random optional units):