mdcps_climate_survey_students_2019-20 — first-fetch findings

• publisher: Miami-Dade County Public Schools, Research Services
• url: https://api.dadeschools.net/WMSFiles/244/Survey_Results_Excels/2019-20/2020%20School%20Climate%20Dashboard-Student%20Results.xlsx
• format: xlsx
• local path: data/cities/miami/sources/mdcps_climate_survey_students_2019-20/2026-09-15/2020%20School%20Climate%20Dashboard-Student%20Results.xlsx

Sheets (10)

• PT Helper
• STUD 2020
• Slicer and Safety
• Report in Table Format
• Report in Graph Format
• Leadership
• Teaching
• Resources
• Quality
• Instructions

PT Helper (header row None)

No header detected in the first 15 rows; first rows:

[
 [
  "Row Labels",
  "Average of Ncount"
 ],
 [
  "0072 - Summerville Advantage Academy*Charter",
  "4"
 ],
 [
  null,
  "4"
 ],
 [
  "Grand Total",
  "4"
 ]
]

STUD 2020 (header row 1)

• 2020 Loc No
• School Name
• GRADE
• Ncount
• CATEGORY
• SURVEY QUESTION
• Qno
• Agree
• Disagree
• DK

Sample first row:

{
  "2020 Loc No": "41",
  "School Name": "0041 - Air Base K - 8 Center International Edu.",
  "GRADE": "A-",
  "Ncount": "163",
  "CATEGORY": "1-Safety and security",
  "SURVEY QUESTION ": "Q01- My school is safe and secure.",
  "Qno": "Q01",
  "Agree": "85.2760736196319",
  "Disagree": "6.134969325153374",
  "DK": "8.588957055214724"
}

Slicer and Safety (header row 4)

• Q06- Bullying is a problem at my school.
• 50

Sample first row:

{
  "Q06- Bullying is a problem at my school.": "Q05- Gang activity is a problem at my school.",
  "50": "25"
}

Report in Table Format (header row 1)

• 2019-2020 School Climate Surveys - Student Feedback
• Unnamed: 1
• Unnamed: 2
• Unnamed: 3
• Unnamed: 4
• Unnamed: 5
• Unnamed: 6
• Unnamed: 7
• Unnamed: 8
• Unnamed: 9

Sample first row:

{
  "2019-2020 School Climate Surveys - Student Feedback": null,
  "Unnamed: 1": "Percent of Students Agreeing or Strongly Agreeing with the each Survey Question",
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": null,
  "Unnamed: 5": null,
  "Unnamed: 6": null,
  "Unnamed: 7": null,
  "Unnamed: 8": null,
  "Unnamed: 9": null
}

Report in Graph Format (header row 1)

• Unnamed: 0
• Unnamed: 1
• Unnamed: 2
• Unnamed: 3
• Unnamed: 4
• Unnamed: 5
• 2019-2020 School Climate Surveys - Student Feedback
• Unnamed: 7
• Unnamed: 8
• Unnamed: 9
• Unnamed: 10
• Unnamed: 11
• Unnamed: 12
• Unnamed: 13
• Unnamed: 14
• Unnamed: 15
• Unnamed: 16

Sample first row:

{
  "Unnamed: 0": null,
  "Unnamed: 1": null,
  "Unnamed: 2": null,
  "Unnamed: 3": null,
  "Unnamed: 4": "Percent of Students Agreeing or Strongly Agreeing with the Survey Question",
  "Unnamed: 5": null,
  "2019-2020 School Climate Surveys - Student Feedback": 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
}

Leadership (header row 7)

• Q08- My principal does a good job running the school.
• 25

Sample first row:

{
  "Q08- My principal does a good job running the school.": "Q07- Student drug and alcohol use are problems at my school.",
  "25": "25"
}

Teaching (header row 4)

• Q26- I like coming to my school.
• 25
• Unnamed: 2
• Unnamed: 3
• Unnamed: 4
• Unnamed: 5
• Unnamed: 6
• Unnamed: 7
• Unnamed: 8
• Unnamed: 9
• Unnamed: 10
• Unnamed: 11

Sample first row:

{
  "Q26- I like coming to my school.": "Q25- My teachers let me know how I am doing on my school-work.",
  "25": "50",
  "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
}

Resources (header row 4)

• Q12- My school has enough books and equipment to help me learn.
• 50
• Unnamed: 2
• Unnamed: 3
• Unnamed: 4
• Unnamed: 5
• Unnamed: 6
• Unnamed: 7
• Unnamed: 8
• Unnamed: 9
• Unnamed: 10

Sample first row:

{
  "Q12- My school has enough books and equipment to help me learn.": "Q13- Food served in the cafeteria at my school looks and tastes good.",
  "50": "25",
  "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
}