Calculate a calculation result

[Guest]

Using Access 2003. Using a query. Have searched this database and tried
several things but not close enough to my situation. I new at this.

I designing a grading database. Generally what I do is assign every grade a
percentage of the whole value, group by percentage value, average the grades
in each of the percentage value, and then add them up to get a Final Grade
on a report.

I got this far in a report: =Avg([fldGrade])*([fldPointValue]/100) but then
couldn't sum the result of that expression.

So I am now trying to do it in the underlying query and have succeeded with
this expression to get an average for each percentage type AvgOfValue:
Avg([fldGrade])*([fldPointValue]/100) but how do I now sum the result of this
calculation so that I can put that field in my report.

Thanks in advance for your help.

 

[Smartin]

Using Access 2003. Using a query. Have searched this database and tried
several things but not close enough to my situation. I new at this.

I designing a grading database. Generally what I do is assign every grade a
percentage of the whole value, group by percentage value, average the grades
in each of the percentage value, and then add them up to get a Final Grade
on a report.

I got this far in a report: =Avg([fldGrade])*([fldPointValue]/100) but then
couldn't sum the result of that expression.

So I am now trying to do it in the underlying query and have succeeded with
this expression to get an average for each percentage type AvgOfValue:
Avg([fldGrade])*([fldPointValue]/100) but how do I now sum the result of this
calculation so that I can put that field in my report.

Thanks in advance for your help.

You may need to join on a student ID here, but:

SELECT Sum(AvgOfValue) FROM UnderlyingQuery;

I must say though, I don't understand your grading formula very well. If
you are summing averages based on weight, aren't you throwing away the
influence of the weights?

 

[Guest]

I might be confused. Here is what I was trying to do. Quizzes are worth 10%,
Tests = 30%, Writing = 20%, etc. so that the percents add up to 100%. The 10%
category has several quizzes so I wanted to average them (likewise with every
other percent category) and then add the categories together to come up with
a final grade. Is there any easier way? I appreciate your help!

Using Access 2003. Using a query. Have searched this database and tried
several things but not close enough to my situation. I new at this.

I designing a grading database. Generally what I do is assign every grade a
percentage of the whole value, group by percentage value, average the grades
in each of the percentage value, and then add them up to get a Final Grade
on a report.

I got this far in a report: =Avg([fldGrade])*([fldPointValue]/100) but then
couldn't sum the result of that expression.

So I am now trying to do it in the underlying query and have succeeded with
this expression to get an average for each percentage type AvgOfValue:
Avg([fldGrade])*([fldPointValue]/100) but how do I now sum the result of this
calculation so that I can put that field in my report.

Thanks in advance for your help.

You may need to join on a student ID here, but:

SELECT Sum(AvgOfValue) FROM UnderlyingQuery;

I must say though, I don't understand your grading formula very well. If
you are summing averages based on weight, aren't you throwing away the
influence of the weights?

 

[Guest]

Here is an example: if a student makes the grades of 90, 87, and 95 on his
quizzes for a quarter, then I would average those grades and multiple the
result by 30% because I want the average of those grades (90.66) to be worth
30% of the final grade (27.198). I would do the same thing with the grades
that fall in the other percentage categories. (The chosen percentage
categories addd up to 100%.) To get the final grade, I would then need to sum
the result of the calculation for each category. Thanks for you help.

Using Access 2003. Using a query. Have searched this database and tried
several things but not close enough to my situation. I new at this.

I designing a grading database. Generally what I do is assign every grade a
percentage of the whole value, group by percentage value, average the grades
in each of the percentage value, and then add them up to get a Final Grade
on a report.

I got this far in a report: =Avg([fldGrade])*([fldPointValue]/100) but then
couldn't sum the result of that expression.

So I am now trying to do it in the underlying query and have succeeded with
this expression to get an average for each percentage type AvgOfValue:
Avg([fldGrade])*([fldPointValue]/100) but how do I now sum the result of this
calculation so that I can put that field in my report.

Thanks in advance for your help.

You may need to join on a student ID here, but:

SELECT Sum(AvgOfValue) FROM UnderlyingQuery;

I must say though, I don't understand your grading formula very well. If
you are summing averages based on weight, aren't you throwing away the
influence of the weights?

 

[Smartin]

Alright I follow you. As long as individual grades are on a 100 point
scale the end result will make sense on a 100 point scale as well.

For your query I think you were going in this direction but in case you
are still having trouble... A two query approach is the simplest and can
be constructed using the drag-n-drop interface.

I'm assuming you have a table set up something like this to record grades:

StudentID
Weight
Grade

Set up the first query using the grades tables to give you StudentID,
Weight, and Grade. Turn it into a totals query, pick AVG for Grade. The
other two fields will default to Group By. Save this query as "AvgGrades".

Set up the second query to use AvgGrades. Drop in student id and create
a calculated field:
Expr1: [Weight]/100*[AvgOfGrade]
(The averaged field from the first query will have a default alias of
"AvgOfGrade".) Turn this query into a totals query, choosing Sum on the
calculated field, and Group By student id.

HTH

Here is an example: if a student makes the grades of 90, 87, and 95 on his
quizzes for a quarter, then I would average those grades and multiple the
result by 30% because I want the average of those grades (90.66) to be worth
30% of the final grade (27.198). I would do the same thing with the grades
that fall in the other percentage categories. (The chosen percentage
categories addd up to 100%.) To get the final grade, I would then need to sum
the result of the calculation for each category. Thanks for you help.

Using Access 2003. Using a query. Have searched this database and tried
several things but not close enough to my situation. I new at this.

I designing a grading database. Generally what I do is assign every grade a
percentage of the whole value, group by percentage value, average the grades
in each of the percentage value, and then add them up to get a Final Grade
on a report.

I got this far in a report: =Avg([fldGrade])*([fldPointValue]/100) but then
couldn't sum the result of that expression.

So I am now trying to do it in the underlying query and have succeeded with
this expression to get an average for each percentage type AvgOfValue:
Avg([fldGrade])*([fldPointValue]/100) but how do I now sum the result of this
calculation so that I can put that field in my report.

Thanks in advance for your help.

You may need to join on a student ID here, but:

SELECT Sum(AvgOfValue) FROM UnderlyingQuery;

I must say though, I don't understand your grading formula very well. If
you are summing averages based on weight, aren't you throwing away the
influence of the weights?