THIS IS A DRAFT DOCUMENT - IN PROGRESS.
IT HAS BEEN PUBLISHED IN ORDER TO BE SHARED WITH CLIENT FOR COLLABORATION.
The following query statements will assist Texas LEAs in querying their Aeries database to obtain counts for federally mandated AVID reporting. To obtain counts for AVID students, run the AVID KEEP query first, then run the various TOTAL queries to obtain counts for the 'kept' students.
NOTES:
- Keller ISD does not offer AVID Excel. All students are AVID Elective.
- Keller ISD does not offer AICE courses.
AVID KEEP Statement
Middle School:
KEEP STU SEC MST CRS IF ( CRS.CN = "nnnn" OR CRS.CN = "nnnn" )
(where nnnn is the course number for middle school AVID courses; combine all applicable courses with 'OR')
Keeps students enrolled in a course defined by LEA as a middle school AVID course
Middle School course numbers (Keller ISD):
- 0806 AVID 6th
- 0810 AVID 7th AVID 7th
- 0811 AVID 8th AVID 8th
- 5762 AVID 1 AVID I
- 5762A AVID 1 A AVID I A
- 5762B AVID 1 B AVID I B
- 5763 AVID 2 AVID II
- 5763A AVID 2 A AVID II A
- 5763B AVID 2 B AVID II B
- 5764 AVID 3 AVID III
- 5764A AVID 3 A AVID III A
- 5764B AVID 3 B AVID III B
- 5765 AVID 4 AVID IV
- 5766 AVID 4 AVID IV
- 5766A AVID 4 A AVID IV A
- 5766B AVID 4 B AVID IV B
High School:
KEEP STU SEC MST CRS IF ( CRS.SVC = "########" OR CRS.SVC = "########" )
(where ######## is the service ID of an AVID course; combine all applicable service IDs with 'OR')
Keeps students enrolled in a course with an AVID service ID
High school AVID service IDs:
- N1290001 Advancement Via Individual Determination I
- N1290002 Advancement Via Individual Determination II
- N1290030 Advancement Via Individual Determination III
- N1290033 Advancement Via Individual Determination IV
Project Lead the Way (PLTW)
Middle School course numbers (Keller ISD):
- 0856 Design and Modeling, Science of Technology
- 0857 Magic of Electrons, Automation and Robotics
- 9858 Biomedical Sciences and Flight
- 0859 Green Architecture, Energy & the Environment
High School course numbers (Keller ISD):
- 82641 Introduction to Engineering Design
- 82642 Engineering Science (AKA Principles of Engineering)
- 82662 Aerospace Engineering
- 82673 Digital Electronics
- 82644 Civil Engineering
- 82643 Engineering Design and Development
- 82645 Computer Integrated Manufacturing
Queries
| All Students | AVID Students | |||
|---|---|---|---|---|
Ethnic/Racial Identity Demographics page, Ethnicity and Race fields | Male Demographics page, Gender field (STU.GN = "M") | Female Demographics page, Gender field (STU.GN = "F") | Male Demographics page, Gender field (STU.GN = "M") | Female Demographics page, Gender field (STU.GN = "F") |
1. Hispanic or Latino (STU.ETH = "Y") | TOTAL STU ETH GN BY ETH GN Total Hispanic/Latino students by gender | Run AVID KEEP Statement above, then TOTAL query (left). | ||
2. American Indian or Alaska Native (STU.RC1 = "01" | TOTAL STU RC1 GN BY RC1 GN IF RC1 = "01" AND ( RC2 = " " OR RC2 = NULL ) AND STU.ETH = "N" Total students by gender who identify as American Indian or Alaska Native and no other race | |||
3. Asian (STU.RC1 = "02" | TOTAL STU RC1 GN BY RC1 GN IF RC1 = "02" AND ( RC2 = " " OR RC2 = NULL ) AND STU.ETH = "N" Total students by gender who identify as Asian and no other race, and not Hispanic | |||
4. Black or African American (STU.RC1 = "03" | TOTAL STU RC1 GN BY RC1 GN IF RC1 = "03" AND ( RC2 = " " OR RC2 = NULL ) AND STU.ETH = "N" Total students by gender who identify as Black or African American and no other race, and not Hispanic | |||
5. Native Hawaiian or Other Pacific Islander (STU.RC1 = "04" | TOTAL STU RC1 GN BY RC1 GN IF RC1 = "04" AND ( RC2 = " " OR RC2 = NULL ) AND STU.ETH = "N" Total students by gender who identify as Native Hawaiian or Other Pacific Islander and no other race, and not Hispanic | |||
6. White (not Hispanic) (STU.RC1 = "05" | TOTAL STU RC1 GN BY RC1 GN IF RC1 = "05" AND ( RC2 = " " OR RC2 = NULL ) AND STU.ETH = "N" Total students by gender who identify as White and no other race, and not Hispanic | |||
7. Two or more races (STU.RC1 > "0" AND STU.RC2 > "0") | TOTAL STU RC1 RC2 RC3 RC4 RC5 GN BY RC1 RC2 RC3 RC4 RC5 GN IF ( RC1 > "0" AND RC2 > "0" ) Total students by gender and race who have more than one race selected | |||
| 8. Decline to state | ||||
| Grade Level (Fall) | ||||
| Middle School | ||||
| 9. 6th (STU.GR= 6) | TOTAL STU GN GR BY GN GR IF ( GR >= 6 AND GR <= 8 ) Total students in grade level 6, 7, and 8 by gender and grade level | Run AVID KEEP Statement above, then TOTAL query (left). | ||
| 10. 7th (STU.GR= 7) | ||||
| 11. 8th (STU.GR= 8) | ||||
| High School | ||||
| 12. 9th (STU.GR= 9) | TOTAL STU GN GR BY GN GR IF ( GR >= 9 AND GR <= 12 ) Total students in grade levels 9, 10, 11, and 12 by gender and grade level | Run AVID KEEP Statement above, then TOTAL query (left). | ||
| 13. 10th (STU.GR= 10) | ||||
| 14. 11th (STU.GR= 11) | ||||
| 15. 12th (STU.GR= 12) | ||||
| Total GR >= 9 AND GR <= 12 | TOTAL STU GN BY GN IF ( GR >= 9 AND GR <= 12 ) Total students in grade levels 9, 10, 11, and 12 by gender | Run AVID KEEP Statement above, then TOTAL query (left). | ||
| 16. Student Special Populations: Indicate the students—both AVID and All—who meet the item description. Include AVID students in the All Students count. Enter “U” if data is unavailable. | ||||||
| 6th | 7th | 8th | ||||
Economically Disadvantaged/ Eligible for Free or Reduced-Price Lunch Free and Reduced page, NSLP Lunch Type Code field (FRE.CD = "F" or "R" or "X") and NSLP Eligibility Start (FRE.ESD >= first date of school year) and NSLP Eligibility Start (FRE.EED <= current date) | All | TOTAL STU FRE STU.GR BY STU.GR IF ( FRE.CD = "F" OR FRE.CD = "R" OR FRE.CD = "X" ) AND FRE.ESD >= MM/DD/YYYY AND FRE.EED <= MM/DD/YYYY AND ( GR >= 6 AND GR <= 8 ) (where MM/DD/YYYY is first day of school year, and then current date) Total students in grade level 6, 7, and 8 by grade level whose Free/Reduced Lunch code indicates participation this school year | ||||
| AVID | Run AVID KEEP statement above, then TOTAL query | |||||
| 9th | 10th | 11th | 12th | |||
| All | TOTAL STU FRE STU.GR BY STU.GR IF ( FRE.CD = "F" OR FRE.CD = "R" OR FRE.CD = "X" ) AND FRE.ESD >= MM/DD/YYYY AND FRE.EED <= MM/DD/YYYY AND ( STU.GR >= 9 AND STU.GR <= 12 ) (where MM/DD/YYYY is first day of school year, and then current date) Total students in grade level 9, 10, 11, and 12 by grade level whose Free/Reduced Lunch code indicates participation this school year | |||||
| AVID | Run AVID KEEP statement above, then TOTAL query | |||||
| 6th | 7th | 8th | ||||
Member of a Migrant Family Special Programs page, Program Code field (PGM.CD = "135") | All | TOTAL STU PGM STU.GR BY STU.GR IF PGM.CD = "135" AND ( STU.GR >= 6 AND STU.GR <= 8 ) Total students in grade level 6, 7, and 8 by grade level enrolled in Migrant program | ||||
| AVID | Run AVID KEEP statement above, then TOTAL query | |||||
| 9th | 10th | 11th | 12th | |||
| All | TOTAL STU PGM STU.GR BY STU.GR IF PGM.CD = "135" AND ( STU.GR >= 9 AND STU.GR <= 12 ) Total students in grade level 9, 10, 11, and 12 by grade level enrolled in Migrant program | |||||
| AVID | Run AVID KEEP statement above, then TOTAL query | |||||
| 6th | 7th | 8th | ||||
Classified Limited English Proficient Demographics page, LangFlu field (STU.LF = "1") | All | TOTAL STU STU.GR BY STU.GR IF STU.LF = "1" AND ( STU.GR >= 6 AND STU.GR <= 8 ) Total students in grade level 9, 10, 11, and 12 by grade level identified as LEP/English Learner (EL) | ||||
| AVID | Run AVID KEEP statement above, then TOTAL query | |||||
| 9th | 10th | 11th | 12th | |||
| All | TOTAL STU STU.GR BY STU.GR IF STU.LF = "1" AND ( STU.GR >= 9 AND STU.GR <= 12 ) Total students in grade level 9, 10, 11, and 12 by grade level identified as LEP/English Learner (EL) | |||||
| AVID | Run AVID KEEP statement above, then TOTAL query | |||||
| 17. Number of middle school (grades 6-8) AVID Elective classes (sections) available to students. middle school: CRS.CN = "nnnn" (where nnnn is the course number for middle school AVID courses) high school if taken in middle school: CRS.SVC = "########" (where ######## is the service ID of an AVID course) | Middle School: LIST MST CRS MST.SC MST.SE BY MST.SC IF ( CRS.CN = "nnnn" OR CRS.CN = "nnnn" ) (where nnnn is the course number for middle school AVID courses; combine all applicable courses with 'OR') Total middle school AVID courses by section High School (if taken in middle school): LIST MST CRS MST.SC MST.SE BY MST.SC IF ( CRS.SVC = "########" OR CRS.SVC = "########" ) (where ######## is the service ID of an AVID course; combine all applicable service IDs with 'OR') Total high school school AVID courses by section Add high school and middle school totals. | |
| 18. SKIP | ||
| 19. Number of high school (grades 9-12) AVID Elective classes (sections) available to students. | LIST MST CRS MST.SC MST.SE BY MST.SC IF ( CRS.SVC = "########" OR CRS.SVC = "########" ) (where ######## is the service ID of an AVID course; combine all applicable service IDs with 'OR') | |
| 20. Enter the number of teachers, counselors, and other administrators presently at campus. Staff page, Job Assignments tab, Role Description field (STJ.JC) Substitute Teacher = 047 Teacher = 087 School Counselor = 008 Other Administrators (Assistant Principal) = 003 | Teachers | TOTAL STJ IF ( STJ.JC = "047" OR STJ.JC = "087" ) Total teachers and substitute teachers |
| Counselors | TOTAL STJ IF STJ.JC = "008" Total school counselors | |
| Other Administrators | TOTAL STJ IF STJ.JC = "003" Total assistant principals | |
| 21-24. SKIP | ||
25. Number of AVID Elective middle school students (grades 6-8) currently enrolled in at least their second year of AVID. Transcripts Table (HIS) HIS.YR = "19" HIS.CN = "nnnn" (where nnnn is the course number for a middle school AVID course) CRS.CN = "nnnn" (where nnnn is the course number for a middle school AVID course) | TOTAL HIS CRS STU STU.ID BY STU.ID IF ( HIS.YR = 19 AND HIS.CC > 0 AND ( HIS.CN = "nnnn" OR HIS.CN = "nnnn" ) ) AND ( STU.GR >= 6 AND STU.GR <= 8 ) AND ( CRS.CN = "nnnn" OR CRS.CN = "nnnn" ) (where nnnn is the course number for middle school AVID courses; combine all applicable courses with 'OR') Total 6th-8th grade students who received credit in the 2019-2020 school year in one or more AVID courses and are enrolled this year in one or more AVID courses | |
26. Number of AVID Elective high school students (grades 9-12) currently enrolled in at least their third year of AVID (including middle school AVID enrollment). Transcripts Table (HIS) HIS.YR = "18" AN "19" HIS.CN = "nnnn" (where nnnn is the course number for a middle or high school AVID course) CRS.CN = "nnnn" (where nnnn is the course number for a middle school AVID course) | TOTAL HIS CRS STU STU.ID BY STU.ID IF ( HIS.YR = 18 AND HIS.CC > 0 AND ( HIS.CN = "nnnn" OR HIS.CN = "nnnn" ) ) AND ( HIS.YR = 19 AND HIS.CC > 0 AND ( HIS.CN = "nnnn" OR HIS.CN = "nnnn" ) ) AND ( STU.GR >= 9 AND STU.GR <= 12 ) AND ( CRS.SVC = "########" OR CRS.CN = "########" ) (where nnnn is the course number for middle or high school AVID courses; combine all applicable courses with 'OR') Total 9th-12th grade students who received credit in the 2018-2019 school year in one or more middle or high school AVID courses, received credit in the 2019-2020 school year in one or more middle or high school AVID courses, and are enrolled this year in one or more AVID courses | |
| 27. SKIP | ||
| 28. Number of current AVID Elective high school students (grades 9-12) who are taking a sequence of courses allowing them to meet four-year college entrance requirements (based upon their current transcript and four-year plan). Graduation Status page, Graduation Track field STU.GRT (district defined) FHSP-PARTICIPANT-CODE | Run AVID KEEP statement above, then the following TOTAL: TOTAL STU.GRT IF STU.GRT = "?" AND ( STU.GR >= 9 AND STU.GR <= 12 ) (where ? is the district-defined code indicating participation) Total students in grade levels 9-12 who are participating in the FHSP program | |
29. Number of AVID Elective high school students (grades 9-12) who are currently taking a course at a college or university, concurrent enrollment course, or dual-enrollment course that allows them to earn transferable college credit (see Supplemental Instruction Sheet for further details). College-level course - CRS.CL = "24" OnRamps Dual Enrollment CRS.OD = "Y" | Male (STU.GN = "M") | Run AVID KEEP statement above, then the following TOTAL: TOTAL STU SEC CRS BY IF ( CRS.CL = "24" OR CRS.OD = "Y" ) AND STU.GN = "M" Total male students by gender in college-level or OnRamps courses |
| Female (STU.GN = "F") | Run AVID KEEP statement above, then the following TOTAL: TOTAL STU SEC CRS BY IF ( CRS.CL = "24" OR CRS.OD = "Y" ) AND STU.GN = "F" Total female students in college-level or OnRamps courses | |
| 30. Number of AVID Elective high school students (grades 9-12) who are currently taking or have taken two or more Career & Technical Education, Career Pathways, or Career Preparation courses (do not include Project Lead the Way courses; include in item 31). | Male (STU.GN = "M") | |
| Female (STU.GN = "F") | ||
| 31. Number of AVID Elective high school students (grades 9–12) who are currently taking or have taken two or more Project Lead the Way courses. | Male (STU.GN = "M") | |
| Female (STU.GN = "F") | ||
| 32-36. SKIP | ||
37. Honors, Pre-AP®, and/or high school credit-bearing courses other than Algebra or higher-level math courses (includes gifted and talented courses). Honors (CRS.TY = "H") Pre-AP (CRS.TY = "Q") Algebra or higher-level math (CRS.CN # "nnnn") | AVID | Run AVID KEEP statement above, then TOTAL query (below) (nested KEEP statements) |
| All | 1. KEEP STU IF ( STU.GR >= 6 AND STU.GR <= 8 ) Keep 6th-8th grade students 2. TOTAL STU SEC CRS STU.GR BY STU.GR IF ( CRS.TY = "Q" OR CRS.TY = "H" OR CRS.CR > "0" ) AND ( CRS.CN # "nnnn" AND CRS.CN # "nnnn" ) (where nnnn is the course number for Algebra and other higher-level math courses; combine all applicable course numbers with 'AND') Total students by grade level who are taking Pre-AP or Honors Course, excluding Algebra higher-level math courses | |
| 38. If your school provides any of the following courses, please enter the number of students enrolled for each grade level and population. High-school-level Algebra and/or high school credit-bearing math courses (e.g., Geometry, Algebra 2). | AVID | Run AVID KEEP statement above, then TOTAL query (below) |
| All | TOTAL STU SEC CRS BY STU.GR IF ( CRS.CN = "nnnn" OR CRS.CN = "nnnn" ) (where nnnn = course number for high school-level Algebra, etc; combined multiple course numbers with 'OR') Total students by grade level who have taken an Algebra or high school-credit math course | |
AP (CRS.CL = "30") | IB (CRS.CL = "37" and "38") | AICE N/A | Dual Enrollment (CRS.CL = "24") CRS.OD = "Y" ? | CTE (CRS.S1, S2, or S3 = "C") | PLTW (Project Lead The Way) (CRS.CN = "nnnn") | |
| 39. Are the following types of courses offered at your school? Indicate all that apply. Y/N | Y | N | Y | Y | ||
| 40. For each type of course for which you answered YES, report the TOTAL NUMBER OF SECTIONS offered for these classes. Report all sections even if AVID students are not enrolled. Only include AP, IB, AICE, qualified dual-enrollment, CTE, or PLTW courses. | TOTAL MST CRS IF CRS.CL = "30" Total count of sections of AP courses | TOTAL MST CRS IF ( CRS.CL = "37" OR CRS.CL = "38" ) Total count of sections of AP courses | TOTAL MST CRS IF CRS.CL = "24" Total count of sections of dual-credit courses | TOTAL MST CRS IF ( CRS.S1 = "C" OR CRS.S2 = "C" OR CRS.S3 = "C" ) Total count of sections of CTE courses | TOTAL MST CRS IF ( CRS.CN = "nnnn" OR CRS.CN = "nnnn" ) (where nnnn is the course number for middle or high school PLTW courses; combine all applicable courses with 'OR') Total count of sections of PLTW courses |
41. Number of students who ENROLLED in at least one AP, IB, AICE, or PLTW course. | AVID | Run AVID KEEP statement above, then TOTAL query (#42 below) |
| 42. Number of students who ENROLLED in at least one AP, IB, AICE, or PLTW course. AP: CRS.CL = "30" IB: CRS.CL = "37" and "38" AICE: N/A for KISD PLTW: CRS.CN = "nnnn" (where nnnn is the course number for PLTW course) | All Students | TOTAL STU MST CRS IF (CRS.CL = "30" OR CRS.CL = "37" OR CRS.CL = "38" OR CRS.CL = "24" OR CRS.CN = "nnnnn" OR CRS.CN = "nnnnn" ) (where nnnn is the course number for middle or high school PLTW courses; combine all applicable courses with 'OR') Total students enrolled in the 2019-2020 school year in one or more AP, IB, or PLTW courses |
| 43. Number of students who in 2019-2020 COMPLETED at least one AP, IB, AICE, or PLTW course. | AVID Students | Run AVID KEEP statement above, then TOTAL query (#44 below) |
| 44. Number of students who in 2019-2020 COMPLETED at least one AP, IB, AICE, or PLTW course. Transcripts Table (HIS) HIS.YR = "19" HIS.CR Credits Attempted HIS.CC Completed Credits AP: CRS.CL = "30" IB: CRS.CL = "37" and "38" AICE: N/A for KISD PLTW: CRS.CN = "nnnn" (where nnnn is the course number for PLTW course) | All Students | TOTAL STU HIS CRS STU.ID BY STU.ID IF HIS.YR = "19" AND HIS.CC > "0" AND ( CRS.CL = "30" OR CRS.CL = "37" OR CRS.CL = "38" OR CRS.CN = "nnnn" OR CRS.CN = "nnnn") (where nnnn is the course number for middle or high school PLTW courses; combine all applicable courses with 'OR') Total students who received credit in the 2019-2020 school year in one or more AP, IB, or PLTW courses |
| 45. Number of students who in 2019-2020 took at least one AP, IB, AICE, or PLTW exam. | AVID Students | Please contact your Keller ISD Testing Coordinator for assistance. |
| 46. Number of students who in 2019-2020 took at least one AP, IB, AICE, or PLTW exam. | All Students | Please contact your Keller ISD Testing Coordinator for assistance. |
47. Number of students who in 2019-2020 took at least one AP, IB, AICE, or PLTW exam and who scored 3+ on the AP exam(s); 4+ on the IB exam(s); a “C” or better on the AICE exam(s); or an equivalent or higher score on the PLTW End-of-Course (EoC) Assessment(s). | AVID Students | Please contact your Keller ISD Testing Coordinator for assistance. |
48. Number of students who in 2019-2020 took at least one AP, IB, AICE, or PLTW exam and who scored 3+ on the AP exam(s); 4+ on the IB exam(s); a “C” or better on the AICE exam(s); or an equivalent or higher score on the PLTW End-of-Course (EoC) Assessment(s). | All Students | Please contact your Keller ISD Testing Coordinator for assistance. |
49. Number of students who in 2019-2020 earned all credits attempted. | AVID Students | Run AVID KEEP statement above, then TOTAL queries (#50 below) |
| 50. Number of students who in 2019-2020 earned all credits attempted. Transcripts Table (HIS) HIS.YR = "19" HIS.CR Credits Attempted HIS.CC Completed Credits | All Students | 1. Get total students who attempted credits: TOTAL STU HIS STU.ID BY STU.ID IF HIS.YR = "19" Total students who attempted credits in the 2019-2020 school year 2. Get total students whose credits attempted do not match credits earned: TOTAL STU HIS STU.ID BY STU.ID IF HIS.YR = "19" AND HIS.CR # HIS.CC Total students whose attempted credits do not match credits earned in the 2019-2020 school year 3. Subtract the total of the second query from the total of the first query. |
| 51. AVID Elective students’ average attendance rate in 2020-2021 | Middle School (grades 6-8) | Run AVID KEEP statement above, then TOTAL query (#53 below) |
| High School (grades 9-12) | Run AVID KEEP statement above, then TOTAL query (#53 below) | |
| 52. SKIP (AVID Excel) | ||
| 53. All students’ average attendance rate in 2020-2021 (STU.DP Days Present STU.DE Days Enrolled) | Middle School (grades 6-8) (GR >= 6 AND GR <= 8) | 1. TOTAL STU DP IF ( GR >= 6 AND GR <= 8 ) Total days present for all students at the in grade levels 6-8 2. TOTAL STU DE IF ( GR >= 6 AND GR <= 8 ) Total days enrolled for all students at the in grade levels 6-8 3. Divide Total 1 by Total 2 |
| High School (grades 9-12) (GR >= 9 AND GR <= 12) | 1. 2. 3. | |
| 54. Number of AVID Elective/AVID Excel/All 8th graders in 2019-2020. (STU.GR = 8) | AVID Elective Students | Run AVID KEEP statement above, then TOTAL query (#54 below) (Needs to be run for prior school year) |
| All Students | TOTAL STU IF STU.GR = 8 All 8th grade students (Needs to be run in prior school year) | |
55. Number of AVID Elective/AVID Excel/All 8th graders who in 2019-2020 completed Algebra I, or an equivalent higher level math course with a grade of “C” or better and who were eligible to enroll in Geometry, Algebra 2, and/or the next higher-level math course in 9th grade. Math Only Transcript Mark HIS.MK Algebra I Service IDs: 03100500, 03100507 | AVID Elective Students | Run AVID KEEP statement above, then TOTAL query (#55 below) |
| All Students | 1. TOTAL STU HIS CRS STU.ID BY STU.ID IF HIS.YR = "19" AND HIS.GR = 8 AND ( CRS.SVC = "########" OR CRS.SVC = "########" ) AND HIS.MK >= "70" (where ######## is the service ID of Algebra I or equivalent higher-level math) Total students by student ID who were in 8th grade last year and had a transcript grade of 70 or above in Algebra I or an equivalent higher-level math. 2. Filter the search results by 2. | |
| 56. Number of AVID Elective/AVID Excel/All 8th graders who in 2019-2020 completed an Honors, Pre-AP, and/or high school credit-bearing course other than a math course (e.g., World Languages) with a grade of “C” or better. No Math Honors (CRS.TY = "H") Pre-AP (CRS.TY = "Q") High school credit (CRS.S1, S2, S3 = "M") | AVID Elective Students | Run AVID KEEP statement above, then TOTAL query (#56 below) |
| All Students | TOTAL STU HIS CRS STU.ID BY STU.ID IF HIS.YR = "19" AND HIS.GR = 8 AND ( CRS.TY = "Q" OR CRS.TY = "H" OR CRS.CR > "0" ) AND CRS.S1 # "M" AND CRS.S2 # "M" AND CRS.S3 # "M" AND CRS.DC # "M" AND HIS.MK >= "70 Total students by student ID who were in 8th grade last year and had a transcript grade of 70 or above in an honors, Pre-AP, or specified high school credit courses. | |
| 57. Number of AVID Elective/AVID Excel/All 8th graders who in 2019-2020 took a pre-collegiate test, such as PSAT™ 8/9, ACT Aspire™, ACT Plan®, or ACT Explore®. | AVID Elective Students | Please contact your Keller ISD Testing Coordinator for assistance. |
| All Students | Please contact your Keller ISD Testing Coordinator for assistance. | |
| 58. Number of AVID 8th graders who in 2019-2020 were recommended for enrollment in a complete sequence of college-preparatory courses upon entering high school. | Avid Elective Students | |