Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 5: Histogram
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...
Pingry School
The Water Lab – Spreadsheet Simulation
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 4: t-Test
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean
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...
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
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,...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
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...
Curated OER
Using a Spreadsheet to Solve Gas Law Problems
High schoolers 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. High schoolers compute volume, temperature, or pressure...
Curated OER
Using a Spreadsheet to Understand Density
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.
Curated OER
A Fishy Tale
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.
Curated OER
High Temperature records by State
In 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.
Curated OER
A Line Graph of the Ocean Floor
Learners develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph instructional activity, students develop a spreadsheet of ocean depths. They import the information into a word processed...
Curated OER
Endangered Species
In this geography worksheet, students 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 use a...
Curated OER
Weather
Learners create a spreadsheet and chart using data collected. In this weather lesson, students select five cities from their state, including the city they live in. Learners take daily temperature readings from all five...
Curated OER
Haber's Process- A Computer Simulation
Learners 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...
Alabama Learning Exchange
How Big Can a Bee Be?
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...
Teach Engineering
Air Pollution in the Pacific Northwest
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...
Curated OER
Birds, Fractions and Percentages
Students study fractions, percentages, spreadsheets, and computers by watching and recording the number of species of birdsseen. They create a spreadsheet to record the results of their one month study.
Curated OER
Forces of Flight - Lift
Students design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science lesson plan is excellent for use with upper-elementary and middle-level learners and uses spreadsheet...
Curated OER
Does Humidity Affect Cloud Formation?
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,...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students 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.
Howard Hughes Medical Institute
Lesson 8: WildCam Gorongosa Data Analysis
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...
Curated OER
Graphing Data from the Chemistry Laboratory
High schoolers graph and analyze data using a spreadsheet.
Curated OER
Collect the Weather Lesson Plan
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.
Other popular searches
- Spreadsheets
- Excel Spreadsheets
- Budget Spreadsheet
- Favorite Foods Spreadsheet
- Microsoft Excel Spreadsheets
- Candy Wrapper Spreadsheet
- Basic Spreadsheet Skills
- Spreadsheet Lesson Plans
- Meteorology and Spreadsheets
- Using Excel Spreadsheets
- Amusement Park Spreadsheet
- Creating a Spreadsheet