Guide to SATI and ACT Test Scores in the IUIE

SATI and ACT test scores in the IUIE are available in two general views.  One view is to list all scores for a student, including cases where a student takes the same test on different dates.  For examples, see the following report objects:

• ADM_APPL_TST_SCORE_GT
• SR_STU_TST_SCR_GT

Section I: Highest Test Scores

Overview

SATI and ACT test scores in the IUIE are available in two general views.  One view is to list all scores for a student, including cases where a student takes the same test on different dates.  For examples, see the following report objects:

• ADM_APPL_TST_SCORE_GT
• SR_STU_TST_SCR_GT

In contrast, the view most frequently used at IU for reporting and scholarship selection is the highest test score for each student and test component.  Here are some examples of IUIE reports that list only the highest score for each student and test component:

• Current Applications (DSS.ADM_CUR_APPL_GT)
  • IUIE path: Master Catalog à Student à Admissions à Admissions Data à Appls – Current Rows

• SR Student Term (DSS_RDS.SR_STU_TERM_GT)
  • IUIE path: Master Catalog à Student àRecords à Student Term à Data Extracts à Student Term

• IR Census/Term Snapshot (DSS_RDS.IR_CEN_TRM_SNPSHT_GT)
  • IUIE path: Master Catalog à Student àInstitutional Reporting à Enrollment à IR_CEN_TRM_SNPSHT_GT

See Appendix IV for instructions on how to search the IUIE for all tables and views with the highest ACT and SATI test score columns. 

Logic for Selecting Highest Test Scores

Beginning August 1, 2011, the following principles are used to select the highest valid SATI and ACT test scores:

• Only include valid test scores:

• SATI critical reading, math, writing, reading/writing section, and math section scores
  • Must be a multiple of 10 (end in zero)
  • Range from 200 through 800
  • Must be taken on a date where a valid test score is submitted for both the critical reading and math sections, or for both the reading/writing section and math section scores.

• SATI essay scores
  • Range from 2 through 12
  • Must be taken on a date where a valid test score is submitted for both the critical reading and math scores, or for both the reading/writing section and math section scores.

• ACT scores
  • Scores must be an integer (with no decimals)
  • For the writing-only test, the score must range from 2 through 12
  • For the other test components, the score must range from 1 – 36
  • Must be taken on a date where a valid test score is submitted for English, Mathematics, Reading, and Science.
  • Effective 7/29/2011, the derived ACT super composite score is reported externally, in place of the ACT composite score received from ACT or the high school. The derived ACT super composite score is only available in the Warehouse in the IUIE column   It is not available in the SIS test score table.

• Only include official scores. These have one of these data sources.  (Note that the Bloomington campus uses only ACT- and ETS-sourced “agency” data for their internal operations.)

• ACT (American College Testing service)
• ETS (Educational Testing Service – SAT)
• SCH (high school)
• MF (IU’s legacy student system – mainframe).

• For students who took the SATI test prior to April 1995, IU converts their math and verbal score to the post-1995 scale. These converted scores are included seamlessly in the existing SATI math and critical reading (VE) fields, and they are given equal consideration with the post-1995 scores when determining a student’s highest math and verbal scores.  See Appendix III for a list of conversion values.

• All scores that meet the guidelines listed above are considered when selecting the highest test score. Here are some implications:

• A student’s highest SATI scores may be from different test dates. For example, the highest SATI math score may be from a different test date than the critical reading, writing, and essay SATI scores. 

• Similarly, a student’s highest ACT scores may be from different test dates.

• Note that no preference is given based on test date.

• If a student’s SATI math score is 622 (not a multiple of 10) and the critical reading score is 650, neither score is included in the highest test score fields, since the score of 622 is invalid.

• Self-reported scores are excluded from the highest test scores.

Section II:  Derived Test Score Information for Internal Use

For official reporting to the federal government, the State of Indiana, and private surveys, only the highest official test scores are considered (see Section I above for details).  The one exception is the new derived ACT super composite score, which replaces the composite score received from ACT, effective 7/29/2011:

Otherwise, for internal administrative purposes, these four derived reporting test score fields are available to meet most needs[1]:

[1] Note that admissions offices may need to use converted composite scores from a particular time period for term-specific admissions activities.  The four fields listed in the table above and continuing on the next page are derived from those term-specific fields based on the date when the user accesses the data warehouse.  A full list of the various derived composite scores can be found in Appendix I below.

