Kansas State Department of Education
Kansas Education Comparative Performance and Fiscal System
Instructions

1. You must have your browser configured to accept "cookies". On this page and subsequent pages, you can view helpful tips by moving your mouse over the word "Tip" (there will be a green circle next to it). If you click on the word "Tip", you will see this instruction manual.
2. If you want to create your own report by selecting data items for a selected USD(s) and school year, click on "START BUILDING YOUR CUSTOM REPORT". If you want to view a report for all USD's that we have already generated, click on "OR ACCESS STANDARD REPORTS" (see Figure 1).

Figure 1.

Step 2: Selecting Unified School Districts (USD’s)

1. Select from one of the following:
• All Unified School Districts
• One or more Unified School Districts
• USD’s who own property in a specific KSBE District
• USD’s whose home office is located in a specific county
• USD’s who own property in a specific Kansas House District
• USD’s who own property in a specific Kansas Senate District

Example: Click on the radio button next to "Home County", then select "Johnson" from the list of counties.

2. Click on "NEXT STEP" (see Figure 2).

Figure 2.

Step 3: Optional Selection Criteria

1. If you want to narrow your selection criteria, you can choose any of the following:
• USD Headcount Enrollment Size
• Low Income (Free and Reduced-Price Lunch) Percentage
• Special Ed. Percentage (Sp. Ed. Headcount (excludes Gifted) divided by total headcount)

Example: Select "Over 10,000" from the list box next to "USD Headcount Enrollment Size".

2. Click on "NEXT STEP" (see Figure 3).

Figure 3.

Step 4: School Year

1. Select a school year. When you run the report, it will display data for this school year. At the present time, if you select only one USD on the Unified School Districts page (see Figure 2), you can select multiple school years. If you select more than one USD, you can select only one school year at a time.

Example: Select "2004-2005" from the list of school years.

2. Click on "NEXT STEP" (see Figure 4).

Figure 4.

Step 5: Data Items

1. Click on the checkbox next to each data item that you want to display in the report. You can choose as many data items as you want. NOTE: If you click on the checkbox next to "School District Budget Data", the program will display the "Budget Data" page when you click on "Next Step". If you don’t select "School District Budget Data", the program will display the "Create Report" page.

Example: Click on the checkboxes next to "Mill Levy Rates", "FTE Enrollment", "Headcount Enrollment", "Percentage of Students Approved for Free- and Reduced-Price Lunches", and "School District Budget Data".

2. Click on "NEXT STEP" (see Figure 5).

Figure 5.

Step 6: Budget Data

1. As was mentioned in Step 5, if you click on the checkbox next to "School District Budget Data" on the Data Items page, the program will display the "Budget Data" page.
2. Select at least one fund, the type of data to display (i.e., revenues or expenditures), and the type of report to display. If you select "Revenues" for the type of data, you can choose "Fund Total" or "Total by Function/Sub-Function" for the type of report. If you select "Expenditures", you can choose "Fund Total", "Total by Function/Sub-Function", "Total by Object", or "Total by Object/Sub-Object" for the type of report.

Example: Select "General" from the list of Budget Funds, "Revenues" from the list of Budget Types, and "Total by Function/Sub-Function" from the list of Budget Reports.

3. Click on "NEXT STEP" (see Figure 6).

Figure 6.

Step 7: Create the Report

1. Click on "CLICK HERE TO CREATE YOUR REPORT" or "CREATE REPORT" (see Figure 7).

Figure 7.

Step 8: Display the Report

1. Once the program displays your report, you have several options (see Figure 8):
• You can click on a column heading to sort the report in ascending order by that column. If you click on the same column again, the program will sort the report in descending order by that column.
• You can click on the "Export to Excel" button to display or save the report as an Excel spreadsheet. When you click on this button, a prompt will appear that asks you if you want to open the Excel spreadsheet or save the spreadsheet on your computer. If you click on "Open", the program will display the Excel spreadsheet in your browser. If you click on "Save", a prompt will appear that asks you to enter a filename and select the location where you want to save the file. If you want to manipulate the data using Excel, then you should click on "Save" instead of "Open".
• You can click on the "Rotate Report" button to "rotate" the report so that the columns that were displayed in the original report now become rows, and the rows are now columns. If you click on "Rotate Report" again, the program will "rotate" the report again so that it’s displayed in its original format.

Example: Click on "Total Mill Levy", then click on it again. Click on the "Rotate Report" button, then click on it again.

Figure 8.

Questions or Problems: cpfs@ksde.org