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