MS. MILLER'S COMPUTER LAB
  • Chamblee High School
    • 4th Sci Math Rigor Hope
    • AP CSA
    • AP CSP
    • CSP
    • PGAS
  • Tech Fair Competition Club
  • About
  • Blog
  • Industry Certification CHS
Picture

Lesson 3 and 4

 The SIOP LESSON PLAN #3 and #4:
formatted for the ESOL Course

5th Grade Will Design Oakcliff's New Play Space Including Playgrounds, Soccer Fields, and Blacktop:  A STEM Unit Plan Integrating SIOP Language Goals

Task Constraints for Lesson 3 and 4: 
  1. Draw the outline of the play elements onto the grid. You can download the aerial view with the grid overlay into Microsoft PAINT and draw your overlays there. But, you will probably find it easier for the math to do this in Microsoft EXCEL. By either method, you and your STEM TEAM will create a drawing on a grid, so that you may calculate the square footage of everything. What you create in Microsoft Excel Online should match the aerial picture with the grid overlay. Your aerial layout map should have a key or legend, for clarity.
  2. Do the math. Your STEM Team will support your mathematical calculations using Microsoft Excel Online as a calculating tool. Your teacher will help you with the formulas for calculating percentages, fractions, and/or percents.
  3. Compare your percentages to the graph or percentages from the first Lesson.
  4. Improve your percentages to more closely match the percentages in Lesson 1. Justify any differences. For example, you might have come up with a brilliant play structure that no one considered earlier.
Technology I need to use:
Snipping Tool -
to copy the images of the grids I make in PAINT and Microsoft EXCEL.


Microsoft EXCEL - Create the Grid equivalent of the Microsoft PAINT grid overlay. (See example below)

Microsoft Bing or Google Chrome - to research the sizes of the soccer fields, play structures, etc.

Microsoft PAINT - to download the grid and add color overlays to show the area covered by the different play structures and areas my team chooses.

Picture
Click on the image above to download the image to your computer. Save a copy into your online STEM Notebook. Take the Image into PAINT to put in overlays.
Picture
Click on the image above to see a larger view. You will create this grid in Microsoft Excel. Then you'll take a screen shot and insert it in your STEM Notebook.

At the end of this lesson
  • I will be able to recall the STEM EDP and the Online STEM Notebook and use it with my STEM TEAM to calculate the area of play space equipment,
  • I will be able to display the math as charts and graphs using Excel as a calculation tool, and place into my Online STEM Notebook.
  • I will be able to read the descriptions of  the play equipment's size and space requirements, and transfer the dimensions onto the scaled grid created in Excel, using the picture with the grid overlay for reference.
  • I will be able to  argue the benefits of my STEM Team's plan allotment of percentage/fraction/decimal of space allotted to each play activity.



Collecting the Data - Opinion Continuum
  1. Formulate-Share-Listen-Create The teacher presents a question:

    "Using the school's aerial picture with the grid overlay, how can your STEM team calculate the percentage, fraction, or decimal math to show how much space your design covers?"
  2. The students formulate an answer individually. Then they share their answers with their STEM partner. Partners will listen carefully to their partner’s answer, note the similarities and differences, and they both create a new answer that incorporates the best of both ideas, typing  their combined answer into their STEM Notebooks. Later they will share with the rest of the class.
  3. The aerial picture with the grid overlay will color in squares, using the MS Paint Program, or Draw shapes over the grid to match the "footprint" of the play space items.
  4. The STEM Team will make a chart, to represent the square footage of play spaces, percentage, or fraction of the play space of each play feature.
  5. The STEM Team will create a graph to show the different areas of play areas in relationship to the whole play space.
  6. All of these items will go into the Online STEM Notebook.
Ideas for Academic Interaction
Possible sentence frames...
  1. Looking the aerial map of the school with the grid overlay, how can we use the grid in EXCEL to find the percentage/fraction/decimal of the total play space area that the different play areas cover?
  2. How should we present this math data?
  3. Which is the clearest representation of the math, a bar graph, a table, a pie graph?
  4. How do we create a chart that turns into a graph in MS Excel?
  5. How can I use Snipping Tool to collect information into my STEM Notebook?
  6. Does our design meet the math of the class's preferred play from day one?
Proudly powered by Weebly
  • Chamblee High School
    • 4th Sci Math Rigor Hope
    • AP CSA
    • AP CSP
    • CSP
    • PGAS
  • Tech Fair Competition Club
  • About
  • Blog
  • Industry Certification CHS