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:

{
  "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:

[
 [
  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:

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

2024 Leadership (header row 1)

• SchoolStudent
• 0041 AIR BASE K-8

Sample first row:

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

2024 Resources (header row 1)

• SchoolStudent
• 0041 AIR BASE K-8

Sample first row:

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

2024 Teaching (header row 1)

• SchoolStudent
• 0041 AIR BASE K-8

Sample first row:

{
  "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:

{
  "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:

{
  "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
}