A little excel/math logic help needed

[BigToque]

I'm making a spreadsheet to help track my grades and I've come across a little issue that I'm almost embarrassed I can't seem to figure out. It might just be that my brain is a little fried after this last block of courses...

Example:

Test 1 - Value 50% - Grade 100%
Test 2 - Value 30% - No Grade (Not yet taken)
Test 3 - Value 20% - No Grade (Not yet taken)

So in this example I've taken one test and got 100% on it. I want to be able to calculate the average I need over both remaining tests to pass (say pass is 70%). This is obvious how to calculate if the weighting of each test is the same:

(passing grade - [current mark]) / (remaining marks available)
(70-50)/(50)
(20)/(50)

The logic of how to take into consideration the weighting of each test is escaping me at the moment.

 

[Fayd]

I'm making a spreadsheet to help track my grades and I've come across a little issue that I'm almost embarrassed I can't seem to figure out. It might just be that my brain is a little fried after this last block of courses...

Example:

Test 1 - Value 50% - Grade 100%
Test 2 - Value 30% - No Grade (Not yet taken)
Test 3 - Value 20% - No Grade (Not yet taken)

So in this example I've taken one test and got 100% on it. I want to be able to calculate the average I need over both remaining tests to pass (say pass is 70%). This is obvious how to calculate if the weighting of each test is the same:

(passing grade - [current mark]) / (remaining marks available)
(70-50)/(50)
(20)/(50)

The logic of how to take into consideration the weighting of each test is escaping me at the moment.

you've got 100% on the first test, which is 50% of the class.

so you have 50/70 required points.

you only need 40% average on the next 2 tests. .4*(.5) = .2

.2+.5 = .7

why would you want to weight each test? you wanted an average...

when i took calc-I, i went into the final with 102% or so...so I only needed something like a 56% on the final to clear the class with an A. haha.

 

[Tweak155]

I think in this scenario the tests are worth 33% each. So you earned 33% and need 37% more to get a 70. Between 2 tests worth 66% (rounding) you need 37/66 or 56% on both.

You can get the % per test by 1 / numoftests (count), multiply by known results (100% * prev equation) and the rest are (((goal % which is 70) - (earned %)) / ((1/numoftests) * num of remaining tests)). That gives min goal per tests.

On my phone so hope it makes sense.

 

[Fayd]

I think in this scenario the tests are worth 33% each. So you earned 33% and need 37% more to get a 70. Between 2 tests worth 66% (rounding) you need 37/66 or 56% on both.

You can get the % per test by 1 / numoftests (count), multiply by known results (100% * prev equation) and the rest are (((goal % which is 70) - (earned %)) / ((1/numoftests) * num of remaining tests)). That gives min goal per tests.

On my phone so hope it makes sense.

he said in the OP that the tests are worth 50,30,20. >.>

 

[richardycc]

Just do well and get at least a 67% on your 2nd exam, you can skip the 3rd test.

 

[Tweak155]

he said in the OP that the tests are worth 50,30,20. >.>

That's what I get for using my phone haha.

 

[BigToque]

I think I figured out my problem, which ended up being an error in one of the equations I typed out referencing a cell that should have been the one below it...

Such a dumb mistake

Thanks for the help guys.

 

[Charles Kozierok]

It's simpler than you think.. or it's too late for me to be doing math.

If you got 100% on 50% of the marks, then you only need 40% on the remaining two to average 70%.