How to export Test Scores

In order to export the results of a given test, it is necessary
to search several tables before exporting. The example below
illustrates how to export a list of students who have taken the ACT
test with a Mathematics score.

Skip this step (information only) System -> Direct Database Export (DDE) Search the Test table for the
test that you want to find; for example, if you are searching for
ACT test results, search the Test table for records where the Name
value contains ACT. PowerSchool should return one record. Click
List View to view the contents of that record.

Skip this step (information only) Note the value of the ID field in the Test record. For this
example, the ID value is 3.

Skip this step (information only) Search the TestScore table for records where the TestID field
values equal 3, the ID noted in the previous step. This may show
several types of test scores, all which are part of the ACT test,
such as Mathematics, Reading, or English.

Skip this step (information only) The TestScore table also has an ID field. For this example, the
TestScore record with the Mathematics name has an ID value of
15.

System -> Direct Database Export (DDE)

Search the StudentTestScore table for records where the
TestScoreID value equals 15. In this example, PowerSchool would
return all student test score records for the Mathematics score of
the ACT test.

Export the selection of StudentTestScore records to get a list
of students who have taken the ACT test with a Mathematics score.
The following is a sample of fields you might use for the
export: