Maintain CRDC Survey Results

Classic View: Federal Reporting > Civil Rights Data Collection (CRDC) > Maintain Survey Results

Search Terms: Maintain CRDC Survey Results

The Maintain CRDC Survey Results tool allows users to view, edit and export survey results for CRDC Mappings.

The CRDC tool is available for the 2017-2018 and 2020-2021 versions.

Maintain Survey Results

Tool Rights

In order to use the Maintain Survey Results tool, users must have rights to the tool within their own district.


Maintain Survey Results Tool Rights

Tool

R

W

A

D

Maintain Survey Results

User can view survey results.User can generate and edit survey results.

User can generate and edit survey results.

User can generate and edit survey results.


Maintain CRDC Survey Results

This section describes how to view, edit, and export CRDC Results.

To select a version, school year and school:

  1. Select the Version in which to view/edit survey results.
  2. Select the School Year in which to view and/or edit survey results. The School Search field can be used to find a school, if necessary.
  3. Select the School Name in which to view and/or edit survey results.

Maintain Survey Results

School Results Editor

FieldDefinition
VersionAllows the user to select the CRDC version in which to view/edit Survey Results.
School YearAllows the user to select the school year in which to view/edit Survey Results.
School SearchAllows the user to search for a school.
School Name

Allows the user to select the school in which to view the survey results for the selected School Year. Schools in which the user has tool rights to and have at least one active calendar display.

Note: If a mapping for a school has changed, the 'Mapping Changed' message appears next to the school.

Select the module in which to view/edit survey results:

1. Select the module in which to view/edit survey results. The results are shown by module with each question listed below each module.

Note: Results for the SCHR: School Characteristics module must be generated at least once for a given school prior to independently generating results for other modules.

2. If results have been modified, the Refresh button can be used to update the results.

3. Select the appropriate question to view/edit results.

Maintain Survey Results - Select Section and Question

To view, edit, or export Survey Results:

Users with the appropriate tool rights are allowed to view, edit, and/or export survey results for the selected question.

 Maintain Survey Results - View Survey Results

View Survey Results Editor

FieldDefinition
Result
Allows the user to view the survey results for questions. If results have previously been modified, the date and time the mapping was last modified displays. Clicking the link in the Results column displays the results in a side panel on the screen. The results can be exported by clicking the Export button, if desired.
Exclude ResultAllows the user to exlcude the survey result from the flat file.
Override

Allows the user to override the results for the selected question.

CommentsAllows the user to enter comments regarding the survey results.
SaveSaves the changes made by the user.
Save & NextSaves the changes made by the user and advances to the next question.
CancelChanges are not saved.
Edit MappingAllows the user to edit the category mapping. Modifying category mappings may result in changes to survey results.
PreviousAdvances the user to the survey results for the previous question.
NextAdvances user to the survey results for the next question.

If results for a question are not calculated by the CRDC tool:

Users are able to select a value from the Override column in order to report results for a question, if desired.


To view and export Survey Results:

  1. Select the link in the Results column to view the results for the selected question. A side panel displays on the screen which allows the user to view the survey results. The Override column can be used to override the results for the selected question. The Exclude Result checkbox can be used to exclude the results from reporting in the flat file.

    If results totals are different than the totals on the Details screen, return to the Generate CRDC Survey Results screen to generate new results and update the totals.

     

    Question with Survey Results

  2. If desired, Export the results. The results are displayed in an Excel file.


  3. Click Close.

To edit Category Mappings:

  1. Select the School Year in which to view and/or edit survey results. The School Search field can be used to find a school, if necessary.
  2. Select the School Name in which to view and/or edit survey results.
  3. Select the module in which to view/edit survey results. The results are shown by module with each question listed below each module.
  4. Select the appropriate question to view/edit results.
  5. Click Edit Mapping.
  6. Select the mapping that is being modified.
  7. Make the necessary changes to the mapping.
  8. Click Save.
  9. A message displays indicating that changing a category mapping may impact survey results. Users can choose to update the mappings now or later. Selecting Update Later directs the user back to the Question Detail screen. Selecting Update Now directs the user to a new pop-up message.


  10. After clicking Update Now, a message indicating that results for all questions that use the selected category mapping will be updated. Users can elect to retain or delete all manually entered data from the Overrides, Excludes, and Comments fields.


  11. Click Continue. A Mappings Changed icon displays on the Question Detail screen indicating Category Mappings have changed.
  12. Navigate back to the Select a question to view or edit results screen and click Refresh to update the results for the question.

Question Results Logic

Shared Logic Questions:

Fall Snapshot Student Enrollment/Grade Level Logic
Logic
All enrollment logic must be met in order to be reported in the Fall Snapshot logic.

Students will report in the School in which they are enrolled:

  • The student's enrollment must overlap the Fall Snapshot Count Date if reporting in a category not in IDEA.
  • The student's enrollment must overlap the Fall Snapshot IDEA Count date if populated, else the Fall Snapshot Count Date if reporting in an IDEA category.
  • The students Enrollment Service Type must not be selected in the Exclude Enrollment Service Types field in the Report Options to report for the school that is being generated.

