I'm wondering if I can do this in a query or need to make a couple of temp tables.
I want a count of many students scored in certain ranges of a test. (0-50/50-69/etc)
I need the following:
1. A student is only counted one time for the test.
2. the highest grade should be counted for each test.
I am using 4 main tables
CourseHistory- shows all the courses each student takes per semester. There are 2 entries for each year long class (and possibly up to 4 entries if a student goes to summer school)
CourseRef- Reference of all the courses
TestRef- a reference table of all the tests given
TestHistory- Shows all the tests a student has taken. A student may have multiple records for one test. (eg: It took 3 tries to pass English).
I am thinking the easiest way would be is to make a new table that shows only the distinct ClassHistory information. Then it should be possible to pull the highest score per test. Am I thinking along the right lines to get the info?
Thanks,
J
I want a count of many students scored in certain ranges of a test. (0-50/50-69/etc)
I need the following:
1. A student is only counted one time for the test.
2. the highest grade should be counted for each test.
I am using 4 main tables
CourseHistory- shows all the courses each student takes per semester. There are 2 entries for each year long class (and possibly up to 4 entries if a student goes to summer school)
CourseRef- Reference of all the courses
TestRef- a reference table of all the tests given
TestHistory- Shows all the tests a student has taken. A student may have multiple records for one test. (eg: It took 3 tries to pass English).
I am thinking the easiest way would be is to make a new table that shows only the distinct ClassHistory information. Then it should be possible to pull the highest score per test. Am I thinking along the right lines to get the info?
Thanks,
J