Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...

A professional-looking histogram is just a few clicks away. The last installment of a five-part Spreadsheet Data Analysis series focuses on histograms. Learners work through a tutorial to see how spreadsheets can help make frequency...

More than 70 percent of people and 90 percent of businesses use spreadsheets regularly. While many courses overlook the important skill, the simple water lab focuses on entering spreadsheet data, formatting it, and printing plots based...

The t-test tutorial will fit your needs to a T. After calculating the mean, sum of squares, standard deviation, and variance of two data sets on a spreadsheet, scholars learn to calculate the t-values. They then learn to use the TTEST...

There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment...

If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...

Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...

Students use a spreadsheet to solve gas law problems. In this gas laws lesson plan, students use the Express Calc program to load a spreadsheet for the gas law problems. Students compute volume, temperature, or pressure according to the...

Students use density to identify what metal a gold colored weight is made of. They use a spreadsheet to graph the experimental density of common metals and compare the know densities to their calculated density of the known metal.

Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.

For this temperatures worksheet, students view a spreadsheet of the high temperatures of the states and change the data on it using spreadsheet tools. Students complete 4 tasks.

Students develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph lesson, students develop a spreadsheet of ocean depths. They import the information into a word processed document. They...

In this geography learning exercise, high schoolers identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students...

Students use an on line simulation to produce ammonia using Haber's process. In this Haber's process lesson plan, students use a spreadsheet to manipulate the pressure, temperature and catalysts used in the production of ammonia. Their...

Mathematicians analyze the relationships between surface area and volume. They conduct Internet research, conduct various experiments, record the data in a spreadsheet, and graph the results and compare the rate of increase of surface...

Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...

Learners design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science lesson is excellent for use with upper-elementary and middle-level learners and uses spreadsheet software...

Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...

Young scholars use NASA satellite data to compare water vapor over the United States.  In this data analysis instructional activity students use an Excel spreadsheet to map their data. 

How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...

Pupils graph and analyze data using a spreadsheet.

Students explore the weather. In this weather spreadsheet lesson, students keep track of weather patterns as they use instruments and resources to chart the data the collect in spreadsheet form.

Seventh graders plot the data for the average monthly precipitation for three cities. They make a graph using a spreadsheet.

Students construct a scattergram graph. In this statistics lesson, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.