Consider the following logic for the CRDC School of Accountability field:

  • If the CRDC School of Accountability field is NULL or = to the School of Enrollment the student will report in that school.
  • If the CRDC School of Accountability school is not = to the enrolled school, the student will report in the CRDC School of Accountability school.

Use the CRDC Grade level mapping to determine which grade level a student should report:

  • If the student has more than 1 enrollment in the reporting school and the grade levels are different, report the grade level from the primary enrollment.
  • If no primary enrollment or service types are the same, report from the enrollment with the earliest start date or enrollment id.
  • Do not count a student if their enrollment Grade Level is not mapped to a CRDC Grade Level.
  • If the student has a primary enrollment not mapped to a CRDC Grade Level and has a secondary enrollment that is mapped to a CRDC grade level, report the student in the secondary enrollment.


Regular School Year Enrollment/Grade Level Logic
Logic

All enrollment logic must be met in order to be reported in the Regular School Year logic.

  • Students will report in the School in which they are enrolled.
  • The students enrollment must occur in the reporting school year.
  • Do not include students that are in calendars marked as Summer School
  • The students Enrollment Service Type must be selected in the Report Options in order to report for the school that is being reported

Consider the following logic for the CRDC School of Accountability field:

  • If the CRDC School of Accountability field is NULL or = to the School of Enrollment the student will report in that school.
  • If the CRDC School of Accountability school is not = to the enrolled school, the student will report in the CRDC School of Accountability school.
Do not count a student if their enrollment Grade Level is not mapped to a CRDC Grade Level.


Fall Snapshot & Regular School Year IDEA/504/EL/EL Students Enrolled in EL Programs Logic
Logic
Count distinct students saved in each category mapping for the school being reported.


Student Race/Ethnicity Logic
Logic
Count students in the following race categories based on values selected in Race/Ethnicity on Demographics tab.

Students can only report in 1 of the Race/Ethnicity categories listed below:

  • Hispanic or Latino of any race:  will report when the "Is the individual Hispanic/Latino?" question is set to Yes.
  • American Indian or Alaska Native:  will report when the "Is the individual Hispanic/Latino?" question is set to No and only the American Indian or Alaska Native checkbox is checked.
  • Asian:  will report when the "Is the individual Hispanic/Latino?" question is set to No and only the Asian checkbox is checked.
  • Native Hawaiian or Other Pacific Islander:  will report when the "Is the individual Hispanic/Latino?" question is set to No and only the Native Hawaiian or Other Pacific Islander checkbox is checked.
  • Black or African American:  will report when the "Is the individual Hispanic/Latino?" question is set to No and only the Black or African American checkbox is checked.
  • White:  will report when the "Is the individual Hispanic/Latino?" question is set to No and only the White checkbox is checked.
  • If the student hast two or more races that are mapped to the same pescLabel, do not report the student as two or more races.
Do not count a student if their Race/Ethnicity is NULL.

If reporting results for Fall Snapshot, use the identity record that overlaps the report count date.:

  • If an identity record cannot be found that overlaps the count date, use the earliest identity record.

If reporting results for Regular School Year, use the identity record that overlaps the last instructional day of the reporting year.

  • Do not use calendars marked as Summer School to determine the last instructional day.


Gender Logic
Logic

Report a student in the Male gender category when their Legal Gender is = M.

  • If Legal Gender is NULL on Identities, report from Gender on Census.

Report a student in the Female gender category when their Legal Gender is = F.

  • If Legal Gender is NULL on Identities, report from Gender on Census.
Do not report a student if their Gender is NULL.

Use the following date logic to determine which identity record to use:

  • If reporting results for Fall Snapshot, use the identity record that overlaps the report count date.
  • If reporting results for Regular School Year, use the identity record that overlaps the last instructional day of the reporting year.
  • If an identity record cannot be found that overlaps the count date or last instructional day, use the earliest identity record.
  • Do not use calendars marked as Summer School to determine the last instructional day.


Course Count Logic
Logic
The total number of courses offered by a school is determined by how many sections of the course are offered in which there are students enrolled.  Count the total number of classes with the following criteria:
Use the Selected Courses in the Category Mapping(s) used for a question to determine which courses should be considered in the count.

Sum the total number of sections for each course that have a section schedule placement that overlaps with the Count Date that is entered on the Course Category Mapping.

  • If a section has multiple section schedule placements and more than 1 overlap a Count Date, use only the earliest Term that overlaps to count the section.
If the same course is used in multiple mappings that are used for a question, they will be counted multiple times.
If Advanced options are used in a category mapping, do not count any section that is marked as excluded.
There must be at least 1 student scheduled into the section on the Schedule Type Count Date to be counted.


Student Roster Count Logic for Courses - For version 2020-2021 only.
Logic

For Regular School Year, Count a student as enrolled in a course when their enrollment and roster both overlap the last term end date in a section .

For Fall Snapshot, Count a student as enrolled in a course when their enrollment and roster both overlap the fall snapshot count date.

If the student has more than 1 enrollment that overlap the term end date, use the Primary enrollment.

  • If the enrollment start dates are the same, use the highest enrollment ID.
  • If the enrollment start dates are not the same, use the enrollment with the most recent start date.

