Welcome to SCSEPED.org

SCSEPED.org provides all Senior Community Service Employment Program (SCSEP) grantees and sub-recipients access to information about the number of SCSEP authorized positions, the number of current enrollments as of the end of the last 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 additional to any positions authorized by ED. The enrollment data are updated each quarter and always reflect the number of enrollments active in SPARQ on the first day of the current quarter.

Four functions are available to users:
1. Tables by state.
2. Tables by Grantee.
3. Maps.
4. Download All States Data.

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. Dropdown menus at the top left corner of the screen allow the user to select the state, the program year, and the quarter you want to display. Only the selected quarter is displayed on this page. The tables list each county in the state, along with its FIPS number (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 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 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 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 percent of those counties that are under-enrolled, along with the average rate of under-enrollment in the under-enrolled counties
  • - The number and percent 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 percent 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 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 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. Dropdown menus at the left of the screen allow the user to select the grantee, the program year, and the quarter you want 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 number (the Census Bureau’s identifier for the county), followed by four columns of data: the number of 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 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 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 percent of those counties that are under-enrolled, along with the average rate of under-enrollment in the under-enrolled counties
  • - The number and percent 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 percent 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 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. Maps. The data in the state tables can be visualized on a set of maps. When you click on Maps in the menu bar at the top of the page, the nationwide map opens in a separate browser page. The user will now have two tabs open and can toggle between the tables and the maps. A time slider under the map allows the user to select the program year for which data are displayed. The default view for the maps is the current quarter of the program year selected.

On the nationwide map, the user can see summary information about the number of authorized positions and enrollments in a state by moving the cursor over a state. The information is displayed in a pop-up probe box.

A single click on a state will drill down to the state map showing each county in the state. Another click will let the user drill down to a particular county. The counties are color-coded to show which national grantees have authorized positions in each county. Moving the cursor over the county will display the probe box with the summary information about the number of authorized positions and enrollments in the county; it will also highlight in the legend to the right of the map the name of the national grantee or set-aside grantee that has authorized positions in that county. A square within the county boundaries indicates that the state grantee has authorized positions in the county; the size of the square indicates the relative number of state grantee authorized positions.

The legend for the color coding also indicates counties that have no authorized positions at all, counties that have only state authorized positions, and counties in which multiple national grantees or set-aside grantees have authorized positions. Note that NAPCA, which is both a national grantee and a set-aside grantee, does not have its own color in the legend or the map because all of its authorized positions occur in counties with multiple national grantees or set-aside grantees.

The navigation tool in the upper left corner of the map page allows the user to zoom in or zoom out using the slider bar. The compass rose at the top of the slider bar allows the user to move the view north, south, east, or west. Clicking on the icon in the center of the compass rose will bring the user up a level: from the county view to the state view, or from the state view to the nationwide view.

4. Download All States Data. The fifth tab on the menu bar at the top of the page provides 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: maize.ann@dol.gov.