Ok so my co- worker and I are excel illiterate and are trying to figure out a formula for entering students grades in a worksheet. Please help!
Outline: Students complete homework assignments each term but the number of homework assignments changes from term to term. The homework is worth 15% of their total subject grade, however we want excel to calculate their percentage mark based on how many homework assignments they do and then what grade they receive for each one.
Each homework assignment is out of 5. So we want a formula to say, for example, 'If a student completes only 1 homework assignment then their WHOLE homework grade (the whole 15%) comes from that homework mark for the term. So, if they do ONE homework assignment and their mark is 5/5, then they get the whole 15% for homework for the term. (ie. 100% of the possible homework score for the term). So then we want the formula to be able to calculate their mark if they get any score from 0>5 for their homework as well.
On top of this, if they receive TWO, THREE or FOUR assignments for the term, we want the spreadsheet to be able to calculate their grade based on multiple assignments (with the 15% homework grade being spread between those assignments) and also be able to understand somehow that the amount of homework can change from term to term so that we don't have to keep making separate spreadsheets.
Bookmarks