# mdcps_climate_survey_students_2022-23 — first-fetch findings

- publisher: Miami-Dade County Public Schools, Research Services
- url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2022-23/2023_Students_DashBoard_23_August_2_POST.xlsx
- format: xlsx
- local path: `data/cities/miami/sources/mdcps_climate_survey_students_2022-23/2026-09-15/2023_Students_DashBoard_23_August_2_POST.xlsx`

## Sheets (9)
- `Slicer`
- `Safety2`
- `Resource2`
- `Relations2`
- `Teaching2`
- `2023_Stud_Data_12June`
- `Students Demographic`
- `Student Survey Results`
- `Student_Graphs`

### `Slicer` (header row None)
No header detected in the first 15 rows; first rows:
```json
[
 [
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null
 ],
 [
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null
 ],
 [
  "Row Labels",
  "Average of TTL",
  "Average of Female",
  "Average of Male",
  "Average of BlackNonHispanic",
  "Average of Hispanic",
  "Average of Multiracial",
  "Average of WhiteNonHispanic",
  "Average of grade_A",
  "Average of grade_B",
  "Average of grade_C",
  "Average of grade_D"
 ],
 [
  "9999 District",
  "91662.76470588235",
  "0.505",
  "0.495",
  "0.147",
  "0.6460000000000001",
  "0.034",
  "0.063",
  "0.333",
  "0.36",
  "0.209",
  "0.063"
 ]
]
```

### `Safety2` (header row 4)
- `05. I feel safe at my school.`
- `0.71459`

Sample first row:

```json
{
  "05. I feel safe at my school.": "06. My school building is kept clean and in good condition.",
  "0.71459": "0.54595"
}
```

### `Resource2` (header row 4)
- `18. My school has enough books and equipment to help me learn.`
- `0.73569`

Sample first row:

```json
{
  "18. My school has enough books and equipment to help me learn.": "19. Food served in the cafeteria at my school looks and tastes good.",
  "0.73569": "0.29649"
}
```

### `Relations2` (header row 4)
- `13. My principal does a good job running the school.`
- `0.72959`

Sample first row:

```json
{
  "13. My principal does a good job running the school.": "14. The assistant principals are available when needed.",
  "0.72959": "0.62799"
}
```

### `Teaching2` (header row 8)
- `30. My teachers let me know how I am doing on my school work.`
- `0.72343`

Sample first row:

```json
{
  "30. My teachers let me know how I am doing on my school work.": "31. All students have equal opportunity in classroom, regardless of race, ethnicity, gender or religion.",
  "0.72343": "0.72493"
}
```

### `2023_Stud_Data_12June` (header row 1)
- `LOC`
- `School_2023`
- `RgionName`
- `FTEFeb2023`
- `SSQNO`
- `Q_NA`
- `SA`
- `AG`
- `DK`
- `DA`
- `SD`
- `TTL`
- `Pct_Agree`
- `Pct_DK`
- `Pct_Disagree`
- `TTL_Pct`
- `SSQLabel`
- `Female`
- `Male`
- `AmericanIndianAlas`
- `Asian`
- `BlackNonHispanic`
- `Hispanic`
- `Iprefernottoansw`
- `Multiracial`
- `NativeHawaiianorO`
- `WhiteNonHispanic`
- `grade_A`
- `grade_B`
- `grade_C`
- `grade_D`
- `grade_F`
- `REC_DefinitelyNot`
- `REC_DefinitelyYes`
- `REC_MaybeNot`
- `REC_MaybeYes`
- `REC_NotSure`
- `GoodEd_DK`
- `GoodED_No`
- `GoodED_Yes`
- `GoodED_NoNo`
- `GoodED_YesYes`
- `RegionCode`

Sample first row:

```json
{
  "LOC": "41",
  "School_2023": "0041 AIR BASE K-8",
  "RgionName": "South Region",
  "FTEFeb2023": "1101",
  "SSQNO": "SSQ00",
  "Q_NA": null,
  "SA": null,
  "AG": null,
  "DK": null,
  "DA": null,
  "SD": null,
  "TTL": null,
  "Pct_Agree": null,
  "Pct_DK": null,
  "Pct_Disagree": null,
  "TTL_Pct": "0",
  "SSQLabel": "00. Demographic and Non-Likert Questions",
  "Female": "0.537",
  "Male": "0.463",
  "AmericanIndianAlas": "0.008",
  "Asian": "0.035",
  "BlackNonHispanic": "0.144",
  "Hispanic": "0.541",
  "Iprefernottoansw": "0.08900000000000001",
  "Multiracial": "0.09300000000000001",
  "NativeHawaiianorO": "0.002",
  "WhiteNonHispanic": "0.087",
  "grade_A": "0.42100000000000004",
  "grade_B": "0.38800000000000007",
  "grade_C": "0.146",
  "grade_D": "0.022",
  "grade_F": "0.022",
  "REC_DefinitelyNot": "0.04100000000000001",
  "REC_DefinitelyYes": "0.425",
  "REC_MaybeNot": "0.045",
  "REC_MaybeYes": "0.38",
  "REC_NotSure": "0.11",
  "GoodEd_DK": "0.11178861788617885",
  "GoodED_No": "0.03252032520325204",
  "GoodED_Yes": "0.4390243902439025",
  "GoodED_NoNo": "0.02032520325203252",
  "GoodED_YesYes": "0.3963414634146341",
  "RegionCode": "5"
}
```

### `Students Demographic` (header row 5)
- `Unnamed: 0`
- `Unnamed: 1`
- `Unnamed: 2`
- `Unnamed: 3`
- `2023 School Climate Surveys of Students: Demographic Data and Overall Feedback`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`
- `Unnamed: 8`
- `Unnamed: 9`
- `Unnamed: 10`

Sample first row:

```json
{
  "Unnamed: 0": null,
  "Unnamed: 1": null,
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "2023 School Climate Surveys of Students: Demographic Data and Overall Feedback": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null,
  "Unnamed: 7": null,
  "Unnamed: 8": null,
  "Unnamed: 9": null,
  "Unnamed: 10": null
}
```

### `Student Survey Results` (header row 2)
- `Unnamed: 0`
- `2023 School Climate Surveys - Students' Feedback`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`
- `Unnamed: 8`

Sample first row:

```json
{
  "Unnamed: 0": null,
  "2023 School Climate Surveys - Students' Feedback": "Percent of students agreeing or strongly agreeing with each survey question \u2026",
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null,
  "Unnamed: 7": null,
  "Unnamed: 8": null
}
```