The CAHSEE Early Warning Model provides school districts in California with a spreadsheet model that they can use to predict individual students’ probability of passing the California High School Exit Exam (CAHSEE) when they reach grade 10. Districts can use data gathered either in grade 6 or grade 8, which allows them to target assistance to students the following school year, when they enter grade 7 or grade 9.
The model is based on statistical analysis of similar data from the San Diego Unified School District, conducted by members of the San Diego Education Research Alliance at UCSD (sandera.ucsd.edu).
A district can download the spreadsheets, then test (or "validate”) the model by entering data from a cohort from the district that has already taken the exam. Once the model has been validated, the district can input basic data and obtain each student’s predicted probability of passing each exam component (mathematics and English Language Arts, or ELA) and also the overall exam in grade 10.
A key advantage of this model is that it does not rely on a single test score or grade to estimate these probabilities but combines data from multiple sources that districts should have readily available.
The model consists of validation and forecasting spreadsheets for grade 6 and validation and forecasting spreadsheets for grade 8.
Accompanying the model is an instruction manual which explains how to use each spreadsheet.
|Validating the Model for Students Who Have Already Taken the CAHSEE in Grade 10, for Grade 6
(2.41 MB, Excel)
|Forecasting the Probability of Passing the CAHSEE in Grade 10, for Grade 6 Students
(2.17 MB, Excel)
|Validating the Model for Students Who Have Already Taken the CAHSEE in Grade 10, for Grade 8
(2.56 MB, Excel)
|Forecasting the Probability of Passing the CAHSEE in Grade 10, for Grade 8 Students
(2.26 MB, Excel)
(638 KB, PDF)
Note: Some browsers are programmed to automatically attempt to open certain types of files within the browser window. If you would like to
bypass this attempt and make sure that the file is downloaded directly to your disk, right click on the file
link and choose "Save Target As ...".