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

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

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

2. Re: NEWBIE NEEDS HELP. VBA tutorial

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.

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

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....

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

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)

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

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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1