final grade calculation to store in new column... HOW?! please help!

**10121730** · 01-02-2012, 12:53 PM

Hello. First post here for me i hope i get the answers i need, although...i don't really have a "question" as such..
I just need a little help starting off.. Im completely new to all of this and my tutor is an absolute waste of space..no help whatsoever.... never done any programming work in excel before and i'm finding it difficult with such little knowledge to even fully understand the question...
basically i have been given a tutorial which i will attach..
Could somebody please take a look and point me in the right direction, so far all i have done in excel is mock up the id, name, marks for the 4 assignments and the 2 exams , i have also included an average column after each... although im not sure i've even got that formula right.
i have
=AVERAGE(C2:F2)*0.2 for the assignments
and
=AVERAGE(H2:I2)*0.8 for the exams...

it wants me to create a VBA module to calculate the final grade... how on earth would i do this?
am i right in assuming select case ?

sorry if this is all a bit jumbled and vague but i really am stuck!

vba_tut1.docx

any help appreciated,

Thanks,

Cerys

**JieJenn** · 01-02-2012, 01:19 PM

Something like this? Not exactly sure what the doc meant by factor of 10 if the scores are between 20 to 100.

Just an FYI, the formula might be off or incorrect since I am not by my PC, but this should give you an idea how to start I guess.

**10121730** · 01-02-2012, 01:24 PM

thanks for reply.
I believe that's the kind of thing they are after but how would i stop the grade going higher than 100? and what about the module stuff? im assuming il have to use select case for that?!? im so confused with this....

**JieJenn** · 01-02-2012, 01:30 PM

combine the regular formula with IF function. The formula will give you the "Grade", IF function will give you the True Grade

Here is the syntax
If (Grade > 100, 100, Grade)

**10121730** · 01-02-2012, 03:20 PM

argh.. still having trouble with this... i don't mean it lightly when i say im a newbie :P my tutor just literally handed us the sheet and said work this out.