J
Jeffmarks
I have a table that looks like this:
Student Number Date Test Name Subject Area Test Score
My ultimate goal is to create 1 record per student number so that I
can export it and load it into SPSS for analysis.
Some records in the table represent tests that can only be taken once.
So I'm fine using a Crosstab for those, since there will not be any
conflicting data. Can I combine the Test Name and Subject Area into a
single field in the cross tab so that the data will be more meaningful
to me?
Also, how exactly do I handle tests that may be taken multiple times
(until the student passes)?
Thanks in advance for your help in this matter.
Jeff
Student Number Date Test Name Subject Area Test Score
My ultimate goal is to create 1 record per student number so that I
can export it and load it into SPSS for analysis.
Some records in the table represent tests that can only be taken once.
So I'm fine using a Crosstab for those, since there will not be any
conflicting data. Can I combine the Test Name and Subject Area into a
single field in the cross tab so that the data will be more meaningful
to me?
Also, how exactly do I handle tests that may be taken multiple times
(until the student passes)?
Thanks in advance for your help in this matter.
Jeff