Massachusetts, USA

Shapefile with Education and Linquistic indicators for Massachusetts census tracts

The shapefile contains the following variables:

1.  OBJECTID    -       The unique ID for each record in the table

2.  ID          -       The GIS-compatible Geographic Identifier

3.  DISTRICTID  -       The unique ID for each school district

4.  DISTNAME    -       Name of school District
 
5.  STARTGRADE  -       Starting grade for school District

6.  ENDGRADE    -       Ending grade for school District

7.  DISTCODE4   -       4-Digit School District code

8.  DISTCODE8   -       8-Digit School District code

9.  AREA        -       Land area in square miles

10. SHAPE_LEN   -       Perimeter      

11. EXPENDITUR  -       Student Expenditures(Expenditure per pupil)

12. _GRADUATE   -       Graduation rate(Percentage of students graduating)
                        (Formula: GRADUATE/ENROLL)

13. _DROPPED    -       Dropout rate(Percentage of dropouts)
                        (Formula: DROPOUT/ENROLL)

14.  OF_TEACH   -       Percentage of Highly Qualified Teachers (HQT)
                        (Formula: HQT/TEACHERS)

15. _OF_CORE    -       Percentage of core classes taught by qualified teachers
                        (Formula:Total number of core classes/Number of core classes taught by qualified teachers)

16. 3RD_ENGLIS  -       Percentage of 3rd graders who met standards on English test (Formula: ENGLISH/ ENROLL_3)

17. 3RD_MATH    -       Percentage of 3rd graders who met standards on Math test (Formula: MATH/ ENROLL_3)

18. LOW_INCOME  -       Percentage of economically disadvantaged students
                        (Formula: ECON/ ENROLL)

19. Z_GRADRT    -       z-score based on _GRADUATE (Formula: (_GRADUATE - Mean)/Standard Deviation)

20. Z_DROPOUT   -       z-score based on _DROPPED_ (Formula: (_DROPPED_ - Mean)/Standard Deviation)

21. Z_ADJ_DROP  -       Adjusted Z-score based on Z_DROPOUT (Formula: -Z_DROPOUT)

22. Z_LicTch    -       z-score based on _OF_TEACH (Formula: (_OF_TEACH - Mean)/Standard Deviation)

21. Z_HQ_CORET  -       z-score based on _OF_CORE_ (Formula: (_OF_CORE_ - Mean)/Standard Deviation)

22. Z_3RD_ENG   -       z-score based on 3RD_ENGLIS (Formula: (3RD_ENGLIS - Mean)/Standard Deviation)

23. Z_3RD_MATH  -       z-score based on 3RD_MATH (Formula: (3RD_MATH - Mean)/Standard Deviation)

24. Z_LOWINC    -       z-score based on LOW_INCOME (Formula: (LOW_INCOME - Mean)/Standard Deviation)

25. Z_ADJ_LOWI  -       Adjusted Z-score based on Z_LOWINC (Formula: -Z_LOWINC)

26. Z_EXP_STUD  -       z-score based on EXPENDITUR (Formula: (EXPENDITUR - Mean)/Standard Deviation)

27. Z_EDUC      -       Z-score for opportunity based on Education indicators
                        (Formula: (Z_GRADRT + Z_ADJ_DROP + Z_LicTch + Z_HQ_CORET + Z_3RD_ENG + Z_3RD_MATH + Z_ADJ_LOWI + Z_EXP_STUD )/8)

28. X           -       Longitude

29. Y           -       Latitude

30. Edu_Cat     -       Education Opportunity Indicator/Cartegory

31. HH_TOT      -       Households Total

32. HH_LING     -       Households Linguistically isolated

33. POP_O5_TOT  -       Total Population 5 years and over in households

34. POP_5_LING  -       Population 5 years and over in households where all members speak a non-English language(Linguistically isolated)


* - The Z-score is adjusted to ensure positive values of Z-score correspond to positive outcomes of the indicator


Other Variables

a.  ENROLL	-	Total enrollment 

b.  ECON	-	Total number of economically disadvantaged students

c.  ENROLL_3	-	Total enrollment in Grade 3

d.  MATH	-	Number of 3rd grade students meeting standards on Math test

e.  READ	-	Number of 3rd grade students meeting standards on Reading test

f.  HQT	        -	Total number of certified teachers

g.  TEACHERS	-	Number of full-time-equivalent teachers

h.  GRADUATE    -       Total number of graduating students

i.  DROPOUT     -       Total number of dropouts

* - Source: Massachusetts Department of Elementary and Secondary Education (http://www.doe.mass.edu/)