Find a
Select grade level(s) Select resource type(s) Select collection(s) Select standard(s) Skip navigation Digital Library for Earth System Education
Digital Library for Earth System Education
Search tips
Using Imported Data In EXCEL: Plot Atmospheric Temperature DLESE Reviewed Collection
This activity demonstrates how to import data from the Internet and make EXCEL graphs. The instructions included were provided by a classroom teacher who used these instructions with high school students. Following detailed, illustrated instructions, students will complete the activity by working with data from two cities: Little Rock, Arkansas and Miami, Florida. Since temperature generally decreases with height, this change is called the lapse rate. The average global lapse rate is about 0.6C per 100 meters. However, lapse rates vary due to location and time. The data from this activity shows different lapse rates in two cities, with a cold front separating the cities; one of the cities is influenced by a polar air mass, while the other is affected by a tropical air mass.
Intended for grade levels:
  • Middle (6-8)
  • High (9-12)
Type of resource:
  • For the classroom:
    • Classroom activity
    • Computer activity
    • Case study
    • Lesson plan
    • Problem set
    • Project
  • Visual:
    • Illustration - artistic
    • Illustration - scientific
    • Imagery - remotely sensed
    • Map
    • Photograph
    • Visualization - scientific
  • Text:
    • Glossary
    • Abstract / Summary
  • Portal:
    • Educational
  • Services:
    • Ask an expert
  • Dataset:
    • Modeled
    • Remotely sensed
  • Tools:
    • Software
  • Physical object
  • Atmospheric science
  • Biology
  • Climatology
  • Space science
  • Technology
Technical requirements:
Excel spreadsheet
Cost / Copyright:
No cost
This product is free and clear for general use.
DLESE Catalog ID: MYND-000-000-000-017
Resource contact / Creator / Publisher:
Contact: MY NASA DATA Team

Author: Ruth Starkins
Montville Township High School in Montville, New Jersey.