#  >> K-12 >> K-12 For Educators

How to Integrate Spreadsheets With Lesson Plans

Adults who are familiar with spreadsheets and their applications have a strong advantage in the modern workplace. Teachers can give their students a head start with this valuable tool by integrating spreadsheet work into their lessons, particularly math and science lessons. Students who are studying graphing, research and experimentation are already learning to present data in various forms so it is an easy addition to the curriculum to have students present data in the form of a spreadsheet in addition to line, bar and pie graphs.

Instructions

    • 1

      Teach students to use a spreadsheet software program. Show them how to organize data and predict trends.

    • 2

      Have students run whatever experiment or data-gathering project you would usually have them do at this point in the curriculum. For example, they may be testing probability, growing plants under various conditions or conducting a survey of their classmates' favorite activities.

    • 3

      Have students input the data they find into a spreadsheet before they construct any graphs. If they were doing experiments that lend themselves to extrapolation, such as plant growth experiments, have them predict the numbers they would see if they were to continue the experiment for an additional week, five weeks and 10 weeks.

    • 4

      Tell students to use their spreadsheets to help them construct graphs. If they were doing research surveys, they can organize their data on the spreadsheet to make it easier to make a bar graph; they can use their extrapolations to draw line graphs for time-sensitive experiments; they can put like results together on spreadsheets when testing probability, making it easier to construct a pie graph.

    • 5

      Ask students to present their findings to the class. Have them explain whether they found their spreadsheet useful. If so, ask them whether it was useful as a step in the process of making a graph or whether they found that the spreadsheet itself was the clearest way to present their data.

Learnify Hub © www.0685.com All Rights Reserved