Calculating a Final Grade by Using Points

Calculating a Final Grade by Using Points

על ידי Dave Gelber בתאריך
מספר תגובות: 4
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

על ידי Dave Gelber בתאריך
=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

Each number in my formula does have the double brackets around it like , however, the formula doesn't copy and past well.
בתגובה ל: Dave Gelber

Re: Calculating a Final Grade by Using Points

על ידי 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

בתגובה ל: Elena Ivanova

Re: Calculating a Final Grade by Using Points

על ידי Dave Gelber בתאריך
Elena,

Thanks, the formula is not working!

I appreciate your help.

Dave