Dashboard Metrics
SAT/ACT Taken
Background
District Dashboard Metrics
Because of the importance of entrance exams to college acceptance, many school districts across the nation, including Chicago, Charlotte, Dallas and New York, have incorporated metrics on SAT® and ACT® performance into their internal performance management dashboards. In addition, during focus groups conducted with over 2,600 educators throughout Texas, the College Readiness: Entrance Exams metric was considered useful by 95% of those surveyed.
Primary Metric
- SAT®/ACT® Taken: percentage of students who have taken either the SAT® or ACT®.
User Interface
Dashboard Example
Figure 1 shows the College Entrance Exam SAT/ACT Taken metric as seen on the district dashboard.
Figure 1 TSDS College Entrance Exam Metric SAT/ACT Taken
Status Definition
The Status indicator is determined by district goals. The TSDS default thresholds are by grade, as follows:
- 9th Grade = None
- 10th Grade = 5%
- 11th Grade = 40%
- 12th Grade = 60%
Metric Indicators | Trend Comparisons | |||
Metric Name | Sub-metric Name | Metric Status Indicator | Compares: | To: |
College Entrance Exam | SAT/ACT Taken by each grade level (9-12th) | Red (Percentage) = if percent of students completing exam is less than district goal Green (Percentage) = if percent of students completing exam is equal to or greater than district goal | Current school year | Prior school year |
(a) The Campus Attainment column displays the number of campuses meeting their cmapus goal over the total number of cmapuses that have data for this metric.
Trends
The dashboard do not currently support trends for this metric. The UI supports the trend, but the ETL package has not been developed.
Trend Definitions
The objective of trends is to increase the number of students taking college entrance exams.
Trend Indicators for SAT/ACT Taken | |||
| Up green | Percentage is higher compared to previous time frame; upward trend is favorable | |
| Unchanged | + 5 percentage points | |
| Down red | Percentage is lower compared to previous year; flag indicates unfavorable trend | |
Delta Definition
The delta appears only in the campus list and displays the individual campus goals rather than the district goal.
Delta Indicators: Objective is to indicate SAT/ACT Taken | |||
Metric Name | Sub-Metric Name | Campus Goal | Delta |
SAT/ACT Taken | 9th through 12 grades | Set campus goal | Red (Percentage) = if the calculated percentage of students taking the test is less than the campus goal Black (Percentage) = if the calculated percentage of the students taking the test is greater than or equal to the campus goal |
Periodicity
At a minimum, load the data for this metric at least annually, prior to the beginning of the school year. Best practice is to load the data monthly to capture the various test administrations. (SAT and ACT exams are administered and received by districts several times throughout the year).
Recommended Load Characteristics | |
Calendar | Throughout the school year |
Frequency of data load | Monthly |
Latency | Yearly |
Interchange schema | Interchange-StudentAssessment.xsd |
Tooltips
The standard tool tips for the metric definition, column headers, and help functions display for this metric.
- Green metric status: OK
- Red metric status: LOW
- 'More' indicates drill down views for this metric
is ‘No change from the prior period'
is ‘Getting worse from the prior period’
is 'Getting better from the prior period'
Business Rules
The cohort for this metric is students currently enrolled in grades 9 through 12 on all high school campuses at the time of the last data load. Excluded from the cohort are students who
- were previously enrolled, but left or transferred to another campus
- do not match student data due to SSID
- do not have complete transcripts
Data Source
- SAT and ACT data are made available to the districts periodically as they are administered throughout the year.
- Data for this metric is aggregated from the student data provided by the districts.
- Exclude students from the cohort who are transfer students (late enrollees) without complete transcripts.
- Exclude students from the cohort who do not match student data due to SSID.
SAT/ACT Taken
The percentage of 9th through 12th grade students who have taken the SAT or ACT is computed based upon the following rules:
- "Taken the exam" means that student was administered the exam and that the exam was scored.
- If a student has taken both the SAT and the ACT, only one exam is counted for the student.
SAT
This metric displays the percent of students who have taken the SAT with scores at/above state criterion.
ACT
This metric displays the percent of students who have taken the ACT with scores at/above state criterion.
Computed Values
Table 6 defines how values are calculated for each sub-metric. The result of the calculation displays in the Status column on the districtdashboard.
Metric Values | |
SAT/ACT Taken by grade level | (Number of current students in a specific grade level who have taken SAT or ACT) / (Number of currently enrolled students in cohort) |
Data Anomalies
Anomalies
Best practice is to footnote these anomalies:
- the date of the last test assessments in the database displays parenthetically in the title of the metric.
- late enrollees may have taken college readiness tests at their previous school.
- transfer students with an incomplete transcript.
- students that cannot be matched due to SSID.
Footnotes
- The number of students not included in calculation due to transfer students with an incomplete transcript or students that cannot be matched due to SSID should be noted
Date of Refresh
Best practice is for the date of last data refresh to appear next the metric in the following format:
- (Through April 2010)
Drill Downs
Drill Down Views
The dashboards include the option to drill down and see more detail that is associated with a metric. Table 7 lists the drill down views that are recommended for this metric.
| Campus LIst | List of campuses and whether or not they meet their goal for this metric for the specified period. |