ckroon
Posts: 869
|
| Posted: 03/07/2008, 6:03 PM |
|
I am trying to design a testing component.
Certain tests are only for certain grade levels.
For instance, the CST here in CA is only for 3rd thru 10th graders.
I want to be able to filter a grid of student that are eligible for a certain test, according to their grade level.
If I have a table: Tests.. what is the best approach to design this...?
Is it possible to filter out for a list of grades in a field if they are separated by commas..?
I could have a field of" Grades eligible: And the data could be "3,4,5" etc or "3rd Grade, 4th Grade, 5th Grade"..
Is this possible?
_________________
Walter Kempees...you are dearly missed. |
 |
 |
datadoit
|
| Posted: 03/08/2008, 6:31 PM |
|
Just from experience I'd suggest a grades table with a sort column.
Ex:
sort grade
---- -----
1 PK
2 K5
3 K
4 1
5 2
6 3
etc.
The reason for this is obvious... you'll want to sort the grades
correctly at times. If you attempt to sort via the grade "name", you'll
get unwanted results.
Secondly, your queries can account for the sort column:
WHERE sort >= 6 AND sort <= 13
or grades 3rd - 10th.
|
|
|
|
ckroon
Posts: 869
|
| Posted: 03/08/2008, 7:28 PM |
|
Thanks DATA. makes perfect sense.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
|
