Microsoft Access "Classroom management database" question

[P Jefferies]

Microsoft Access "Classroom management database" question.

When grading, it has the ability in this template to put in scores for Assigments, Quizzes, Exams, Etc. For example, student scores 45 our of 100 possible points.

BUT it does not calculate that into a grade, that field is editable and I guess you have to manually put in a letter grade. Leaving room for human error.

Is there a way to make the # of points work or translate into a Letter Grade.
Path is: Open Classroom management database, go to classes, choose assignment tab, and click View assignements. THere you can fill in the score. BUT it doesn't translate into a letter Grade, Why?? How to make that work, it would make this a wonderful tool.

Phil


Submitted via EggHeadCafe - Software Developer Portal of Choice
Use IDENT_CURRENT to retrieve the last inserted value into the Identity column
http://www.eggheadcafe.com/tutorial...96-0f6c2138e101/use-identcurrent-to-retr.aspx

 

[John W. Vinson]

Is there a way to make the # of points work or translate into a Letter Grade.
Path is: Open Classroom management database, go to classes, choose assignment tab, and click View assignements. THere you can fill in the score. BUT it doesn't translate into a letter Grade, Why?? How to make that work, it would make this a wonderful tool.

There are many different schemes to translate numeric grades into letter
grades. Is 90 an A or a B? I've taken classes where 99% was FAIL and 100% was
PASS (odd class, the final exam was the entire basis of the grade; it was
handed out to all students the first session and you could take it any time);
in some classes, 50% might be a passing score, or it might be 30%.

What you could do is cast all the scores into a defined range (say integers
from 0 to 100) and create a grades table with 100 rows, e.g.

0 F
1 F
2 F
....
61 D
62 D
63 D
....
71 C

or use D-, C+ and so on, whatever works in your environment. You could then
join this table to your scores table.