CALPADS contains individual data by student, and Dataquest is the CDE information system that tracks demographic information and test scores by school, ethnicity, grade, etc. The link is here.
DataQuest (CA Dept of Education) Enrollment Data - School (grade and ethnicity). This is where they take the individual student data and aggregate it by school, grade, district, etc.
Each year, UCs then have to report out to the State by campus and by race who applied and who was admitted by their race categories for freshman admits and transfer admits and enrolled -
Undergraduate admissions summary If you click the Berkeley campus, Berkeley says 17 American Indians enrolled in 2020, 4 of which were domestic nonresidents (out of state) and 13 were CA residents. The CSUs also have to do this as well, but this is on another website.
Some school districts and providers that are contractors that produce the transcripts include the race/ethnicity of a student when they produce an official transcript and send it off to colleges.
If you look at the Dataquest website on the CDE website, and filter by gender:
Foothill High Report (01-75101-0130096)
2016-2017 Foothill High - 0 10th grade female students are American Indian/Alaskan Native
2015-2016 Foothill High - 0 9th grade female students are American Indian/Alaskan Native
Thomas S. Hart Middle Report (01-75101-6117592)
2014-2015 Hart Middle School - 0 8th grade male/female students are American Indian/Alaskan Native
2013-2014 Hart Middle School - 0 7th grade male/female students are American Indian or Alaska Native, Not Hispanic
2012-2013 Hart Middle School - 0 6th grade male/female students are American Indian or Alaska Native, Not Hispanic
6001366 Donlon Elementary Report
2011-2012 Donlon Elementary - 0 5th grade male/female students are American Indian or Alaska Native, Not Hispanic
2010-2011 Donlon Elementary - 0 4th grade male/female students are American Indian or Alaska Native, Not Hispanic
etc.
Also, the College Board tracks individual's race and ethnicity. Please see
SA:DATA:2015-16 Changes to the Collection and Reporting of Student Race and Ethnicity Data This is the corporation that performs AP testing, PSAT testing (PSAT/10 and PSAT/NMSQT), SAT testing, etc. and sends official results to colleges for AP test results and SAT test results.
In addition, when students sign up with the College Board in Pleasanton to take the ReadiStep test in grades 8 or 9, and I believe the ethnicity and race are possibly also captured by the College Board at this time (8th grade). I'm not sure about other school districts, but middle school students in Pleasanton usually take the ReadiStep in the 8th grade. This is called the PSAT 8/9 in some school districts. Hart Middle School, along with the other two middle schools in Pleasanton, have given the College Board PSAT 8/9 also called ReadiStep to 8th grade students ( see
PSAT Results Information ) every year except recently because of COVID.
If you look at the College Board website, current ethnicity categories are:
- Cuban
- Mexican
- Puerto Rican
- Another Hispanic, Latino, or Spanish origin
- Not of Hispanic, Latino, or Spanish origin
Race categories are:
- American Indian or Alaska Native
- Asian (including Indian subcontinent and Philippines origin)
- Black or African American
- White (including Middle Eastern origin)
- Native Hawaiian or Other Pacific Islander
I'm not certain whether the ACT also captures race and ethnicity, but I would not be surprised. The CDE summarizes data for SATs, ACTs and AP tests here
Postsecondary Preparation (CA Dept of Education)