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:

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

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

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

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

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

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

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