Week 1

Intro
My name is Katie and I have been teaching for 7 years. My career started in Springfield, Massachusetts where I taught middle school math for a couple years, and currently I am teaching in New York City. I am currently teaching high school Algebra. My future goal is to move to Connecticut and continue to teach high school math.

ISTE Standard:
1.5.b. collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.

NYC Standard:
AI-S.ID.3 Interpret differences in shape, center, and spread in the context of the data sets,
accounting for possible effects of extreme data points (outliers).

Lesson Idea:
To address both of these standards, students could work in groups or partners and create a statistical question that they would like to collect data on about the class. Then, they could collect the data for the question using their classmates. Using Excel, students could input the data using this technology. They could find the 5 number summary and make conclusions about the data. To account for extreme data points, they could add an extra value that is either way too big or too small and conclude how that affects the data set. Using Excel as the technology, students can easily organize the data, analyze using graphs, and make decisions on which is the best way to represent the data.

Kolb's Triple E FrameworkDiscussion:
After reading the Kolb's Triple E Framework, using Excel would be able to enhance, engage, and extend student thinking. Since excel creates the space for students to quickly input data and find summary statistics so quickly, it enhances their experience with this standard. When students have to use ti-84's for this process, they will get discouraged or they will lose the bigger picture. In addition, Excel's ability to create different representations will engage students' thinking. There is limited representations accessible with their calculators, so this will definitely keep students engaged with the many possibilities of graphs and charts. Along with the different possibilities Excel has to offer with representations, it also gives students access to extending their thinking further. They are able to explore on their own with colors and new variables that can deepen their thinking and understanding.

Comments

  1. Queen Mrs. CastleOctober 17, 2025 at 9:55 AM

    I am excited to see another math teacher in this class. I am currently in middle school math, but I love this idea for data points. I have used this in my seventh-grade class, but I could definitely teach them more about what they can do on Excel. The standard in Oklahoma actually requires the use of technology to collect and display data. The idea of using Excel will help them when they start adult jobs. Many fields would appreciate their knowledge.
    I look forward to sharing ideas with you in this class. I can foresee many intertwined lessons.

    ReplyDelete
  2. HumorTo SurviveOctober 18, 2025 at 9:06 AM

    I love your lesson idea. Having students collect and analyze their own data makes statistics so much more meaningful. Using Excel is such a smart choice, it engages students visually and helps them see patterns instantly. I use similar tools in radiology when we analyze image data, so I really connected with your post.

    ReplyDelete

Post a Comment

Popular posts from this blog

Week 2

 Authentic Intellectual Work is focused on students accessing a deep connection to the learning happening in the classroom. This is centered around construction of knowledge, disciplined inquiry, and application into the real world. This is very different from a typical classroom. In my experience in a math classroom specifically, the teacher says what we are learning, has us take notes on the topic, we do an example together and then we have time to do some on our own. The problems we are working on are just skill and drill types and there is little conversation about what the variables or numbers mean in these situations, let alone how this applies to our lives. Now that I am teaching math myself, I am using a problem based curriculum. This curriculum is focused on authentic intellectual work. Students are given a problem that could easily be translated to their real lives, and they have to work on how to come up with strategies or a solution on their own. They are encouraged to ...
Read more

Week 4

Magic School Lesson Plan   Part 1: The quality of the lesson is good. I am pleasantly surprised at the lesson in general. I think that the lesson that AI generated first is a great outline for a lesson addressing these two standards. I could have asked it to be more specific with certain parts but I enjoyed how vague it was. This would allow me to dive deeper with AI or take it and put my own spin on it.  The improvement I would suggest would be asking it to regenerate the lesson with time stamps, more of a problem based approach, and ask it for some worksheets to go along with the activities. I think the tool is useful for the rigor I am looking for in my classroom. Specifically with the assessments that it focuses on. This is a great addition to make sure that students are getting some sort of check in before moving on to the next lesson. This lesson reflects the readings because of it's emphasis on allowing students to create their own data displays, choose their own data t...
Read more

Week 3

Image
This infographic summarizes the 3 most important points from Chapter 4 of How People Learn II: Learners, Contexts, and Cultures. In addition, a connection to Gura's ideas about a creative learning environment and suggested tools that will help implement this style into a classroom.  
Read more