A Module on Data Analysis
Nadia Kennedy, Mathematics, City Tech
Boyan Kostadinov, Mathematics, City Tech
Ariane Masuda, Mathematics, City Tech
8/11/2022
Course: MEDU 3003: Microteaching
Intermediate field school-based experience, which includes preparation for lesson and unit planning, student assessment and delivery of instruction.
Rationale:
This computing integration module focuses on engaging prospective mathematics teachers in a practice of using data sets to answer questions about local Brooklyn schools and learn more about the schools and students where they do field experience, and supporting them in developing data analytical and critical thinking skills.
For the purposes of these activities, we will use datasets from:
1.2. Digital Citizen Students recognize the rights, responsibilities and opportunities of living, learning and working in an interconnected digital world, and they act and model in ways that are safe, legal and ethical.
1.3. Knowledge Constructor Students critically curate a variety of resources using digital tools to construct knowledge, produce creative artifacts and make meaningful learning experiences for themselves and others.
1.7 Global Collaborator Students use digital tools to broaden their perspectives and enrich their learning by collaborating with others and working effectively in teams locally and globally.
Impact of Computing
Computational Thinking
Digital Literacy
Standard 1: Candidate/Completer Performance
Standard 2: Completer Professional Competence and Growth
Standard 3: Quality Program Practices
The module is designed to:
A. Support teacher learning:
B. To integrate into teacher pedagogy:
C. To help teacher candidates develop awareness of ethical issues related to digital use and literacy:
Learn about Your Field Experience School
and School District
To get started: Scroll down to the interactive map of the United States in the Miseducation (ProPublica) database and then answer the following questions:
Click the tabs “Opportunity,” “Discipline,” “Segregation” and “Achievement Gap” and answer these two questions: What do you notice? What do you wonder about?
Next, click the tabs “Black” and “Hispanic.” What do you notice? What do you wonder?
Search for your school or district in the database. What do you notice in the results? What questions do you have?
Prepare a short report on what you have found about your school and about your school district. In your reflection, include detailed results, e.g., “School district ….’s composition is 24 % Black, 41%, Hispanic, 16% White, 17% Asian, 1% Native American, 1% Two or more races.” Or “White students are 1.7 times more likely to be enrolled in at least one AP class as Black students.” Be ready to share your findings in class. In-Class Gallery Walk Teacher candidates share their findings.
Investigate relationships between school funding, inequity, and achievement.
(In)equitable School Funding Investigate relationships between school funding, inequity, and achievement.
Choose one of the following ideas (or generate another) to investigate the interrelationship among school segregation, funding and inequality.
Research your local school district budget, using public records or local media, such as newspapers or television reporting. What is the budget per student? How does that budget compare with the state average? The national average?
Compare your findings about your local school budget to your research about segregation and student outcomes, using the Miseducation database. Do the results of your research suggest any correlations?
Represent digitally? HOW? IDEAS? SHARE HOW? IDEAS?
How much less total funding do school districts that serve predominantly students of color receive compared to school districts that serve predominantly white students?
Why are school district borders problematic?
How many of the nation’s schoolchildren are in “racially concentrated districts, where over 75 percent of students are either white or nonwhite”?
How much less money, on average, do nonwhite districts receive than white districts?
How are school districts funded?
How does lack of school funding affect classrooms?
What is fair school funding and why does it matter?
Investigate the relationship between segregation,
educational opportunities, and (in)equities
Only a tiny number of black students are admitted to the highly selective public high schools in New York City (e.g., 2019, 2020, 2021) raising the pressure on officials to confront the decades-old challenge of integrating New York’s elite public schools. To learn more about this story, listen to this episode of The Daily. For more information, read this essay offering different perspectives on the problem and possible solutions. Make a case for what should be done — or not done — to make New York’s elite public schools more diverse.
Pose a question in relation to NYC school segregation and inequities that you would like to answer. Use NYC Open database https://opendata.cityofnewyork.us/ to find an answer to your question. Be ready to share in class your question, results of your research and visual representations.
Gallery Walk: Share your findings.
Discussion Questions:
What is bias?
Could data be biased? Explain.
If so, what might be some sources of bias?
What can introduce bias in data representation and interpretation?
What can guard against bias?
In what ways data analytical tools can be helpful?
Are there ways in which data analytical tools can be harmful?
What is the impact of data technologies on society and individuals?
From the verbs of plain English to the verbs of data analysis
Take your data, then filter by borough being "MANHATTAN", then select variables (columns) name, borough and mathprof, then arrange in descending (desc) order of mathprof, then slice the data through the first 10 rows (1:10), then print (kable) the resulting data into a table. Replace “then” above with the composition operator (|>) and note how the plain English instruction translates almost literary into the verbs of data analysis needed to implement this instruction.
| name | borough | mathprof |
|---|---|---|
| Special Music School | MANHATTAN | 98 |
| East Side Middle School | MANHATTAN | 97 |
| The Anderson School | MANHATTAN | 97 |
| Tag Young Scholars | MANHATTAN | 96 |
| New Explorations into Science, Technology & Math | MANHATTAN | 95 |
| New York City Lab Middle School for Collaborative Studies | MANHATTAN | 94 |
| The Clinton School | MANHATTAN | 93 |
| M.S. 255 Salk School of Science | MANHATTAN | 92 |
| M.S. 243 Center School | MANHATTAN | 90 |
| Columbia Secondary School | MANHATTAN | 88 |
data |>
group_by(district) |>
summarize(med_mathprof = median(mathprof, na.rm=TRUE)) |>
bar_chart(x=district, y=med_mathprof)Feedback