[IAMchocolatee]

I need your help working out my almost overall percentage!!

Module results so far..docx

[tommm]

I have no idea what's going on in that table.

[ttoby]

I'll assume that the exam in which you were absent for counted for zero marks, and that the two cells marked with '-' are the exams you are yet to get results for.

You are sitting on a 3rd.
If you get 4% weighted average in your remaining exams you'll get a 2.2
If you get 79% weighted average in your remaining exams you'll get a 2.1

Now assuming that they let you get away with missing your final French exam and instead had your other two French I exams counting equally towards that module:

You are sitting on a 2.2.
If you get 63% weighted average in your remaining exams you'll get a 2.1

Here is the spreadsheet I used if you want to check over it. To see it, copy and paste the code below into notepad, then copy and paste it from notepad into cell A1 in Excel.

Average remaining score			79				
							
Subject	total Module Credits	Proportion of that module	Score	Contribution to final result			
French I	10	0.2	53	=B4*C4*D4/120			
	10	0.2	33	=B5*C5*D5/120			
	10	0.6	0	=B6*C6*D6/120			Absent
French II	10	0.2	55	=B7*C7*D7/120			
	10	0.2	24	=B8*C8*D8/120			
	10	0.6	=$D$1	=B9*C9*D9/120			
Green	10	1	63	=B10*C10*D10/120			
Blue	20	0.25	69	=B11*C11*D11/120			
	20	0.75	62	=B12*C12*D12/120			
Pink	20	0.5	62	=B13*C13*D13/120			
	20	0.5	58	=B14*C14*D14/120			
Red	20	0.5	67	=B15*C15*D15/120			
	20	0.5	=$D$1	=B16*C16*D16/120			
Grey	20	0.5	65	=B17*C17*D17/120			
	20	0.5	52	=B18*C18*D18/120			
White	10	1	67	=B19*C19*D19/120			
			Total	=SUM(E4:E19)

[IAMchocolatee]

(Original post by ttoby)
I'll assume that the exam in which you were absent for counted for zero marks, and that the two cells marked with '-' are the exams you are yet to get results for.

You are sitting on a 3rd.
If you get 4% weighted average in your remaining exams you'll get a 2.2
If you get 79% weighted average in your remaining exams you'll get a 2.1

Now assuming that they let you get away with missing your final French exam and instead had your other two French I exams counting equally towards that module:

You are sitting on a 2.2.
If you get 63% weighted average in your remaining exams you'll get a 2.1

Here is the spreadsheet I used if you want to check over it. To see it, copy and paste the code below into notepad, then copy and paste it from notepad into cell A1 in Excel.

Average remaining score79

Subjecttotal Module CreditsProportion of that moduleScoreContribution to final result
French I100.253=B4*C4*D4/120
100.233=B5*C5*D5/120
100.60=B6*C6*D6/120Absent
French II100.255=B7*C7*D7/120
100.224=B8*C8*D8/120
100.6=$D$1=B9*C9*D9/120
Green10163=B10*C10*D10/120
Blue200.2569=B11*C11*D11/120
200.7562=B12*C12*D12/120
Pink200.562=B13*C13*D13/120
200.558=B14*C14*D14/120
Red200.567=B15*C15*D15/120
200.5=$D$1=B16*C16*D16/120
Grey200.565=B17*C17*D17/120
200.552=B18*C18*D18/120
White10167=B19*C19*D19/120
Total=SUM(E4:E19)

I am so scared! I hate French! I thought I was heading for a 2:1 because a majority of my numbers were in the 2:1 zone. Your calculations seem to be very on point but I am so nervous?!


This was posted from The Student Room's iPhone/iPad App

[ttoby]

(Original post by IAMchocolatee)
I am so scared! I hate French! I thought I was heading for a 2:1 because a majority of my numbers were in the 2:1 zone. Your calculations seem to be very on point but I am so nervous?!


This was posted from The Student Room's iPhone/iPad App

The results surprised me as well. I think the thing pulling the marks down is the fact that some of the French marks are much further below the average for the other marks.

