Grading Scales

[Guest]

I am designing a database using access and building tables for my classes. I
have built a student table but dont know how to go about making my grading
tables. There are 5 quizzes and a final exam, along with an overall course
grade. The five quizzes use the same grading scale which are broken down
into letter grades and number wrong. For example; 1-5 wrong=A, -1=99, -2=98,
-3=97 and so forth. My final exam scores although different point values and
different scales are similar. Do I need to make separate tables for each
quiz and the final exam? Eventually, I want to link this info to the students
but that will be later in the game.

 

[Duane Hookom]

I would create tables of Students, Tests, TestScales, TestScaleRanges,
StudentTests. Students would contain each unique student. Tests would have
one record per test. StudentTests would have one record per student per
test with their score.

TestScales would contain one record for each "grading curve".
ScaleID ScaleTitle
1 50 Point Test
2 10 Point Quiz
3 100 Point Test

TestScaleRanges
ScaleID MinWrong MaxWrong Grade
1 0 5 4
1 6 9 3
1 10 15 2
....
2 0 2 4
2 3 4 3
.....
3 0 8 4
3 9 15 3
....

The Test table would have a ScaleID value to identify which curve/scale is
used to grade it. The test table should also have the maximum points and
possibly a field that identifies the percent of the semester grade.

--
Duane Hookom
MS Access MVP


"(e-mail address removed)"