Spreadsheet Teacher Resources

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...

There is power in spreadsheet formulas and learners use this power to model quadratic data. Given a scatterplot of a parabola, pupils create formulas in a spreadsheet to populate the data. The formulas they use lead to an understanding...

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...

Students create their own spreadsheet. They identify the different parts that make up a spreadsheet and organize their data. They practice using functions and formats.

Learners experiment with the basic functions of a spreadsheet. They practice using headers, footers, functions and fonts. They also organize information.

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,...

Do your learners like dinosaurs and theme parks? An ambitious lesson invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...

Work in reverse with the product becoming the given. Using a spreadsheet image of the graph of a trigonometric function, young scholars investigate methods of creating spreadsheet data that results in the given graph. The catch? The data...

Are you Excelent with spread sheets? Video begins with an explanation of populations and life cycles of both plants and animals. Then it walks through how to model generations of a population by using a spreadsheet. It is the...

Students improve data entry in a spreadsheet.

Students create graphs in Excel.  In this spreadsheet lesson, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the...

Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...

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...

Learners analyze the basics of an Excel spreadsheet. They highlight cells in a spreadsheet. They make a column graph. Students are introduced to X-axis and Y-axis. They play various address games on the spreadsheet.

Watch your pupils Excel at using spreadsheets to graph data by watching a video that covers how to graph data in a scatter plot using Microsoft Excel. The video also covers how to change titles, scales, and labels, as well as how to...

What is the correct way to enter dates and percentages into an Excel spreadsheet? Learners discover the answer with an instructional video that teaches them how to apply and use number formats correctly and efficiently.

You are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals...

Young scholars create a spreadsheet that calculate the amount of concrete needed to pour various concrete forms.

Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.

Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...

Sixth graders create a spreadsheet on the favorite ice cream flavors of their peers. They interview their classmates, documenting their findings on a "Favorite Flavors" spreadsheet. Students graph and analyze the data.