College Completion And Efficiency Measures For US by Kaggle | Demographics and Population Studies

About this Dataset

College Completion And Efficiency Measures For US

College Completion and Efficiency Measures for US Institutions

Rates, Awards, Expenditures, and Outcomes

By Jonathan Ortiz [source]

About this dataset

This dataset provides valuable insights into college completion rates and efficiency measures for institutions across the United States. Using data from the National Center for Education Statistics’ Integrated Postsecondary Education System (IPEDS) and the Voluntary System of Accountability’s Student Success and Progress rate, this dataset allows for a detailed look at graduation rates among groups of first-time, full-time degree-seeking students at the undergraduate level.

Gain meaningful insights into individual graduation rates by examining data points like race, gender, control (public versus private) and length of study. Determine how well your favorite institution stands up to its peers in terms of awards per 100 full-time undergraduate students as well as expenditure categories that are educational in nature or indirectly associated with educational efforts. Evaluate median estimated SAT scores & average student aid to gain an understanding if admissions standards have an effect on graduating numbers along with financial situations that can be improved through aid sources available to students. Finally, seek out trends in endowment figures whilst assessing the professor faculty size relative to student enrollment size – a great insight into whether institutions are motivated towards maximizing their students' chance of success through providing adequate resources!

More Datasets

For more datasets, click here.

Featured Notebooks

🚨 Your notebook can be here! 🚨!

How to use the dataset

Welcome to the College Completion and Efficiency Measures dataset! This dataset contains graduation rates, efficiency measures, race & ethnicity information, SAT/ACT scores, average student aid awarded, endowment values and faculty headcounts for college institutions in the United States.

In this guide we will explain how to use this dataset and how to analyze its data.

Understand the Columns: Read through the above description of each column carefully. Take note of what type of data is stored in each column (string or number) and understand which columns are important for your desired analysis. Use the list above as a reference if needed.

Filter Your Results: Narrow down your results by selecting filters relevant to your desired analysis. For example you can filter by state name, gender or race by typing their name in them respective box provided at Kaggle’s Data tab (example given below). You can also filter multiple parameters with OR or AND conditions for more detailed results (example given below).
OR Filters: State Name= ‘California’ OR ‘Oregon’ OR Filters: Level= 'Four Year' AND Gender='Male'.
3 Analyze Your Results: Once you have narrowed down on a specific set of records using filters, you can explore various metrics to measure performance such as Graduation Rate within 150%, Awards per 100 full-time undergraduate students Program Expenses per Student etc., Look up scatter plots between metrics like Endowment Value Vs SAT Scores per incoming Freshman Class or Spending budget vs Graduation rate within 150%. Based on these observations identify areas where infrastructural investments may yield improvement in instutional performance over time

Research Ideas

Finding correlations between graduation rates and factors such as control, gender, race and level of institution to identify potential causes of inequity or areas that require further investigation.

Analyzing differences in completion rates among public and private institutions to measure the effectiveness of government funding in improving completion rates.

Using efficiency measures such as awards per 100 full-time undergraduates and expenditure categories to evaluate how financial resources are used within higher education institutions to maximize student success

Acknowledgements

If you use this dataset in your research, please credit the original authors.
Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: cc_state_sector_grads.csv

Column name	Description
state	The two-letter abbreviation for the state where the institution is located. (String)
state_abbr	The full name of the state where the institution is located. (String)
control	The type of institution (public, private non-profit, or private for-profit). (String)
level	The level of institution (two year or four year). (String)
gender	The gender category based off students studying in respective programs. (String)
race	The race options include eight categories such as White Non Hispanic etc. (String)
cohort	The number of students in the cohort. (Integer)
grad_cohort	The number of students in the cohort who graduated. (Integer)
grad_100	The number of students in the cohort who graduated within 100% of the normal time frame. (Integer)
grad_150	The number of students in the cohort who graduated within 150% of the normal time frame. (Integer)
grad_100_rate	The percentage of students in the cohort who graduated within 100% of the normal time frame. (Float)
grad_150_rate	The percentage of students in the cohort who graduated within 150% of the normal time frame. (Float)
grad_cohort_ct	The total number of students in the cohort. (Integer)

File: cc_institution_grads.csv

Column name	Description
level	The level of institution (two year or four year). (String)
gender	The gender category based off students studying in respective programs. (String)
race	The race options include eight categories such as White Non Hispanic etc. (String)
cohort	The number of students in the cohort. (Integer)
grad_cohort	The number of students in the cohort who graduated. (Integer)
grad_100	The number of students in the cohort who graduated within 100% of the normal time frame. (Integer)
grad_150	The number of students in the cohort who graduated within 150% of the normal time frame. (Integer)
grad_100_rate	The percentage of students in the cohort who graduated within 100% of the normal time frame. (Float)
grad_150_rate	The percentage of students in the cohort who graduated within 150% of the normal time frame. (Float)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit Jonathan Ortiz.

Tables

Cc Institution Details

@kaggle.thedevastator_college_completion_and_efficiency_measures_for_u.cc_institution_details

834.79 KB
3798 rows
63 columns


