students and classes database template question

  • Thread starter Thread starter jm
  • Start date Start date
J

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.
 
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.
 
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.
Click to expand...

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
 
Back
Top