Refer to Fall Snapshot Enrollment or Regular School Year Enrollment logic based on the time frame of the question.

Only count the student 1 time per course category.

Only count the student 1 time per course category.
If Advanced options are used in a category mapping, do not count any section that is marked as excluded.


School Form General Instructions
Logic

For Fall Snapshot questions, report data based on October 1 (or the closest school day to October 1), unless otherwise noted.

For Regular School Year questions, count should be cumulative based on the entire regular school year.

Counts by race/ethnicity by sex are unduplicated counts (i.e., a student is counted only once in the race/ethnicity columns).

Students counted in the race/ethnicity category may also be counted in the Students with Disabilities (IDEA), Students with Disabilities (Section 504 only), and Students who are English Learners (EL) categories.  For example, the following may occur:
  • A Hispanic/Latino student with a disability served under IDEA and who is EL will be counted three times in some tables, once under race/ethnicity, once under Students with Disabilities (IDEA), and once under Students who are EL.  
  • A student with a disability served under section 504 and who is EL will be counted in both the Students with Disabilities (Section 504 only) category and the Students who are EL category.  

If the question does not apply to a school the question will report "NULL".  If a question does apply to a school but there are not results for a data element, a value must report ("0", No, etc).

Student enrollment counts by course are unduplicated counts unless noted otherwise (i.e. a student is counted only once in Algebra I even if they take more than 1 course in that category).


Module Questions Logic:

Click on the module name to view question logic for the module.
DIND: COVID-related Directional Indicators

SCHR: School Characteristics

PSCH: Preschool

ENRL: Enrollment
PENR: Program Enrollment
COUR: Courses & Classes

APIB: Advanced Placement (AP) & International Baccalaureate Diploma Programme (IB) Enrollment

EXAM: SAT/ACT & Advanced Placement (AP) Exams
STAF: School & School Support Staff
SECR: School Security Staff
RETN: Retention
ATHL: Single-Sex Interscholastic Athletics
DISC: Student Discipline (Suspension, Expulsion, Corporal Punishment)

ARRS: Student Discipline (Referrals to Law Enforcement & School-Related Arrests)

OFFN: Offenses
HIBS: Harassment or Bullying
RSTR: Restraint & Seclusion
EXPD: School Expenditures (Personnel and Non-Personnel) - For 2017-2018 Version Only
JUST: Justice Facilities
INET: Internet Access and Devices

Appendix A: Questions by Grade Level

QuestionGrade Level(s)
DIND-1: Directional Indicator – Instruction TypeAll Grade Levels
DIND-2: Directional Indicator – Virtual InstructionAll Grade Levels

SCHR-1:  Grades with Students Enrolled

All Grade Levels

SCHR-2:  Ungraded Detail

Ungraded

SCHR-3:  School Characteristics

All Grade Levels
SCHR-4:  Magnet School DetailAll Grade Levels
SCHR-5:  Alternative School DetailAll Grade Levels

PSCH-1:  Preschool Age for Non-IDEA Children - For 2017-2018 Version Only

Preschool
PSCH-1:  Preschool Enrollment - For 2020-2021 Version OnlyPreschool

PSCH-2:  Preschool Enrollment  - For 2017-2018 Version Only

Preschool

ENRL-1:  Overall Student Enrollment

All Grade Levels

ENRL-2a:  Enrollment of English Learner Students - All EL Students

All Grade Levels
ENRL-2b:  Enrollment of English Learner Students - EL Students in ProgramsAll Grade Levels

ENRL-3a:  Enrollment of Students with Disabilities Served - IDEA Only

All Grade Levels
ENRL-3b:  Enrollment of Students with Disabilities Served Under 504 OnlyAll Grade Levels
PENR-1:  Gifted and Talented Programs IndicatorAll Grade Levels
PENR-2:  Gifted/Talented Student EnrollmentAll Grade Levels
PENR-3:  Dual Enrollment Program Indicator

Grades 9-12

PENR-4:  Student Enrollment in Dual Enrollment Programs

Grades 9-12

PENR-5:  Credit Recovery Program Indicator - For 2017-2018 Version Only

Grades 9-12

PENR-6:  Credit Recovery Program Student Participation - For 2017-2018 Version Only

Grades 9-12

