Welcome to SCSEPED.org

What’s New: 11/30/2020: Due to the end of life of Adobe Flash Player, "Maps" is no longer available on SCSEPED.org. Users can access the 2010 Census Geographic Areas Reference Maps for each state at https://www.census.gov/geographies/reference-maps/2010/geo/2010-geograph....

10/4/2020: Authorized and modified positions, along with enrollments as of 10/1/2020, have been posted for Q2PY20.

9/1/2020: PY 2020 modified positions and enrollments as of 8/5/2020 have been posted for Q1PY20.

8/17/2020: PY 2020 authorized positions and enrollments as of 8/5/2020 have been posted for Q1PY20.

Overview. SCSEPED.org provides all Senior Community Service Employment Program (SCSEP) grantees and sub-recipients access to information about the number of SCSEP authorized and modified positions, the number of current enrollments as of the end of the quarter, and the difference between the two (variance) in each county in the country. For state grantees and national grantees, the authorized positions displayed are those defined by Equitable Distribution (ED) for each program year. For set-aside grantees, the authorized positions are those listed in the grant award; these set-aside positions are separate from and in addition to any positions authorized by ED. The modified positions are calculated based on the minimum wage in each county. (Note: Due to rounding, the sum of the modified positions by county for a grantee or sub-grantee will not always equal the official modified positions displayed in the QPR for that grantee or sub-grantee.) The enrollment data are updated each quarter and reflect the number of enrollments active in SPARQ on the first day of the current quarter. At the end of the fourth quarter, the enrollments for that quarter are updated to reflect the enrollments on the last day of that quarter, which is also the last day of the program year.

Three functions are available to users:
1. Tables by State (both MP and AP in separate tabs).
2. Tables by Grantee (both MP and AP in separate tabs).
3. Download All States Data (both MP and AP in separate tabs).

1. Tables by state. There are separate tables for each state, the District of Columbia, and Puerto Rico. These tables are accessed by clicking on Tables by State in the menu bar at the top of the page. There are separate menu items for MP and AP. Dropdown menus at the top left corner of the screen allow the user to select the state, the program year, and the quarter to display. Only the selected quarter is displayed on this page. The tables list each county in the state, along with its FIPS code (the Census Bureau’s identifier for the county), followed by three columns of data for each grantee that operates in the state: the number of modified or authorized positions assigned to the grantee in each county, the number of current enrollments in each county, and the variance in each county between the number of modified or authorized positions and the number of enrollments. A positive variance number means that the grantee is over-enrolled in that county compared to ED, and a negative variance number means the grantee is under-enrolled.

The first set of columns lists the state grantee; subsequent columns list the national grantees that operate in the state. Set-aside grantees that operate in that state are listed in the columns farthest to the right.

A box at the top right corner of the page summarizes at the state level the modified or authorized positions, enrollments, and variance for the state grantee, all national grantees, the state grantee and the national grantees combined (for the total state ED), and all set-aside grantees. Additional columns list:

  • The total number of counties for each type of grantee
  • The number and percentage of those counties that are under-enrolled, along with the average rate of under-enrollment in the under-enrolled counties
  • The number and percentage of those counties that are over-enrolled, along with the average rate of over-enrollment in the over-enrolled counties
  • The total number of over- or under-enrolled counties, the percentage of all counties that are under- or over-enrolled, and the total variance (the absolute total number of positions over- or under-enrolled without regard to directionality) divided by the number of modified or authorized positions
  • The last column contains a visualization of the trend line of the percent of total variance. Whenever two or more quarters of data are available, you can see the visualization in the last column by clicking on the name of the grantee type in the first column. The color code for the visualization is accessible by clinking on the link, Spark Line Legend, located under the dropdown for state.

For details of the calculations in the tables and summary, see Definitions, the second from the last tab in the menu bar.

The button in the top left corner under the dropdown for the state allows the user to download all the state table data into a spreadsheet.

2. Tables by Grantee. This function provides tables for each national grantee in each state in which the national grantee operates, as well as tables for all state grantees. These tables are accessed by clicking on Tables by Grantee in the menu bar at the top of the page. There are separate menu items for MP and AP. Dropdown menus at the left of the screen allow the user to select the grantee, the program year, and the quarter to display. Unlike the Tables by State, which only display a single quarter of data, the detailed tables on this page display all available quarters in the program year selected regardless of which quarter is selected. The dropdown for quarter does control what quarter is displayed in the Summary of Grantee Counties at the top of the page.

The detailed tables list each county in each state in which the grantee operates, along with its FIPS code (the Census Bureau’s identifier for the county), followed by four columns of data: the number of modified or authorized positions assigned to the grantee in each county, the number of current enrollments in each county, the variance in each county between the number of modified or authorized positions and the number of enrollments, and the percent of positive or negative variance in that county. There is a summary row showing the totals for each state. The last column of the state summary shows the percent of total variance in that state, which is calculated by dividing the total absolute variance (the total number of positions over- or under-enrolled without regard to directionality) by the number of authorized positions.

A box at the top right corner of the page summarizes at the grantee level the modified or authorized positions, enrollments, and variance for each state in which the national grantee selected operates, along with a row showing totals for the grantee. The summary provides one row for each state grantee when State Grantees is selected from the Grantee dropdown. Additional columns list:

  • The total number of counties in the state served by the grantee
  • The number and percentage of those counties that are under-enrolled, along with the average rate of under-enrollment in the under-enrolled counties
  • The number and percentage of those counties that are over-enrolled, along with the average rate of over-enrollment in the over-enrolled counties
  • The total number of over- or under-enrolled counties, the percentage of all counties that are under- or over-enrolled, and the total variance (the total number of positions over- or under-enrolled without regard to directionality) divided by the number of modified or authorized positions
  • The last column contains a visualization of the trend line of the percent of total variance. Regardless of which quarter is selected, whenever two or more quarters of data are available, you can see the visualization of all available quarters for the program year in the last column by clicking on the name of the state in the first column. The color code for the visualization is accessible by clinking on the link, Spark Line Legend, in the upper right corner, above the last column.

For details of the calculations in the tables and summary, see Definitions, the last tab in the menu bar.

The buttons in the top right corner above the summary allow the user to download the detailed table; the summary for the quarter for the national grantee you have selected or for all state grantees; or the summary for all grantees for all available quarters. After the “Please wait…” message disappears, you must then click on the link to the left of the download buttons to complete the download.

3. Download All States Data. The separate tabs for MP and AP on the menu bar at the top of the page provide access to an export function that allows the user to download all of the data for all states, the District of Columbia, and Puerto Rico. The content and format of this download of all data are the same as the content and format for the download of individual state data that can be accessed from the Tables by State page. A dropdown lets the user select the program year and quarter. Once the data are downloaded, a national grantee or set-aside grantee can sort the data to isolate those states and counties in which the grantee operates.

For questions or more information about this site, please e-mail: SCSEP HELP, support@scsephelp.zendesk.com.