Curated OER
Using Computer for Statistical Analysis
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Curated OER
Calculating & Graphing Using a Spreadsheet
Students use the lab apparatus to calculate the average velocity and average acceleration at several points and record the data. They use the spreadsheets to plot distance vs. time, velocity vs. time and acceleration vs. time graphs.
Curated OER
Flavorful Spreadsheets
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
Curated OER
Graphically Speaking
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Curated OER
Fantasy Basketball
Learners play Fantasy Basketball in order to practice locating Internet information and using technology tools to display data; students demonstrate an understanding and use of graphing, probability, and statistics.
Curated OER
Income Levels & Social Class: Is It All About Cash?
Young scholars graph data and interpret that data after reading information about lifestyles and income levels. They calculate percentages, set up spreadsheets and calculate columnar data.
Curated OER
How Much Is It?
Learners explore foreign currencies. In this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Learners use a conversion table and search Internet...
Curated OER
Are You Here Today?
Students recognize their own name in print and the names of their classmates. They use one to one correspondence to determine who has not checked in, completed their field, and if absent indicate that on the form. Students tally the...
Curated OER
Let's Get Linear
Math whizzes utilize spreadsheets to examine linear modeling. They roll marbles down a ramp from three different heights and measure how far they roll. They use Excel to record their data and create a plot of their data.
Curated OER
Million Dollar House
Fourth graders use a combination of calculators and spread sheet software to furnish their own million dollar horse without going over the specified amount of a million. The goal being to create a house that came to the exact amount of...
Curated OER
Is That Your Final Answer?
This unit on integers includes a pre-test, a post-test, four spreadsheets, and links to an interactive web-site to support the learning of integer operations. Access to computers and the Internet are imperative to this unit. The lessons...
Curated OER
Listen to Your Heart
Sixth graders explore how exercise affects heart rate and use spreadsheets to record and analyze data.
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson plan, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Curated OER
Edible Math
Second graders use M&M candies to graph colors, illustrate story problems and practice hands-on math. They use spreadsheets, worksheets and graphs to organize math problems that use M&M's.
Curated OER
Touring the Regions of the United States
Fifth graders explore the regions of the United States. They use maps, research on the Internet and use measurements and estimations. Students create a presentation using spreadsheets and publishing software.
Curated OER
Exploring the Beach
Students explore the beach. In this marine habitat lesson, students inspect sand grains, design beach profiles, classify marine life, and examine natural beach habitats. Students use spreadsheets to record data from their activities at a...
Curated OER
Level III: Technology Integration
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
Curated OER
Dental Detectives
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Howard Hughes Medical Institute
Measuring Biodiversity in Gorongosa
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
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
Irish Eyes: Taking a Look at Local Landscape
Direct your class’s attention to the elements that make their community unique. After examining sample travel brochures, groups select something from their community to use as the subject, and then research, create, and publish a...
Curated OER
Organizing Writing/Composing a First Draft
Does your language arts class have a hard time with writing transitions? Use this organizational writing instructional activity to create three effective transition sentences that middle schoolers will use in their research of renewable...
Curated OER
E-mailing the Chamber of Commerce
Encourage effective internet research and e-mail correspondence as scholars investigate a US capital city they've never visited to find pertinent and relevant information. They begin by picking a city, then visit that city's chamber of...
Curated OER
Buying Cars/Financing Cars Compound Interest
Provide a real world context in which exponential functions are used to determine a eal world phenomena such as compound interest and exponential growth. This activity should be taught after students have mastered the laws of exponents...