# mdcps_climate_survey_students_2023-24 — first-fetch findings

- publisher: Miami-Dade County Public Schools, Research Services
- url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2023-24/2024_Students_DashBoard_in_Excell_Nov2024_rev.xlsx
- format: xlsx
- local path: `data/cities/miami/sources/mdcps_climate_survey_students_2023-24/2026-09-15/2024_Students_DashBoard_in_Excell_Nov2024_rev.xlsx`

## Sheets (9)
- `2024 Students Demographic`
- `2024_Slicer`
- `2024_Safety`
- `2024 Leadership`
- `2024 Resources`
- `2024 Teaching`
- `2024_Student_Data`
- `2024 Student Results_Tables`
- `2024 Student Results_Graphs`

### `2024 Students Demographic` (header row 5)
- `Unnamed: 0`
- `Unnamed: 1`
- `Unnamed: 2`
- `Unnamed: 3`
- `2024 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,
  "2024 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
}
```

### `2024_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 FTEFeb2024",
  "Average of TTL_Cnt",
  "Average of Female",
  "Average of Male",
  "Average of BlackNonHispanic",
  "Average of WhiteNonHispanic",
  "Average of Hispanic",
  "Average of Multiracial",
  "Average of Grade_A",
  "Average of Grade_B",
  "Average of Grade_C"
 ],
 [
  "0041 AIR BASE K-8",
  "1093",
  "356",
  "0.5646067415730337",
  "0.4353932584269663",
  "0.12921348314606743",
  "0.07584269662921349",
  "0.601123595505618",
  "0.056179775280898875",
  "0.4101123595505618",
  "0.38202247191011235",
  "0.14887640449438203"
 ]
]
```

### `2024_Safety` (header row 1)
- `SchoolStudent`
- `0041 AIR BASE K-8`

Sample first row:

```json
{
  "SchoolStudent": null,
  "0041 AIR BASE K-8": null
}
```

### `2024 Leadership` (header row 1)
- `SchoolStudent`
- `0041 AIR BASE K-8`

Sample first row:

```json
{
  "SchoolStudent": null,
  "0041 AIR BASE K-8": null
}
```

### `2024 Resources` (header row 1)
- `SchoolStudent`
- `0041 AIR BASE K-8`

Sample first row:

```json
{
  "SchoolStudent": null,
  "0041 AIR BASE K-8": null
}
```

### `2024 Teaching` (header row 1)
- `SchoolStudent`
- `0041 AIR BASE K-8`

Sample first row:

```json
{
  "SchoolStudent": null,
  "0041 AIR BASE K-8": null
}
```

### `2024_Student_Data` (header row 1)
- `Key`
- `LOC`
- `SchoolStudent`
- `FTEFeb2024`
- `TTL_Cnt`
- `SSQNO`
- `TTL`
- `Pct_Agree`
- `PCT_DK`
- `Pct_Disagree`
- `PctNA`
- `TTL_Pct`
- `SSQLabel`
- `Female`
- `Male`
- `American-Indian`
- `Asian`
- `BlackNonHispanic`
- `Hispanic`
- `IpreferNotAnswer`
- `Multiracial`
- `NativeHawaii`
- `WhiteNonHispanic`
- `Grade_A`
- `Grade_B`
- `Grade_C`
- `Grade_D`
- `Grade_F`
- `Rec_DefinitelyNot`
- `Rec_DefinitelyYes`
- `Rec_MaybeNot`
- `Rec_MaybeYes`
- `Rec_NotSure`
- `GoodEd_DK`
- `GoodEd_Yes`
- `GoodEd_No`
- `GoodEd_YesYes`
- `RegionCode`
- `TTL_Cnt2`
- `Q_NA`
- `SA`
- `AG`
- `DK`
- `DA`
- `SD`
- `N_Female`
- `N_Male`
- `N_American-Indian`
- `N_Asian`
- `N_BlackNonHispanic`
- `N_Hispanic`
- `N_IpreferNotAnswer`
- `N_Multiracial`
- `N_NativeHawaii`
- `N_WhiteNonHispanic`
- `N_Grade_A`
- `N_Grade_B`
- `N_Grade_C`
- `N_Grade_D`
- `N_Grade_F`
- `N_Rec_DefinitelyNot`
- `N_Rec_DefinitelyYes`
- `N_Rec_MaybeNot`
- `N_Rec_MaybeYes`
- `N_Rec_NotSure`
- `N_GoodEd_DK`
- `N_GoodEd_Yes`
- `N_GoodEd_No`
- `N_GoodEd_YesYes`
- `Low_Ncnt`
- `Report_Date`
- `Grd_4_Plus`
- `N_Stud_Resp_May9`
- `N_School_Staff`
- `N_Staff_Resp_May9`
- `N_Parent_Resp_May9`
- `TotalRespondents`
- `School_2024_Mix`
- `RegionName`

Sample first row:

```json
{
  "Key": "0041-Q00",
  "LOC": "41",
  "SchoolStudent": "0041 AIR BASE K-8",
  "FTEFeb2024": "1093.0",
  "TTL_Cnt": "356",
  "SSQNO": "Q00",
  "TTL": null,
  "Pct_Agree": null,
  "PCT_DK": null,
  "Pct_Disagree": null,
  "PctNA": null,
  "TTL_Pct": "0",
  "SSQLabel": "Q00. Demographic Line",
  "Female": "0.5646067415730337",
  "Male": "0.4353932584269663",
  "American-Indian": "0.014044943820224719",
  "Asian": "0.03651685393258427",
  "BlackNonHispanic": "0.12921348314606743",
  "Hispanic": "0.601123595505618",
  "IpreferNotAnswer": "0.07865168539325842",
  "Multiracial": "0.056179775280898875",
  "NativeHawaii": "0.008426966292134831",
  "WhiteNonHispanic": "0.07584269662921349",
  "Grade_A": "0.4101123595505618",
  "Grade_B": "0.38202247191011235",
  "Grade_C": "0.14887640449438203",
  "Grade_D": "0.03651685393258427",
  "Grade_F": "0.02247191011235955",
  "Rec_DefinitelyNot": "0.0702247191011236",
  "Rec_DefinitelyYes": "0.41853932584269665",
  "Rec_MaybeNot": "0.042134831460674156",
  "Rec_MaybeYes": "0.35674157303370785",
  "Rec_NotSure": "0.11235955056179775",
  "GoodEd_DK": "0.15168539325842698",
  "GoodEd_Yes": "0.39325842696629215",
  "GoodEd_No": "0.019662921348314606",
  "GoodEd_YesYes": "0.4353932584269663",
  "RegionCode": "5.0",
  "TTL_Cnt2": "356",
  "Q_NA": null,
  "SA": null,
  "AG": null,
  "DK": null,
  "DA": null,
  "SD": null,
  "N_Female": "201.0",
  "N_Male": "155.0",
  "N_American-Indian": "5.0",
  "N_Asian": "13.0",
  "N_BlackNonHispanic": "46.0",
  "N_Hispanic": "214.0",
  "N_IpreferNotAnswer": "28.0",
  "N_Multiracial": "20.0",
  "N_NativeHawaii": "3.0",
  "N_WhiteNonHispanic": "27.0",
  "N_Grade_A": "146.0",
  "N_Grade_B": "136.0",
  "N_Grade_C": "53.0",
  "N_Grade_D": "13.0",
  "N_Grade_F": "8.0",
  "N_Rec_DefinitelyNot": "25.0",
  "N_Rec_DefinitelyYes": "149.0",
  "N_Rec_MaybeNot": "15.0",
  "N_Rec_MaybeYes": "127.0",
  "N_Rec_NotSure": "40.0",
  "N_GoodEd_DK": "54.0",
  "N_GoodEd_Yes": "140.0",
  "N_GoodEd_No": "7.0",
  "N_GoodEd_YesYes": "155.0",
  "Low_Ncnt": null,
  "Report_Date": "2024-05-09 00:00:00",
  "Grd_4_Plus": "571.0",
  "N_Stud_Resp_May9": "351.0",
  "N_School_Staff": "72.0",
  "N_Staff_Resp_May9": "57.0",
  "N_Parent_Resp_May9": "154.0",
  "TotalRespondents": "356.0",
  "School_2024_Mix": "0041 AIR BASE K-8",
  "RegionName": "South"
}
```

### `2024 Student Results_Tables` (header row 2)
- `Unnamed: 0`
- `2024 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,
  "2024 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
}
```