Hi, I'm hoping someone can help me build a formula--I'm struggling trying to get this work. The courses I am teaching are based on the points system. I've set up the grade book and entered all the tasks I'm assigning and inputed the highest amount of points a student could earn for each assignment. The entire grading period is worth 1336 points. There are 46 tasks for the grading period. How do I build the formula to calculate the percentage a student will earn? I've already used the following formula to calculate points earned, how do I build this formula to divide points earned by 1336?
Here is what I have
=1+2+3+4+5+6+7+8+9+10+11+12+13+14+15+16+17+18+19+20+21+22+23+24+25+26+27+28+29+30+31+32+33+34+35+36+37+38+39+40+41+42+43+44+45+46
Thanks for any help you can provide.
Dave
Dave Gelber ထံသို့ အကြောင်းပြန်ရာတွင်
Re: Calculating a Final Grade by Using Points
by Dave Gelber -
Dave Gelber ထံသို့ အကြောင်းပြန်ရာတွင်
Re: Calculating a Final Grade by Using Points
by Elena Ivanova -
Hi Dave,
This forum has text filters to convert double square brackets to wiki links, so you can type double straight lines instead
How about:
= sum(||item1||, ||item2||, ||item3||, etc)/1336
This forum has text filters to convert double square brackets to wiki links, so you can type double straight lines instead
How about:
= sum(||item1||, ||item2||, ||item3||, etc)/1336
Elena Ivanova ထံသို့ အကြောင်းပြန်ရာတွင်
Re: Calculating a Final Grade by Using Points
by Dave Gelber -
Elena,
Thanks, the formula is not working!
I appreciate your help.
Dave
Thanks, the formula is not working!
I appreciate your help.
Dave
Dave Gelber ထံသို့ အကြောင်းပြန်ရာတွင်
Re: Calculating a Final Grade by Using Points
by Elena Ivanova -
I hope it was 'now', not 'not'