students and classes database template question

[jm]

Don't know if anyone has used it, but at MS there is a free students
and classes database. In there is has a table students and classes (of
course). It has a grade. I can't see anywhere the grade is
calculated. I can manually enter, but that doesn't make a lot of sense
because the results table has a score for each assignment and a
percentage of the grade in the assignments table. It appears the grade
would be calculated automatically. I'm hoping I'm just overlooking the
obvious, but I can't find where it takes all the values and gives a
grade like A, B, etc.

Thank you for any help.

 

[mnature]

When you are on the "Classes" screen, click on the "View Student" button near
the bottom of the window. This brings up a page showing what scores the
student has received for various assignments/tests. Their cumulative Grade
(as a percent) is shown for each class they are enrolled in. I believe that
you are supposed to enter their grade manually, based upon that Grade
percentile.

 

[jm]

So that A, B, C, etc. is manually entered. Guess that's why I couldn't
find it.

thank you.

 

[Tim Ferguson]

I can't see anywhere the grade is
calculated. I can manually enter, but that doesn't make a lot of sense
because the results table has a score for each assignment and a
percentage of the grade in the assignments table. It appears the grade
would be calculated automatically.

In a query, presumably... If the grade is geunuinely dependent on other
fields, then there is no place for storing it as an attribute anywhere.

On the other hand, if the calculated grade is a "starting point" and can be
adjusted ad hoc, for example in response to a student's circumstances, then
it needs its own field and it can't be allocated in software.

Or did I misunderstand the question?

Tim F