COUR-1a:  Grade 7/8 Algebra I ClassesGrades 7 & 8
COUR-1b:  Grade 7/8 Algebra I Classes Taught By Certified TeachersGrades 7 & 8
COUR-2a:   Grade 7 Algebra I Enrollment IndicatorGrade 7
COUR-2b:  Grade 8 Algebra I Enrollment IndicatorGrade 8
COUR-3a:  Student Enrollment in Algebra I in Grade 7Grade 7
COUR-3b:  Student Enrollment in Algebra I in Grade 8Grade 8
COUR-4a:  Grade 7 Students who Passed Algebra IGrade 7
COUR-4b:  Grade 8 Students who Passed Algebra IGrade 8
COUR-5a:  Grade 8 Geometry Enrollment IndicatorGrade 8
COUR-5b:  Student Enrollment in Geometry in Grade 8Grade 8
COUR-6a:  High School Student Enrollment in Algebra I - Grades 9 & 10Grades 9 & 10
COUR-6b:  High School Student Enrollment in Algebra I - Grades 11 & 12Grades 11 & 12
COUR-7a:  High School Students who Passed Algebra I - Grades 9 & 10Grades 9 & 10
COUR-7b:  High School Students who Passed Algebra I - Grades 11 & 12Grades 11 & 12
COUR-8:  Classes in Mathematics Courses in High SchoolGrades 9-12
COUR-9:  Classes in Mathematics Courses in High School Taught by Teachers with a Mathematics CertificationGrades 9-12
COUR-9a:  Student Enrollment in Mathematics Courses in High School - Algebra IIGrades 9-12
COUR-9b:  Student Enrollment in Mathematics Courses in High School  - Advanced MathematicsGrades 9-12
COUR-9c:  Student Enrollment in Mathematics Courses in High School - CalculusGrades 9-12
COUR-9d: Student Enrollment in Mathematics Courses in High School - GeometryGrades 9-12
COUR-10:  Classes in Science CoursesGrades 9-12
COUR11a:  Student Enrollment in Science Courses - BiologyGrades 9-12
COUR-11b:  Student Enrollment in Science Courses - ChemistryGrades 9-12
COUR-11c:  Student Enrollment in Science Courses - PhysicsGrades 9-12
COUR-12:  Single-Sex Academic Classes IndicatorGrades 9-12
COUR-13:  Single-Sex Academic Classes DetailGrades 9-12
COUR-14:  Classes in Science Courses in High School Taught by Teachers with a Science CertificationGrades 9-12
COUR-15:  Classes in Computer Science CoursesGrades 9-12
COUR-16:  Classes in Science Courses in High School Taught by Teachers with a Science CertificationGrades 9-12
COUR-17:  Student Enrollment in Computer Science CoursesGrades 9-12
APIB-1:  International Baccalaureate(IB) Diploma ProgrammeGrades 9-12
APIB-2:  Student Enrollment in the International Baccalaureate (IB) Diploma ProgrammeGrades 9-12
APIB-3:  Advanced Placement (AP) Program IndicatorGrades 9-12
APIB-4:  Different Advanced Placement (AP) CoursesGrades 9-12
APIB-5:  Advanced Placement (AP) Course Self-SelectionGrades 9-12
APIB-6:  Advanced Placement (AP) Student EnrollmentGrades 9-12
APIB-7:  Advanced Placement (AP) Mathematics Enrollment IndicatorGrades 9-12
APIB-8:  Student Enrollment in Advanced Placement (AP) MathematicsGrades 9-12
APIB-9:  Advanced Placement (AP) Science Enrollment IndicatorGrades 9-12
APIB-10:  Student Enrollment in Advanced Placement (AP) ScienceGrades 9-12
APIB-11:  Advanced Placement (AP) Other Subjects Enrollment Indicator - For 2017-2018 Version OnlyGrades 9-12
APIB-11:  Advanced Placement (AP) Computer Science Enrollment Indicator - For 2017-2018 Version OnlyGrades 9-12
APIB-12:  Student Enrollment in Other Advanced Placement (AP) Subjects - For 2020-2021 Version OnlyGrades 9-12
APIB-12:  Student Enrollment in Advanced Placement (AP) Computer Science - For 2020-2021 Version OnlyGrades 9-12
APIB-13:  Advanced Placement (AP) Computer Science Enrollment Indicator - For 2017-2018 Version OnlyGrades 9-12
APIB-14:  Student Enrollment in Advanced Placement (AP) Computer Science - For 2017-2018 Version OnlyGrades 9-12
EXAM-1:  Student Participation in the SAT Reasoning Test or ACTGrades 9-12
EXAM-2a:  Student Participation in Advanced Placement (AP) Exams   - Students who took AP Exams - For 2017-2018 Version OnlyGrades 9-12
EXAM-2b:  Student Participation in Advanced Placement (AP) Exams  - Students who did not take AP Exams - For 2017-2018 Version OnlyGrades 9-12
STAF-1:  Teachers – FTE Count and CertificationAll Grade Levels
STAF-2:  Teacher Years of Experience - For 2017-2018 Version OnlyAll Grade Levels
STAF-2:  School Counselors Number FTE - For 2020-2021 Version OnlyAll Grade Levels
STAF-3:  Teacher Absenteeism - For 2017-2018 Version OnlyAll Grade Levels
STAF-3:  Support Services Staff Number FTE - For 2020-2021 Version OnlyAll Grade Levels
STAF-4:  School Counselors - For 2017-2018 Version OnlyAll Grade Levels
STAF-5:  Support Services Staff - For 2017-2018 Version OnlyAll Grade Levels
STAF-6:  Current Year and Previous Year Teachers Count - For 2017-2018 Version OnlyAll Grade Levels
SECR-1:  Security StaffAll Grade Levels
RETN-1: Student Retention IndicatorGrades K-12
RETN-2 GRK:  Retention of Students in KindergartenGrades K
RETN-2 GR1:  Retention of Students in Grade 1Grades 1
RETN-2 GR2:  Retention of Students in Grade 2Grades 2
RETN-2 GR3:  Retention of Students in Grade 3Grades 3
RETN-2 GR4:  Retention of Students in Grade 4Grades 4
RETN-2 GR5:  Retention of Students in Grade 5Grades 5
RETN-2 GR6:  Retention of Students in Grade 6Grades 6
RETN-2 GR7:  Retention of Students in Grade 7Grades 7
RETN-2 GR8:  Retention of Students in Grade 8Grades 8
RETN-2 GR9:  Retention of Students in Grade 9Grades 9
RETN-2 GR10:  Retention of Students in Grade 10Grades 10
RETN-2 GR11:  Retention of Students in Grade 11Grades 11
RETN-2 GR12:  Retention of Students in Grade 12Grades 12
ATHL-1:  Single-Sex Interscholastic Athletics IndicatorGrades 9-12
ATHL-2:  Single-Sex Interscholastic Athletics Sports, Teams and ParticipantsGrades 9-12
DISC-1a:  Preschool Suspensions and Expulsions - Only One Out-of-School SuspensionPreschool
DISC-1b:  Preschool Suspensions and Expulsions - More than One Out-of-School Suspension  - For 2017-2018 Version OnlyPreschool
DISC-1b:  Preschool Suspensions and Expulsions - Expulsions  - For 2020-2021 Version OnlyPreschool
DISC-1c:  Preschool Suspensions and Expulsions - ExpulsionsPreschool
DISC-2:  Preschool Instances of SuspensionPreschool
DISC-3:  Corporal Punishment IndicatorAll Grade Levels
DISC-4:  Preschool Corporal Punishment     Preschool
DISC-5:  Preschool Instances of Corporal PunishmentPreschool
DISC-6:  Instances of Corporal PunishmentGrades K-12
DISC-7a:  Discipline of Students without Disabilities - Corporal PunishmentGrades K-12
DISC-7b:  Discipline of Students without Disabilities - In-School SuspensionsGrades K-12
DISC-7c:  Discipline of Students without Disabilities - Only One Out-of-School SuspensionGrades K-12
DISC-7d:  Discipline of Students without Disabilities - More than One Out-of-School SuspensionGrades K-12
DISC-7e:  Discipline of Students without Disabilities - Expulsions with Educational ServicesGrades K-12
DISC-7f:  Discipline of Students without Disabilities - Expulsions without Educational ServicesGrades K-12
DISC-7g:  Discipline of Students without Disabilities - Expulsions Under Zero-ToleranceGrades K-12
DISC-8a:  Transfer to Alternative School for Students without DisabilitiesGrades K-12
DISC-9a:  Discipline of Students with Disabilities - Corporal PunishmentGrades K-12
DISC-9b:  Discipline of Students with Disabilities - One or More In-School SuspensionsGrades K-12
DISC-9c:  Discipline of Students with Disabilities - Only One Out-of-School SuspensionGrades K-12
DISC-9d:  Discipline of Students with Disabilities - More than One Out-of-School SuspensionGrades K-12
DISC-9e:  Discipline of Students with Disabilities - Expulsions with Educational ServicesGrades K-12
DISC-9f:  Discipline of Students with Disabilities - Expulsions without Educational ServicesGrades K-12
DISC-9g:  Discipline of Students with Disabilities - Expulsions Under Zero-ToleranceGrades K-12
DISC-10:  Transfer to Alternative School for Students with DisabilitiesGrades K-12
DISC-11:  Instances of SuspensionGrades K-12
DISC-12:  School Days Missed Due to Out-of-School Suspension     Grades K-12
ARRS-1a:  Discipline of Students without Disabilities - Referred to Law Enforcement AgencyGrades K-12
ARRS-1b:  Discipline of Students without Disabilities - School Related ArrestGrades K-12
ARRS-2a:  Discipline of Students with Disabilities - Referred to Law Enforcement AgencyGrades K-12
ARRS-2b:  Discipline of Students with Disabilities - School Related ArrestGrades K-12
OFFN-1:  Offenses – Number of IncidentsAll Grade Levels
OFFN-2:  Offenses - Firearm UseAll Grade Levels
OFFN-3:  Offenses - HomicideAll Grade Levels
OFFN-4: Offenses - Number of Incidents Committed by Student - For 2020-2021 Version OnlyAll Grade Levels
OFFN-5: Offenses - Number of Incidents Committed by School Staff - For 2020-2021 Version OnlyAll Grade Levels
OFFN-6: Offenses - Allegations Against School Staff (Resignation or Retirement) - For 2020-2021 Version OnlyAll Grade Levels
OFFN-7: Offenses - Allegations Against School Staff (Determined Responsible) - For 2020-2021 Version OnlyAll Grade Levels
OFFN-8: Offenses - Allegations Against School Staff (Determined Not Responsible) - For 2020-2021 Version OnlyAll Grade Levels
OFFN-9: Offenses - Allegations Against School Staff (Determination Pending) - For 2020-2021 Version OnlyAll Grade Levels
OFFN-10: Offenses - Allegations Against School Staff (Duty Reassignment) - For 2020-2021 Version OnlyAll Grade Levels
HIBS-1a:  Allegations of Harassment or Bullying - Sex, Race, Color, National Origin, and DisabilityGrades K-12
HIBS-1b:  Allegations of Harassment or Bullying - Sexual Orientation and ReligionGrades K-12
HIBS-2a:  Students Reported as Harassed or Bullied - SexGrades K-12
HIBS-2b:  Students Reported as Harassed or Bullied - Race, Color, or National OriginGrades K-12
HIBS-2c:  Students Reported as Harassed or Bullied - DisabilityGrades K-12
HIBS-3a:  Students Disciplined for Harassment or Bullying - SexGrades K-12
HIBS-3b:  Students Disciplined for Harassment or Bullying - Race, Color, or National OriginGrades K-12
HIBS-3c:  Students Disciplined for Harassment or Bullying - DisabilityGrades K-12
RSTR-1a:  Non-IDEA Students Subjected to Restraint or Seclusion - Mechanical RestraintGrades K-12
RSTR-1b:  Non-IDEA Students Subjected to Restraint or Seclusion - Physical RestraintGrades K-12
RSTR-1c:  Non-IDEA Students Subjected to Restraint or Seclusion - SeclusionGrades K-12
RSTR-2a:  IDEA Students Subjected to Restraint or Seclusion - Mechanical RestraintGrades K-12
RSTR-2b:  IDEA Students Subjected to Restraint or Seclusion - Physical RestraintGrades K-12
RSTR-2c:  IDEA Students Subjected to Restraint or Seclusion - SeclusionGrades K-12
RSTR-3:  Instances of Restraint or Seclusion
Grades K-12
EXPD-1:  Salary Amount for Total Personnel Funded with State and Local Funds - For 2017-2018 Version OnlyGrades K-12
EXPD-2:  Salary Amount for Teachers Funded with Federal, State and Local Funds  - For 2017-2018 Version OnlyAll Grade Levels
EXPD-3:  Full-time Equivalency Count and Salary Amount for Teachers Funded with State and Local Funds - For 2017-2018 Version OnlyGrades K-12
EXPD-4:  Full-time Equivalency Counts and Salary Amounts for School Staff Funded with State and Local Funds - For 2017-2018 Version OnlyGrades K-12
EXPD5:  Full-time Equivalency Counts and Salary Amounts for School Staff Funded with Federal, State, and Local Funds - For 2017-2018 Version OnlyAll Grade Levels
EXPD-6:  Amount of School-level Non-Personnel Expenditures Associated with Activities Funded with State and Local Funds - For 2017-2018 Version OnlyGrades K-12
EXPD-7:  Amount of School-level Non-Personnel Expenditures Associated with Activities Funded with Federal, State and Local Funds - For 2017-2018 Version OnlyAll Grade Levels
EXPD-8:  Salary Amount for Total Personnel Funded with Federal, State and Local Funds - For 2017-2018 Version OnlyAll Grade Levels
JUST-1:  Justice Facility TypeAll Grade Levels
JUST-2:  Days in Regular School Year at Justice FacilityAll Grade Levels
JUST-3:  Justice Facility Educational Program Hours per WeekAll Grade Levels
JUST-4:  Justice Facility Educational Program ParticipantsAll Grade Levels
INET-1:  Internet Access and DevicesAll Grade Levels
INET-2:  Wi-Fi Enabled DevicesAll Grade Levels

