Using Imported Data in Excel

Bring the sun to your class! Young scholars analyze actual solar wind data in the second lesson of a five-part series. Their analysis includes speed, temperature, and density data.

The next time you read a magazine or watch the news, make note of how many graphs you see because they are everywhere! Here, scholars collect, enter, and graph data using computers. The graphs are then analyzed to aid in discussion of...

Based on the rate of melting observed from 2003-2007 in Greenland, it would take less than 10 minutes to fill the Dallas Cowboys' Stadium. The 17th lesson in a series of 21 has scholars use the ICESat data to understand the ice mass...

How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...

"Clean the data!" "I did not know it was dirty." Introduce your class to the process of cleaning data so that it can analyze it. Groups work through a guide that demonstrates the common ways to filter and sort data. Pairs then...

Data, data everywhere. Challenge your class to begin thinking about data, the ways people collect information, and what we can learn from this data. Class members discuss sources of data and then individuals answer questions in the...

Good versus bad data. Pairs rate online collections of data representations from good to bad and then suggest ways to improve the visualizations. The class then creates a list of best practices and common errors in data representations...

Beginning with a discussion about using technology to collect data, this resource includes a video about the next Mars rover as an example. Young scientists are taught that filtering is necessary before collected data can be analyzed....

Understanding energy usage requires knowing more than how much energy it takes to charge your cell phone. Scholars learn each text sent uses energy as does each video, game, and phone call. They observe the larger grid of data transfers...

Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The...