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:

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

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

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

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

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

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

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

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