DARTS : SAT Scores: Traditional With Translation to New Values

Report Purpose

SAT scores are a critical measure for admissions departments and a variable used in many student success measures.  This report translates Scholastic Aptitude Test (SAT) scores from old to new due to recent major revisions to the SAT made by the College Board. The scores are pulled from the UM_STUD_EXTRACT - Student Reporting Extract directly which show students with "old" scores, and those with the new scores if the student has them. Additionally, it creates the translation giving new score equivalencies to old scores based on SAT Concordance Tables.

Please note:

• Returns registered students after Fall 2010 only
• Blank scores do not return as null, but return as '0'
• When the test date is after the census date of the term chosen, the scores are not included.
  
• When old SAT Writing or Critical Reading is missing, the converted EWRS score is set to be 0 
  

Report Location

MyCampus > MaineStreet > Enterprise Applications > Campus Solutions-92-Reporting > PS Query tile > Query Manager or Query Viewer

Note - If your CSRPT Reporting Homepage dashboard does not have a PS Query tile, contact the UMS - Campus Solutions Security Liaisons for your institution.

Report Name

UM_SAT_TRANSLATED

Report Type

PS Query

Prompts Required

• Institution:
• Term: (only works after 0910)

Data Fields Generated

 The first 5 set of "Max_SAT_ " fields are from UM_STUD_CENSUS. The last 5 fields are from UM_SAT_CONCORD, and the last two fields are the combination of the converted scores based on old scores and new scores. 

Tables Used

• UM_STUD_CENSUS - Student Reporting Extract Arch
• UM_SAT_CONCORD