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.


  1. 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.
  2. Skip this step (information only) Note the value of the ID field in the Test record. For this example, the ID value is 3.
  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.
  4. 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.
  5. System -> Direct Database Export (DDE)
  6. 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.
  7. 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:
    • StudentID
    • [students]LastFirst
    • [students]Student_Number
    • [students]Grade_Level
    • AlphaScore
    • NumScore
    • PercentScore
    • StudentTestID
    • [StudentTest]Grade_Level
    • [StudentTest]TermID
    • [StudentTest]Test_Date
    • TestScoreID
    • [TestScore]Description
    • [testScore]Name
    • ID
    TestID: VSOL = 15
             ACT = 2
             SAT I = 3
             SAT II = 4
VSOL TestScoreID  
    30.....15.....Algebra I..........1
    31.....15.....Geometry..........1
    32.....15.....Algebra II..........1
    33.....15.....Earth Science..........1
    34.....15.....Biology..........1
    35.....15.....Chemistry..........1
    36.....15.....World History I..........1
    37.....15.....World History II..........1
    38.....15.....U.S. History..........1
    39.....15.....English 11: Writing..........1
    40.....15.....English 11: Multiple Choice..........1
    41.....15.....World Geography..........1

ACT TestScoreID
1.....2.....English.....English:Usage/Mechannics Rhetorical Skills.....1
2.....2.....Math.....Math: Pre-Algebra/Elem.Alg. Alg./Coord.Geometry Plane Geometry/Trig......1
3.....2.....Reading.....Reading: Soc.Studies/Sciences Arts/Literature.....1
4.....2.....Science.....Science.....1
5.....2.....Composite.....Composite (average).....1

SAT I TestScoreID
9.....3.....SAT 1 Verbal.....SAT 1 Verbal.....1
10.....3.....SAT 1 Math.....SAT 1 Math.....2
47.....3.....SAT 1 Writing.....SAT 1 Writing.....3

SAT II TestScoreID
12.....4.....SAT II Writing.....Writing.....1
13.....4.....SAT II US History.....US History.....1
14.....4.....SAT II Math IC.....Math IC.....1
15.....4.....SAT II World History.....World History.....1
16.....4.....SAT II Literature.....Literature.....1
17.....4.....SAT II Biology-E.....Biology-E.....1
18.....4.....SAT II Spanish.....Spanish.....1
42.....4.....SAT II Biology-M.....Biology-M.....1
43.....4.....SAT II Math I.....Math I.....1
44.....4.....SAT II Math 2.....Math 2.....1
45.....4.....SAT II French.....French Subject Test.....1
48.....4.....SAT II Chemistry.....Chemistry.....1
49.....4.....SAT II Physics..........1

Comments