The Trend Analysis system is a tool that can be used to examine the Commission's various database tables
for trends over time. It can also be used to discover anomalies with the data such as large numerical
differences between consecutive years reported and gaps when no data were reported.
To aid in finding the anomalies, a "tolerance" can be defined to find rows of data that contain a percentage
change of 10-50% between any two consecutive years. If any two consecutive years of data in a given row
meet or exceed the set tolerance percentage, the row will be colored yellow (more than 3x the tolerance),
green (more than 2x) or blue (more than 1x). Also, a row will be colored gray in cases when the school
has been closed. The "red flag" option can also be set to allow users to highlight individual data cells that
have a large numerical difference from that of consecutive cells surrounding it. This "red flag" option can be
set to 1x, 2x, or 3x of the "tolerance" selected. When this tolerance level is met, the individual cell
will be red to indicate that it has been flagged.
The Commission has collected data in the following areas:
- First-time Students
- High School Graduates
- Degrees / Completions
These data are aggregated into database tables and used to generate the various
Custom Data Reports
available via the web and used internally. Since these tables answer, and/or provide
input to over 95% of the questions and issues surrounding higher education, the quality and reliability of these
data tables is paramount. Internally, Commission staff use a system similar to this to validate data that is submitted
each year by the public segments before posting the data on the website. Any anomalies found are researched
with the segments and documented in the
in the data refers to different time frames depending on the data:
Unless otherwise specified, all enrollment, full-time equivalent enrollment, and transfer numbers are Fall-term data.
For enrollment, full-time equivalent enrollment, and Fall-term transfer numbers, the data is for the Fall term of the year shown. (e.g. 2000 refers to Fall 2000 data)
For full-year transfer numbers, the data is for the academic year ending in the year shown. (e.g. 2000 refers to Academic Year 1999-2000 data)
For high school graduation, K-12 enrollment, and degree and completion numbers, the data is for the academic year ending in the year shown. (e.g. 2000 refers to Academic Year 1999-2000 data)
An "N/A" indicates there were no data from that source for the time period. Sometimes an institution is not open, or it may not exist during the time period selected. Other times there were no enrollment, transfer or degree data for the criteria selected in a specific year.
If you are looking for specific data, use the
Custom Data Reports
system. This system provides the most flexibility for generating a data report.
For information on the dates
available for each table see
Custom Data Reports Dates Available
questions, or suggestions are welcome; send to
or fill out the
to be notified when this data is updated.
Select a table to explore:
Looking for other Commission data?
Visit Where to Find Data
for quick links sorted by the type of data.
Want to reproduce a pre-configured data report?
Visit Reproduce Pre-Configured Report
for available instructions.
How to Cite this Information
page for some suggestions.
See something weird?
Known problems and notes about the data are documented on the Caveats
page. Please let us know if you notice something that is not included. Send an e-mail to Data_Quality@cpec.ca.gov
or fill out the Comments