Appendix B: Questions by Category Mapping

Category MappingQuestion
Grade Levels







































DIND-1: Directional Indicator – Instruction Type
DIND-2: Directional Indicator – Virtual Instruction

SCHR-1:  Grades with Students Enrolled

PSCH-1:  Preschool Age for Non-IDEA Children - For 2017-2018 Version Only

PSCH-1:  Preschool Enrollment - For 2017-2018 Version Only

PSCH-2:  Preschool Enrollment  - For 2020-2021 Version Only

COUR-2a:   Grade 7 Algebra I Enrollment Indicator

COUR-2b:  Grade 8 Algebra I Enrollment Indicator

COUR-3a:  Student Enrollment in Algebra I in Grade 7

COUR-3b:  Student Enrollment in Algebra I in Grade 8

COUR-4a:  Grade 7 Students who Passed Algebra I

COUR-4b:  Grade 8 Students who Passed Algebra I

COUR-5a:  Grade 8 Geometry Enrollment Indicator
COUR-5b:  Student Enrollment in Geometry in Grade 8
COUR-6a:  High School Student Enrollment in Algebra I - Grades 9 & 10
COUR-6b:  High School Student Enrollment in Algebra I - Grades 11 & 12
COUR-7a:  High School Students who Passed Algebra I - Grades 9 & 10
COUR-7b:  High School Students who Passed Algebra I - Grades 11 & 12
COUR-9a:  Student Enrollment in Mathematics Courses in High School - Algebra II
COUR-9b:  Student Enrollment in Mathematics Courses in High School  - Advanced Mathematics
COUR-9c:  Student Enrollment in Mathematics Courses in High School - Calculus
COUR-9d: Student Enrollment in Mathematics Courses in High School - Geometry

