Can't calculate my BTEC grade using the Pearson BTEC National calculator

Watch
Announcements
#1
Hi there, I've been trying to calculate my grade units for the Business diploma part of my course for days, however I couldn't do it using the BTEC National calculator as I couldn't even find the mandatory units there. I really need help to calculate my overall 2 A-level grade and I would appreciate if anyone could do it for me. I have done units 1, 2, 3, 4, 5, 6, 19 and 27 in Business level 3 diploma and I have gotten respectively, M, P, P, D, D, P, D, D. What would these unit grades amount to in terms of a 2 A-level grades for my BTEC? Thank you for any responses.
0
11 months ago
#2
(Original post by A-Yellow-Spring)
Hi there, I've been trying to calculate my grade units for the Business diploma part of my course for days, however I couldn't do it using the BTEC National calculator as I couldn't even find the mandatory units there. I really need help to calculate my overall 2 A-level grade and I would appreciate if anyone could do it for me. I have done units 1, 2, 3, 4, 5, 6, 19 and 27 in Business level 3 diploma and I have gotten respectively, M, P, P, D, D, P, D, D. What would these unit grades amount to in terms of a 2 A-level grades for my BTEC? Thank you for any responses.
I assume it is an NQF 2016 course. When you open the spreadsheet cells for rows 9 - 16 are minimised. What you need to do is open and save as, then drag on the cells so that all of the Mandatory units are showing.
You will then be able to input your grades. However for the externally examined units, you need to put in your points and not the grade. You will then be able to calculate the overall grade.
Last edited by bamtutor; 11 months ago
0
#3
(Original post by bamtutor)
When you open the spreadsheet cells for rows 9 - 16 are minimised. What you need to do is open and save as, then drag on the cells so that all of the Mandatory units are showing.
You will then be able to input your grades. However for the externally examined units, you need to put in your points and not the grade. You will then be able to calculate the overall grade.
How do I open the rows for 9-16?
0
11 months ago
#4
(Original post by A-Yellow-Spring)
How do I open the rows for 9-16?
You place your mouse over the numbers in the very first left hand column and drag them down one at a time until they show.
0
#5
(Original post by bamtutor)
You place your mouse over the numbers in the very first left hand column and drag them down one at a time until they show.
I tried to drag them down but I still can't find them.
0
11 months ago
#6
(Original post by A-Yellow-Spring)
How do I open the rows for 9-16?
When I opened it they weren't minimised. However you need to put the points and ot the grade in for each unit - if you haven't discovered this then you may have been looking at the wrong spreadsheet. It's the one called BTEC Nationals here https://qualifications.pearson.com/e...alculator.html
0
#7
(Original post by Compost)
When I opened it they weren't minimised. However you need to put the points and ot the grade in for each unit - if you haven't discovered this then you may have been looking at the wrong spreadsheet. It's the one called BTEC Nationals here https://qualifications.pearson.com/e...alculator.html
I always download the BTEC Nationals calculator from this website, but whenever I download it and open it on Excel it always just does this and hides the rows from 8-19
0
11 months ago
#8
If you look at your photo rows 9 - 18 are not showing. Place mouse on top of 19 and try dragging up and down until 18 shows, then do that for all
0
#9
(Original post by bamtutor)
If you look at your photo rows 9 - 18 are not showing. Place mouse on top of 19 and try dragging up and down until 18 shows, then do that for all
It is still not working, even though I tried dragging up and down. I still can't find the 18th row.
0
11 months ago
#10
I’m on my phone so can’t check, but maybe google ‘How do I show hidden rows on Excel’
0
11 months ago
#11
Select the two rows (8 and 19) right click and it should bring up an option to unhide rows
0
11 months ago
#12
0
11 months ago
#13
The rows are hidden by a macro - you can get to them but it's easier to do what they want you to do which is to enter your subject at the top.

If you select Business in the orange 'Select Sector' box at the top then the rows you need should automatically appear. If they don't then try going to another sheet of the spreadsheet and back and then try again.
Last edited by Compost; 11 months ago
0
11 months ago
#14
You can also manually click or drag to expand a hidden row. Hidden rows are indicated by a thicker border line. Move your cursor over this line until it turns into a double bar with arrows. Double click to reveal or click and drag to manually expand the hidden row or rows. (If you've hidden multiple rows, you may have to do this multiple times
or;
1. To unhide all hidden rows in Excel, navigate to the "Home" tab.
2. Click "Format," which is located towards the right hand side of the toolbar.

3. Navigate to the "Visibility" section. You'll find options to hide and unhide both rows and columns.

4. Hover over "Hide & Unhide."

5. Select "Unhide Rows" from the list. This will reveal all hidden rows, a feature especially helpful if you've hidden multiple rows throughout a large spreadsheet.
Last edited by bamtutor; 11 months ago
0
11 months ago
#15
(Original post by bamtutor)
You can also manually click or drag to expand a hidden row. Hidden rows are indicated by a thicker border line. Move your cursor over this line until it turns into a double bar with arrows. Double click to reveal or click and drag to manually expand the hidden row or rows. (If you've hidden multiple rows, you may have to do this multiple times
or;
1. To unhide all hidden rows in Excel, navigate to the "Home" tab.
2. Click "Format," which is located towards the right hand side of the toolbar.

3. Navigate to the "Visibility" section. You'll find options to hide and unhide both rows and columns.

4. Hover over "Hide & Unhide."

5. Select "Unhide Rows" from the list. This will reveal all hidden rows, a feature especially helpful if you've hidden multiple rows throughout a large spreadsheet.
The rows are hidden as part of the functionality of the spreadsheet. If the OP just selects their subject in the drop down at the top then the rows they need will appear
1
#16
Hello , I've tried all of the tips that you teo gave me, however whenever I click on the "unhide rows/columns" option, nothing happens. The only thing that I have discovered is that there is another drop down box above the grade inputs.
0
#17
0
#18
I can tell that there is a space between row 8 and 19 however no matter what I try it just won't do anything for me, could one of you input my grades in for me please? I don't think I will be able to do that myself.
Last edited by A-Yellow-Spring; 11 months ago
0
11 months ago
#19
Who does btec applied science ?
0
#20
(Original post by Kueno Oscar)
Who does btec applied science ?
There is an applied science forum in the BTEC section.
0
X

new posts
Back
to top
Latest
My Feed

Oops, nobody has postedin the last few hours.

Why not re-start the conversation?

see more

See more of what you like onThe Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Poll

Join the discussion

Yes (96)
27.51%
No (253)
72.49%