mdcps_climate_survey_students_2022-23 — first-fetch findings

• publisher: Miami-Dade County Public Schools, Research Services
• url: https://api.dadeschools.net/WMSFiles/244/SchoolClimateSurvey/2022-23/2023_Students_DashBoard_23_August_2_POST.xlsx
• format: xlsx
• local path: data/cities/miami/sources/mdcps_climate_survey_students_2022-23/2026-09-15/2023_Students_DashBoard_23_August_2_POST.xlsx

Sheets (9)

• Slicer
• Safety2
• Resource2
• Relations2
• Teaching2
• 2023_Stud_Data_12June
• Students Demographic
• Student Survey Results
• Student_Graphs

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 TTL",
  "Average of Female",
  "Average of Male",
  "Average of BlackNonHispanic",
  "Average of Hispanic",
  "Average of Multiracial",
  "Average of WhiteNonHispanic",
  "Average of grade_A",
  "Average of grade_B",
  "Average of grade_C",
  "Average of grade_D"
 ],
 [
  "9999 District",
  "91662.76470588235",
  "0.505",
  "0.495",
  "0.147",
  "0.6460000000000001",
  "0.034",
  "0.063",
  "0.333",
  "0.36",
  "0.209",
  "0.063"
 ]
]

Safety2 (header row 4)

• 05. I feel safe at my school.
• 0.71459

Sample first row:

{
  "05. I feel safe at my school.": "06. My school building is kept clean and in good condition.",
  "0.71459": "0.54595"
}

Resource2 (header row 4)

• 18. My school has enough books and equipment to help me learn.
• 0.73569

Sample first row:

{
  "18. My school has enough books and equipment to help me learn.": "19. Food served in the cafeteria at my school looks and tastes good.",
  "0.73569": "0.29649"
}

Relations2 (header row 4)

• 13. My principal does a good job running the school.
• 0.72959

Sample first row:

{
  "13. My principal does a good job running the school.": "14. The assistant principals are available when needed.",
  "0.72959": "0.62799"
}

Teaching2 (header row 8)

• 30. My teachers let me know how I am doing on my school work.
• 0.72343

Sample first row:

{
  "30. My teachers let me know how I am doing on my school work.": "31. All students have equal opportunity in classroom, regardless of race, ethnicity, gender or religion.",
  "0.72343": "0.72493"
}

2023_Stud_Data_12June (header row 1)

• LOC
• School_2023
• RgionName
• FTEFeb2023
• SSQNO
• Q_NA
• SA
• AG
• DK
• DA
• SD
• TTL
• Pct_Agree
• Pct_DK
• Pct_Disagree
• TTL_Pct
• SSQLabel
• Female
• Male
• AmericanIndianAlas
• Asian
• BlackNonHispanic
• Hispanic
• Iprefernottoansw
• Multiracial
• NativeHawaiianorO
• WhiteNonHispanic
• grade_A
• grade_B
• grade_C
• grade_D
• grade_F
• REC_DefinitelyNot
• REC_DefinitelyYes
• REC_MaybeNot
• REC_MaybeYes
• REC_NotSure
• GoodEd_DK
• GoodED_No
• GoodED_Yes
• GoodED_NoNo
• GoodED_YesYes
• RegionCode

Sample first row:

{
  "LOC": "41",
  "School_2023": "0041 AIR BASE K-8",
  "RgionName": "South Region",
  "FTEFeb2023": "1101",
  "SSQNO": "SSQ00",
  "Q_NA": null,
  "SA": null,
  "AG": null,
  "DK": null,
  "DA": null,
  "SD": null,
  "TTL": null,
  "Pct_Agree": null,
  "Pct_DK": null,
  "Pct_Disagree": null,
  "TTL_Pct": "0",
  "SSQLabel": "00. Demographic and Non-Likert Questions",
  "Female": "0.537",
  "Male": "0.463",
  "AmericanIndianAlas": "0.008",
  "Asian": "0.035",
  "BlackNonHispanic": "0.144",
  "Hispanic": "0.541",
  "Iprefernottoansw": "0.08900000000000001",
  "Multiracial": "0.09300000000000001",
  "NativeHawaiianorO": "0.002",
  "WhiteNonHispanic": "0.087",
  "grade_A": "0.42100000000000004",
  "grade_B": "0.38800000000000007",
  "grade_C": "0.146",
  "grade_D": "0.022",
  "grade_F": "0.022",
  "REC_DefinitelyNot": "0.04100000000000001",
  "REC_DefinitelyYes": "0.425",
  "REC_MaybeNot": "0.045",
  "REC_MaybeYes": "0.38",
  "REC_NotSure": "0.11",
  "GoodEd_DK": "0.11178861788617885",
  "GoodED_No": "0.03252032520325204",
  "GoodED_Yes": "0.4390243902439025",
  "GoodED_NoNo": "0.02032520325203252",
  "GoodED_YesYes": "0.3963414634146341",
  "RegionCode": "5"
}

Students Demographic (header row 5)

• Unnamed: 0
• Unnamed: 1
• Unnamed: 2
• Unnamed: 3
• 2023 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,
  "2023 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
}

Student Survey Results (header row 2)

• Unnamed: 0
• 2023 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,
  "2023 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
}