ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Note: Variables that are important for this assignment are bolded and highlighted.
2
Variable NameDefinitionValue
3
ADA_BTWStudent's average daily attendance rate0 ~ 1
4
AT_RISKStudent identified as "at-risk" of dropping out of school because of a variety of reasons. 1=At risk, 0=Not at risk
5
CAMPUS_IDSchool ID
6
CAMPUS_NAMESchool Name
7
DATE_ENTRYThe initial date a student enrolled in the school district for the present academic year.
8
Date_Entry_CurrentCampThe student's first enrollment date at the current school this academic year.
9
Days_CurrentCampThe number of days a student enrolled in the current school for the present semester.
10
DAYS_ERL_SPThe number of days a student enrolled in the district for the present semester.
11
DAYS_PRESENT_SPThe total number of days a student has attended the current school during the current semester.
12
Days_SA_CY
The number of days present this semester for students who were already in the district last year and continued their enrollment at this particular school.
13
DOB_MonthThe student's birth month as recorded in the district's data system.
14
EL_YRS_USThe number of years English learner students have been living in the U.S.
15
Eligible_Entry
Eligibility of receiving the survey in terms of program (not in the Alternative Education Special Programs)
1= Eligible, 0=Ineligible
16
EMP_ID1Employee ID of the English teacher
17
EMP_ID2Employee ID of the Math teacher
18
EMP_ID3Employee ID of the Science teacher
19
GradeSchl_EligEligibility of receiving the survey in terms of grade level (not in PreK, Kinder, 1st grade or 2nd grade)
20
IndEligibility indicator of receiving the survey 1= Eligible, 0=Ineligible
21
IS_ACTIVE_STUDENTIndicator of active enrollment1= Active, 0=Inactive
22
IS_ESLIndicator of student who is learning English as a Second Language1= ESL, 0=Non-ESL
23
IS_GTIdentifies students who are formally participating in a gifted and talented education program.1= Gifted, 0=Not in a gifted program
24
IS_LEPIdentifies students with limited English proficiency1= Limited English proficiency, 0=Not LEP
25
IS_LEP+4YR
Identifies students who were previously classified as LEP but have been proficient in English and no longer in the LEP program for over four years.
1=Yes, 0=No
26
IS_SPED
Identifies students who have been formally evaluated and qualified to receive specialized instruction and support services as part of a special education program.
NA
27
LEP_IND_CODECode to identify student who is in the Limited English Proficiency programNA
28
PARENT1_EMAILParent email 1
29
PARENT2_EMAILParent email 2
30
SCHOOL_YEARAcademic year
31
STU_DOB_FORMATTEDThe student's date of birth as recorded in the district's data system.
32
STU_FIRST_NAME_CapStudent's first name
33
STU_FORMATTED_NAMEStudent's formal name record
34
STU_GRD_LVLStudent grade level9, 10, 11, 12
35
STU_IDStudent ID number
36
STU_LANGUAGEStudent's first language
37
STU_LANGUAGE_CODEStudent's first language code
38
STU_LAST_NAME_CapStudent's last name
39
TC_FName_1First name of the English teacher
40
TC_FName_2First name of the Math teacher
41
TC_FName_3First name of the Science teacher
42
TC_LName_PreFix1Formal name of the English teacher
43
TC_LName_PreFix2Formal name of the Math teacher
44
TC_LName_PreFix3Formal name ofthe Science teacher
45
TC_LName1Last name of the English teacher
46
TC_LName2Last name of the Math teacher
47
TC_LName3Last name of the Science teacher
48
TC_Sample_Cnt1Number of students who provided feedback to the English teacher
49
TC_Sample_Cnt2Number of students who provided feedback to the Math teacher
50
TC_Sample_Cnt3Number of students who provided feedback to the Science teacher
51
TC_STU1Combination of English teacher ID and student ID
52
TC_STU2Combination of Math teacher ID and student ID
53
TC_STU3Combination of Science teacher ID and student ID
54
TdayData storage date
55
TestShows if the case is a testing record1= testing record; 0 or null = actual response
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100