Remote Sensing Exercise for Teacher Workshops
Anaktuvuk, Alaska from
In the last three years, the United States Government has
placed online real time data from any number of government
sources such as the marine buoy system, the NOAA weather system,
EPA's Surf your Watershed, USGS water resources information, the
seismic tracking system, and the volcano tracking system.
This data may be used for a variety of purposes from studies
of the particular system to data for problems in Mathematics. I
have used it to teach:
- Interconnectivity of Office programs such as Microsoft
Excel, Microsoft Powerpoint, Microsoft Internet Explorer,
and Micosoft Word or their Corel or Lotus equivalents.
- To teach massaging data in Excel or other spreadsheets.
- To teach data analysis using linear, power series or
trend analysis tools in spreadsheets.
- To follow or study floods on local rivers and creeks
using data from the USGS.
- As a geography lesson.
- As data to create Power Point Presentations including
tables, images, text.
A typical lesson plan has these components.
- Identify sources and locations of information, usually
given on the page with the data.
- Link to such sources uses a Web Browser such as Internet
Explorer, Netscape or Opera.
- Copy the Title of the source location to a Power
- Copy an image of the sensing device to the same
Power Point slide
- Copy the coordinates to a Power Point Slide
- Highlight (select) the data table
- Paste the data table in Excel or another
- Select a column of numerical data in Excel to
massage the data
- Under Data in the menu, select Text to
- Click on Next
- Adjust the columns to separate numerical
data from any artifacts or formatting
- Repeat the process for other columns of
- Rearrange the numerical columns to place
them side by side with headers.
- Select one or more columns and click on
the chart icon or select chart from the
- Make a bar, line, scatter, or more
complicated chart depending on subject
- Select this chart
- Copy the chart to the clipboard
- Place the chart on the same or a new page
in Power Point.
- Open Microsoft Word or another word processor.
- Copy the Power Page to the Word Processor
Page (you could use this method to create
reports (a lab report) based on a
presentation or a presentation based upon
a report (a lab report).
- Repeat the above process until all the data is analyzed
or take the charts and apply trend analysis to them using
Power Series or a Linear analysis. All of these commands
are available in modern spreadsheets such as Excel.
- Return to Top
Links to different remote sensing systems:
09/19/2003 by Jack L. Carter
Return to My
Return to MSMS Home
E-mail Jack L. Carter
Return to Top