# mdcps_climate_survey_parents_2020-21 — first-fetch findings

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

## Sheets (14)
- `2021 Parent Demographic`
- `Dem21Slicer`
- `21_Par_Dem_Data`
- `2021 Parent Tables`
- `2021 Parent Graphs`
- `Par_Safety21`
- `Par_Teachers21`
- `Par_School21`
- `Instructions & Definitions`
- `Par_Leadership21`
- `Par_Resources21`
- `Par_Slicer21`
- `21_Par_Climate_Data`
- `Category_Questions`

### `2021 Parent Demographic` (header row 1)
- `Unnamed: 0`
- `2020-2021 School Climate Surveys - Demographic Distribution of Parents who responded to the survey`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`

Sample first row:

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

### `Dem21Slicer` (header row None)
No header detected in the first 15 rows; first rows:
```json
[
 [
  "Row Labels",
  "Average of No. Responses",
  "Average of Male",
  "Average of Female",
  "Average of Hispanic",
  "Average of Black Non-Hispanic",
  "Average of White Non-Hispanic",
  "Average of Multiracial",
  "Average of I prefer not to answer",
  "Average of Other",
  "Average of Magnet_NO",
  "Average of Magnet_Yes"
 ],
 [
  "6071 - George W. Carver Middle",
  "113",
  "0.12389380530973451",
  "0.8761061946902655",
  "0.4690265486725664",
  "0.008849557522123894",
  "0.4247787610619469",
  "0.02654867256637168",
  "0.05309734513274336",
  "0.017699115044247787",
  "0.017699115044247787",
  "0.9823008849557522"
 ],
 [
  "Grand Total",
  "113",
  "0.12389380530973451",
  "0.8761061946902655",
  "0.4690265486725664",
  "0.008849557522123894",
  "0.4247787610619469",
  "0.02654867256637168",
  "0.05309734513274336",
  "0.017699115044247787",
  "0.017699115044247787",
  "0.9823008849557522"
 ]
]
```

### `21_Par_Dem_Data` (header row 1)
- `2021 School`
- `No. Responses`
- `Male`
- `Female`
- `Black Non-Hispanic`
- `Hispanic`
- `White Non-Hispanic`
- `Multiracial`
- `I prefer not to answer`
- `Other`
- `Magnet_NO`
- `Magnet_Yes`
- `Zero_Mtg`
- `One`
- `2 or 3 Mtg`
- `4 or 5 Mtg`
- `6 Plus Mtg`
- `KG`
- `1st`
- `2nd`
- `3rd`
- `4th`
- `5th`
- `6th`
- `7th`
- `8th`
- `9th`
- `10th`
- `11th`
- `12th`

Sample first row:

```json
{
  "2021 School": "0001 - Did not Specify which Elementary School",
  "No. Responses": "1136",
  "Male": "0.14700704225352113",
  "Female": "0.8529929577464789",
  "Black Non-Hispanic": "0.058098591549295774",
  "Hispanic": "0.7966549295774648",
  "White Non-Hispanic": "0.08538732394366197",
  "Multiracial": "0.01056338028169014",
  "I prefer not to answer": "0.029049295774647887",
  "Other": "0.020246478873239437",
  "Magnet_NO": "0.9163732394366197",
  "Magnet_Yes": "0.08362676056338028",
  "Zero_Mtg": "0.3336267605633803",
  "One": "0.1813380281690141",
  "2 or 3 Mtg": "0.34242957746478875",
  "4 or 5 Mtg": "0.08890845070422536",
  "6 Plus Mtg": "0.05369718309859155",
  "KG": "211",
  "1st": "172",
  "2nd": "153",
  "3rd": "172",
  "4th": "187",
  "5th": "197",
  "6th": "17",
  "7th": "9",
  "8th": "8",
  "9th": "0",
  "10th": "0",
  "11th": "1",
  "12th": "9"
}
```

### `2021 Parent Tables` (header row 1)
- `Unnamed: 0`
- `2020-2021 School Climate Surveys - Parents Feedback`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`
- `Unnamed: 8`

Sample first row:

```json
{
  "Unnamed: 0": null,
  "2020-2021 School Climate Surveys - Parents Feedback": "Percent of parents agreeing or strongly agreeing with each survey  statement",
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null,
  "Unnamed: 7": null,
  "Unnamed: 8": null
}
```

### `2021 Parent Graphs` (header row 1)
- `2020-2021 School Climate Surveys - Parents Feedback`
- `Unnamed: 1`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`
- `Unnamed: 8`
- `Unnamed: 9`
- `Unnamed: 10`
- `Unnamed: 11`
- `Unnamed: 12`
- `Unnamed: 13`
- `Unnamed: 14`
- `Unnamed: 15`
- `Unnamed: 16`
- `Unnamed: 17`

Sample first row:

```json
{
  "2020-2021 School Climate Surveys - Parents Feedback": "Percent of parents agreeing or strongly agreeing with each survey statement",
  "Unnamed: 1": null,
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null,
  "Unnamed: 7": null,
  "Unnamed: 8": null,
  "Unnamed: 9": null,
  "Unnamed: 10": null,
  "Unnamed: 11": null,
  "Unnamed: 12": null,
  "Unnamed: 13": null,
  "Unnamed: 14": null,
  "Unnamed: 15": null,
  "Unnamed: 16": null,
  "Unnamed: 17": null
}
```

### `Par_Safety21` (header row 4)
- `Q34- The school and law enforcement work to keep the school free of substance abuse.`
- `0.759493670886076`

Sample first row:

```json
{
  "Q34- The school and law enforcement work to keep the school free of substance abuse.": "Q33- The school and law enforcement work to keep the school free of gang activity.",
  "0.759493670886076": "0.759493670886076"
}
```

### `Par_Teachers21` (header row 6)
- `Q14- My child's school is effectively teaching students to develop good study and work habits.`
- `0.8734177215189873`

Sample first row:

```json
{
  "Q14- My child's school is effectively teaching students to develop good study and work habits.": "Q07- My child's teachers assign meaningful homework to help students learn.",
  "0.8734177215189873": "0.9367088607594937"
}
```

### `Par_School21` (header row 4)
- `Q13- My child's school is effectively teaching students to think and solve problems critically.`
- `0.8354430379746836`

Sample first row:

```json
{
  "Q13- My child's school is effectively teaching students to think and solve problems critically.": "Q12- My child's school is effectively teaching students to use computers.",
  "0.8354430379746836": "0.8227848101265823"
}
```