The first and third fields in the table above contain derived scores between 400 and 1600, while STU_DRVD_RPT_ACT2SAT_NBR contains scores between 590 and 1600 (see Appendix II below).  The last field contains one of these three values: ACT, SAT2016, or SAT2017.  The indicator SAT2016 means that the highest value represents an SATI composite score based on the pre-2017 Math + Critical Reading scores.  The indicator SAT2017 means that the highest value represents an SATI composite score based on the post-2016 Math Section and Reading/Writing Section scores.[2]  The values for these fields are based on the highest official test scores described in the section above. 

The table (IR_DRVD_CMPST_TSTSCR_GT in the IUIE) for converting ACT composite scores to the SAT composite format contains each historical set of conversion crosswalk values.  These conversions can be found in Appendix II.  See Appendix IV for instructions on how to search the IUIE for all tables and views with these columns.

Here is an illustration of how a student’s highest derived SATI composite score is determined: 

 [2] See the companion IR Data Guide Excel spreadsheet for information about the SATI redesign that took place in 2016 and became effective in spring 2017 at IU:  SAT Redesign Technical Changes: Finding IR (Test): Institutional Analytics: Indiana University (iu.edu)

Here is an illustration of how a student’s derived ACT super composite score is determined:

The Derived SATI or Converted ACT Max Composite Score (STU_DRVD_RPT_SAT_CMPST_NBR) is 1250 in this case. This is the higher of the Derived SATI Composite Score and the Derived ACT Super Composite Score - SAT Format.  The column STU_DRVD_RPT_SRC_CNV_IND is set to SAT2017, since the source of the 1250 score is the SATI Math Section + Reading/Writing Section scores.

Keep in mind that the values from the columns STU_DRVD_RPT_SAT_CALC_NBR (1250), STU_DRVD_RPT_ACT2SAT_NBR (1070) and STU_DRVD_RPT_SAT_CMPST_NBR (1250) are not reported officially to external agencies, but may be used internally.

Section III:  For more information

More information about the SATI and ACT scores can be found on these websites:

http://www.act.org/content/act/en/products-and-services/the-act/scores/act-sat-concordance.html  https://collegereadiness.collegeboard.org/educators/higher-ed/scoring/concordance

If you have additional questions, please contact University Institutional Research  by sending an email to IAHELP@IU.EDU.

Appendices

 Appendix I:  Table for converting ACT composite scores to the SATI composite format

(Based on conversions stored in IR_DRVD_CMPST_TSTSCR_ST)

Appendix II:  Table for converting pre-April 1995 SATI math and verbal scores to the post-1995 scale

The following tables were downloaded from this College Board website, which is no longer maintained:  http://professionals.collegeboard.com/data-reports-research/sat/equivalence-tables/sat-score

Appendix III:  IUIE report objects with students’ highest ACT and SATI test scores

Follow these steps to search the IUIE for tables and views with students’ highest ACT and SATI scores:

1. Log into the IUIE and navigate to the Master Catalog.

2. In the Search box in the upper right corner, type the technical name of a table or view (e.g. SR_STU_TERM_GT) that includes students’ highest ACT and SATI scores, and then click on the Search button.
3. Scroll down through the search results until you see the name of the table or view that you searched for. Use your mouse to click on the underlined name of the table or view.  This will take you to that report object.  (See the illustration on the next page.)
4. You may be presented with a secondary screen with different locations for the same table or view. Pick any one of these by clicking on the underlined name of the report object.
5. Once in the report object, scroll down until you find one of the highest test score column names. (See the illustration on the next page.)
6. Click on the underlined column name that you desire.  You will then see a display of all tables and views with this column.
7. In addition, some Pre-defined Queries (PDQ’s) in the IUIE may include these columns. Here is a list of PDQs with the highest SATI and ACT score columns as of summer 2016:

   ie_sis_sr_bl_retention.sqr

   ie_sis_sr_majors_extract.sqr

   ie_sis_sr_retention.sqr

   ie_sis_sr_student_profile_report.sqr

   ie_sis_sr_stu_term_subplans.sqr

   ie_sis_sr_enrl_cls_rpt.sqr

   ie_sis_adm_adma_comm.sqr

   ie_sis_adm_admp_comm.sqr

   ie_sis_adm_crm_data_load_ea.sqr

   ie_sis_adm_pros_comm.sqr

   ie_sis_adm_stat_lbl.sqr

   ie_sis_adm_zero_gpa_qual.sqr

   ie_sis_fa_compass_appl_sum_2013.sqr

   ie_sis_fa_compass_appl_sum.sqr

   ie_sis_fa_fndtn_schlshp_sprdsht.sqr

   ie_sis_fa_mary_sinclair_schlrs.sqr

   ie_sis_fa_oem_nmd_awd_schlrshps.sqr

   ie_sis_fa_schlrs_slct_freshman.sqr

   ie_sis_fa_schlrs_slct.sqr

   ie_sis_fa_ssa_fin_aid.sq