Comparative Spending Guide March 1999

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.

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
The 1997-98 and 1998-99 Reconciliation files have the following structure.

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)