# mdcps_climate_survey_students_2020-21 — first-fetch findings

- publisher: Miami-Dade County Public Schools, Research Services
- url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2020-21/2021-Student_DashBoard_July_21.xlsm
- format: xlsm
- local path: `data/cities/miami/sources/mdcps_climate_survey_students_2020-21/2026-09-15/2021-Student_DashBoard_July_21.xlsm`

## Sheets (11)
- `Stud_Demog`
- `Stud_2021_Table_Format`
- `Stud_2021_Graph_Format`
- `Slicer21`
- `Safety_21`
- `Leadership_21`
- `Quality_Ed_21`
- `Resources_21`
- `Teaching_21`
- `STUD2021`
- `Excel_TIPS`

### `Stud_Demog` (header row 1)
- `Unnamed: 0`
- `2020-2021 School Climate Surveys - Demographic distribution of students who responded to the survey`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`

Sample first row:

```json
{
  "Unnamed: 0": null,
  "2020-2021 School Climate Surveys - Demographic distribution of students who responded to the survey": null,
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null
}
```

### `Stud_2021_Table_Format` (header row 1)
- `2020-2021 School Climate Surveys - Student Feedback`
- `Unnamed: 1`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`

Sample first row:

```json
{
  "2020-2021 School Climate Surveys - Student Feedback": null,
  "Unnamed: 1": "Percent of students Strongly agreeing or Agreeing with each survey question",
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null,
  "Unnamed: 7": null
}
```

### `Stud_2021_Graph_Format` (header row 1)
- `2020-2021 School Climate Surveys - Student Feedback`
- `Unnamed: 1`

Sample first row:

```json
{
  "2020-2021 School Climate Surveys - Student Feedback": null,
  "Unnamed: 1": "Percent of students Strongly agreeing or Agreeing with each survey question"
}
```

### `Slicer21` (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
 ],
 [
  "Row Labels",
  "Average of Mbrship_2021",
  "Average of N_Srvy_Responses",
  "Average of Resp_Rate",
  "Average of GoodEdu_Agree",
  "Average of GoodEdu_DK",
  "Average of GoodEdu_Disagree",
  "Average of Recommend_pct",
  "Average of Recommend_DK_Pct",
  "Average of Recommend_NOT_Pct",
  "Average of Completely_face2face_Pct",
  "Average of Completely_Online_Pct"
 ],
 [
  "0521 - Broadmoor Elementary",
  "423",
  "35",
  "0.08274231678486997",
  "0.7714285714285715",
  "0.11428571428571428",
  "0.11428571428571428",
  "0.7714285714285715",
  "0.17142857142857143",
  "0.05714285714285714",
  "0.4857142857142857",
  "0.11428571428571428"
 ],
 [
  " ",
  "--",
  "35",
  "--",
  "0.7714285714285715",
  "0.11428571428571428",
  "0.11428571428571428",
  "0.7714285714285715",
  "0.17142857142857143",
  "0.05714285714285714",
  "0.4857142857142857",
  "0.11428571428571428"
 ]
]
```

### `Safety_21` (header row 4)
- `11. Student drug and alcohol use are problems at my school.`
- `0.4`

Sample first row:

```json
{
  "11. Student drug and alcohol use are problems at my school.": "10. Bullying is a problem at my school.",
  "0.4": "0.42857142857142855"
}
```

### `Leadership_21` (header row 7)
- `12. My principal does a good job running the school.`
- `0.8285714285714286`

### `Quality_Ed_21` (header row 6)
- `33. What I learn in class helps me outside the school.`
- `0.5428571428571428`

Sample first row:

```json
{
  "33. What I learn in class helps me outside the school.": "32. The overall climate or feeling at my school is positive and helps me learn.",
  "0.5428571428571428": "0.6"
}
```

### `Resources_21` (header row 4)
- `21. Adults at my school help me when I need it.`
- `0.7428571428571429`

Sample first row:

```json
{
  "21. Adults at my school help me when I need it.": "20. Adults at my school care about me as an individual.",
  "0.7428571428571429": "0.8285714285714286"
}
```
