Scribd Logo
Upload

Welcome to Scribd!

  • 203 views

    Excel With The Planets LP

    Uploaded by

    josedejesus
    This lesson plan uses Excel and online resources to teach 4th-6th grade students about the planets in our solar system. Students will use the Internet to research and collect data on the planets, which they will then input into a Microsoft Excel spreadsheet template to create a pictograph displaying their findings. The lesson incorporates standards in science, math, and educational technology. Students will demonstrate skills in using productivity tools and conducting online research.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    Excel With The Planets LP

    Uploaded by

    josedejesus
    203 views3 pages
    This lesson plan uses Excel and online resources to teach 4th-6th grade students about the planets in our solar system. Students will use the Internet to research and collect data on the planets, which they will then input into a Microsoft Excel spreadsheet template to create a pictograph displaying their findings. The lesson incorporates standards in science, math, and educational technology. Students will demonstrate skills in using productivity tools and conducting online research.

    Original Title

    Excel with the Planets LP

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This lesson plan uses Excel and online resources to teach 4th-6th grade students about the planets in our solar system. Students will use the Internet to research and collect data on the planets, which they will then input into a Microsoft Excel spreadsheet template to create a pictograph displaying their findings. The lesson incorporates standards in science, math, and educational technology. Students will demonstrate skills in using productivity tools and conducting online research.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    203 views3 pages

    Excel With The Planets LP

    Uploaded by

    josedejesus
    This lesson plan uses Excel and online resources to teach 4th-6th grade students about the planets in our solar system. Students will use the Internet to research and collect data on the planets, which they will then input into a Microsoft Excel spreadsheet template to create a pictograph displaying their findings. The lesson incorporates standards in science, math, and educational technology. Students will demonstrate skills in using productivity tools and conducting online research.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 3
    At a glance
    Powered by AI
    The lesson plan aims to teach students about planets in the solar system by having them research planets online and input data into a Microsoft Excel spreadsheet to create a pictograph.

    The lesson plan is trying to teach students about the planets in our solar system and have them practice basic Microsoft Excel skills by completing a spreadsheet and pictograph displaying planet data.

    Students use internet resources like Fact Monster and Kids Astronomy to research planets and collect data. They input this data into a Microsoft Excel spreadsheet template to create a pictograph displaying the information.

    Technology-Connected

    Lesson Plan

    Title: Excel with the Planets


    Grade Levels:  Grades 4th- 6th
    Curriculum Areas:  Science & Math
    Measurable Objectives:  TLW use Internet resources to research and collect data on
    planets in the solar system.
     TLW demonstrate the basic skills of Microsoft Excel by
    completing a spreadsheet and a pictograph to displaying their
    data.
    Grade Level  {SCI.5.ESS.44} Explain rotation and revolution by using
    Expectations: (GLEs) models or illustrations
     {SCI.5.ESS.43} Describe the characteristics of the inner and
    outer planets
     {MA.6.30} See Above - Describe and analyze trends and
    patterns observed in graphic displays
     {MA.5.28} See Above - Use various types of charts and
    graphs, including double bar graphs, to organize, display, and
    interpret data and discuss patterns verbally and in writing
     {MA.4.36} See Above - Analyze, describe, interpret, and
    construct various types of charts and graphs using
    appropriate titles, axis labels, scales, and legends
    K-12 Educational  Technology Research Tools (Linking and Generating Knowledge
    Technology Standards: Foundation Skill)
    Students use appropriate technology to locate, evaluate, and
    collect information from a variety of sources
     Technology Productivity Tools (Resource Access and
    Utilization Foundation Skill)
    Students use productivity tools to work collaboratively in
    developing technology-rich, authentic, student-centered
    products.

    1
    Technology Connection:  Computer with Internet access
     Microsoft Excel
     Excel Spreadsheet Template
     How Many Planets?
    http://msnucleus.org/membership/storybooks/planet.html
     Planet 10
    http://www.solarsystem.org.uk/planet10
     Fact Monster – The Solar System
    http://www.factmonster.com/ipka/A0909527.html
     Kids Astronomy.com
    http://www.kidsastronomy.com/the_planets.htm
     How Many Planets? (digital storybook & songs)
    http://msnucleus.org/membership/guide/storybooks.html
    Assessment:  Observation & Participation
     Completed Excel Data Table with Pictograph
    Procedures:  Start the lesson off with a digital storybook to introduce
    information about the solar system.
    K-12 Animated Storybooks – How Many Planets?
     (Optional) On the same site, you can share some of the
    following songs (Zoom Zoom, Constellations, and Beep Beep).
     Allow students time to use one or more of the following sites
    to complete one of the four data forms attached (“What’s My
    Size?”, “How Many Moons?”, “What’s My Distance?”, or “How
    Long is a Year?” .
    Planet 10
    Fact Monster – The Solar System
    Kids Astronomy.com
     Students will use the attached Excel spreadsheet template to
    input their data. First, they need to click on the tab at the
    bottom of the Excel spreadsheet that shows the data they
    are inputting (ex. Diameter, Distance, Moons, or Orbits)
    Excel Basics – You many need to cover some of the basics of
    moving around on a spreadsheet and basic formatting tips.
     As the students input their data, the bars on the graph will
    appear. As they continue to input their data, the bar graph
    will turn into a pictograph.
     Students will print a hard copy of their pictograph to share
    with the class.
     Extension – Students will go to Planet 10 to complete the
    World Builder activity.
    “Think you could create the perfect World? Here’s your
    2
    chance to try. With World Builder, you call the shots. Work
    your way through each of the creation screens, but make your
    choices wisely, only certain conditions will ensure your planet
    is a successful place for life to grow and evolve.”
    Materials:  Excel with the Planets Data Forms
     pencil
    Teacher’s Name:  Kathy Prine
    School:  CM Fagan

    You might also like