COUR11a:  Student Enrollment in Science Courses - Biology

COUR-11b:  Student Enrollment in Science Courses - Chemistry
COUR-11c:  Student Enrollment in Science Courses - Physics

COUR-17:  Student Enrollment in Computer Science Courses

EXAM-1:  Student Participation in the SAT Reasoning Test or ACT
RETN-1: Student Retention Indicator

RETN-2 GRK:  Retention of Students in Kindergarten

RETN-2 GR1:  Retention of Students in Grade 1
RETN-2 GR2:  Retention of Students in Grade 2
RETN-2 GR3:  Retention of Students in Grade 3
RETN-2 GR4:  Retention of Students in Grade 4
RETN-2 GR5:  Retention of Students in Grade 5
RETN-2 GR6:  Retention of Students in Grade 6
RETN-2 GR7:  Retention of Students in Grade 7
RETN-2 GR8:  Retention of Students in Grade 8
RETN-2 GR9:  Retention of Students in Grade 9
RETN-2 GR10:  Retention of Students in Grade 10
RETN-2 GR11:  Retention of Students in Grade 11
RETN-2 GR12:  Retention of Students in Grade 12
Fall Snapshot IDEA Students



PSCH-1:  Preschool Age for Non-IDEA Children  - For 2017-2018 Version Only

