Skip to main content

KYVL QuickSearch



Committees and Work Groups

Academic library data

  • Begin at IPEDS > Use the Data > Compare Institutions.
  • Use most current data, which may be provisional release
  • Continue
  • In Institution Name, paste this list of NCES Unit IDs to search IPEDS data for KYVL academic library members:

156189, 156222, 156213, 156231, 156286, 156295, 157553, 156392, 156356, 156365, 156408, 156417, 156620, 156648, 156727, 157438, 156745, 156790, 156851, 156860, 156921, 157100, 157058, 157076, 157207, 157216, 157304, 157331, 157377, 157386, 157401, 157447, 247940, 157711, 156338, 157739, 157757, 157793, 157809, 157818, 157863, 157085, 157289, 157535, 156541, 157483, 157951, 157298, 461759, 157748

  • Select
  • Check all
  • Continue
  • Continue
  • Search for variables
    • 12-month full-time equivalent enrollment (Frequently used / Derived variables > 12-month enrollment)
      • Select year(s)
      • Select variable
    • Total materials/services expenditures (Academic Libraries > Characteristics, collections, expenditures and services >  Expenditures)
      • Select year(s)
      • Select variable
  • Continue
  • Continue
  • (Select report options)
  • Continue

K12 data

​For K12 public school district data:

  • Begin at Kentucky Department of Education > Open House > School Report Card > Data Sets
  • Select most recent year available
  • Select Profile > School / District Details
  • Open downloaded spreadsheet
  • Key data for calculating assessments is found in the following columns:
    • E - DIST_NAME
    • G - SCH_NAME
    • K - SCH_TYPE
    • O - MEMBERSHIP (student headcount)
      • Must convert to number for formulas below to work
      • Hide blanks, convert, unhide
  • Create a new table of three columns
    • Deduped list of district names
    • A1 school count - =COUNTIFS(Table1[DIST_NAME],$AE2,Table1[SCH_TYPE],"A1")
    • Student headcount- =SUMIFS(Table1[MEMBERSHIP],Table1[DIST_NAME],$AE2,Table1[SCH_NAME],"---District Total---")
  • This table will contain the data necessary for formula calculation.

Private school data can be found in the Kentucky Schools Directory.

Map of Kentucky public school districts

Public library data

Kentucky Public Library Statistics are generally published between March and May for the preceding fiscal year.

For an Excel copy, contact KDLA. Required data are County, Population and Collection Expenditures Total. Data must be merged by county.

Special library data

Formula data for hospitals is been taken from the the American Hospital Directory. Kentucky Hospital Directory may be consulted for additional information. Calculation of fees for non-hospital special libraries will be reviewed in F18-19.

Spreadsheet formula (draft)

Transition Rules Applied column formula (AcTab)

F18-19

=ROUND(IF([@[F18-19 Formula Total]]<=[@[F17-18 Baseline]],[@[F17-18 Baseline]],IF([@[F18-19 Formula Total]]<=1.2*[@[F17-18 Baseline]],[@[F18-19 Formula Total]],IF([@[F18-19 Formula Total]]>2.5*[@[F17-18 Baseline]],([@[F18-19 Formula Total]]/[@[F17-18 Baseline]])^(1/5)*[@[F117-18 Baseline]],1.2*[@[F17-18 Baseline]]))),0)

F19-20 (Years change automatically when columns are renamed)

=ROUND(IF([@[F19-20 Formula Total]]<=[@[F18-19 Baseline]],[@[F18-19 Baseline]],IF([@[F19-20 Formula Total]]<=1.2*[@[F18-19 Baseline]],[@[F19-20 Formula Total]],IF([@[F19-20 Formula Total]]>2.0736*[@[F18-19 Baseline]],([@[F19-20 Formula Total]]/[@[F18-19 Baseline]])^(1/4)*[@[F18-19 Baseline]],1.2*[@[F18-19 Baseline]]))),0)

F20-21: 1.728, (1/3)
F21-22: 1.44, (1/2)
F22-23: 1.2, (increase)

In Formula column formula (AcTab): CHECK LOGIC

=IF([@[F19-20 Formula % Change]]<0,"F18",IF([@[F19-20 Formula % Change]]<=0.2,"F19",IF([@[F19-20 Formula % Change]]<=0.44,"F20",IF([@[F19-20 Formula % Change]]<=0.728,"F21",IF([@[F19-20 Formula % Change]]<=1.0736,"F22","F23")))))

Summary of formula calculations:

  • If Formula < Baseline: Baseline [already in formula]
  • Else If Formula <= 1.2*Baseline: Formula [in formula with this increase]
  • Else if Formula > max: root [in formula in F22-23]
  • Else: 1.2*Baseline [en route to formula]
Kentucky Virtual Library • 1024 Capital Center Drive, Suite 320 • Frankfort, KY 40601 • 844.400.KYVL toll free • kyvl@ky.gov
A program of the Kentucky Council on Postsecondary Education logo