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...
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 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...
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,...
Curated OER
Student News And Weather Channel
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
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
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...
Virginia Department of Education
The Rate of Motion
How much time does it take to jump over three balloons? Pupils calculate the speed of tasks that require different motions. They determine motions for tasks such as walking, skipping, hopping, and jumping before creating a...
Center for Math and Science Education
Solar System Launch
Trying to understand the vastness of outer space can be quite a challenge for young scientists. Help put things in perspective with this cross-curricular activity as students work in pairs creating scaled models of...
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
Lesson Plan Outline for Rainbow Science
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
Bonneville
Making Observations and Recording Data for Solar Powered Water Pumping
Get pumped about an activity with water pumps. The fifth of seven installments in the Understanding Science and Engineering unit has pupils learn how to make observations, record data, and create data displays. Each group measures the...
Curated OER
Volcano Spreadsheet and Graph
Fourth graders find the height of selected volcanoes and convert their measurements to feet. Students interpret information from a graph. They also write math questions that require the use of a class created graph. Students use a...
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
Kindergarten Class Favorites
Students discuss their favorite foods, a list of four favorite food are compiled on the board or a chart. They each vote for their favorite food and the data is entered onto a spread sheet and a graph is created while the students watch...
Intel
Composting: Why Bother?
The first STEM lesson in a group of 10 explores composting. After discussing how to make a better tomorrow, classes are challenged to track garbage in their communities, visit a local waste management facility, and conduct a survey...
Curated OER
A Healthy Heart
Sixth graders create a spreadsheet using specific data. A speaker comes to discuss the heart, and the difference between anaerobic and aerobic activity. They make posters to encourage a healthy heart lifestyle.
Curated OER
Escape Velocity
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
Curated OER
Rock Creek Water Quality
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photos. They calculate the Water Quality Index and create a spreadsheet of the test data.
Curated OER
Rock Creek Water Quality
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photographs. They calculate the Water Quality Index and create a spreadsheet.
Curated OER
Putting Your Money to Work
Students create a collect data on expenses. In this algebra lesson plan, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this lesson plan.
Curated OER
Weather Watchers
Students practice using objective and quantitative means to describe and compare the weather. They compile weather conditions and create a spreadsheet to record their findings.