PSCH-1:  Preschool Enrollment  - For 2020-2021 Version Only

PSCH-2:  Preschool Enrollment  - For 2017-2018 Version Only

ENRL-1:  Overall Student Enrollment

ENRL-2a:  Enrollment of English Learner Students - All EL Students

ENRL-3a:  Enrollment of Students with Disabilities Served - IDEA Only
COUR-9a:  Student Enrollment in Mathematics Courses in High School - Algebra II
COUR-9b:  Student Enrollment in Mathematics Courses in High School  - Advanced Mathematics
COUR-9c:  Student Enrollment in Mathematics Courses in High School - Calculus
COUR-9d: Student Enrollment in Mathematics Courses in High School - Geometry
COUR11a:  Student Enrollment in Science Courses - Biology
COUR-11b:  Student Enrollment in Science Courses - Chemistry
COUR-11c:  Student Enrollment in Science Courses - Physics
COUR-17:  Student Enrollment in Computer Science Courses
Regular School Year IDEA Students



























COUR-3b:  Student Enrollment in Algebra I in Grade 8

COUR-4b:  Grade 8 Students who Passed Algebra I

COUR-6a:  High School Student Enrollment in Algebra I - Grades 9 & 10
COUR-6b:  High School Student Enrollment in Algebra I - Grades 11 & 12
COUR-7a:  High School Students who Passed Algebra I - Grades 9 & 10
COUR-7b:  High School Students who Passed Algebra I - Grades 11 & 12
EXAM-1:  Student Participation in the SAT Reasoning Test or ACT

RETN-2 GRK:  Retention of Students in Kindergarten

RETN-2 GR1:  Retention of Students in Grade 1
RETN-2 GR2:  Retention of Students in Grade 2
RETN-2 GR3:  Retention of Students in Grade 3
RETN-2 GR4:  Retention of Students in Grade 4
RETN-2 GR5:  Retention of Students in Grade 5
RETN-2 GR6:  Retention of Students in Grade 6
RETN-2 GR7:  Retention of Students in Grade 7
RETN-2 GR8:  Retention of Students in Grade 8
RETN-2 GR9:  Retention of Students in Grade 9
RETN-2 GR10:  Retention of Students in Grade 10
RETN-2 GR11:  Retention of Students in Grade 11
RETN-2 GR12:  Retention of Students in Grade 12

Fall Snapshot 504 Students

ENRL-1:  Overall Student Enrollment

ENRL-3b:  Enrollment of Students with Disabilities Served Under Section 504 Only

Regular School Year 504 Students














RETN-2 GRK:  Retention of Students in Kindergarten

RETN-2 GR1:  Retention of Students in Grade 1
RETN-2 GR2:  Retention of Students in Grade 2
RETN-2 GR3:  Retention of Students in Grade 3
RETN-2 GR4:  Retention of Students in Grade 4
RETN-2 GR5:  Retention of Students in Grade 5
RETN-2 GR6:  Retention of Students in Grade 6
RETN-2 GR7:  Retention of Students in Grade 7
RETN-2 GR8:  Retention of Students in Grade 8
RETN-2 GR9:  Retention of Students in Grade 9
RETN-2 GR10:  Retention of Students in Grade 10
RETN-2 GR11:  Retention of Students in Grade 11
RETN-2 GR12:  Retention of Students in Grade 12
Fall Snapshot EL Students



ENRL-1:  Overall Student Enrollment

PSCH-1:  Preschool Enrollment - For 2020-2021 Version Only

PSCH-2:  Preschool Enrollment - For 2017-2018 Version Only

ENRL-2a:  Enrollment of Limited English Proficient Students

ENRL-3a:  Enrollment of Students with Disabilities Served - IDEA

ENRL-3b:  Enrollment of Students with Disabilities Served Under Section 504 Only

