# mdcps_climate_survey_students_2019-20 — first-fetch findings

- publisher: Miami-Dade County Public Schools, Research Services
- url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2019-20/2020%20School%20Climate%20Dashboard-Student%20Results.xlsx
- format: xlsx
- local path: `data/cities/miami/sources/mdcps_climate_survey_students_2019-20/2026-09-15/2020%20School%20Climate%20Dashboard-Student%20Results.xlsx`

## Sheets (10)
- `PT Helper`
- `STUD 2020`
- `Slicer and Safety`
- `Report in Table Format`
- `Report in Graph Format`
- `Leadership`
- `Teaching`
- `Resources`
- `Quality`
- `Instructions`

### `PT Helper` (header row None)
No header detected in the first 15 rows; first rows:
```json
[
 [
  "Row Labels",
  "Average of Ncount"
 ],
 [
  "0072 - Summerville Advantage Academy*Charter",
  "4"
 ],
 [
  null,
  "4"
 ],
 [
  "Grand Total",
  "4"
 ]
]
```

### `STUD 2020` (header row 1)
- `2020 Loc No`
- `School Name`
- `GRADE`
- `Ncount`
- `CATEGORY`
- `SURVEY QUESTION `
- `Qno`
- `Agree`
- `Disagree`
- `DK`

Sample first row:

```json
{
  "2020 Loc No": "41",
  "School Name": "0041 - Air Base K - 8 Center International Edu.",
  "GRADE": "A-",
  "Ncount": "163",
  "CATEGORY": "1-Safety and security",
  "SURVEY QUESTION ": "Q01- My school is safe and secure.",
  "Qno": "Q01",
  "Agree": "85.2760736196319",
  "Disagree": "6.134969325153374",
  "DK": "8.588957055214724"
}
```

### `Slicer and Safety` (header row 4)
- `Q06- Bullying is a problem at my school.`
- `50`

Sample first row:

```json
{
  "Q06- Bullying is a problem at my school.": "Q05- Gang activity is a problem at my school.",
  "50": "25"
}
```

### `Report in Table Format` (header row 1)
- `2019-2020 School Climate Surveys - Student Feedback`
- `Unnamed: 1`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`
- `Unnamed: 8`
- `Unnamed: 9`

Sample first row:

```json
{
  "2019-2020 School Climate Surveys - Student Feedback": null,
  "Unnamed: 1": "Percent of Students Agreeing or Strongly Agreeing with the each Survey Question",
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null,
  "Unnamed: 7": null,
  "Unnamed: 8": null,
  "Unnamed: 9": null
}
```

### `Report in Graph Format` (header row 1)
- `Unnamed: 0`
- `Unnamed: 1`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `2019-2020 School Climate Surveys - Student Feedback`
- `Unnamed: 7`
- `Unnamed: 8`
- `Unnamed: 9`
- `Unnamed: 10`
- `Unnamed: 11`
- `Unnamed: 12`
- `Unnamed: 13`
- `Unnamed: 14`
- `Unnamed: 15`
- `Unnamed: 16`

Sample first row:

```json
{
  "Unnamed: 0": null,
  "Unnamed: 1": null,
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": "Percent of Students Agreeing or Strongly Agreeing with the Survey Question",
  "Unnamed: 5": null,
  "2019-2020 School Climate Surveys - Student Feedback": 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
}
```

### `Leadership` (header row 7)
- `Q08- My principal does a good job running the school.`
- `25`

Sample first row:

```json
{
  "Q08- My principal does a good job running the school.": "Q07- Student drug and alcohol use are problems at my school.",
  "25": "25"
}
```

### `Teaching` (header row 4)
- `Q26- I like coming to my school.`
- `25`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`
- `Unnamed: 8`
- `Unnamed: 9`
- `Unnamed: 10`
- `Unnamed: 11`

Sample first row:

```json
{
  "Q26- I like coming to my school.": "Q25- My teachers let me know how I am doing on my school-work.",
  "25": "50",
  "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
}
```

### `Resources` (header row 4)
- `Q12- My school has enough books and equipment to help me learn.`
- `50`
- `Unnamed: 2`
- `Unnamed: 3`
- `Unnamed: 4`
- `Unnamed: 5`
- `Unnamed: 6`
- `Unnamed: 7`
- `Unnamed: 8`
- `Unnamed: 9`
- `Unnamed: 10`

Sample first row:

```json
{
  "Q12- My school has enough books and equipment to help me learn.": "Q13- Food served in the cafeteria at my school looks and tastes good.",
  "50": "25",
  "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
}
```