Welcome to SCSEPED.org

What’s New: 8/22/19. The PY 2019 modified positions as of 8/20/19 and enrollments as of 7/1/19 have been posted for Q1 PY 19. Modified positions will be updated again before Q1 PY 19 is closed in SPARQ.

7/10/17. The PY 2019 authorized positions and enrollments as of 7/1/19 have been posted for Q1 PY19. Modified positions will be posted in early August, after grantees have allocated their authorized positions to their sub-grantees.

7/1/19. Enrollments as of 7/1/19 have been posted for Q4 PY 2018. These replace the enrollments as of 4/1/19.

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 additional 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.

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 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 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 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 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. Maps. The modified positions and enrollments 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 modified 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 modified positions in each county. Moving the cursor over the county will display the probe box with the summary information about the number of modified 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 modified positions in the county; the size of the square indicates the relative number of state grantee modified positions.

The legend for the color coding also indicates counties that have no modified positions at all, counties that have only state modified positions, and counties in which multiple national grantees or set-aside grantees have modified 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.

Note: If the maps do not load in Internet Explorer, go to Compatibility View Settings under Options in the upper right corner of the screen. Add SCSEPED.org to the list of websites for Compatibility View.

4. 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, help@scsep-help.com.