COUR-9a:  Student Enrollment in Mathematics Courses in High School - Algebra II
COUR-9b:  Student Enrollment in Mathematics Courses in High School  - Advanced Mathematics
COUR-9c:  Student Enrollment in Mathematics Courses in High School - Calculus
COUR-9d: Student Enrollment in Mathematics Courses in High School - Geometry
COUR11a:  Student Enrollment in Science Courses - Biology
COUR-11b:  Student Enrollment in Science Courses - Chemistry
COUR-11c:  Student Enrollment in Science Courses - Physics
COUR-17:  Student Enrollment in Computer Science Courses
Regular School Year EL Students



























COUR-3b:  Student Enrollment in Algebra I in Grade 8

COUR-4b:  Grade 8 Students who Passed Algebra I

COUR-6a:  High School Student Enrollment in Algebra I - Grades 9 & 10
COUR-6b:  High School Student Enrollment in Algebra I - Grades 11 & 12
COUR-7a:  High School Students who Passed Algebra I - Grades 9 & 10
COUR-7b:  High School Students who Passed Algebra I - Grades 11 & 12
EXAM-1:  Student Participation in the SAT Reasoning Test or ACT

RETN-2 GRK:  Retention of Students in Kindergarten

RETN-2 GR1:  Retention of Students in Grade 1
RETN-2 GR2:  Retention of Students in Grade 2
RETN-2 GR3:  Retention of Students in Grade 3
RETN-2 GR4:  Retention of Students in Grade 4
RETN-2 GR5:  Retention of Students in Grade 5
RETN-2 GR6:  Retention of Students in Grade 6
RETN-2 GR7:  Retention of Students in Grade 7
RETN-2 GR8:  Retention of Students in Grade 8
RETN-2 GR9:  Retention of Students in Grade 9
RETN-2 GR10:  Retention of Students in Grade 10
RETN-2 GR11:  Retention of Students in Grade 11
RETN-2 GR12:  Retention of Students in Grade 12
Fall Snapshot Students Enrolled in EL Programs

ENRL-2a:  Enrollment of Limited English Proficient Students

Advanced Mathematics

COUR-8:  Classes in Mathematics Courses in High School
COUR-9:  Classes in Mathematics Courses in High School Taught by Teachers with a Mathematics Certification
COUR-9b:  Student Enrollment in Mathematics Courses in High School  - Advanced Mathematics
Algebra I - Grades 7 & 8






COUR-1a:  Grade 7/8 Algebra I Classes

COUR-1b:  Grade 7/8 Algebra I Classes Taught By Certified Teachers

COUR-2a:   Grade 7 Algebra I Enrollment Indicator

COUR-2b:  Grade 8 Algebra I Enrollment Indicator

COUR-3a:  Student Enrollment in Algebra I in Grade 7

COUR-3b:  Student Enrollment in Algebra I in Grade 8

COUR-4a:  Grade 7 Students who Passed Algebra I

COUR-4b:  Grade 8 Students who Passed Algebra I

Algebra I - High School




COUR-6a:  High School Student Enrollment in Algebra I - Grades 9 & 10

COUR-6b:  High School Student Enrollment in Algebra I - Grades 11 & 12
COUR-7a:  High School Students who Passed Algebra I - Grades 9 & 10
COUR-7b:  High School Students who Passed Algebra I - Grades 11 & 12
COUR-8:  Classes in Mathematics Courses in High School
COUR-9:  Classes in Mathematics Courses in High School Taught by Teachers with a Mathematics Certification
Algebra II

COUR-8:  Classes in Mathematics Courses in High School
COUR-9:  Classes in Mathematics Courses in High School Taught by Teachers with a Mathematics Certification
COUR-9a:  Student Enrollment in Mathematics Courses in High School - Algebra II
Calculus

COUR-8:  Classes in Mathematics Courses in High School
COUR-9:  Classes in Mathematics Courses in High School Taught by Teachers with a Mathematics Certification
COUR-9c:  Student Enrollment in Mathematics Courses in High School - Calculus
Geometry - Grade 8

COUR-5a:  Grade 8 Geometry Enrollment Indicator

COUR-5b:  Student Enrollment in Geometry in Grade 8

Geometry - High School

COUR-8:  Classes in Mathematics Courses in High School

COUR-9:  Classes in Mathematics Courses in High School Taught by Teachers with a Mathematics Certification
COUR-9d: Student Enrollment in Mathematics Courses in High School - Geometry
Biology

COUR-10:  Classes in Science Courses

COUR11a:  Student Enrollment in Science Courses - Biology

COUR-14:  Classes in Science Courses in High School Taught by Teachers with a Science Certification
Chemistry

COUR-10:  Classes in Science Courses

COUR-11b:  Student Enrollment in Science Courses - Chemistry

COUR-14:  Classes in Science Courses in High School Taught by Teachers with a Science Certification
Physics

COUR-10:  Classes in Science Courses

COUR-11c:  Student Enrollment in Science Courses - Physics

COUR-14:  Classes in Science Courses in High School Taught by Teachers with a Science Certification
Computer Science

COUR-15:  Classes in Computer Science Courses

COUR-17:  Student Enrollment in Computer Science Courses