But fortunately it's your first year and what really counts is that you won't fail with these marks. Depending on the university these marks will count for a small percentage or will be ignored so you'll have plenty of opportunity to pull your average back up, presumably by dropping french next year

[IAMchocolatee]

(Original post by ttoby)
The results surprised me as well. I think the thing pulling the marks down is the fact that some of the French marks are much further below the average for the other marks.

But fortunately it's your first year and what really counts is that you won't fail with these marks. Depending on the university these marks will count for a small percentage or will be ignored so you'll have plenty of opportunity to pull your average back up, presumably by dropping french next year

I don't get it, why did they surprise you? By how bad they were or?

All the ones I have a low mark in we're due to group work. Especially ****ty French! Lol

This was posted from The Student Room's iPhone/iPad App

[ttoby]

(Original post by IAMchocolatee)
I don't get it, why did they surprise you? By how bad they were or?

All the ones I have a low mark in we're due to group work. Especially ****ty French! Lol

This was posted from The Student Room's iPhone/iPad App

There were so many marks in the 60s and some in the 50s that at first glance I was expecting the average to be closer to a 2.1. Yeah, group work can be a bit of a pain.

[IAMchocolatee]

(Original post by ttoby)
There were so many marks in the 60s and some in the 50s that at first glance I was expecting the average to be closer to a 2.1. Yeah, group work can be a bit of a pain.

Ah I see, so is my average a third at the moment? I will be so gutted if I get anything below 2:1! I've worked so hard this year!


This was posted from The Student Room's iPhone/iPad App

[ttoby]

(Original post by IAMchocolatee)
Ah I see, so is my average a third at the moment? I will be so gutted if I get anything below 2:1! I've worked so hard this year!


This was posted from The Student Room's iPhone/iPad App

You're currently averaging 57%, which is a high 2.2. If your French exam you missed was ignored then you would be averaging just under 60%.

Since this is your first year, then if it counts towards your final grade, the main thing you want to focus on is the mark rather than the grade. So if you were to get, say, 57% this year then depending on the weightings, you could probably pull the mark up to a 2.1 next year by getting in the mid 60s.

[IAMchocolatee]

(Original post by ttoby)
You're currently averaging 57%, which is a high 2.2. If your French exam you missed was ignored then you would be averaging just under 60%.

Since this is your first year, then if it counts towards your final grade, the main thing you want to focus on is the mark rather than the grade. So if you were to get, say, 57% this year then depending on the weightings, you could probably pull the mark up to a 2.1 next year by getting in the mid 60s.

Oh I see, I get to retake the French exam with no caps, so hopefully ?


This was posted from The Student Room's iPhone/iPad App

[ttoby]

(Original post by IAMchocolatee)
Oh I see, I get to retake the French exam with no caps, so hopefully ?


This was posted from The Student Room's iPhone/iPad App

In that case, you're in a better situation:

You're sitting on a third.
If you get 3% weighted average in your remaining exams including the resit you'll get a 2.2.
If you get 58% weighted average in your remaining exams including the resit you'll get a 2.1.

[IAMchocolatee]

(Original post by ttoby)
In that case, you're in a better situation:

You're sitting on a third.
If you get 3% weighted average in your remaining exams including the resit you'll get a 2.2.
If you get 58% weighted average in your remaining exams including the resit you'll get a 2.1.

This the bit that confuses me what do you mean by '3'% weighted average etc? do you mean If I get 3% as a result in my next exams result?

I highly doubt I will get anything below 60% in the awaiting results (Lord God I hope) btw you're an angel!!

[ttoby]

(Original post by IAMchocolatee)
This the bit that confuses me what do you mean by '3'% weighted average etc? do you mean If I get 3% as a result in my next exams result?

I highly doubt I will get anything below 60% in the awaiting results (Lord God I hope) btw you're an angel!!

By weighted average, I mean take each score from the remaining exams, times each of them by their weightings (which is the number of cats in the module times the proportion of that module), take the total of your results then divide that by the total weightings.

So basically it's like the normal average but taking into account the fact that some modules are worth more than others.