DOE A to Z: A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #
Electronic Distribution User Manual
A. Installation
The New Jersey State Department of Education Comparative Spending Guide distribution diskette contains two files, CSG99.ZIP and PKUNZIP.EXE. Users of the data should create a directory on their PC, change directory to that location and copy these files to that directory by typing the following:
COPY A:*.*
Once complete, type
PKUNZIP CSG
25 files will be unzipped. These files contain all data used in the comparative spending guide and are stored in Dbase III+ formats (Excel format for Reconciliation files). This format will allow users to import the data into numerous commercially available database software packages and thereby, allow for the analysis of the data using these packages.
B. File Index
File names correspond to the Comparative Spending Guide Indicator number. For example, all data for indicator 1 are contained in the file CSG1.dbf.
C. File Structure - Indicator Files
The 22 CSG indicator files have 12 unique file structures:
1. Structure for Indicator 1
Field Name | Description |
Group | Text indicating Operating type/Enrollment grouping |
Coname | County Name |
District | District Code |
Distname | District Name |
PP96 | Per pupil amount (96-97 actual costs) |
Rank96 | Per pupil Ranking (96-97 actual costs) |
PP97 | Per pupil amount with TPAF(97-98 actual costs) |
Rank97 | Per pupil Ranking with TPAF (97-98 actual costs) |
PP97 | Per pupil amount without TPAF(97-98 actual costs) |
Rank97 | Per pupil Ranking without TPAF (97-98 actual costs) |
PP98 | Per pupil amount (98-99 budget costs) |
Rank98 | Per pupil Ranking (98-99 budget costs) |
2. Structure for Indicator 2,4,5,6,8,10,12,13
Field Name | Description |
Group |
Text indicating Operating type/Enrollment grouping |
Coname | County Name |
District | District code |
Distname | District Name |
PP96 | Per pupil amount (96-97 actual costs) |
Rank96 | Per pupil Ranking (96-97 actual costs) |
Pct96 | % of Total Cost/pupil (96-97) |
PP97 | Per pupil amount (97-98 actual costs) |
Rank97 | Per pupil Ranking (97-98 actual costs) |
Pct97 | % of Total Cost/pupil (97-98) |
PP98 | Per pupil amount (98-99 budget costs) |
Rank98 | Per pupil Ranking (98-99 budget costs) |
Pct98 | % of Total Cost/pupil (98-99) |
3. Structure for Indicator 3,7,9,11
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name PP96 Per pupil amount (96-97 actual costs) Rank96 Per pupil Ranking (96-97 actual costs) Pct96 % of Total Cost/pupil (96-97) Pct296 % of Total Salaries/Benefits to Indicator Variable (96-97) PP97 Per pupil amount (97-98 actual costs) Rank97 Per pupil Ranking (97-98 actual costs) Pct97 % of Total Cost/pupil (97-98) Pct297 % of Total Salaries/Benefits to Indicator Variable (97-98) PP98 Per pupil amount (98-99 budget costs) Rank98 Per pupil Ranking (98-99 budget costs) Pct98 % of Total Cost/pupil (98-99) Pct298 % of Total Salaries/Benefits to Indicator Variable (98-99)
4. Structure for Indicator 14
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name PP96 % of Total Salaries (96-97) PP97 % of Total Salaries (97-98) PP98 % of Total Salaries (98-99)
5. Structure for Indicator 15
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name PP96 Per Pupil Costs (96-97) PP97 Per Pupil Costs (97-98) PP98 Per Pupil Costs (98-99)
6. Structure for Indicator 16
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name Strat97 Student/Teacher Ratio (97-98) Rk97 Ratio Ranking (97-98) Salt97 Teacher Salary (97-98) Rk97 Salary Ranking (97-98) Strat98 Student/Teacher Ratio (98-99) Rk98 Ratio Ranking (98-99) Salt98 Teacher Salary (98-99) Rk98 Salary Ranking (98-99)
7. Structure for Indicator 17
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name Ssrat97 Student/Special Service Ratio (97-98) Rk97 Ratio Ranking (97-98) Sals97 Special Service Salary (97-98) Rk97 Salary Ranking (97-98) Ssrat98 Student/Special Service Ratio (98-99) Rk98 Ratio Ranking (98-99) Sals98 Special Service Salary (98-99) Rk98 Salary Ranking (98-99)
8. Structure for Indicator 18
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name Sarat97 Student/Administrator Ratio (97-98) Rk97 Ratio Ranking (97-98) Sala97 Administrator Salary (97-98) Rk97 Salary Ranking (97-98) Sarat98 Student/Administrator Ratio (98-99) Rk98 Ratio Ranking (98-99) Sala98 Administrator Salary (98-99) Rk98 Salary Ranking (98-99)
9. Structure for Indicator 19
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name Farat97 Faculty/Administrator Ratio (97-98) Rk97 Faculty/Administrator Ranking (97-98) Farat98 Faculty/Administrator Ratio (98-99) Rk98 Faculty/Administrator Ranking (98-99)
10. Structure for Indicator CSG20
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name Col1 General Fund Balance (96-97) Col2 1996-97 Actual Col3 General Fund Balance (97-98) Col4 1997-98 Actual
11. Structure for Indicator CSG21
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name Col1 Actual Excess (96-97) Col2 Actual Excess (97-98) Col3 Actual Excess (98-99)
12. Structure for Indicator VITSTAT
Field Name Description Group Text indicating Operating type/Enrollment grouping Coname County Name District District code Distname District Name PP98 Per pupil Comparative Cost (98-99) Stpct98 Revenue: State % Ltpct98 Revenue: Local % Fdpct98 Revenue: Federal % Tupct98 Revenue: Tuition % Fbpct98 Revenue: Free balance % Otpct98 Revenue: Other % Strat98 / Teacher ratio 98 Ssrat98 Student / Special Service ratio 98 Sarat98 Student / Administrator ratio 98 Pctspeced Percent Special Education Students
D. File Structure - Reconciliation Files
The 1996-97 Reconciliation file has the following structure.
The 1997-98 and 1998-99 Reconciliation files have the following structure.
Field Name Description Coname County Name Distname District Name IND2 Classroom Instruction IND6 Support Services IND8 Administrative Costs IND10 Operation/Maintenance IND12 Food Service IND13 Extracurricular Costs Emplben Employee Benefits IND1 Total Costs Tuition Tuition Expenses Transport Transportation Lpinterest LP Interest/Res. Costs/Judgements Currentexp Total Current Expense IND15 Equipment Fac_acq Facility/Acquisition Capitalout Total Capital Outlay Specschool Special Schools Genfund General Fund ADE Average Daily Enrollment
Field Name | Description |
Coname | County Name |
Distname | District Name |
Indicator 1 | Total Cost Per Pupil |
Indicator 2 | Total Classroom Instruction |
Indicator 3 | Classroom Salaries & Benefits |
Indicator 4 | Classroom Gen Supplies Textbooks |
Indicator 5 | Classroom Purchased Services & Other |
Indicator 6 | Total Support Services |
Indicator 7 | Support Services Sals & Bens |
Indicator 8 | Total Admin Costs |
Indicator 9 | Admin Salaries & Benefits |
Indicator 10 | Oper.& Maint of Plant |
Indicator 11 | Oper.& Maint of Plant Sals & Bens |
Indicator 12 | Total Food Services |
Indicator 13 | Extracur Costs |
Indicator 15 | Equipment |
Avg Daily Enroll | Average Daily Enrollment (for the 1997-98 Reconciliation) |
Est Enroll | Estimated Enrollment (for the 1998-99 Reconciliation) |
E. Miscellaneous Information
Each indicator file also contains information regarding the Operating type and State Average information printed on the Comparative Spending Guide. This information is located within the file at the beginning of each district operating type/enrollment grouping. Depending on the indicator file and operating type grouping, the number of records containing the information will vary. The descriptive text regarding these records have been written in the DISTNAME field. The following guide should be used to view these data summary records:
Indicator | Operating type/enrollment Grouping | # Records with Summary Statistics |
1-15 | All groups except 7-12 / 9-12 | 4 records/grouping |
1-15 | Group 7-12 / 9-12 only | 6 records/grouping |
16,17,18,19 | All groups except 7-12 / 9-12 | 1 record/group (Op type average only) |
16,17,18,19 | Group 7-12 / 9-12 only | 2 records/group (Op Type average only) |