Skip to: Content | Footer

California Postsecondary Education Data Home Page

Reproduce Pre-Configured Report

Follow these instructions to replicate the pre-configured reports located throughout the website. For all of the various reports, change or select only the options listed. All of the other aggregations and filters can be ignored. For some reports, the data will need to be manipulated after the full report has been generated. For example, the college-going rates exclude students with unknown genders and ethnicities. To match the numbers on the pre-configured page, these data must be deleted from the results. Square brackets, [], around an option or title indicates that it is a placeholder for a selection or input.

Instructions These instructions assume that you have some familiarity with how the Custom Data Report System works and some experience using a spreadsheet program such as Microsoft Excel or a database program such as Microsoft Access to manipulate the downloaded data. Information about how to use the Custom Data Report System can be found in the Instructions and in the step-by-step walk through of an example report.

To generate the Freshmen Pathway Charts - High School to [Postsecondary Education Institution] located at http://www.cpec.ca.gov/OnLineData/FreshmenPathway.asp:

  1. Start at the Custom Data Reports, http://www.cpec.ca.gov/OnLineData/OnLineData.asp.

  2. Select "Higher Education Enrollment" from the list under "Select a Data Report".

  3. Mark the radio button in front of "Freshmen at Public Institutions / College Going Counts" and hit the Enter key or click on "Select Final Options" at the bottom of the page.

  4. Under "Time Frame for Data", change the following options:
    • Select "Last 5 Years" from the drop-down list.
  5. Under "Aggregate (Group) Data By", modify the following options:

    1. Under "The High School's":
      • Mark the checkbox in front of "Type of School".
      • Mark the checkbox in front of "School Name".
  6. Adjust the following filters:

    1. Under "Include only Students at Current (Receiving) Colleges or Universities that match the following criteria", change the following options:
      • Type "[One or Two Words from the Name]" in the form (without the quotes).
      • Select "[The System for the College or University]" from the drop-down list.
    2. Under "Include only Students from High Schools that match the following criteria", change the following options:
      • Type "not unknown" in the form (without the quotes).
    3. Under "High School Graduates and A-G Completions", change the following options:
      • Mark the radio button in front of "Do Not Include" for "Graduates From".
  7. Click on "Generate Report" at the bottom of the page. A new window will open with the results.

Special Instructions / Notes

  • The location of this report is actually the main page for the Freshmen Pathways. This data can be found by clicking on the name of the Postsecondary Education Institution.
  • The Freshmen Pathways report includes 15 years. Download the data then change the years to Years 6-10, then Years 11/15. Combine the data using a spreadsheet or database program.
  • When entering the [One or Two Words from the Name] choose something that is fairly unique to the school.
 

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

See Citing Information on the Terms of Use 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 form.