Data Mining
The Data Mining 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:
- Enrollment
- First-time Freshmen
- High School Graduates
- Transfer
- 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
Caveats.
The
year in the data on subsequent pages refers to different time frames depending on the data:
-
Unless otherwise specified, all enrollment and transfer numbers are Fall-term data.
-
For 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 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)
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.
Any comments,
questions, or suggestions are welcome; send to
Data_Request@cpec.ca.gov or fill out the
Comments form.
Sign up to be notified when this data is updated.
Select a table to explore:
