mdcps_climate_survey_staff_2020-21 — first-fetch findings

• publisher: Miami-Dade County Public Schools, Research Services
• url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2020-21/2021_Staff_Climate_DashBoard_July27.xlsm
• format: xlsm
• local path: data/cities/miami/sources/mdcps_climate_survey_staff_2020-21/2026-09-15/2021_Staff_Climate_DashBoard_July27.xlsm

Sheets (11)

• 2021 Staff Demographic
• 2021 Report in Table Format
• 2021 Report in Graph Format
• Instructions & Definitions
• PT Helper 21
• Safety 21
• Leadership 21
• Resources 21
• Teaching 21
• 2021 Staff Data
• Category_Questions

2021 Staff Demographic (header row 1)

• Unnamed: 0
• 2020-2021 School Climate Surveys - Demographic Distribution of Teachers 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 Teachers who responded to the survey": null,
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null
}

2021 Report in Table Format (header row 1)

• Unnamed: 0
• 2020-2021 School Climate Surveys - Instructional Staff 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 - Instructional Staff Feedback": "Percent of staff agreeing or strongly agreeing with the 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 Report in Graph Format (header row 1)

• Unnamed: 0
• 2020-2021 School Climate Surveys - Instructional Staff Feedback
• 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
• Unnamed: 18
• Unnamed: 19

Sample first row:

{
  "Unnamed: 0": null,
  "2020-2021 School Climate Surveys - Instructional Staff Feedback": "Percent of staff agreeing or strongly agreeing with the each survey statement",
  "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,
  "Unnamed: 18": null,
  "Unnamed: 19": null
}

Instructions & Definitions (header row 1)

• Unnamed: 0
• Miami-Dade County Public Schools: School Climate Surveys
• Unnamed: 2
• Unnamed: 3

Sample first row:

{
  "Unnamed: 0": null,
  "Miami-Dade County Public Schools: School Climate Surveys": "Each year, M-DCPS conducts the School Climate Surveys involving parents, students, and staff. The purpose of these surveys is to gather information regarding what these groups think about the school and their perceptions concerning how the school can be improved. Results have been provided in considerable detail in order to facilitate an in-depth view of the learning climate at each school. The opinions offered in the survey represent anonymous and self-reported perceptions on the part of parents, students, and staff  who participated in the survey.",
  "Unnamed: 2": null,
  "Unnamed: 3": null
}

PT Helper 21 (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",
  "Pct Teaching Face2 Face",
  "Pct Teaching Mostly Face 2 Face",
  "Pct Teaching Hybrid",
  "Pct Teaching Mostly Online",
  "Pct Teaching Online",
  "Pct Female Teachers",
  "Pct Male Teachers",
  "Pct White Teachers",
  "Pct Black Teachers",
  "Pct Hispanic Teachers",
  "Pct Multiracial Teachers"
 ],
 [
  "0101 - Arcola Lake Elementary",
  "0.0731707317073171",
  "0.21951219512195136",
  "0.682926829268293",
  "0",
  "0.024390243902439036",
  "0.7317073170731705",
  "0.2682926829268294",
  "0.024390243902439036",
  "0.4878048780487808",
  "0.31707317073170727",
  "0.024390243902439036"
 ],
 [
  "Grand Total",
  "0.0731707317073171",
  "0.21951219512195136",
  "0.682926829268293",
  "0",
  "0.024390243902439036",
  "0.7317073170731705",
  "0.2682926829268294",
  "0.024390243902439036",
  "0.4878048780487808",
  "0.31707317073170727",
  "0.024390243902439036"
 ]
]

Safety 21 (header row 5)

• Q21-I feel there is a school violence problem.
• 0.07317073170731707

Sample first row:

{
  "Q21-I feel there is a  school violence problem.": "Q06-Adequate disciplinary measures are used at my school.",
  "0.07317073170731707": "0.8048780487804879"
}

Leadership 21 (header row 4)

• Q28-I feel staff morale is high at my school.
• 0.7560975609756098

Sample first row:

{
  "Q28-I feel staff morale is high at my school.": "Q13-My Principal is receptive to constructive criticism.",
  "0.7560975609756098": "0.6829268292682927"
}

Resources 21 (header row 4)

• Q27-I like working at my school.
• 0.9024390243902439

Sample first row:

{
  "Q27-I like working at my school.": "Q26-I have a feeling of job security at my school. ",
  "0.9024390243902439": "0.7560975609756098"
}