Calculating Class Percentages by Student

S

Shaun

I'm using the Classroom Management Database Template from MS; however, the
class scoring is based on percentage of grades. I need the ability to score
students assignments off the raw scores and not weight them.

Here's my modified calculation:

Sum(Abs(([results].[score]/[assignments].[maximumpoints]))/Count([results].[resultID])

The calculation executes just fine, however I have a student that is
receiveing a 79.30% in my class (410 scored points devided by 517 maximum
points * 100). My modified calculation above generates a score of 79.56% -
not quite sure what I'm doing wrong.

Any suggestions would be great.
 
D

Duane Hookom

Could you tell us what you are attempting to calculate? I would think you
need to divide the Sum of the Scores by the Sum of Maximum Points.
 
S

Shaun

Ok, now I feel dumb. I should have went the simple route.

Thanks for the smack in the head! :)

Shaun

Duane Hookom said:
Could you tell us what you are attempting to calculate? I would think you
need to divide the Sum of the Scores by the Sum of Maximum Points.

--
Duane Hookom
MS Access MVP

Shaun said:
I'm using the Classroom Management Database Template from MS; however, the
class scoring is based on percentage of grades. I need the ability to
score
students assignments off the raw scores and not weight them.

Here's my modified calculation:

Sum(Abs(([results].[score]/[assignments].[maximumpoints]))/Count([results].[resultID])

The calculation executes just fine, however I have a student that is
receiveing a 79.30% in my class (410 scored points devided by 517 maximum
points * 100). My modified calculation above generates a score of
79.56% -
not quite sure what I'm doing wrong.

Any suggestions would be great.
Click to expand...
Click to expand...
 
D

Duane Hookom

Didn't mean to make you "feel dumb". We all get them "doh...!" moments now
and then. I have often gone around the block to get next door.

--
Duane Hookom
MS Access MVP

Shaun said:
Ok, now I feel dumb. I should have went the simple route.

Thanks for the smack in the head! :)

Shaun

Duane Hookom said:
Could you tell us what you are attempting to calculate? I would think you
need to divide the Sum of the Scores by the Sum of Maximum Points.

--
Duane Hookom
MS Access MVP

Shaun said:
I'm using the Classroom Management Database Template from MS; however,
the
class scoring is based on percentage of grades. I need the ability to
score
students assignments off the raw scores and not weight them.

Here's my modified calculation:

Sum(Abs(([results].[score]/[assignments].[maximumpoints]))/Count([results].[resultID])

The calculation executes just fine, however I have a student that is
receiveing a 79.30% in my class (410 scored points devided by 517
maximum
points * 100). My modified calculation above generates a score of
79.56% -
not quite sure what I'm doing wrong.

Any suggestions would be great.
Click to expand...
Click to expand...
Click to expand...
 
Top