CREATE TABLE cc_institution_details (
  "index" BIGINT,
  "unitid" BIGINT,
  "chronname" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "level" VARCHAR,
  "control" VARCHAR,
  "basic" VARCHAR,
  "hbcu" VARCHAR,
  "flagship" VARCHAR,
  "long_x" DOUBLE,
  "lat_y" DOUBLE,
  "site" VARCHAR,
  "student_count" BIGINT,
  "awards_per_value" DOUBLE,
  "awards_per_state_value" DOUBLE,
  "awards_per_natl_value" DOUBLE,
  "exp_award_value" BIGINT,
  "exp_award_state_value" BIGINT,
  "exp_award_natl_value" BIGINT,
  "exp_award_percentile" BIGINT,
  "ft_pct" DOUBLE,
  "fte_value" BIGINT,
  "fte_percentile" BIGINT,
  "med_sat_value" DOUBLE,
  "med_sat_percentile" DOUBLE,
  "aid_value" DOUBLE,
  "aid_percentile" DOUBLE,
  "endow_value" DOUBLE,
  "endow_percentile" DOUBLE,
  "grad_100_value" DOUBLE,
  "grad_100_percentile" DOUBLE,
  "grad_150_value" DOUBLE,
  "grad_150_percentile" DOUBLE,
  "pell_value" DOUBLE,
  "pell_percentile" DOUBLE,
  "retain_value" DOUBLE,
  "retain_percentile" DOUBLE,
  "ft_fac_value" DOUBLE,
  "ft_fac_percentile" DOUBLE,
  "vsa_year" DOUBLE,
  "vsa_grad_after4_first" DOUBLE,
  "vsa_grad_elsewhere_after4_first" DOUBLE,
  "vsa_enroll_after4_first" DOUBLE,
  "vsa_enroll_elsewhere_after4_first" DOUBLE,
  "vsa_grad_after6_first" DOUBLE,
  "vsa_grad_elsewhere_after6_first" DOUBLE,
  "vsa_enroll_after6_first" DOUBLE,
  "vsa_enroll_elsewhere_after6_first" DOUBLE,
  "vsa_grad_after4_transfer" DOUBLE,
  "vsa_grad_elsewhere_after4_transfer" DOUBLE,
  "vsa_enroll_after4_transfer" DOUBLE,
  "vsa_enroll_elsewhere_after4_transfer" DOUBLE,
  "vsa_grad_after6_transfer" DOUBLE,
  "vsa_grad_elsewhere_after6_transfer" DOUBLE,
  "vsa_enroll_after6_transfer" DOUBLE,
  "vsa_enroll_elsewhere_after6_transfer" DOUBLE,
  "similar" VARCHAR,
  "state_sector_ct" BIGINT,
  "carnegie_ct" BIGINT,
  "counted_pct" VARCHAR,
  "nicknames" VARCHAR,
  "cohort_size" DOUBLE
);

Cc Institution Grads

@kaggle.thedevastator_college_completion_and_efficiency_measures_for_u.cc_institution_grads

10.32 MB
1302102 rows
11 columns


CREATE TABLE cc_institution_grads (
  "index" BIGINT,
  "unitid" BIGINT,
  "year" BIGINT,
  "gender" VARCHAR,
  "race" VARCHAR,
  "cohort" VARCHAR,
  "grad_cohort" DOUBLE,
  "grad_100" DOUBLE,
  "grad_150" DOUBLE,
  "grad_100_rate" DOUBLE,
  "grad_150_rate" DOUBLE
);

Cc State Sector Details

@kaggle.thedevastator_college_completion_and_efficiency_measures_for_u.cc_state_sector_details

22.15 KB
312 rows
17 columns


CREATE TABLE cc_state_sector_details (
  "index" BIGINT,
  "stateid" BIGINT,
  "state" VARCHAR,
  "state_abbr" VARCHAR,
  "state_post" VARCHAR,
  "level" VARCHAR,
  "control" VARCHAR,
  "schools_count" BIGINT,
  "counted_pct" DOUBLE,
  "awards_per_state_value" DOUBLE,
  "awards_per_natl_value" DOUBLE,
  "exp_award_state_value" DOUBLE,
  "exp_award_natl_value" BIGINT,
  "state_appr_value" DOUBLE,
  "state_appr_rank" DOUBLE,
  "grad_rate_rank" DOUBLE,
  "awards_per_rank" DOUBLE
);

Cc State Sector Grads

@kaggle.thedevastator_college_completion_and_efficiency_measures_for_u.cc_state_sector_grads

1.06 MB
84942 rows
16 columns


CREATE TABLE cc_state_sector_grads (
  "index" BIGINT,
  "stateid" BIGINT,
  "state" VARCHAR,
  "state_abbr" VARCHAR,
  "control" VARCHAR,
  "level" VARCHAR,
  "year" BIGINT,
  "gender" VARCHAR,
  "race" VARCHAR,
  "cohort" VARCHAR,
  "grad_cohort" BIGINT,
  "grad_100" DOUBLE,
  "grad_150" BIGINT,
  "grad_100_rate" DOUBLE,
  "grad_150_rate" DOUBLE,
  "grad_cohort_ct" BIGINT
);